Senior Data Analyst – People Analytics

IMC Trading; Chicago (IL); On-site; USD 140,000 - 180,000; Full time

Job summary

IMC Trading is seeking a Senior Data Analyst in Chicago, Illinois to join the Financial Planning & Analytics team. The role involves developing data dashboards, building ETL pipelines, and providing analytical insights on workforce trends. Candidates should possess 5+ years of relevant experience and strong skills in Python, SQL, and BI tools like Qlik or Tableau. The position offers a competitive salary in the range of $140,000 - $180,000 annually.

Qualifications

• 5+ years of experience as a Data Analyst or similar role.
• Experience in building dashboards and reporting solutions.
• Proven ability in developing and maintaining ETL pipelines.

Responsibilities

• Build and maintain dashboards and reports for HR and FP&A.
• Extract, transform, and load data using Python-based ETL pipelines.
• Support FTE forecasting and headcount budgeting processes.

Skills

Python

SQL

Data Analysis

BI Tools (Qlik, Tableau, Power BI)

ETL Pipelines

Communication Skills

Data Privacy Regulations

Familiarity with HR Data

Education

Bachelor's degree in Computer Science, Finance, Statistics, or related field

Tools

Python

SQL

Qlik

Tableau

Power BI

HRIS Systems (Workday, SAP)

Job description

Senior Data Analyst

As a Senior Data Analyst, you will join our Financial Planning & Analytics (FP&A) team and partner closely with HR, Finance and Talent Acquisition stakeholders to deliver data analysis and reporting that drives people‑related decisions across the organization. This is a hands‑on, technical role. You will spend most of your time building dashboards, writing code, engineering data pipelines, and translating stakeholder requirements into production‑ready analytics solutions. You will also serve as a key analytical partner to HR leadership – providing actionable insights on workforce trends, talent acquisition, compensation, employee engagement, and organizational effectiveness. The ideal candidate is a strong data analyst who is equally comfortable working with HR and financial data, can operate independently, and thrives in a fast‑paced environment with extensive ad‑hoc reporting requirements.

Your Core Responsibilities

• BI Development & Data Engineering
  • Design, develop, and maintain dashboards and reports for HR, Talent Acquisition, and FP&A stakeholders using Qlik or similar BI tools (Tableau, Power BI)
  • Build and maintain Python‑based ETL pipelines to extract, transform, and load data from HRIS, ATS, finance systems, and other internal sources into the analytics database
  • Own the full product delivery cycle for analytics solutions: requirements gathering, design, development, testing, and deployment to production
  • Extend and optimize the analytics database to support new data sources and evolving reporting needs
  • Ensure data quality, consistency, and reliability across all pipelines and reporting assets
  • Build and automate reporting workflows to reduce manual effort and improve scalability
• HR Reporting & Analytics
  • Develop and maintain standard HR metrics and recurring reports covering headcount, attrition, diversity & inclusion, compensation equity, and employee engagement
  • Build and support recruitment dashboards to track recruitment‑funnel progress, pipeline characteristics, and time‑to‑fill metrics
  • Partner with HR Business Partners (HRBPs) to translate data requests into clear reports and visualizations
  • Conduct ad‑hoc analyses on people data to support HR and business decision‑making
  • Leverage SQL and Python to query large HR datasets, perform statistical analyses, and develop predictive models (e.g., attrition risk, flight risk scoring)
• FP&A & Workforce Planning Support
  • Support FTE forecasting and headcount budgeting processes by building and maintaining models and reports in partnership with Finance and HR/Recruitment teams
  • Contribute to annual HR planning cycles, including headcount forecasting, workforce cost modeling, and scenario analysis
  • Track and manage FTE movement against budget
  • Analyze workforce trends to identify patterns and risk areas relevant to financial planning
• Stakeholder Partnership & Communication
  • Act as a trusted analytical advisor to HR and Finance to understand their needs and proactively surface findings
  • Present data, trends, and insights to both technical and non‑technical audiences in clear, concise formats
  • Collaborate with other BI Developers and Engineers within BP&A to maintain shared data standards, governance practices, and documentation
  • Demonstrate curiosity in understanding business context, using that understanding to deliver solutions that balance standardization with practical requirements

Your Skills And Experience

• 5+ years of experience as a Data Analyst, BI Developer, Financial Analyst, or similar analytics role
• Demonstrated proficiency in Python and SQL, including writing clean, production‑ready code; experience working with large datasets
• Proven experience building reporting and dashboard solutions in Qlik, Tableau, Power BI, or a comparable BI tool
• Demonstrated experience developing and maintaining ETL pipelines and data architecture
• Working knowledge of at least one HRIS platform (Workday, SAP SuccessFactors, Oracle, ADP, or equivalent)
• Excellent communication and interpersonal skills; ability to work directly with non‑technical stakeholders and present findings clearly
• Self‑driven and comfortable working independently in a dynamic environment with shifting priorities and heavy ad‑hoc reporting needs
• Familiarity with data privacy regulations as they apply to employee and people data
• Bachelor's degree in Computer Science, Finance, Statistics, Information Systems or other quantitative field
• Exposure to FP&A processes such as headcount budgeting, FTE forecasting, or workforce cost modeling preferred
• Experience working with HR data including HRIS, ATS, compensation, and headcount data is a plus
• Familiarity with HR metrics frameworks, people analytics best practices, and DEI reporting preferred

Salary Range

$140,000 - $180,000 USD