Data Engineer II

James R. Glidewell, Dental Ceramics, Inc.
Irvine, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior
Compensation
$ 130K

Job location

Irvine, United States of America

Tech stack

Java
PHP
Amazon Web Services (AWS)
Data Architecture
ETL
Data Transformation Services
Document-Oriented Databases
Python
Open Source Technology
Pentaho Data Integration
Ruby
SQL Stored Procedures
SQL Server Integration Services
T-SQL
Information Technology

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.

Requirements

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

About the company

Glidewell Laboratories is the industry leader in dental technology due to our agility, speed, and cutting edge technology. We work in a fast-paced and highly sought-after employee-friendly work environment. Behind all of this success is an amazing group of people who are passionate about bringing innovation to the marketplace, while providing quality and affordability to better the lives of people all over the world. If you share in our passion for teamwork and a vision for excellence, let's talk about a rewarding career at Glidewell! In addition are the following generous employee benefits: Medical, Dental, Vision, 401K with company match, company-paid life insurance, additional onsite dental services, vacation, holiday, and sick time, employee gym (with fitness classes and meditation room), employee medical/wellness center (with massage therapy and acupuncture), two company subsidized cafes, Internet cafes, employee lounges with big screen TVs, game tables, fun company sponsored events, a diverse work environment with over forty nationalities represented, and much more!

Apply for this position