Data Engineer II

Glidewell Dental; Irvine (CA); On-site; USD 105,332 - 130,000; Full time

Job summary

Glidewell Dental in Irvine, CA seeks a senior Data Engineer to design, implement, and optimize ETL/ELT pipelines using SSIS, Pentaho, and open-source tools. You will develop stored procedures, views, and functions, and collaborate with a Data Architect to translate requirements into robust data solutions.

You will define metrics for semantic layers, support BI reporting, and contribute to AWS-based proof-of-concepts while maintaining thorough documentation.

Qualifications

• Bachelor's Degree in Computer Technology required.
• Minimum five (5) years of relevant work experience in ETL/BI/Data Engineering.
• Experience in TSQL.
• Experience in DTS/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, debugs, and optimizes ETL/ELT packages using SSIS, Pentaho, or other open-source programs.
• Creates, debugs, and optimizes stored procedures, views, and functions.
• Collaborates with Data Architect and stakeholders to understand requirements, relation between various data sets, and frequency of updates.
• Defines metrics and calculations along with updates to the semantic layer.
• Collaborates with the business community to identify 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.

Skills

T-SQL

SSIS

ETL/ELT

Python

Java

AWS

Education

Bachelor's Degree in Computer Technology

Tools

SSIS

Pentaho

Job description

• 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.

Essential Functions

• 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.

Education and Experience

• Bachelor's Degree in Computer Technology required.
• Minimum five (5) years of relevant work experience in the areas below, or any equivalent education and/or experience from which comparable knowledge, skills and abilities have been demonstrated/achieved:
• 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).

Pay Range: $105,332.19 - 130,000.00/yr