Data Engineer/Data Operations Engineer

LorganTech Solutions LLC
Chicago, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 125K

Job location

Chicago, United States of America

Tech stack

Airflow
Google BigQuery
Cloud Database
Continuous Integration
Data Validation
Information Engineering
Data Integration
ETL
Data Systems
Data Warehousing
Database Development
Software Debugging
Python
Nagios
Operational Databases
DataOps
SQL Databases
Talend
Data Processing
Google Cloud Platform
Software Troubleshooting
Control M

Job description

We are seeking a highly motivated Data Operations Engineer / Data Integration Engineer to join our team supporting a large-scale enterprise data platform The ideal candidate will have strong experience in cloud-based data engineering, SQL development, ETL/ELT integration, and production support within a 24x7 mission-critical environment., * Design, develop, and maintain enterprise data integration pipelines

  • Build and optimize SQL queries for high-performance data processing
  • Develop and maintain ETL/ELT workflows using Talend or dbt
  • Debug production pipeline failures.
  • Support and monitor production data pipelines in a 24x7 operational environment
  • Troubleshoot production issues and perform root cause analysis
  • Collaborate with business users, architects, and cross-functional teams to deliver data solutions
  • Ensure data quality, integrity, and reliability across enterprise systems
  • Participate in production releases, incident management, and operational improvements
  • Document technical solutions and operational procedures

Requirements

  • 5-7 years of Data Engineering/Data Operations/Data Integration experience
  • Expert-level SQL
  • Talend or dbt
  • GCP (Preferred) or AWS
  • GCP Big query
  • Python
  • Experience supporting 24x7 production environments
  • Excellent communication, articulation, and presentation skills, This role requires excellent analytical skills, strong communication abilities, and the capability to work closely with business and technical stakeholders., * 5-7 years of experience in Data Engineering, Data Operations, or Data Integration
  • Strong expertise in SQL (mandatory)
  • Hands-on experience with Talend or dbt for data integration and transformation
  • Experience with Google Cloud Platform (GCP) with Big Query.
  • Good working knowledge of Python for data processing and automation
  • Experience supporting 24x7 production environments
  • Strong troubleshooting and root cause analysis skills
  • Experience monitoring, maintaining, and optimizing production data pipelines
  • Familiarity with data quality, data validation, and operational support processes
  • Understanding of ETL/ELT concepts and enterprise data warehouse environments

Preferred Qualifications

  • Experience working in Agile/Scrum environments
  • Exposure to CI/CD and deployment processes
  • Knowledge of scheduling and orchestration tools (Airflow, Control-M, etc.) is a plus
  • Experience with monitoring and alerting tools is preferred, * Excellent verbal and written communication skills
  • Strong presentation and stakeholder management skills
  • Ability to clearly articulate technical concepts to both technical and non-technical audiences
  • Self-driven, proactive, and able to work independently in a fast-paced environment
  • Strong problem-solving and analytical abilities

Benefits & conditions

Pay: Up to $60.00 per hour

Apply for this position