Charlie Health is hiring a Lead Platform Engineer for our Data Platform team. In this role, you will be responsible for designing, implementing, and maintaining the data models, data access patterns, contracts, and database infrastructure that power our transactional systems. You will ensure data quality, consistency, scalability, and security from the start of feature development and lead the migration to modern data models.
What You'll Do
- Define, implement, and evolve data models and schemas in Postgres to support product and analytical use cases.
- Develop and maintain data access standards and patterns in core backend systems with Python and Typescript.
- Lead the definition, design, and phased migration to improved data models for core business concepts.
- Work alongside product engineering teams to deliver features with correct and well-modeled data at the source.
- Measure and improve data quality, correctness, stability, and usability improvements across transactional systems.
- Provide options around key initiatives and break down work into visible and achievable milestones, delivering incremental value.
- Mentor and train other engineers throughout the organization and seek to continually improve architecture, data modeling standards, and engineering processes.
- Improve data usability, trust, and developer productivity by building shared tooling, patterns, and documentation.
- Maintain and improve transactional database infrastructure running in AWS.
- Review SQL and data access code for production systems.
- Partner with engineers across the organization to ensure database migrations are executed correctly and safely.
- Profile, analyze, and tune slow or inefficient queries in Postgres.
- Leverage AI-powered tooling to enhance the software development lifecycle.
- Drive security, reliability, scalability, observability, and cost-efficiency improvements across deployed services.
- Participate in an on-call rotation, responding to and resolving critical infrastructure and application issues promptly.
What We're Looking For
- 6+ years of experience in a role focused on Backend or Data Platform Engineering.
- 3+ years of experience writing production-level SQL and backend code.
- Recent expertise with Python as a primary programming language.
- Experience with data modeling concepts and best practices (e.g., dimensional modeling, data vault, or similar).
- Experience with observability, monitoring, and logging tools such as Datadog and Cloudwatch.
- Proven track record of breaking down large problems and delivering incremental value to meet deadlines while providing options for long-term improvements.
- Ability to troubleshoot complex distributed systems.
- Familiarity with AI-enabled developer productivity tooling.
- Strong communication and problem-solving skills, and the ability to work in a fast-paced startup environment.
- Hands-on experience participating in an on-call rotation, responding to and resolving critical infrastructure and application issues promptly.
- Team members who live within 45 minutes of a Charlie Health office are expected to follow a hybrid work schedule.
Nice to Have
- Proficiency with programming languages like Typescript or Golang.
- Experience with large data migrations on production systems.
- Expertise with AWS services like Aurora, S3, SQS, ECS Fargate, and Lambda.
- Proficiency with Snowflake as a cloud data warehouse.
- Experience with Data Engineering tools like DBT, Dagster, Fivetran, and Hightouch.
- Familiarity with event-driven data architectures and stream processing (e.g., Eventbridge, Kafka, or similar).
Technical Stack
- Databases & Warehousing: Postgres, Aurora, Snowflake
- Languages: Python, Typescript
- Cloud & Infrastructure: AWS, S3, SQS, ECS Fargate, Lambda
- Observability: Datadog, Cloudwatch
- Data Tools: DBT, Dagster, Fivetran, Hightouch
- Eventing: Eventbridge, Kafka
Team & Environment
You will join the Data Platform team, working across Product Engineering, Analytics, ML, and Platform.
Benefits & Compensation
- Annual salary range: $175,000 - $255,000 per year
- Equity: Stock options may be included
- Comprehensive benefits are provided to all full-time, exempt employees
Work Mode
This is a hybrid role. Team members who live within 45 minutes of a Charlie Health office, including in NY, are expected to work from an office part of the week.
At Charlie Health, we value being an Equal Opportunity Employer. We strive to cultivate an environment where individuals can be their authentic selves. Being an Equal Opportunity Employer means every member of our team feels as though they are supported and belong. We value diverse perspectives to help us provide essential mental health and substance use disorder treatments to all young people.
