Senior Data Engineer
Imagine Pediatrics•United States (Remote), TX
•$150,000 - $180,000
About The Position
As a Senior Data Engineer at Imagine Pediatrics, you will design, build, refactor, and maintain the data models and pipelines that power product, clinical analytics, and operational reporting across the organization. This role requires a mix of technical expertise and analytical thinking, applying engineering best practices to transform raw data from a variety of sources into well-defined, consumable datasets and making them accessible in multiple systems.
Requirements
- 5–7+ years of healthcare data engineering or analytics engineering experience, with expert-level SQL proficiency and strong data modeling fundamentals.
- Strong experience with dbt and orchestration tools.
- Experience with cloud data warehouses, preferably Snowflake, including performance-aware SQL development and query optimization.
- Experience designing scalable data models, including incremental approaches, and implementing comprehensive testing strategies.
- Comfort working with the command line and modern engineering practices, including version control, CI/CD, testing, and code review.
- Proven ability to troubleshoot complex data issues across ingestion, transformation, and warehouse layers, and to communicate findings and solutions effectively to technical and non-technical audiences.
- Proven ability to reason about the downstream analytical impact of pipeline and model design, including data freshness, grain, and transformation behavior.
Nice To Haves
- Proficiency in Python for automation, tooling, or pipeline development.
- Experience building API-based and event-driven ingestion systems.
- Experience with AWS services such as Lambda, SQS, SNS, and S3.
- Experience working with FHIR resources and clinical systems.
- Experience with high-volume ingestion tools (e.g., Hevo, Fivetran, or similar).
Responsibilities
- Design and build scalable, well-tested DBT models.
- Develop and maintain scalable ELT pipelines, ensuring observability and reliability across workflows while leveraging multiple languages and frameworks.
- Write performance-aware SQL, understand query execution, and identify and resolve bottlenecks in queries and pipelines.
- Improve existing patterns in the codebase and establish new ones.
- Partner with product managers, engineers, and stakeholders to understand data needs and provide actionable paths forward.
- Work closely with engineers across teams to resolve dependencies, facilitate alignment on technical decisions, and mentor other engineers.
- Document logic, business rules, and methodology to promote transparency and enable teammates to reference and build on your work.
Benefits
- Annual bonus incentive
- Competitive company benefits package
- Eligibility to participate in an employee equity purchase program
- Competitive medical, dental, and vision insurance
- Healthcare and Dependent Care FSA
- Company-funded HSA
- 401(k) with 4% match, vested 100% from day one
- Employer-paid short and long-term disability
- Life insurance at 1x annual salary
- 20 days PTO + 10 Company Holidays & 2 Floating Holidays
- Paid new parent leave
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
