Data Engineer

Capgemini; Chicago (IL); Hybrid; USD 57,000 - 90,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Retirement benefits

Job summary

Tundra Technical Solutions in Chicago, IL is seeking a mid-level data engineer to automate a manual, Excel-based monthly data process. You will build the data pipeline and ETL logic in Python to replace CSV exports, perform reference-data lookups, and generate output files programmatically.

The role requires SQL on a cloud data warehouse, Google BigQuery experience, and Power BI to connect live reports. A background in legacy Excel/VBA is a plus.

Qualifications

• Experience building ETL pipelines in Python.
• Comfortable writing and adapting SQL queries against cloud data warehouses.
• Direct experience querying and scheduling extracts from BigQuery.
• Building live Power BI reports to replace static Excel outputs.

Responsibilities

• Automate a manual, Excel-based monthly data process including data extraction, reference-data lookups, and file generation.
• Replace CSV exports and spreadsheet formulas with programmatic outputs.
• Collaborate with stakeholders to ensure accurate data delivery and scheduled reporting.

Skills

Python

SQL

Google BigQuery

Power BI

Job description

Automate a currently manual, Excel-based monthly data process (data extraction, reference-data lookups, and file generation) that today relies on manual CSV exports, spreadsheet formulas, and manual file distribution.

Required technical profile:

• Python (building the data pipeline/ETL logic, replicating spreadsheet lookup and matching logic, and generating output files programmatically)
• SQL(comfortable writing and adapting queries against a cloud data warehouse)
• Google BigQuery(direct experience querying and scheduling extracts from BQ)
• Power BI(building/connecting live reports to replace static Excel outputs)

Nice-to-have:

Familiarity with legacy Excel / VBA processes, since part of the work involves understanding and replacing existing macro-driven logic

Resource: A mid-level data engineer (C1) comfortable working independently across the full stack above (rather than a narrow specialist in just one tool) is likely the best fit.

Duration/urgency: Immediate, Chicagoland resident will be ideal, but anywhere in US who can do a short-term travel will work

The pay range that the employer in good faith reasonably expects to pay for this position is $41.61/hour - $65.01/hour.

• medical
• dental
• vision
• 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 our 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 characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair 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 property, 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 contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.