About the role
Cloud Data Engineer:
What You'll Do
- Advanced SQL Development — Design, optimize, and troubleshoot complex Redshift SQL for RCM analytics, including advanced query patterns (window functions, CTEs, query tuning), performance optimization at scale, and complex data transformation logic.
- Data Ingestion & Pipeline Development — Design and build cloud-native data ingestion pipelines (e.g., AWS Glue, Redshift, S3) to process healthcare transaction and EDI data.
- Python & Dynamic Queries — Build parameterized dashboard queries using Python and Jinja templating.
- Agentic & AI-Assisted Development — Build and apply agentic/GenAI solutions hands-on for data profiling, code generation, and QA — e.g., Amazon Bedrock, Langflow, Claude, GitHub Copilot, or similar.
- Rapid Dashboarding — Stand up and iterate on dashboards (using Superset) quickly in an ambiguous, fast-moving environment.
- Global Team Collaboration — Coordinate daily with India-based colleagues and other distributed team members.
Skillset
- 2+ years advanced SQL/Redshift experience — query optimization, performance tuning, complex transformations.
- Python with Jinja (or similar) templating.
- AWS cloud experience (Glue, S3, Redshift) for ETL/ingestion pipelines.
- Hands-on agentic/GenAI experience (e.g., Bedrock, Langflow, Claude, GitHub Copilot).
- Strong communicator, comfortable in ambiguous, fast-moving environments and across a globally distributed team.