Senior Data Engineer - Business Analytics - Self Defense Industry - Remote Optional

$105,000 - $130,000/Yr

Delta Defense - West Bend, WI

Full-time - Mid Level

Remote - West Bend, WI

Personal and Laundry Services

About the position

As a Senior Data Engineer at Delta Defense, you will play a crucial role in advancing our Enterprise Data Warehouse. This position is not just about contributing; it involves architecting a business-centric technology solution that enhances our ability to report on key performance indicators (KPIs), metrics, and insights that drive decision-making across the organization. You will be part of a dynamic, cross-functional team, providing hands-on technical leadership and guiding the development of data and process strategies essential for our ongoing growth. In this role, you will establish standards for data transformations, ensuring adherence to rules and requirements for data formats and attributes. You will develop and maintain data quality standards through profiling methodologies and implement engineering best practices around continuous integration and delivery (CI/CD), unit testing, and performance optimization. Your responsibilities will also include designing and implementing statistical models for classification and information extraction from data, as well as troubleshooting problems and identifying solutions. You will partner with the Data Architecture team to ensure the quality and consistency of the data model, leveraging existing data infrastructure to fulfill data-related requests. Analyzing data to spot anomalies and trends will be a key part of your role, as will leading junior team members and providing mentorship. This position is ideal for someone who is passionate about transforming data into actionable business intelligence and is ready to make a significant impact in a mission-driven organization.

Responsibilities

• Establish standards for performing data transformations and ensure adherence to rules and requirements for the formats and attributes of data.
• Develop a standard for data quality by creating, maintaining, and enhancing data profiling methodologies.
• Establish the use of engineering best practices around CI/CD, unit testing, performance testing and optimization.
• Design, develop and implement statistical models to carry out various novel aspects of classification and information extraction from data.
• Partner directly with the Data Architecture team to ensure quality and consistency of the data model.
• Leverage existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes.
• Analyze data to spot anomalies, trends, and correlate similar data sets.
• Design, develop, and implement general statistical models.
• Troubleshoot problems, identify possible solutions, and resolve accordingly.
• Ensure adherence to risk policies and standards as set forth by the organization.
• Lead junior team members, providing guidance and mentorship in the development of others.
• All other duties as assigned.

Requirements

• Bachelor's degree in Computer Science, Information Management, Data Science/Analysis or related field, or equivalent relevant work experience and certifications.
• Strong understanding of best practices related to PII (Personally Identifiable Information) and be able to apply them.
• 2+ years dbt experience required.
• 5+ years of experience in data engineering required.
• Prior experience executing within cloud data warehouses (Snowflake, Redshift, BigQuery) required.
• 2+ years of experience in a business intelligence role desired.
• Ability to work efficiently with AWS cloud technologies such as S3, EMR required.
• 5+ years of SQL experience.
• 3+ years of experience in Agile SDLC.
• Solid understanding of ETL/ELT methodologies.
• Proficiency with Python and scripting languages, 3+ years of experience preferred.
• Solid understanding of industry standards in analytical data modeling techniques.
• Preferred experience in Data Vault.
• Working knowledge of Tableau.
• Demonstrates the Core Values of Delta Defense, LLC.

Nice-to-haves

• Experience with Data Vault methodology.
• Familiarity with Tableau for data visualization.

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, & Pet Insurance
• Complimentary USCCA Elite membership & store discounts
• Nationally recognized in 2023 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 12 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!
• Bonus-eligible for company incentive plan.