TAG - The Aspen Group Logo

TAG - The Aspen Group

Senior Data Engineer

Posted 18 Days Ago
Hybrid
Chicago, IL, USA
130K-160K Annually
Senior level
Hybrid
Chicago, IL, USA
130K-160K Annually
Senior level
Designs, builds, and operates scalable data platforms and ELT pipelines across Google Cloud using dbt, Python, Airflow, and BigQuery. Responsibilities include data modeling, governance, security, cost optimization, observability, infrastructure as code, incident response, and end-to-end feature delivery. The role pilots AI-assisted engineering practices, develops reusable tooling, collaborates with business and technical stakeholders, and mentors data engineers.
The summary above was generated by AI

The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S. and has supported over 20,000 healthcare professionals and team members with close to 1,500 health and wellness offices across 48 states in four distinct categories: dental care, urgent care, medical aesthetics, and animal health. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Chapter Aesthetic Studio, and Lovet. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale.

Job Description

The Senior Data Engineer designs, builds, and operates data pipelines and platform infrastructure across multi-brand data platforms that power business insights and decision-making. This is a senior technical role driving data engineering initiatives using dbt Cloud, Python, Airflow, and Google BigQuery ensuring best practices in data modeling, pipeline orchestration, platform scalability, and data governance, while bringing modern AI-assisted engineering practices into the team's day-to-day work. The Senior Data Engineer will mentor other engineers, drive engineering excellence, and collaborate with cross-functional teams to design and implement high-performance data solutions.

Key Responsibilities

Data Platform Architecture & Development

  • Design, develop, and optimize scalable, cloud-native data platforms on Google Cloud (BigQuery, Cloud Storage, Pub/Sub, etc.)
  • 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.

AI & Engineering Excellence

  • Champion AI-assisted engineering (code review, documentation, data profiling) to boost team velocity and quality
  • Build reusable tooling and playbooks that codify best practices for the broader team
  • Evaluate and pilot emerging AI/LLM tools and workflows, recommending adoption where they improve engineering quality or speed

Reliability, Operations & Cloud

  • Monitor and optimize BigQuery cost/performance, remediate anti-patterns (unclustered scans, credential misuse)
  • Triage production issues quickly and consistently, participate in on-call and incident response, including PagerDuty-to-incident.io migration work
  • Maintain observability (dashboards, alerting, freshness checks) and manage infrastructure as code (Terraform) for pipelines, DAGs, and Cloud Functions
  • Partner with security teams to resolve data governance and security findings (PII exposure, access controls)

Collaboration

  • Partner with brand stakeholders and third-party integration partners, enforcing access and environment guardrails
  • Work closely with data analysts, data scientists, and business teams to translate business needs into scalable data solutions
  • Mentor engineers on data engineering, dbt/SQL, and AI-assisted development practices

Qualifications & Experience

  • 3+ years of experience in Sr data engineering experience.
  • 3+ years of experience in data engineering
  • 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

Educational Qualifications

  • Bachelor's degree in Computer Science, Mathematics, or Software Engineering
  • Master's degree (preferred, not required)
  • Relevant certifications a plus

Annual Salary Range: $130,000-$160,000/year, with a generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match.

If you are an applicant residing in California, please view our privacy policy here: https://careers.aspendental.com/us/en/tag-privacy-policy-for-california-employees

HQ

TAG - The Aspen Group Chicago, Illinois, USA Office

800 Fulton Market, Chicago, IL, United States

Similar Jobs

3 Days Ago
Hybrid
Chicago, IL, USA
113K-188K Annually
Senior level
113K-188K Annually
Senior level
eCommerce • Information Technology • Retail • Industrial
Leads data architecture, data warehouse design, ETL development, and scalable analytics solutions using cloud and modern data technologies. Develops Python, SQL, and JavaScript code; optimizes distributed systems and CI/CD pipelines; troubleshoots production systems; evaluates emerging technologies and AI tooling; collaborates with technical and business stakeholders; and mentors junior engineers.
Top Skills: Agile/ScrumApache AirflowAstronomerAWSAzureChatgptCi/CdClaude CodeDatabricksDevOpsDockerGitGithub CopilotGoogle Cloud PlatformJavaJavaScriptKafkaKubernetesMongoDBPostgresPythonRest ApisSnowflakeSQL
5 Days Ago
In-Office
Chicago, IL, USA
92K-164K Annually
Senior level
92K-164K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Senior Data Engineer responsible for monitoring enterprise data pipelines, resolving production incidents, implementing data quality checks, automating operational workflows, and improving reliability across pharmacy data environments. The role also involves AI-enabled process optimization, data governance, documentation, technology evaluation, and operational best practices. Required experience includes data engineering, Azure cloud platforms, Scala or PySpark, SQL, Databricks, Airflow, Azure Data Factory, and production pipeline support.
Top Skills: AirflowAzureAzure Data FactoryDatabricksDistributed DatabasesPysparkRelational DatabasesScalaSnowflakeSQL
6 Days Ago
Remote or Hybrid
United States
165K-235K Annually
Senior level
165K-235K Annually
Senior level
Big Data • Cloud • Productivity • Software • Database • Analytics • Automation
Build and maintain Databricks-based data platforms, including ingestion, transformation, storage, governance, data modeling, and serving pipelines. Establish medallion architecture standards, canonical data models, quality controls, lineage, schema evolution, and reliable batch or incremental processing. Improve pipeline observability, scalability, idempotency, and recoverability while moving curated data to systems such as ClickHouse. Collaborate across application and analytics teams to create durable, governed production datasets.
Top Skills: Amazon AuroraAmazon RdsApache AirflowSparkBigQueryCdcClickhouseCloud Object StorageDatabricksDelta LakeIamOpenmetadataPostgresSnowflakeUnity Catalog

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account