Cloud Engineer III

Engineering & Data Transformation:

• Design, develop, and maintain dbt projects, models, macros, and reusable transformation frameworks.
• Implement dbt best practices including modular design, testing, and lineage tracking.
• Support CI/CD deployment processes and automated testing for dbt projects.

Data Modeling & Data Warehouse Development:

• Develop and maintain cloud data warehouse solutions using AWS services such as Redshift, S3, and Glue.
• Design dimensional data models including star schemas, snowflake schemas, and slowly changing dimensions.
• Optimize data structures and query performance for large-scale analytical workloads.

Data Engineering & Pipeline Development:

• Build and maintain batch and near real-time data pipelines using AWS, dbt, SQL, and Python.
• Integrate data from operational systems, APIs, and healthcare platforms.
• Troubleshoot and resolve data pipeline and data warehouse performance issues.

Collaboration & Delivery:

• Partner with application teams, business stakeholders, and analytics teams to understand data requirements.
• Deliver trusted, well-documented datasets for reporting and self-service analytics.
• Participate in Agile development processes including sprint planning, code reviews, and release management.