Senior Audit and Data Solutions Analyst

Ctpf; Chicago (IL); On-site; USD 99,000 - 144,000; Full time

Job summary

CTPF in Chicago, IL seeks a Senior Audit and Data Solutions Analyst to perform complex employer data review and audits, collaborate with outside auditors, and lead support for analysts and specialists to ensure accuracy and compliance in employer reporting.

The role combines data analysis, IT methodology research, and project management to improve efficiency while managing projects independently. Strong SQL, analytical, and communication skills are essential.

Qualifications

• Bachelor's degree with 6+ years of experience.
• Agile and project management experience preferred.

Responsibilities

• Perform complex employer data review and audit functions.
• Collaborate with outside auditors and support analysts and specialists to ensure accuracy in employer reporting.
• Analyze data, research IT methodologies, and implement procedures to enhance efficiency.
• Develop project plans, test plans, requirements, and communication deliverables.
• Prepare and deliver training to outside audit firms and present to the Board of Trustees.
• Maintain detailed organized documentation of audit files and processes.
• Coordinate with end users and stakeholders on production support and risks.
• Construct and manage complex reports across various databases.

Skills

Analytical thinking

Organizational skills

SQL

Data analysis

Communication skills

Problem solving

Presentation skills

Agile

Project management

Education

Bachelor's degree

Tools

SQL Software

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior Audit and Data Solutions Analyst

Regular Full-Time Chicago, IL, US

Salary Range: $99,439.00 To $144,187.00 Annually

Position Summary

This dual role will be performing complex employer data review and audit functions, collaborating with outside auditors, and leading support for analysts and specialists to ensure accuracy and compliance in employer reporting. Along with analyzing data, researching information technology methodologies, and implementing procedures to enhance organizational efficiency while serving as a subject matter expert and independently managing projects and processes.

• Provide training, guidance, and support to the Specialist in addressing daily inquiries
• Analyze and review audit report data prepared by outside auditors for accuracy and compliance with administrative rules
• Audit licensure look-up results for accuracy
• Prepare and deliver training to outside audit firms in support of the manager
• Identify patterns and recommend audit and remediation actions for data discrepancies
• Prepare and update procedures for team tasks
• Assist the manager with preparing and making presentations to the Board of Trustees
• Review auditing to ensure participant eligibility, including covered positions, licensing, and participation
• Conduct sample reviews of remediation completion for audit findings
• Document high-level findings for each audit and provide to manager for transparency and internal documentation
• Maintain detailed organized documentation of audit files and processes.
• Develop project plans, test plans, requirements, and communication deliverables
• Monitor project progress and evaluate project successes and obstacles
• Coordinate with end users, managers, and stakeholders on production support, project risks, and status updates
• Construct and manage complex reports across various databases
• Maintain open, transparent communication with your manager about progress, priorities, and any roadblocks
• Flag potential challenges early and collaborate with your manager and Director of Employer Services to develop solutions
• Additional duties as assigned

Qualificiations

• Bachelor's degree with 6 or more years of experience
• Agile and project management experience preferred

Knowledge, Skills and Abilities

• Demonstrated analytical and organizational skills with a commitment to accuracy and timely follow through
• Ability to adapt quickly to change and prioritize multiple tasks without compromising quality standards
• Strong listening, presentation, and problem-solving skills with the ability to analyze complex data
• Ability to work effectively in high-pressure situations requiring sound decision making and handling confidential matters
• Proficient in SQL, development, and data analysis to support business strategies
• Ability to collaborate effectively with technical and non-technical users to achieve project goals and presentation to your audience
• Excellent verbal and written communication skills for diverse audiences
• Knowledge of business systems design and process improvement methodologies preferred
• Ability to meet assigned deadlines and work independently of day-to-day supervision
• Understanding of pension systems and related data discrepancies

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job.

• Regularly required to use both hands
• Frequently required to stand, sit, stoop, talk, and hear
• Frequently required to read computer screens, correspondence, and reports
• Occasionally required to lift and/or move up to 20 pounds

This job is performed in an indoor office environment and involves regular use of computers and other standard office equipment. Occasional work outside regular hours, including evenings, weekends, or limited travel, may be required.

Supervisory Responsibility

• May provide guidance and coach others

Disclaimer:

This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees may be required to follow other job-related instructions and to perform other job-related duties as requested, subject to all applicable state and federal laws. Management reserves the right to revise or change job descriptions, job duties, functions and requirements as the need arises. This job description does not constitute a written or implied contract of employment.

CTPF is an Equal Opportunity Employer. CTPF does not discriminate due to race, color, creed, religion, sex, sexual orientation, gender and/or gender identity or expression, marital or parental status, national origin, ethnicity, citizenship status, veteran or military status, age, disability, unemployment status, or any other legally protected basis. Qualified candidates of diverse backgrounds are encouraged to apply for any vacant positions.

By signing below, I understand the requirements and the essential functions of this position.