Data Engineer II

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 #J-18808-Ljbffr Glidewell Dental