The Data Engineer is responsible for designing, enhancing, and maintaining our organization's data infrastructure including Azure Dedicated SQL Pools, Data Lakes, and traditional on-premise SQL servers. This position designs, builds and manages data pipelines connecting to both on-premise and cloud sources using SSIS as well as Azure Data Factory. The Data Engineer works closely with the Data & Analytics team to ensure that our data infrastructure is efficient, reliable, and scalable.
This Client is committed to employee wellbeing and life-work balance, offering development opportunities, a flexible time-off program, and an industry leading parental leave policy.
Primary Duties & Responsibilities
-Designs, enhances, and maintains Data Warehouse and Data Lake.
-Monitors system performance.
-Designs, enhances, and maintains data pipelines connecting to both on-premise and cloud sources using SSIS as well as Azure Data Factory.
-Develops and maintains documentation for data pipelines and data processing systems.
-Ensures that data quality and data integrity are maintained throughout the data pipeline.
-Collaborates with other technology teams to ensure that our data infrastructure is integrated with other systems and platforms.
-Implements data security and privacy measures to protect sensitive data.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.