Data Engineer (Production Support) - 8pm to 4am and weekends - Remote

ContractStaffingRecruiters.com; Branford (CT); Remote; USD 90,000 - 120,000; Full time

Job summary

ContractStaffingRecruiters.com is looking for a software engineer or ETL/data integration/big data developer to join a production support team. This role involves supporting the ingestion, transformation, and distribution of data, with responsibilities including real-time issue resolution and the development of scalable data solutions.

Successful candidates will possess strong programming skills in Python, SQL, and PL/SQL, along with familiarity in Oracle and MySQL databases. The position requires availability for off-hours and weekend support.

Qualifications

• Experience with data ingestion, transformation, and distribution.
• Strong analytical skills to troubleshoot and resolve issues.
• Ability to work on off-hours and weekend support.

Responsibilities

• Analyze, solve, and correct issues in real time.
• Develop scalable data solutions from multiple sources.
• Design ETL processes for data transformation.

Skills

Python

SQL

PL/SQL

Oracle

SQL Server

MySQL

Big data technologies

Tools

Fivetran HVR

Business Objects

Cisco Tidal scheduler

SAP ABAP

Job description

Remote

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. This role requires off-hours and weekend support. Schedule TBD. Candidate will also perform analysis, troubleshooting, and resolution of issues reported by end users.

Responsibilities

• 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 expedite issues. Monitor production activities/processes to ensure timely and effective reporting, tracking, follow-up, and communication for related incidents. Identify 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, Excel spreadsheets into SQL databases.
• Create/update/maintain comprehensive documentation.
• Aptitude to learn new technologies and 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, PL/SQL
• Database platforms such as: Oracle, SQL Server, MySQL
• Big data concepts and technologies, such as: Synapse, Databricks
• Experience with Fivetran HVR, the Business Objects toolset, Cisco Tidal scheduler, and SAP ABAP programming a plus