Senior Application and Data Integration Analyst

Job Description

The Senior Application & Data Integration Analyst will be responsible for supporting, enhancing, and optimizing enterprise applications with a strong emphasis on SQL-based data analysis, system integrations, and vendor‑managed platforms. This role works closely with business stakeholder teams (Finance, Accounting, Operations) and vendors to troubleshoot issues, implement enhancements, and ensure data accuracy, compliance, and operational efficiency.

• Serve as the primary technical analyst for SQL-based applications, data integrations and data‑centric troubleshooting
• Design, analyze, and optimize SQL data models, stored procedures, and ETL processes
• Develop and maintain SSIS packages for data integration and transformation
• Perform ad‑hoc data analysis and complex SQL queries to support business needs
• Debug, enhance, and optimize existing SQL code written by internal teams or vendors
• Partner directly with business stakeholders to gather requirements, analyze issues, and deliver enhancements
• Support finance‑related applications with understanding of GL, AP, AR, and related processes
• Perform data maintenance, identify root causes of data issues, and coordinate fixes with the business and vendors
• Coordinate with vendors on application upgrades and patches, scheduling and execution, UAT, communication and release planning
• Lead and execute change management activities using ITSM methodologies
• Manage user access and security for vendor systems
• Respond to SOX audit requests and support quarterly/monthly audit submissions
• Provide ongoing production support for SQL, integrations, and vendor applications

• Background in Finance, Accounting, or Employee Benefits systems
• Working knowledge of General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR)
• Experience with Alteryx workflows
• API integration experience (REST/SOAP)

• College Degree or equivalent
• 6 years related experience
• Expert technical knowledge
• Knowledge of industry regulations
• Ability to lead and coordinate team activities of others
• Ability to formulate, document and recommend new policies and procedures
• Able to work in and lead a team
• Demonstrated ability to communicate verbally and in writing throughout all levels of an organization, both internally and externally
• Ability to travel as required by business and on‑call availability

CBIZ Inc. is a leading professional services advisor to middle market businesses and organizations nationwide. With unmatched industry knowledge and expertise in accounting, tax, advisory, benefits, insurance, and technology, CBIZ delivers forward‑thinking insights and actionable solutions to help clients anticipate what's next and discover new ways to accelerate growth. CBIZ has more than 10,000 team members across more than 160 locations in 22 major markets coast to coast.

CBIZ strives to be our team members' employer of choice by creating an environment where team members are appreciated, recognized for their contributions, and provided with opportunities to grow, both personally and professionally, throughout their careers.

Together, CBIZ and CBIZ CPAs are ranked as one of the top providers of accounting services in the United States. CBIZ CPAs is an independent CPA firm that provides audit, review and attest services, while CBIZ provides business consulting, tax and financial services. In certain jurisdictions, CBIZ CPAs operates under its previous name, Mayer Hoffman McCann P.C.