Cloud Engineer III

Are you passionate about making a difference in people's lives? Do you enjoy working in a service-oriented industry? If so, this opportunity may be the right fit for you!

Modivcare is looking for an experienced Cloud Engineer III to join our team, responsible for building scalable data pipelines, developing dimensional data models, and creating the transformation layer that powers reporting, self-service analytics, operational applications, and AI initiatives. The ideal candidate is a collaborative and technically skilled data engineering professional with expertise in modern cloud data platforms, data transformation, and enterprise analytics solutions.

This role…

dbt Engineering & Data Transformation

• Design, develop, and maintain dbt projects, models, macros, snapshots, tests, and reusable transformation frameworks.
• Build and maintain enterprise data transformation pipelines using dbt Core and advanced SQL.
• Develop reusable business logic and data models that support reporting, self-service analytics, operational applications, and AI initiatives.
• Implement dbt best practices including modular design, testing, documentation, lineage tracking, and source control.
• Optimize dbt models and transformation workloads for performance, scalability, and maintainability.
• Support CI/CD deployment processes and automated testing for dbt projects.
• Collaborate with business and technical teams to translate requirements into scalable and reusable transformation logic.

Data Modeling & Data Warehouse Development

• Develop and maintain cloud data warehouse solutions using AWS services including Redshift, S3, Glue, Athena, Lambda, and Step Functions.
• Design and maintain dimensional data models supporting reporting, self-service analytics, and operational data needs.
• Build and maintain fact tables, dimensions, star schemas, snowflake schemas, and slowly changing dimensions (SCDs).
• Develop curated data marts and trusted datasets for reporting,...