Data Engineer I

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:

1. 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.

2. 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.