Data Engineer (Snowflake & DBT)

The Role

This role is pivotal in supporting the implementation of a new data architecture within the Data Team to meet increasing workload demands. The Data Engineer will play a key role in building, automating, and maintaining corporate automation workflows, aligning with the organization's strategic objectives. The objective is to enhance data processing capabilities to support informed decision-making and drive strategic impact.

This is a hybrid position and requires onsite work 1 time per week at our Chicago HQ office.

Responsibilities

1. Develop, implement, and maintain pipelines for ETL processes to facilitate data-driven decision-making.
2. Focus on ingesting, storing, processing, and analyzing large datasets efficiently.
3. Create scalable web services for tracking data to support organizational goals.
4. Translate technical and functional requirements into detailed designs.
5. Provide limited On-Call after-hours critical support on a rotating schedule with other team members.

Qualifications

1. Proficiency in building, implementing, and maintaining data pipelines for efficient ETL processes.
2. Strong SQL scripting and automation skills to streamline data workflows.
3. Familiarity with ETL tools and frameworks such as Fivetran.
4. Experience in maintaining and optimizing data infrastructure for accurate data processing.
5. Ability to automate data workflows such as data ingestion, aggregation, and ETL processing.
6. Skill in preparing raw data into consumable datasets for technical and non-technical stakeholders.
7. Knowledge of data engineering principles, data visualization, and data architecture.
8. Fluency in designing data models to support efficient data storage.
9. Understanding of data warehousing (Redshift, Snowflake), cloud computing (AWS), and data security.
10. Ability to provide data accuracy, integrity, privacy, security, and compliance.
11. Strong critical thinking and problem-solving skills to address data management issues effectively.

Additional Requirements

1. Must pass any and all required background checks.
2. Must be and remain compliant with all legal or company regulations for working in the industry.
3. Must be a minimum of 21 years of age.