Data Engineer

Contruent LLC
Naperville, IL

About the Role

We are seeking a Data Engineer to help advance our analytics infrastructure, data pipelines, and reporting capabilities. This role will work closely with the Manager of Data Science & AI Engineering to manage and optimize our SQL environments, develop automated data flows, and modernize our Power BI ecosystem.

You’ll be responsible for maintaining the integrity and performance of our data systems, enabling scalable and reliable analytics across the organization. The ideal candidate combines strong SQL engineering skills with a deep understanding of data modeling, ETL, and business intelligence.

Key Responsibilities


  • Maintain and optimize large SQL Server and AWS RDS databases, ensuring performance, reliability, and scalability.

  • Design, build, and manage ETL pipelines and data integrations using AWS Glue , Lambda , and related AWS services.

  • Develop and enhance Power BI datasets, models, and dashboards with an emphasis on usability, governance, and performance.

  • Partner with business stakeholders to translate requirements into well-designed data models and reporting solutions.

  • Implement best practices for database indexing, query optimization, and data lifecycle management.

  • Support the deployment of data-driven and AI-enabled applications alongside the Data Science & AI Engineering team.

  • Contribute to data quality monitoring, metadata management, and documentation of data sources and transformations.

  • Assist in modernizing legacy reporting workflows and migrating data assets to AWS cloud platforms.

Required Skills & Experience


  • 3–5 years of experience as a Data Engineer , Data Scientist , or Database Developer .

  • Advanced proficiency in SQL and database administration (SQL Server, AWS RDS).

  • Hands-on experience building ETL pipelines with AWS Glue , Lambda , or equivalent tools.

  • Strong experience with Power BI (data modeling, DAX, Power Query, and performance tuning).

  • Familiarity with Python for scripting and automation.

  • Understanding of modern data architectures (star/snowflake schemas, data lakes, and cloud-native data design).

  • Solid grasp of version control (Git) and CI/CD principles for data deployments.

  • Ability to collaborate across technical and business teams to deliver reliable, scalable analytics.


  • Experience handling sensitive data through isolation and anonymization

 

Preferred Qualifications


  • Experience with AWS analytics stack (S3, Glue Data Catalog, Athena, Redshift, or Bedrock).

  • Exposure to data orchestration tools (Airflow, Step Functions, or Databricks Workflows).

  • Familiarity with API-based integrations and data ingestion from SaaS systems (e.g., HubSpot, Unanet, or Salesforce).

  • Strong understanding of data governance , security , and change management within analytics environments.

  • Interest in or exposure to machine learning , AI automation , or predictive analytics workflows.

Tech Stack You’ll Work With


  • Databases: AWS RDS, SQL Server

  • Cloud: AWS (Glue, S3, Lambda, Bedrock, SageMaker)

  • Languages: SQL, Python

  • Analytics: Power BI, AWS QuickSight

  • ETL / Pipelines: AWS Glue, Python scripts, SQL stored procedures

 

Posted 2025-11-07

Recommended Jobs

Sales Development Representative

AwardSpring
Chicago, IL

Company Overview AwardSpring is a growing Software as a Service (SaaS) company that partners with colleges and foundations to simplify scholarship management. Our mission is to help students acces…

View Details
Posted 2025-09-01

Senior engineer

Capital One
Chicago, IL

Do you love building and pioneering in the technology space? Do you enjoy solving complex technical problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital …

View Details
Posted 2025-11-03

Server

Sapori Trattoria
Chicago, IL

At [Your Restaurant Name], we pride ourselves on delivering an exceptional dining experience that blends outstanding cuisine, warm hospitality, and a carefully curated wine program. We’re looking for…

View Details
Posted 2025-11-06

Associate Director, Field Medical Affairs Rare Disease-Bone & Genetic Medicine (Central US states)

Regeneron
America, IL

As an Associate Director, Field Medical Affairs, you will play a pivotal role as a field-based, professional within our General Medicine Rare Disease group. You will deliver both strategic and operat…

View Details
Posted 2025-10-22

Grill- Food & Beverage Worker Point Mallard Golf Course...

Spur Staffing
Decatur, IL

Spur Staffing is looking for a dedicated Grill - Food & Beverage worker committed to providing a clean and fun environment for the Decatur Municipality. Decatur Municipality is seeking a professional…

View Details
Posted 2025-09-29

Sr. Manager, Global IT Procurement

McCain Foods Limited
America, IL

​ Position Title: Sr. Manager, Global IT Procurement Position Type: Regular - Full-Time ​ Position Location: Oakbrook Terrace  Grade: Grade 06 Requisition ID: 37837  ​ ​ In…

View Details
Posted 2025-11-06

Program Manager - CTI Clinical Research

Northwestern Medical Group
Chicago, IL

The salary range for this position is $53.26 - $71.90 (Hourly Rate) Placement within the salary range is dependent on several factors such as relevant work experience and internal equity. For positi…

View Details
Posted 2025-10-30

R-152579 Full-Time Nabisco Merchandiser/Order Writer

Mondelez International
Darien, IL

Join our Mission to Lead the Future of Snacking AT Mondelēz International  Full Time Nabisco Merchandiser/Order Writer  Join our team of Full Time Nabisco Merchandiser/Order Writers and fulfill…

View Details
Posted 2025-11-06

Staff Accountant

MedPro Disposal
Naperville, IL

Company Overview Join the leader transforming healthcare waste management across America. MedPro Disposal is the nation's largest privately-held medical waste management company, serving 35,000+…

View Details
Posted 2025-10-21

Sales lead

US AMRJones Lang LaSalle Americas, Inc.
Chicago, IL

JLL empowers you to shape a brighter way . Our people at JLL and JLL Technologies are shaping the future of real estate for a better world by combining world class services, advisory and techno…

View Details
Posted 2025-11-03