Compliance Officer-Data Analytics & Reporting

Hightower Advisors; Chicago (IL); Hybrid; USD 75,000 - 110,000; Full time

Benefits offered by this job

Medical insurance

Parental leave

Gym on-site

401k matching

Flexible PTO

Work-from-home Fridays

Pet insurance

Job summary

Hightower Advisors in Chicago seeks a Compliance Data and Reporting analyst to support branch examination planning and compliance testing. You’ll develop dashboards and repeatable data tests, reconciling information across compliance, branch, and examination systems.

You’ll work with SQL, Alteryx, and Power BI to deliver practical reporting solutions, and collaborate with technology and business partners to ensure data quality and actionable insights.

Qualifications

• 2–4 years of experience in data analysis, reporting, or compliance testing.
• Experience analyzing structured data and producing repeatable reports.
• Working proficiency in SQL and hands-on with Alteryx, Power BI, or similar tools.
• Foundational knowledge of SEC/FINRA or compliance practices.
• Ability to translate data findings to nontechnical audiences and document data sources.

Responsibilities

• Develop and maintain reports, dashboards, and tools for branch examination planning and risk identification.
• Gather, reconcile, and validate information from compliance systems and business sources.
• Analyze results to identify unusual activity, trends, and potential risks.
• Explain results, document findings, and present summaries to leadership and partners.
• Support examination lifecycle from risk assessment to remediation tracking.
• Create repeatable data-based tests for examinations and compliance reviews.
• Contribute to testing and reporting for other Compliance priorities as needed.
• Use SQL and tools like Alteryx; automate recurring work with Power Automate and Power Apps.
• Clarify needs with partners and document data sources, definitions, and report logic.

Skills

SQL

Alteryx

Power BI

Power Automate

Power Apps

AI assistants

Documentation

Tools

SQL

Alteryx

Power BI

Power Automate

Power Apps

Job description

Our Story

Founded in 2008, Hightower is a wealth management firm that provides investment, financial and retirement planning services to individuals, foundations and family offices, as well as 401(k) consulting and cash management services to corporations. Hightower's capital solutions, operational support services, size and scale empower its vibrant community of independent-minded wealth advisors to grow their businesses and help their clients achieve their financial vision. Based in Chicago with advisors across the U.S., we operate as a registered investment advisor (RIA).

Your Future Team

Hightower's Compliance Department strives to provide support to our advisor teams. We are passionate about serving as collaborators within all facets of the organization. We focus on developing strategies that are for advisors, their clients, and other mid and back-office departments. We do this while observing the spirit of the regulation. We are seeking a Compliance Officer, Compliance Data and Reporting to support Hightower's branch examination program and broader compliance testing efforts. This junior-level role will work with experienced compliance professionals to develop useful reporting, review data for potential issues, and communicate findings. The analyst will help turn examination and compliance needs into reliable, repeatable analysis for an SEC-registered investment adviser and FINRA-regulated broker-dealer.

What You'll Do

• 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.

What You'll Bring

• 2–4 years of experience in data analysis, reporting, business intelligence, compliance testing, audit, or a related role; experience in financial services is preferred.
• Experience analyzing structured data and developing reports or other repeatable analytical outputs for business or compliance users.
• Working proficiency in SQL and hands-on experience with a reporting or data preparation tool such as Alteryx, Power BI, or a comparable platform.
• Foundational knowledge of investment adviser or broker-dealer compliance, supervision, audit, or examination practices, with the ability to learn applicable SEC, FINRA, and firm requirements.
• Ability to assess data for accuracy, investigate exceptions, identify meaningful patterns, and communicate results clearly to nontechnical audiences.
• Familiarity with Microsoft Power Automate and Power Apps and approved AI assistants such as ChatGPT, Claude, or Copilot, or the ability to learn them quickly and use them responsibly.

What We Offer

• Coverage on the first day of employment for medical, dental, and vision insurance
• Paid parental leave (16 weeks for primary caregiver and 8 weeks for secondary caregiver)
• Mother's lounge onsite
• Flexible PTO plan
• In-office Monday through Thursday and work from home on Fridays
• Free brand-new gym in the Chicago office
• 401k matching plan
• HSA employer contributions
• Student loan assistance
• Pet insurance

AN EQUAL OPPORTUNITY EMPLOYER: Hightower is an equal opportunity employer and does not discriminate based upon race, color, religion, sex, sexual orientation, pregnancy, marital status, national origin, citizenship, veteran status, ancestry, age (over 40), physical or mental disability, medical condition (cancer-related), gender identity or expression, genetic information including sickle cell or hemoglobin C trait, or any other consideration made unlawful by applicable federal, state, or local law. You are a U.S. citizen, U.S. permanent resident or possess other unrestricted U.S. work authorization and will not require sponsorship for U.S. work authorization now or anytime in the future.