Glidewell Dental
Description
Position at Glidewell Dental
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 team in the design and development of reports and dashboards for various business units. Collaborates with and provides recommendations to senior team members regarding business intelligence (BI) strategy within the IT Department. Maintains and updates documentation for data engineer processes and procedures. Creates proof of concept (POC) using Amazon Web Services (AWS). Identifies and implements transformation and/or conversions necessary to provide consistent and usable data. Implements AWS services to improve ETL/ELT efficiency and/or real time reporting. Provides support and training to internal team members. Performs other related duties and projects as business needs require at direction of management. Education and Experience:
Bachelor's Degree in Computer Technology is required. Minimum eight (8) 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: Expertise in data ingestion from major carriers (UPS, FedEx, USPS, DHL, Canada Post,etc.) and TMS application data into the Data Lake/Warehouse Understanding of logistics and transportation application integration Experience in TSQL. Experience in using reporting tools such as Crystal, Tableau, Power BI, or SSRS. 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. Experience using cloud based technologies (ex:AWS). Microsoft Certification a plus. AWS certification a plus.
Pay Range: $50.00 to $74.00/hr
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!
Glidewell Laboratories is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. We are committed to the principle of equal employment opportunity for all employees and to provide employees with a work environment free of discrimination and harassment on the basis of race, color, religion, national origin, sex, age, physical or mental disability, veteran status, sexual orientation, gender identity, genetic information, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [email protected]. Please indicate the specifics of the assistance needed.
Note to Current employees: Please apply through Employee Transfer Application to complete the transfer request form.
Position at Glidewell Dental
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 team in the design and development of reports and dashboards for various business units. Collaborates with and provides recommendations to senior team members regarding business intelligence (BI) strategy within the IT Department. Maintains and updates documentation for data engineer processes and procedures. Creates proof of concept (POC) using Amazon Web Services (AWS). Identifies and implements transformation and/or conversions necessary to provide consistent and usable data. Implements AWS services to improve ETL/ELT efficiency and/or real time reporting. Provides support and training to internal team members. Performs other related duties and projects as business needs require at direction of management. Education and Experience:
Bachelor's Degree in Computer Technology is required. Minimum eight (8) 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: Expertise in data ingestion from major carriers (UPS, FedEx, USPS, DHL, Canada Post,etc.) and TMS application data into the Data Lake/Warehouse Understanding of logistics and transportation application integration Experience in TSQL. Experience in using reporting tools such as Crystal, Tableau, Power BI, or SSRS. 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. Experience using cloud based technologies (ex:AWS). Microsoft Certification a plus. AWS certification a plus.
Pay Range: $50.00 to $74.00/hr
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!
Glidewell Laboratories is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. We are committed to the principle of equal employment opportunity for all employees and to provide employees with a work environment free of discrimination and harassment on the basis of race, color, religion, national origin, sex, age, physical or mental disability, veteran status, sexual orientation, gender identity, genetic information, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [email protected]. Please indicate the specifics of the assistance needed.
Note to Current employees: Please apply through Employee Transfer Application to complete the transfer request form.