Data Analyst Power Bi Developer Jobs in Aurora, IL

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

Please note that immigration sponsorship is not offered for this specific opening.