[Remote] Data Engineer
Note: The job is a remote job and is open to candidates in USA. Capgemini is hiring a Data Engineer for a remote contract role. The position will automate a manual, Excel-based monthly data process by building Python and SQL data pipelines, querying Google BigQuery, generating files programmatically, and replacing static Excel outputs with Power BI reports.
Responsibilities
- 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
Skills
- * 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)
- * 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
Benefits
- Medical benefits
- Dental benefits
- Vision benefits
- Retirement benefits
Company Overview
Company H1B Sponsorship