Data Architect - West Bend, WI with Hybrid Option Available

Why This Role Matters To You

Work for Delta Defense, the private company that provides Marketing, Operations and Customer Service for the U.S. Concealed Carry Association. The USCCA safeguards life, freedom, and finances for responsible American protectors. Learn more about the USCCA at https://www.usconcealedcarry.com/.

Primary 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.

Benefits

Benefits information can be reviewed at: https://www.deltadefense.com/careers

Work Schedule

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.