Data Warehouse Architect for BI & Analytics

Blattner

Avon (MN)

On-site

USD 101,000 - 146,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

HDHP insurance

401(k) match

HSA

Dental & Vision

Education Assistance

Work/Life Balance

On-site Gym

Job summary

Blattner in Avon, MN seeks a Senior Data Engineer specializing in Data Warehouse and Analytics to design, implement, and optimize database solutions supporting BI and analytics initiatives. You will architect data warehouse solutions, ensure data integrity, optimize performance, and support analytics teams in extracting meaningful insights from data.

This role serves as SME for data and analytics, collaborates with IT and business partners, builds ETL/ELT pipelines with MS SQL and Azure Data

Qualifications

Bachelor's degree in a technology area; MIS/Analytics preferred.
5–8 years of database development focusing on data warehouse design and optimization.
Experience in ETL/ELT, data cleansing, data loading, data dictionaries, and SQL optimization.

Responsibilities

Designs, develops and optimizes ETL/ELT solutions using data warehouse design best practices for MS SQL and Azure Data Factory ETL/ELT solutions.
Analyzes data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming, and loading the data into the data staging, warehouse, and other system integration projects.
Analyzes business requirements and outlines solutions.
Provides technical assistance in identifying, evaluating, and developing systems and procedures.
Builds custom reports and business dashboards utilizing BI tools like Power BI, Tableau, and other industry leading tools.