Data Engineer Production Support REMOTE

ContractStaffingRecruiters.com; Hartford (CT); Remote; USD 80,000 - 110,000; Full time

Job summary

A leading company in data solutions is looking for a skilled Software Engineer or ETL Developer to join their Production Support team. This role focuses on supporting the ingestion, transformation, and distribution of data, involving problem-solving and communication across teams. The ideal candidate will have experience with Python, SQL, and various database platforms, along with the ability to analyze and resolve issues effectively.

Qualifications

• Experience with Python, SQL, and ETL processes.
• Understanding of Oracle and other database platforms.
• Big Data technologies like Azure Synapse & Databricks are a plus.

Responsibilities

• Monitor pipelines and troubleshoot issues in real time.
• Develop scalable data solutions and design database objects.
• Identify process improvement opportunities.

Skills

Problem Solving

Communication

Interpersonal Skills

SQL

Python

PLSQL

VB

Big Data

Tools

Oracle

SQL Server

MySQL

Azure Synapse

Databricks

SAP Business Objects

Cisco Tidal

SAP ABAP

Job description

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

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 languages, 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