Data Engineer II

Glidewell Dental•Irvine, CA

2d•$105,332 - $130,000

About The Position

The Data Engineer II is responsible for creating and debugging ETL/ELT packages, stored procedures, views, and functions. This role involves collaborating with data architects and stakeholders to understand data requirements and relationships, defining metrics and calculations, and assisting in the design and development of reports and dashboards. The Data Engineer II will also contribute to the IT Department's business intelligence strategy, maintain process documentation, and collaborate on proof-of-concept projects using Amazon Web Services (AWS).

Requirements

Bachelor’s Degree in Computer Technology required.
Minimum five (5) years of relevant work experience.
Experience in TSQL
Experience in Business Objectives, Data Transformation Services (DTS) /SQL Server Integration Services (SSIS) and 3rd party ETL/ELT tools.
Experience in an open source language such as Python, Java, PHP, or Ruby.
Minimum one (1) year of relevant cloud base technology experience such as Amazon Web Services (AWS).

Responsibilities

Creates and debugs ETL/ELT packages using SQL Server Integration Services (SSIS), Pentaho, or other open-source programs.
Creates, debugs, and optimizes stored procedures, views, and functions.
Collaborates with Data Architect and other stakeholders to understand requirements, relation between various data sets, and frequency of updates.
Defines metrics and calculations along with the corresponding updates to the semantic layer.
Collaborates with the business community to identify, analyze and document data engineer’s needs.
Collaborates with internal team members in the design and development of reports and dashboards for various business units.
Assists in the definition of business intelligence (BI) strategy within the IT Department.
Maintains documentation for data engineer processes and procedures.
Collaborates with team to create proof of concept (POC) using Amazon Web Services (AWS).
Performs other related duties and projects as business needs require at direction of management.