Job Category: Business Analytics Requisition Number: SENIO001642 West Bend, WI 53095, USA Job Details Description Are you ready for a career 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)? Delta Defense, LLC is the private company that provides Marketing, Operations and Customer Service for the USCCA. The USCCA helps responsible Americans avoid danger, save lives, and keep their families safe. Learn more about the USCCA at Position Summary: As a Senior Data Engineer at Delta Defense, you’ll step into a pivotal role on a dynamic, cross-functional team at the forefront of advancing our Enterprise Data Warehouse. You will be responsible for the hands on technical leadership guiding the development of both data and process strategies crucial for our ongoing growth. More than just contributing, you’ll be architecting a business-centric technology solution that supports and enhances our ability to report on KPIs, metrics, and insights that drive decision-making across Delta Defense. We’re looking for someone who is not just skilled but also relentlessly resourceful. You’ll need to manage complex requests with speed without compromising on the high standards of quality we uphold at Delta Defense. Are you passionate about transforming data into actionable business intelligence? If you’re ready to take on this challenge and make a significant impact in a mission-driven organization, we’re excited to see what you can bring to our team. Essential Duties and Responsibilities: Establish standards for performing data transformations and ensure adherence of 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. Required Skills/Experience: 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. Why YOU should Work at Delta Defense! We are a fun, fast-paced, and rewarding place to work and grow! 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! 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. Benefits information can be reviewed at: Salary range $105,000 – $130,000 based on experience. This role is also bonus-eligible for company incentive plan. Anticipated application close: 06/15/2024 If you are a Colorado resident, please email us at to receive complete benefits information. Please include the job title in the subject line of the email. PM19 LI May 15, 2024 PI20e96e0d76e4-3224
data-quality Key Performance Indicators (KPIs) Business Analyst CI/CD Tableau Python Amazon Redshift normalization Data Engineering data-vault snowflake-cloud-data-platform SQL metrics ETL data cleansing google-bigquery