Data Architect - West Bend, WI with Hybrid Option Available
Delta Defense, West Bend, WI, United States
Data Architect - West Bend, WI with Hybrid Option Available
Job Category : Business Analytics
Requisition Number : DATAA001900
Posted : December 12, 2025
Full-Time
Locations
Showing 1 location
This position is based at our corporate headquarters in West Bend, Wisconsin and allows for a hybrid work schedule with a minimum of
3 days per week in office .
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Join us as a
Data Architec t on the Enterprise Data Warehouse Team, where you will play a hands‑on role in shaping and building the new EDW 2.0 built on modern cloud‑based data platforms dbt and Snowflake. Primary responsibilities include designing the Data Vault and Dimensional Data Warehouse data models along with developing the dbt data pipelines that transform raw data into enterprise grade data products, powering self‑service Business Intelligence, Advanced Analytics and AI initiatives.
As a qualified candidate, your key experiences include demonstrable hands‑on Dimensional Data Modeling (Kimaball), Analytics / Data Engineering, advanced SQL skills and experience building and using dimensionally modeled Enterprise Data Warehouses.
Essential Duties and Responsibilities
Design
EDW Data Vault and Dimensional Data Warehouse data models using SqlDBM.
Collaborate
with Advanced Analytics, IT and Business Teams to gather data requirements and translate them into conceptual, logical and physical data models.
Engineer
data pipelines to transform complex and disparate data sources that powers the EDW.
Provide technical guidance and mentorship
to help develop and upskill the EDW Team along with fostering a collaborative and supportive environment.
Become a subject matter expert in multiple business processes and subject areas.
Required Skills/Experience
High school diploma or equivalent required.
Bachelor’s degree preferred in Computer Science, Information Management, Data Science/Analytics, statistics, or equivalent relevant experience.
Dimensional Data Modeling (star schemas) experience required.
5+ years of experience in Data Engineering and/or Business Intelligence roles.
Experience developing data pipelines / ETL jobs for Enterprise Data Warehouse.
5+ years of SQL experience including complex data transformations.
1+ years dbt experience preferred.
Modern cloud database experience with platforms like Snowflake.
Modern Business Intelligence experience with platforms like Tableau or Sigma.
Demonstrates the Core Values of Delta Defense, LLC.
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr
Job Category : Business Analytics
Requisition Number : DATAA001900
Posted : December 12, 2025
Full-Time
Locations
Showing 1 location
This position is based at our corporate headquarters in West Bend, Wisconsin and allows for a hybrid work schedule with a minimum of
3 days per week in office .
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Join us as a
Data Architec t on the Enterprise Data Warehouse Team, where you will play a hands‑on role in shaping and building the new EDW 2.0 built on modern cloud‑based data platforms dbt and Snowflake. Primary responsibilities include designing the Data Vault and Dimensional Data Warehouse data models along with developing the dbt data pipelines that transform raw data into enterprise grade data products, powering self‑service Business Intelligence, Advanced Analytics and AI initiatives.
As a qualified candidate, your key experiences include demonstrable hands‑on Dimensional Data Modeling (Kimaball), Analytics / Data Engineering, advanced SQL skills and experience building and using dimensionally modeled Enterprise Data Warehouses.
Essential Duties and Responsibilities
Design
EDW Data Vault and Dimensional Data Warehouse data models using SqlDBM.
Collaborate
with Advanced Analytics, IT and Business Teams to gather data requirements and translate them into conceptual, logical and physical data models.
Engineer
data pipelines to transform complex and disparate data sources that powers the EDW.
Provide technical guidance and mentorship
to help develop and upskill the EDW Team along with fostering a collaborative and supportive environment.
Become a subject matter expert in multiple business processes and subject areas.
Required Skills/Experience
High school diploma or equivalent required.
Bachelor’s degree preferred in Computer Science, Information Management, Data Science/Analytics, statistics, or equivalent relevant experience.
Dimensional Data Modeling (star schemas) experience required.
5+ years of experience in Data Engineering and/or Business Intelligence roles.
Experience developing data pipelines / ETL jobs for Enterprise Data Warehouse.
5+ years of SQL experience including complex data transformations.
1+ years dbt experience preferred.
Modern cloud database experience with platforms like Snowflake.
Modern Business Intelligence experience with platforms like Tableau or Sigma.
Demonstrates the Core Values of Delta Defense, LLC.
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr