Data Engineer

A-dec Inc.

Newberg (OR)

On-site

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A-dec in Newberg, OR is seeking a Data Engineer to expand and optimize the data pipeline architecture and data warehouse. You will support software developers, data architects, and analysts across multiple teams to improve data flow and accessibility.

Responsibilities include building real-time and batch data integrations, writing complex SQL queries, and designing scalable ETL processes. Collaboration with cross-functional teams is essential to deliver reliable analytics and insights for the

Qualifications

  • Bachelor’s degree in Computer Science or related technical field or equivalent practical experience.
  • 2+ years of experience in Information Technology with a focus on Business Applications, Data Engineering, Data Architecture, Data Analytics and Science.
  • Good understanding of data warehousing and Business Intelligence environments.
  • Excellent problem solving, critical thinking, and communication skills.
  • Experience with distributed source code version control system (e.g. git).
  • Experience with ticketing system (ServiceNow; JIRA etc.).
  • Expertise with Python, databases, and SQL expertise.
  • Strong analytic skills related to working with unstructured datasets.
  • Experience with data pipeline and workflow management tools.

Responsibilities

  • Build both real-time and batch data integrations from disparate source systems into the EDW.
  • Work with data and analytics experts to strive for superior functionality in our data systems.
  • Write complex queries for reporting and the application consumption.
  • Assemble large, complex data sets that meet functional and non-functional business requirements.
  • Design and implement real-time ETL and batch processing of information to support modeling and reporting needs.
  • Provide production support for data integration and transformation pipelines.
  • Scale and tune data pipelines, databases, and SQL queries.
  • Build and maintain data reconciliation processes.
  • Identify trends in data sets and develop algorithms to make raw data more useful.
  • Connect data to users in mixed cloud and on-prem environments.
  • Improve data reliability, efficiency, and quality.
  • Partner with data architect & analysts to support modeling and reporting needs and to build and maintain internal data processing and visualization.
  • Translate requests into replicable analytic reports using varying applications.
  • Create tools to serve data such as APIs and packages.
  • Troubleshoot and provide root cause analysis for database software and data integrity issues

Skills

Python
SQL
Data Warehousing
ETL
Git
BI Tools
JIRA
ServiceNow
Azure Synapse
Unstructured data

Education

Bachelor’s degree in CS or related
2+ years IT/Data experience

Tools

Azure Synapse
SQL databases

Job description

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

The position is responsible for expanding and optimizing the data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The Data Engineer(s) will support our software developers, data architect, and data analysts on data initiatives. You must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. The right candidate will be excited by the prospect of optimizing the company’s data warehouse to support the next generation of products and data initiatives.

Job Duties & Responsibilities

  • Build both real-time and batch data integrations from disparate source systems into the EDW.
  • Work with data and analytics experts to strive for superior functionality in our data systems.
  • Write complex queries for reporting and the application consumption.
  • Assemble large, complex data sets that meet functional and non-functional businessrequirements.
  • Design and implement real-time ETL and batch processing of information to support modelingand reporting needs.
  • Provide production support for data integration and transformation pipelines.
  • Scale and tune data pipelines, databases, and SQL queries.
  • Build and maintain data reconciliation processes.
  • Responsible for finding trends in data sets and developing algorithms to help make raw datamore useful to the enterprise.
  • Connect data to users in mixed cloud and on-prem environments.
  • Identify ways to improve data reliability, efficiency, and quality.
  • Partner with data architect & analysts to support modeling and reporting needs and to build andmaintain internal data processing and visualization.
  • Translate requests into replicable analytic reports using varying applications.
  • Create tools to serve data such as APIs and packages, as needed.
  • Troubleshoot and provide root cause analysis for database software and data integrity issues

Minimum Qualifications

  • Bachelor’s degree in Computer Science or related technical field or equivalent practical experience.
  • 2+ years of experience in Information Technology with a focus on Business Applications, DataEngineering, Data Architecture, Data Analytics and Science.
  • Good understanding of data warehousing and Business Intelligence environments.
  • Excellent problem solving, critical thinking, and communication skills.
  • Experience with distributed source code version control system (e.g. git).
  • Experience with ticketing system (ServiceNow; JIRA etc.).
  • Expertise with Python, databases, and SQL expertise.
  • Strong analytic skills related to working with unstructured datasets.
  • Experience with data pipeline and workflow management tools

Preferred Qualifications

  • Experience with Azure environment such as Synapse, Azure SQL DB, Azure ML Pipeline, Azure DataFactory.
  • Knowledge of machine learning and data science processes.
  • Experience building reports and dashboards using BI tools.
  • Basic knowledge of statistics.
  • Stellar communications skills for requirements gathering

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 law. In 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

A-dec, Inc. (USA) • Newberg (OR)

On-site
USD 110,000 - 150,000
Systems Engineer, Principal
Systems Engineer, Principal

A-dec, Inc. (USA) • Newberg (OR)

On-site
USD 150,000 - 200,000
Supervisor, Warehouse (Shipping/Warehouse - Swing Shift)
Supervisor, Warehouse (Shipping/Warehouse - Swing Shift)

A-dec, Inc. (USA) • Oregon

On-site
USD 70,000 - 110,000
Electrical Engineer, Principal
Electrical Engineer, Principal

A-dec Inc. • Newberg (OR)

On-site
USD 140,000 - 180,000
Manager, Operations
Manager, Operations

A-dec Inc. • Newberg (OR)

On-site
USD 90,000 - 130,000
Woodworker I (Swing Shift)
Woodworker I (Swing Shift)

A-dec, Inc. (USA) • Newberg (OR)

On-site
USD 42,000 - 64,000
Product Manager II (Parts & Services)
Product Manager II (Parts & Services)

A-dec, Inc. (USA) • Newberg (OR)

On-site
USD 95,000 - 135,000
Supervisor, Machining (Swing Shift)
Supervisor, Machining (Swing Shift)

A-dec, Inc. (USA) • Newberg (OR)

On-site
USD 70,000 - 100,000
Maintenance & Reliability Engineer, Sr
Maintenance & Reliability Engineer, Sr

A-dec, Inc. (USA) • Newberg (OR)

On-site
USD 90,000 - 120,000
Manager, Operations
Manager, Operations

A-DEC • Newberg (OR)

On-site
USD 90,000 - 140,000