Data Engineer

Delta Defense is seeking a Data Engineer to help transform complex information into actionable insights. In this onsite role in West Bend, WI, you will build dependable data solutions and support the Enterprise Data Warehouse through transformation, data quality practices, KPI and reporting enablement, and close collaboration with Data Architecture, while maintaining engineering best practices.

What you’ll do

• Work with data collection and processing systems to produce clean, tested, and reusable datasets for analysis.
• Apply established standards for data transformations and ensure format and attribute requirements are followed.
• Support data quality by maintaining and improving data profiling methodologies.
• Maintain engineering best practices including CI/CD, unit testing, and performance testing and optimization.
• Partner with the Data Architecture team to support the quality and consistency of the data model.
• Use existing data infrastructure to complete data requests, including data housekeeping, data cleansing, normalization, hashing, and implementing required model changes.
• Analyze data to identify anomalies, trends, and correlations across similar datasets.
• Troubleshoot data-related issues, identify potential solutions, and resolve accordingly.
• Maintain awareness of PII best practices and ensure adherence to Risk policies and standards set by the organization.
• Perform other duties as assigned.

What you bring

• High school diploma or equivalent.
• Associate or bachelor’s degree preferred in Computer Science, Information Management, Data Science/Analytics, statistics, or equivalent relevant experience.
• 2-5 years of experience in data engineering or business intelligence roles.
• 3-5 years of SQL experience.
• Ability to work efficiently with AWS cloud technologies such as S3 and EMR (EMR preferred).
• 1+ years experience in Agile SDLC.
• 1+ years dbt experience preferred.
• Solid understanding of ETL/ELT methodologies.
• Python and scripting language proficiency preferred.
• Solid understanding of industry standard analytical modeling techniques.
• Demonstrates the Core Values of Delta Defense, LLC.

Technologies

• SQL, AWS, S3, EMR, dbt, Python
• ETL/ELT, CI/CD, Agile SDLC

Location and sponsorship

This position is based at the company’s HQ in West Bend, WI. While some hybrid flexibility is available, the goal is for the selected candidate to be onsite. Delta Defense does not provide sponsorship for this role now or in the future.