Staff Data Engineer: Data Warehousing & Pipelines Lead

A-dec, Inc. (USA); Newberg (OR); On-site; USD 120,000 - 180,000; Full time

Job summary

A-dec, Inc. in Newberg, Oregon seeks a Staff Data Engineer to independently plan and lead data, analytics, and BI projects. You will develop data models, maintain our data warehouse, and build scalable pipelines across sources to support analytics needs.

Responsibilities include designing multi-tenant data systems, ensuring data quality and security, and collaborating with Data & Analytics and other teams to meet requirements with robust, well-documented code.

Qualifications

• Experience with SQL, data warehousing, and BI tools.
• Ability to learn and troubleshoot on the job.
• Experience with APIs to move data between systems.
• Strong collaboration and communication skills.

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.

Skills

SQL

Data Warehousing

Python

Data Lakes

ETL

BI

APIs

Version Control

Education

BS degree or equivalent

Tools

Azure

Snowflake

Databricks

Job description

A-dec, Inc. in Newberg, Oregon seeks a Staff Data Engineer to independently plan and lead data, analytics, and BI projects. You will develop data models, maintain our data warehouse, and build scalable pipelines across sources to support analytics needs.

Responsibilities include designing multi-tenant data systems, ensuring data quality and security, and collaborating with Data & Analytics and other teams to meet requirements with robust, well-documented code.