
Data Engineer I
Role summary
Alterman is seeking a Data Engineer I to join their team. This role is responsible for designing, building, and deploying data solutions, including constructing and optimizing data pipelines, designing data models for reporting, and creating ELT jobs. The Data Engineer I will also maintain data engineering best practices, contribute to data catalogs, and test ELT functions. The position requires 2 years of experience in cloud-based data pipelines and ELT/Data Warehousing, along with proficiency in SQL, Azure DevOps, and Snowflake. Python experience is preferred for transformations and automation.
Overview
*The Data Engineer I is a key technical resource for Alterman’s data pipelines and helps contextualize and provide easy access to data for the entire organization. The Data Engineer I designs, builds, and deploys data solutions that capture, explore, transform, and utilize data to support and drive business initiatives.*
Essential Functions
- 90%
- Constructs new data pipelines and optimizes existing ones to ensure resiliency and scalability.
- Designs data models for optimized reporting.
- Creates complex views specific for various operations groups.
- Creates Extract, Load, Transform (ELT) jobs from various data sources.
- Assists data team with data initiatives and automation needs.
- Maintains and enforces best practices with regards to data source control and queries.
- Contributes to data catalogs and dictionaries.
- Tests and debugs ELT functions.
- Performs other duties as assigned. 10%
Education And Experience
- 2 years of related experience engineering and operationalizing data pipelines within a cloud environment required.
- 2 years of related experience with ELT and Data Warehousing required.
- Experience with Azure DevOps and Snowflake required.
- Experience with SQL required; Python preferred for light transformations and automation.
- Experience with data engineering best practices for development required, including query optimization, version control, code reviews and documentation.
Skills/Abilities
- Excellent verbal and written communication skills, with a demonstrated ability to translate the stories found in the data.
- Strong analytical and critical thinking skills.
- Statistical modeling and/or data visualizations skills preferred.
- Proficient with Microsoft Office Suite, or other related software.
- Proficient in SQL and/or Python.
- Familiarity with data quality, lineage, and cataloging practices.
- Awareness of data governance and security (RBAC/roles, object tags, masking, RAPS).
- Able to learn corporate processes, standards, and technologies.
- Able to work adaptively and collaboratively.
- Able to cross-train with other system owners and administrators to ensure adequate coverage across platforms.
Work Environment
- Office environment.
Physical Demands
- Prolonged periods of sitting at a desk and working on a computer.
- Manual dexterity associated with computer data entry required.
Similar roles
Data Engineer IPAR Technology · Toronto, Ontario, Canada · Remote
Sr Data Engineer IPrincipal Financial Group · Des Moines, Iowa, United States · Remote
Senior Data Engineer IPax8 · United States · Remote
Senior Data Engineer IHeartland Business Systems · West Des Moines, Iowa, United States · Hybrid
Data Engineer IHoneywell Aerospace Technologies · Phoenix, Arizona, United States · Hybrid