Analytics Engineer - Remote Optional

About the position

As an Analytics Engineer at Delta Defense, you'll play a pivotal role in a cross-functional team. 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. This role isn't just about data-it's about empowering our mission through insightful analysis and innovation. If you're ready to make a transformative impact, we encourage you to explore this opportunity with us.

Responsibilities

• Build 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.
• While performing data transformations, ensure adherence of the rules and requirements for the formats and attributes of data.
• Follow engineering best practices around CI/CD, unit testing, performance testing and optimization.
• Effectively collaborate with Data Architecture to ensure the quality and consistency of the data model.
• Create clear and effective documentation as needed.
• Maintain understanding and awareness of best practices related to PII, adherence to Risk policies and standards as set forth by the organization.

Requirements

• Bachelor's degree in Computer Science, Information Management, Data Science/Analytics, or equivalent relevant experience.
• 3+ years of SQL experience required.
• Proficiency in dbt preferred.
• Familiarity with ETL/ELT methodologies.
• Background in analytics engineering or data engineering experience is preferred.
• Experience with cloud data warehouses (Snowflake, Redshift, BigQuery).
• Experience with Python and shell scripting a plus.
• Experience with Agile development methods.
• Understanding of Tableau.
• Experience with Dimensional (star schemas) and Data Vault data models is advantageous.
• Demonstrates the Core Values of Delta Defense, LLC.

Benefits

• 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!