Junior Compliance Data & Reporting Analyst

Colonial Group; Chicago (IL); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

Paid parental leave

Mother's lounge onsite

Flexible PTO plan

In-office Monday–Thursday; work from '

Free gym in Chicago office

401k matching plan

HSA employer contributions

Student loan assistance

Pet insurance

Job summary

Hightower, a Chicago-based wealth management firm, seeks a Compliance Data and Reporting professional to support branch examination planning and testing. This junior-to-mid-level role focuses on building reliable, repeatable analytics with SQL, Alteryx, and BI tools, while coordinating with compliance and technology partners.

You will validate data, identify risks, and communicate findings to senior compliance leaders. The role offers hybrid work in Chicago with solid benefits.

Qualifications

• 2–4 years of experience in data analysis, reporting, BI, or compliance testing.
• Experience in financial services preferred.
• Proficient in SQL and reporting tools such as Alteryx or Power BI.
• Foundational knowledge of SEC/FINRA regulatory requirements.
• Ability to communicate results clearly to nontechnical audiences.

Responsibilities

• Develop and maintain reports, dashboards, and analytical tools that support branch examination planning, data review, and risk identification.
• Gather, reconcile, and validate information from compliance, branch, examination, and other business systems.
• Analyze reporting results to identify unusual activity, recurring issues, trends, and potential compliance risks.
• Explain analytical results and their limitations, document potential findings, and present clear summaries to compliance leaders and examination partners.
• Support the branch examination lifecycle, including risk assessment, examination preparation, findings review, and remediation tracking.
• Build and perform repeatable data-based tests for branch examinations and related compliance reviews.
• Contribute to the development of testing and reporting for other Compliance Department priorities as capacity allows.
• Use SQL and data preparation or reporting tools such as Alteryx to analyze information, and help automate recurring work with Microsoft Power Automate and Power Apps.
• Work with compliance, examination, business, and technology partners to clarify needs, deliver practical reporting solutions, and document data sources, definitions, report logic, and quality checks.

Skills

Data analysis experience

SQL proficiency

BI/reporting tools

Financial services knowledge

Tools

Alteryx

Power BI

Job description

Hightower, a Chicago-based wealth management firm, seeks a Compliance Data and Reporting professional to support branch examination planning and testing. This junior-to-mid-level role focuses on building reliable, repeatable analytics with SQL, Alteryx, and BI tools, while coordinating with compliance and technology partners.

You will validate data, identify risks, and communicate findings to senior compliance leaders. The role offers hybrid work in Chicago with solid benefits.