Data Engineer - 100% Remote

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

Job summary

A leading company in data solutions is seeking a software engineer/developer with expertise in ETL and big data integration. This role involves supporting data processing, transformation, and distribution while working closely with stakeholders to develop scalable solutions. Candidates should be skilled in Python, SQL, and familiar with database technologies like Oracle and SQL Server. Join a team that values problem-solving and innovation in data management.

Qualifications

• Experience with programming languages like Python, SQL, PLSQL, and VB.
• Proficient in database platforms (Oracle, SQL Server, MySQL).
• Familiar with big data concepts and technologies.

Responsibilities

• Support data ingestion, transformation, and distribution to end consumers.
• Design and develop ETL processes for data transformation.
• Work with Business Intelligence team on data architecture.

Skills

Python

SQL

PLSQL

VB

Data processing

Data transformation

Cloud technologies

Strong interpersonal and communication skills

Tools

Oracle

SQL Server

MySQL

Azure SQL Server

Databricks

Synapse

Job description

We are seeking a software engineer/developer or ETL/data integration/big data developer with experience in projects emphasizing data processing and storage.

This person will be responsible for supporting the data ingestion, transformation, and distribution to end consumers. Candidate will perform requirements analysis, design/develop process flow, unit and integration tests, and create/update process documentation.

The Opportunity:

We are seeking a software engineer/developer or ETL/data integration/big data developer with experience in projects emphasizing data processing and storage.

This person will be responsible for supporting the data ingestion, transformation, and distribution to end consumers. Candidate will perform requirements analysis, design/develop process flow, unit and integration tests, and create/update process documentation.

• Work with the Business Intelligence team and operational stakeholders to design and implement both the data presentation layer available to the user community, as well as the underlying technical architecture of the data warehousing environment.
• 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.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
• Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake
• Uses additional cloud technologies (e.g., understands concept of Cloud services like Azure SQL server)
• 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.
• Manage multiple projects, responsibilities and competing priorities.

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 Synapse & Databricks