Data Engineer - Hybrid - Farmington, CT

ContractStaffingRecruiters.com; Farmington (CT); On-site; USD 80,000 - 120,000; Full time

Job summary

ContractStaffingRecruiters.com is seeking a Data Engineer in Farmington, CT who will develop scalable solutions for complex data processing. The successful candidate will support data ingestion and transformation, alongside responsibilities in designing ETL processes and database objects.

Key qualifications include experience with programming languages such as Python and SQL, familiarity with AWS/Azure cloud computing, and strong interpersonal skills for team collaboration.

Qualifications

• Experience in programming languages, frameworks, and file formats such as Python, SQL, PL/SQL, DBT.
• Familiarity with database platforms such as Oracle, SQL Server, MySQL.
• Knowledge of big data technologies like Synapse and Databricks.
• Experience with AWS and Azure cloud computing.

Responsibilities

• Develop scalable and reliable data solutions for real-time and batch processing.
• Design and develop ETL processes for transforming various data formats into SQL databases.
• Maintain comprehensive project documentation.
• Manage multiple projects, responsibilities, and competing priorities.

Skills

Python

SQL

PL/SQL

DBT

Oracle

SQL Server

MySQL

AWS

Azure

Big data concepts

Cloud technologies

Job description

We are seeking a Data Engineer with experience in projects emphasizing complex data solutions. This person will be responsible for supporting the data ingestion, transformation, and distribution to end consumers. The candidate will perform requirements analysis, design/develop process flow, and unit/integration testing, to deliver complex data products. 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.

Key Responsibilities

• 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, and XLS spreadsheets into SQL databases.
• Understand the concept of data marts and data lakes and experience with migrating legacy systems to data marts/lakes.
• Use additional cloud technologies (e.g., understanding the concept of cloud services like Azure SQL Server).
• Maintain comprehensive project 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 with customers, contractors, 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, PL/SQL, DBT.
• Database platforms such as Oracle, SQL Server, MySQL.
• Big data concepts and technologies such as Synapse and Databricks.
• AWS and Azure cloud computing.