Data Engineer
AWS
Big Data
Cloud
Cloud Operations
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Lake
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Transforms
Data Warehouse
Database
Databases
Engineer
ETL
Informatica
SQL
Job Description
Turn complex data into actionable insights by building dependable data solutions and supporting the Enterprise Data Warehouse.
Responsibilities
- Work with systems and infrastructure that collect and process data to deliver clean, tested, reusable datasets for analysis.
- Follow established standards for data transformations, ensuring compliance with formatting and attribute requirements.
- Support data quality by maintaining and improving data profiling methodologies.
- Maintain engineering best practices across CI/CD, unit testing, performance testing, and optimization.
- Partner with the Data Architecture team to improve data model quality and consistency.
- Use the existing data infrastructure to handle data requests, including data housekeeping, data cleansing, normalization, hashing, and implementing required data model changes.
- Analyze datasets to identify anomalies, trends, and correlations across similar data.
- Troubleshoot issues, identify potential solutions, and resolve problems as needed.
- Build knowledge and follow best practices related to PII and adherence to Risk policies and standards set by the organization.
- Perform all other duties as assigned.
Requirements
- High school diploma or equivalent.
- Associate or bachelor’s degree preferred in Computer Science, Information Management, Data Science/Analytics, statistics, or equivalent 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, including S3 and EMR preferred.
- 1+ years experience in Agile SDLC.
- 1+ years dbt experience preferred.
- Solid understanding of ETL/ELT methodologies.
- Python and scripting experience 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 Working Conditions
- West Bend, WI (onsite) at HQ
- Some hybrid flexibility available, with a goal of staying onsite
- No sponsorship provided now or in the future for this role