Senior Data Engineer — AI-Driven Data Platform on GCP

Aspen Dental; Chicago (IL); On-site; USD 130,000 - 160,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401(k) with match

PTO

Job summary

The Aspen Group is seeking a Senior Data Engineer to design and operate data pipelines and platform infrastructure powering insights across multiple brands including Aspen Dental. You will implement scalable data solutions on Google Cloud, advance AI-assisted practices, and mentor other engineers.

Responsibilities span data platform development, governance, and collaboration with analysts and product teams. A strong background in SQL, Python, dbt, and Airflow is required.

Qualifications

• 3+ years of Sr data engineering experience.
• 3+ years of data engineering experience.
• Strong expertise in SQL, Python, dbt, and Airflow/Cloud Composer.
• Hands-on experience designing scalable, cost-efficient data platforms in Google Cloud (GCP)
• Deep understanding of data warehousing, ELT architectures, and distributed computing.
• Experience with orchestration tools like Airflow and event-driven architectures.
• Strong knowledge of CI/CD, infrastructure as code (Terraform), and DevOps principles.
• Ability to mentor data engineers and influence technical strategy.

Responsibilities

• Design, develop, and optimize scalable, cloud-native data platforms on Google Cloud (BigQuery, Cloud Storage, Pub/Sub).
• Establish best practices for data modeling, performance tuning, and cost optimization in BigQuery.
• Lead development of efficient ELT pipelines using dbt Cloud, Python, and Airflow.
• Develop dbt models, tests, and documentation. Responsible to own data governance, data quality, security, and compliance standards across owned pipelines.
• Own feature delivery end-to-end, from design through production, including code review standards.

Skills

SQL

Python

dbt

Airflow

GCP

Education

Bachelor’s degree in Computer Science, Mathematics, or Software Engineering

Master’s degree (preferred)

Certifications a plus

Tools

dbt Cloud

Airflow

Google BigQuery

Terraform

Cloud Functions

Job description

The Aspen Group is seeking a Senior Data Engineer to design and operate data pipelines and platform infrastructure powering insights across multiple brands including Aspen Dental. You will implement scalable data solutions on Google Cloud, advance AI-assisted practices, and mentor other engineers.

Responsibilities span data platform development, governance, and collaboration with analysts and product teams. A strong background in SQL, Python, dbt, and Airflow is required.