Summer Data Analyst Rotational Program Jobs in Illinois

Job Title: Senior Data & Analytics Engineer (Enterprise Intelligence)
Role Overview
We are seeking a high-caliber Senior Data & Analytics Engineer to serve as a Subject Matter Expert (SME) within our enterprise data organization. In this role, you will be responsible for the end-to-end lifecycle of data intelligence-from building robust pipelines in Databricks to delivering executive-level insights in Power BI. You will bridge the gap between complex raw data and scalable business KPIs, ensuring that our analytical models are high-performing, governed, and accurate. Beyond technical execution, you will act as a mentor and lead, providing code reviews and establishing best practices for our internal analytics teams.
Key Responsibilities
• SQL Mastery: Design, optimize, and maintain complex SQL queries, views, and stored procedures. Support self-service reporting environments and implement rigorous data quality controls.
• Databricks Engineering: Build and manage Databricks notebooks and Delta tables. Develop sophisticated data pipelines to transform large-scale datasets into curated, audit-ready analytical layers.
• Power BI Leadership: Lead the development and enhancement of Power BI dashboards and semantic models. Ensure reports provide actionable insights for both executive and operational stakeholders.
• Data Modeling & Strategy: Collaborate with business SMEs to translate complex requirements into scalable data models and KPIs across diverse organizational use cases.
• Governance & Validation: Perform advanced data profiling and reconciliation across multiple source systems to ensure adherence to enterprise governance and performance standards.
• Technical Mentorship: Provide SME-level guidance and best-practice coaching. Conduct code reviews for internal teams to ensure high standards in SQL, Databricks, and Power BI development.
Qualifications & Requirements
• Technical Expertise:
• Expert-level proficiency in Power BI, SQL, and Databricks.
• Deep experience with Delta Lake architecture and notebook-based transformations.
• Advanced knowledge of DAX, Power Query, and semantic model optimization.
• Experience:
• Proven track record of building data pipelines for large-scale, complex datasets.
• Experience translating business requirements into technical documentation and KPIs.
• Previous experience in a lead or mentorship capacity.
• Skills: Strong analytical rigor, excellent communication skills, and the ability to perform complex data reconciliation. Equal Opportunity Employer / Disabled / Protected Veterans
The Know Your Rights poster is available here:
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf
The pay transparency policy is available here:
https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf
For temporary assignments lasting 13 weeks or longer, AllSTEM Connections is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.
We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.
AllSTEM Connections participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.
https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf
We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Additional Skills
(none specified)
AllSTEM Representative Contact Info
Account Executive:
Nichols
Branch Phone:
(909) 244-1777
Location:
Ontario, CA