Senior Analytics Engineer

Company: Delta Defense
Location: West Bend
Posted on: May 7, 2025

Job Description:

Job Category: Information TechnologyRequisition Number: SENIO001735 West Bend, WI 53095, USAJob DetailsDescriptionAre you ready to support a mission you can BELIEVE in?

• Do you have a strong belief in the 2nd Amendment?
• Do you support the natural-born right to armed self-defense?
• Do you believe in the mission of the U.S. Concealed Carry Association (USCCA)?The USCCA safeguards life, freedom, and finances for responsible American gun owners.Delta Defense, LLC is the private company that provides Marketing, Operations and Customer Service for the USCCA. Learn more about the USCCA atPosition Summary:This position is based at our corporate headquarters in West Bend, Wisconsin and requires a minimum of 3 days per week in office.As a Senior Analytics Engineer at Delta Defense, you'll play a pivotal role in our cross-functional team, providing hands-on technical leadership. Your expertise will transform raw and operational data from diverse sources into robust, business-focused technology solutions. These solutions will empower the organization by enabling the reporting of KPIs, metrics, and insights. A key requirement for this role is proficiency with dbt technology, which will be essential in driving our data transformation processes. We're looking for candidates who are relentlessly resourceful, able to tackle complex requests swiftly, and committed to maintaining the highest standard of quality.Essential Duties and Responsibilities:
  • Lead the development of data pipelines that integrate complex and disparate data sources in order to create clean, tested, and reusable datasets ready for analysis.
  • Ensure data quality by creating, maintaining, and enhancing data profiling methodologies.
  • Contribute to the establishment of standards for performing data transformations. Ensure adherence of rules and requirements for formats and attributes of data.
  • Follow and validate the use of engineering best practices around CI/CD, unit testing, performance testing and optimization.
  • Effectively collaborate and partner with the Data Architecture team to ensure the quality and consistency of the data model.
  • Ensure clear and effective documentation.
  • Understand and apply best practices related to PII, adherence to risk policies and standards as set forth by the organization.
  • Design scalable and re-usable Enterprise Data Warehouse dimensional models.
  • Encourage and mentor junior team members. Leverage prowess in dbt technology to provide guidance in the development of others.Required Skills/Experience:
    • Bachelor's degree in IT or related field; Computer Science, Information Management, Data Science/Analytics, or equivalent relevant experience.
    • Proficiency in dbt required.
    • 4+ years of SQL experience.
    • Solid understanding of ETL/ELT methodologies.
    • Significant experience with cloud data warehouses (Snowflake, Redshift, BigQuery).
    • Experience with Python and shell scripting is a plus.
    • Experience with Agile development methods.
    • Understanding of Tableau.
    • Experience with AWS cloud technologies such as S3, EMR.
    • The ability to communicate ideas, information, and viewpoints clearly, both verbally and in writing.
    • Experience with Dimensional Data modeling (star schemas).
    • Demonstrates the Core Values of Delta Defense, LLC.Why YOU should Work at Delta Defense!
      • 23 Days of Personal Time Off, 8 company holidays, plus paid day of volunteer service annually
      • Personal protection, fitness, and home office reimbursement program ($500 annually)
      • Robust insurance coverage options: Medical, Dental, Vision, HSA, FSA, Life, STD, & LTD
      • Complimentary USCCA Elite membership & store discounts
      • Nationally recognized in 2023 and 2024 as a Newsweek Top 100 America's Most Loved Workplace
      • Top Workplaces USA award in 2022!
      • Named on Inc. 5000 "Fastest Growing Private Companies" list 13 years in a row!
      • Milwaukee Journal Sentinel "Top Workplace" award 7 years in a row!
      • Milwaukee Business Journal "Best Place to Work" award 6 years in a row!
      • We are a fun, fast-paced, and rewarding place to work and grow!Benefits information can be reviewed at: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.PM19January 7, 2025PIc0f6da45f939-37820-36429258

Keywords: Delta Defense, Mount Prospect , Senior Analytics Engineer, Engineering , West Bend, Illinois