Data Engineer (Production Support) - REMOTE

ZipRecruiter; Hartford (CT); Remote; USD 85,000 - 120,000; Full time

Job summary

A leading company is seeking a Data Engineer (Production Support) to join their team in Hartford. The ideal candidate will focus on monitoring and troubleshooting data pipelines and development of ETL processes, ensuring data is accurately ingested and transformed. Strong programming skills, particularly in Python and SQL, are essential, along with knowledge of big data technologies. This role offers an engaging environment where you can contribute to technical problem-solving and process improvement efforts.

Qualifications

• Experience with Python, SQL, and big data technologies required.
• Ability to independently analyze and resolve issues in real time.
• Experience with Oracle, SQL Server, MySQL, and SAP tools is a plus.

Responsibilities

• Monitor pipelines and troubleshoot issues in real time.
• Support data ingestion, transformation, and distribution to end consumers.
• Develop reliable data solutions and maintain comprehensive documentation.

Skills

Python

SQL

PLSQL

VB

Big Data Concepts

Interpersonal Skills

Communication Skills

Tools

Oracle

SQL Server

MySQL

Azure Synapse

Databricks

SAP Business Objects

Cisco Tidal

SAP ABAP

Job description

Job DescriptionJob Description

Data Engineer (Production Support)

This is a support focused role meaning little to no new development. Resource will conduct daily monitoring of pipelines and troubleshooting of any issues, monitor ServiceNow queue and addressing tickets, etc.

The Opportunity:

We are seeking a software engineer or ETL/data integration/big data developer to join our production support team.

This person will be responsible for supporting the ingestion, transformation, and distribution of data to end consumers.

Candidate will also perform analysis, troubleshooting, and resolution of issues reported by end users.

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

• Solve problems by identifying bugs and root-cause analysis.
• Work with internal development and operations team to escalate issues.
• Monitor production activities/processes to ensure timely and effective reporting, tracking, follow-up, and communication for related incidents.
• Identifying process improvement opportunities.

Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes.

Design and develop database objects, tables, stored procedures, views, etc.

Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases

Create/update/maintain comprehensive documentation.

Aptitude to learn new technologies and the ability to perform continuous research, analysis, and process improvement.

Strong interpersonal and communication skills to be able to work in a team environment to include customer and contractor technical, end users, and management team members.

Experience Needed:

Programming , frameworks, and file formats such as: Python, SQL, PLSQL, and VB

Database platforms such as: Oracle, SQL Server, MySQL

Big data concepts and technologies, such as: Azure Synapse & Databricks

SAP experience with the Business Objects toolset, Cisco Tidal scheduler, and SAP ABAP programming a plus