Data Integration Engineer — On-Site LA | Automation

Over J Consulting; Los Angeles (CA); Vor Ort; USD 95.000 - 118.000; Vollzeit

Zusammenfassung

Over J Consulting in Los Angeles is seeking a hands-on Data Integration Engineer to understand current processes, build solutions, and support data workflows for utility and infrastructure clients. You will join a small delivery team, report to the CEO, work with analysts and engineers, and be responsible for end-to-end data integration, scripting, testing, and documentation.

The role requires independent execution, strong communication, and ability to meet in-person schedule at Downtown Los

Qualifikationen

• Five years of relevant professional experience in data integration or data engineering.
• Practical Python experience, including reading, debugging, modifying and testing existing code.
• Strong SQL skills including joins, data types, null handling, duplicate detection, validation and reconciliation.
• Advanced Excel skills and experience creating repeatable transformations with Power Query or an equivalent tool.
• Practical experience connecting systems or moving data through APIs, database connections or automated file transfers.
• Personal delivery of at least two operational integrations or automations, including an inherited workflow you improved and supported.
• Experience using Git or equivalent version control, testing changes and documenting work for others.
• Ability to independently execute scoped work, ask precise questions, communicate issues early and respond constructively to review.
• Current residence within a reasonable commuting distance of Downtown Los Angeles and the ability to meet the required in-person schedule.

Aufgaben

• Analyze existing spreadsheets, scripts, databases and workflows. Trace where information comes from, how it is transformed and how people use the output.
• Diagnose inherited processes, identify dependencies and failure points, and make controlled improvements while preserving approved business rules.
• Write and maintain Python scripts, SQL queries and Excel or Power Query transformations to combine, clean, map and reconcile data from different sources.
• Connect approved systems using APIs, database connections or automated file transfers. Address authentication, changing data structures, retries, duplicate records and incomplete runs.
• Identify missing, invalid, conflicting, stale or misidentified data. Document exceptions and work with the appropriate business or engineering owner to resolve them.
• Test changes, reconcile inputs to outputs and use version control so work is repeatable and maintainable.
• Document setup, dependencies, data definitions, operating steps, quality checks and recovery procedures so another colleague can run and support the workflow.
• Explain findings, limitations and recommendations clearly. Lead focused client reviews to clarify questions, discuss tradeoffs and agree on next steps.
• Coordinate with Engineering, Operations and IT. Raise unresolved business rules, delivery risks and capacity concerns early. Route engineering decisions to the appropriate technical authority.

Kenntnisse

Python

SQL

Excel/Power Query

Git

APIs

Data integration

Automation

Ausbildung

Relevant degree

Jobbeschreibung

Over J Consulting in Los Angeles is seeking a hands-on Data Integration Engineer to understand current processes, build solutions, and support data workflows for utility and infrastructure clients. You will join a small delivery team, report to the CEO, work with analysts and engineers, and be responsible for end-to-end data integration, scripting, testing, and documentation.

The role requires independent execution, strong communication, and ability to meet in-person schedule at Downtown Los