Data Engineer, Staff

At A-dec we do more than create the highest quality products and services for the dental industry; we strive to deliver a superior employment experience for each of our team members. With an environment that encourages and assists each person in developing to their highest potential a career at A-dec is incredibly rewarding.

Overview

JOB DUTIES AND RESPONSIBILITIES:

• Designs and builds multi-tenant systems capable of loading and transforming large volumes of structured and semi-structured fast-moving data.
• Works with Program and Project Managers to understand the features do technical assessment design code test and deliver.
• Defines and manages SLAs and data quality for datasets and processes.
• Designs implements tests deploys and maintains stable secure and scalable data engineering solutions and pipelines in support of data and analytics projects including integrating new sources of data into our central data warehouse and moving data out to applications.
• Independently works on a wide range of complex problems that require new approaches through adaptation and modification of standard data analytics and BI principles theories techniques and procedures providing solutions that are imaginative thorough and practical.
• Develops new and varied solutions to data analytics and BI projects and contributes to the value of program solutions by studying industry best practices seeking to understand and validate internal customer needs and supporting line of site of program execution to business impacting.
• Performs one-off data manipulation/munging and analysis on a wide variety organizing data.
• Implements and monitors best in class security measures in our data warehouse and analytics environment with an eye towards the evolving threat landscape.
• Analyzes data analytics and BI problems to determine suitable solutions. Establishes and coordinates design reviews with peers and project leads. Responsible for organizing data and preparing documentation for assigned projects.
• Responsible for thoroughly testing their data analytics and BI solutions coordinating others on data analytics and BI verification tests and testing peer data analytics and BI solutions when necessary.
• Most work examined at a higher level. Actual supervision received may be minimal or moderate depending upon project complexity. Closer supervision given on new aspects of assignments.

QUALIFICATIONS:

Knowledge Skills and Abilities

• Strong command of best practices applied in relational databases and SQL as well as Extract Transform and Load (ETL) data into a relational database.
• Deep understanding Data Warehousing Date Lakes Date Pipelines and Business Intelligence Applications.
• Ability to interpret moderately complex data analytics and BI requirements and apply data analytics and BI design methodologies.
• General data manipulation skills: read in data process and clean it transform and recode it merge different data sets together reformat data between wide and long etc.
• Ability to learn new techniques and troubleshoot code without support in other words be able to learn on the job.
• Use APIs to push and pull data from various data systems and platforms.
• Ability to write clear code that is well-documented and stored in a version control system.
• Proficient with Python databases and SQL expertise.
• Proven ability to work both independently and collaboratively within a team environment while following established procedures.
• Excellent listening interpersonal communication and problem-solving skills.

Education and Experience

• At least ten years of relevant data analytics and BI engineering experience
• BS degree in related field or equivalent work experience

Preferred Qualifications

• Experience with Azure environment
• Experience developing cloud data warehouses (e.g. Snowflake or Databricks)
• Experience with lambda and kappa architectures
• Experience with iPaaS platforms and other no-code/low-code platforms

Disclaimer

This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not to be construed as a comprehensive inventory of all duties responsibilities and qualifications required of employees assigned to this job. A-dec reserves the right to assign job duties and days and hours of work based on factors such as workload requirements staffing levels and customer demands.

At A-dec we value our people and show it by prioritizing an inclusive culture total well-being and opportunities for learning and career advancement.

A background check and screen for the illegal use of drugs is required.

A-dec is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race color religion sex national origin disability status protected veteran status or any other characteristic protected by addition A-dec will not discriminate against applicants because they have inquired about discussed or disclosed their own pay or the pay of another. *VEVRAA Federal Contractor

A-dec is interested in qualified candidates authorized to work in the United States for US-based positions. We are unable to sponsor or take over sponsorship of employment visas.