- Glidewell Dental
- Irvine, CA
- Full-Time
- 82 days ago
- $105,332.19 – $130,000
Data Engineer II.
Before you go
Before you leave us, sign up for our email alerts
We don't do job spam, just the best digital jobs delivered straight to your inbox.
Data Engineer II: our view in 3 lines...
- The Role:This role is for a data engineer focused on ETL and ELT development, SQL-based data work, and business intelligence support.
- The Person:The person will build and debug ETL and ELT packages, optimize stored procedures and views, support report and dashboard development, maintain documentation, and help create AWS proof of concepts.
- Requirements:The ideal candidate has experience in TSQL, SQL Server Integration Services (SSIS), 3rd party ETL/ELT tools, an open source language such as Python, Java, PHP, or Ruby, and Amazon Web Services (AWS).
About the role
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
