Data Engineer: Real-Time Pipelines & Data Warehouse

A-dec Inc.; Newberg, Northern (OR, KY); Hybrid; USD 100,000 - 140,000; Full time

Job summary

A-dec in Newberg, OR is seeking a Data Engineer to expand and optimize our data warehouse and data pipelines across multiple teams. You will develop real-time and batch integrations, write advanced SQL queries, and support analytics and reporting.

Join a collaborative environment where you can influence data architecture, build APIs, and ensure data quality while aligning with cross-functional stakeholders and product initiatives.

Qualifications

• Bachelor's degree in Computer Science or related field or equivalent practical experience.
• 2+ years of experience in Information Technology with a focus on Data Engineering, Data Architecture, Data Analytics and Science.
• Good understanding of data warehousing and Business Intelligence environments.
• Experience with Python, databases, and SQL expertise.

Responsibilities

• Build both real-time and batch data integrations from disparate source systems into the EDW.
• 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 ways to improve data reliability, efficiency, and quality.

Skills

Python

SQL

Data warehousing

ETL

Education

Bachelor's degree in Computer Science or related field

Tools

Git

ServiceNow

JIRA

Azure Synapse

Azure Data Factory

Azure SQL DB

Job description

A-dec in Newberg, OR is seeking a Data Engineer to expand and optimize our data warehouse and data pipelines across multiple teams. You will develop real-time and batch integrations, write advanced SQL queries, and support analytics and reporting.

Join a collaborative environment where you can influence data architecture, build APIs, and ensure data quality while aligning with cross-functional stakeholders and product initiatives.