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/
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
PM19
Equal Opportunity EmployerThis 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.
Skills Required
- High school diploma or equivalent
- Bachelor's degree in Computer Science, Information Management, Data Science/Analytics, statistics, or equivalent relevant experience
- Dimensional Data Modeling (star schemas / Kimball) experience
- 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
- Modern cloud database experience with platforms like Snowflake
- Modern Business Intelligence experience with platforms like Tableau or Sigma
- Design EDW Data Vault and dimensional data warehouse models using SqlDBM
- Authorization to work for any employer in the U.S.; employer will not sponsor visas
Delta Defense LLC Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Delta Defense LLC and has not been reviewed or approved by Delta Defense LLC.
-
Leave & Time Off Breadth — PTO is characterized as generous at the outset, supplemented by paid holidays and volunteer time. Time-off structures are presented as a core strength of the package.
-
Retirement Support — A 401(k) plan with an immediately vested company match is emphasized. The retirement offering is framed as generous, reinforcing long-term financial support.
-
Wellbeing & Lifestyle Benefits — Wellbeing resources include on-site fitness, wellness reimbursements, and access to licensed mental-health therapists. Mission-aligned perks like complimentary USCCA membership, training access, and personal/home security reimbursements add distinctive value.
Delta Defense LLC Insights
What We Do
Delta Defense, LLC is the private company that provides Marketing, Operations and Customer Care for the USCCA. The USCCA helps responsible Americans avoid danger, save lives and keep their families safe. We're one of the fastest-growing companies in America and a favorite workplace in SE Wisconsin. Named on Inc. 5000 Fastest-Growing Private Companies List 9 years in a row #1 Milwaukee Journal Sentinel Top Workplace - Five years in a row #1 Milwaukee Business Journal Best Place to Work - Five years in a row We are a fun, fast-paced and rewarding place to work and grow! Delta Defense LLC is a growing team of innovative, hard-working, fun-loving people who embrace our mission and our culture.
