Semantic Data Modeling Jobs in Chicago, IL (NOW HIRING)

Lincolnshire, IL, United States (On-site)

Contract (4 months 15 days)

Published 18 days ago

pyspark

SQL

GCP

databricks

PowerBI

We are seeking a highly skilled Onshore Data Engineering Lead to drive the design, development, support, and continuous enhancement of enterprise-scale data platforms. This role is ideal for a hands-on technical leader with deep expertise in SQL, Databricks, PySpark, and Power BI, combined with strong stakeholder management and delivery leadership skills.

As a key member of the team, you will work closely with client stakeholders to understand business needs, translate requirements into scalable data solutions, and lead coordination with offshore development teams to ensure high-quality, timely delivery. You will play a critical role in improving data reliability, operational efficiency, and business value realization across the organization.

• Design, develop, and maintain large-scale data pipelines and enterprise data solutions.
• Build, optimize, and support data processing workflows using Databricks, PySpark, and SQL.
• Develop and maintain Power BI dashboards, reports, and semantic data models to support business decision-making.
• Lead production support activities, including incident management, troubleshooting, root cause analysis (RCA), and service improvements.
• Collaborate with business and technical stakeholders to gather requirements and translate them into effective technical solutions.
• Coordinate and guide offshore teams, ensuring delivery quality, adherence to timelines, and alignment with project objectives.
• Identify and implement opportunities for process automation, performance tuning, and operational excellence.
• Drive best practices in data engineering, governance, and platform reliability.

• Expert-level proficiency in SQL, including query optimization, performance tuning, and data modeling.
• Strong hands-on experience with Databricks (GCP preferred; experience with non-Azure Databricks environments required).
• Extensive experience developing solutions with PySpark.
• Strong expertise in Power BI, including DAX, dashboard development, reporting, and data modeling.
• Proven experience designing, building, and supporting enterprise-scale ETL/ELT pipelines and modern data platforms.
• Strong background in production support, issue resolution, and root cause analysis.
• Excellent communication, stakeholder engagement, and client-facing consulting skills.
• Demonstrated ability to lead cross-functional and distributed teams.

• Experience with Google BigQuery
• Proficiency in Python
• Knowledge of Delta Lake
• Experience with Data Lakehouse architectures
• Familiarity with CI/CD pipelines, DataOps practices, and automated deployment frameworks

• 8+ years of overall IT experience.
• 5+ years of experience in Data Engineering, Analytics, or related disciplines.
• Proven experience working within onsite-offshore delivery models.
• Experience leading technical initiatives and collaborating directly with business stakeholders.
• If you are looking to lead impactful data initiatives while working closely with both business stakeholders and global delivery teams, we'd love to hear from you.

The pay range that the employer in good faith reasonably expects to pay for this position is $27.00 - $37.00 USD/hour. Our offered benefits include medical, dental, vision, and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America's leading providers of Staffing and Consulting Services. Our success and out clients' success are built on a foundation of service excellence.

We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected cahracteristic. Qualified applicants with arrest or conviction recors will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fait Chance Act. Unincorporated LA County workers; we reasonably believe that criminal history may have a direct, adverse, and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided propert, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public informaiton. In addition, job duties require acces to secure and protected client information technology systems and related data security obligations.