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.
Data Architect - 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/ (https://www.usconcealedcarry.com/)
Join us as a Data Architect 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.
At Delta Defense, you'll find an environment that encourages growth, innovation, and the pursuit of excellence. Join us, and be part of a mission-driven community where your contributions have life saving impact and your development matters.
Data Architect - 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.
Data Architect - 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.
Why YOU should Work at Delta Defense!
- We are a fun, fast-paced, and rewarding place to work and grow!
- Nationally recognized in 2025 as number 25 on The Wall Street Journal Top 100 list of America's Most Loved Workplaces
- Nationally recognized in 2023 and 2024 as a Newsweek Top 100 America’s Most Loved Workplace
- Named on Inc. 5000 “Fastest Growing Private Companies” list 14 years in a row!
- Top Workplaces USA award in 2022!
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.
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.
Benefits information can be reviewed at: https://www.deltadefense.com/careers (https://www.deltadefense.com/careers)
PM19
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 (https://www.eeoc.gov/poster) notice from the Department of Labor.
