[C]-Data Engineer Level 4

V R Della Infotech•Boston, MA

About The Position

The ETL Developer / Data Engineer will expand and optimize data and data-pipeline architecture, improve data flow and collection, and maintain or enhance data architecture in new and existing systems, including data warehouses. The role focuses on building and optimizing data pipelines and supporting data scientists and business stakeholders with suitable data solutions. The position also covers ETL and data-transformation testing, data-model development for data mining, source-to-target and process-flow documentation, and monitoring and troubleshooting ETL processes and jobs. The hire may also take on SQL Server DBA responsibilities, including processes, job and error handling, troubleshooting, and scheduling. The role is listed as a six-month contract with potential to extend. Locations listed are Hudson, MA (preferred), Houston, Boston, or remote; hybrid flexibility may be available for local candidates based on business requirements.

Requirements

Bachelor's degree in computer science or information technology from an accredited institution.
Hands-on experience in a data warehouse testing role.
Experience with ETL and operational data stores (ODS).
At least 3 years of experience with Azure Data Factory (ADF), including exposure to API sources.
At least 4 years of SQL experience, including advanced SQL and query authoring with relational databases, plus working familiarity with a variety of databases.
Working knowledge of Azure.
Proficiency with Azure Managed MS SQL Server databases, including indexes, database security, and backups.
At least 3 years of data testing experience.
At least 2 years of data warehouse testing experience.
Python skills, including data frames and NumPy and pandas libraries.
At least 2 years of C# experience.
At least 1 year of Microsoft Fabric experience.
Ability to develop Azure Logic Apps and Azure Functions in C#.
Experience with data duality, source-system analysis, and business-rules validation.
Ability to write and understand source-to-target documentation.
Detail-oriented and meticulous approach to work.
Good analytical skills.
Ability to work independently and collaboratively.
Ability to manage a pipeline of duties with minimal supervision.

Nice To Haves

Commercial real estate experience.
Familiarity with data and cybersecurity.
Python is also listed under the good-to-have qualifications.

Responsibilities

Maintain and enhance data architecture within new and existing systems, including data warehouses.
Recommend and implement processes to improve data quality, reliability, and database performance.
Use ETL and integration tools for system and data integrations.
Architect solutions that support data scientists and business stakeholders.
Conduct ETL and data-transformation testing.
Develop data models for the data science team to use for data mining.
Maintain source-to-target and process-flow documentation.
Handle DBMS responsibilities, including ETL operations and SQL Server DBA processes such as job and error handling, troubleshooting, and scheduling.
Proactively monitor ETL processes and jobs.
Keep data separated and secure.