Principal Data Engineer

HCEsquared is a healthcare solutions platform focused on dermatology and expanding into other medical specialties, providing clinical and non-clinical content to healthcare professionals to improve patient care.

Location: Remote (U.S.)

Responsibilities

• Design, build, and maintain ETL and reverse-ETL pipelines connecting our MarTech and healthcare data stack into the cloud data warehouse.
• Own the cloud data warehouse and its transformation layer — staging, business logic, and mart tables — keeping data clean, documented, and performant for analytics and data science.
• Integrate specialty healthcare datasets — pharmaceutical claims and HCP intelligence — with our first-party engagement data, building the joins and transformations that make them actionable for commercial measurement and clinical personalization.
• Define and enforce engineering best practices — code standards, testing, documentation, schema governance, and data dictionary — so analytics and data science can move fast without breaking things.
• Monitor, troubleshoot, and optimize pipeline performance, resolving data quality and availability issues before they block analytics.
• Stay current with the modern data stack and introduce new tools — connectors, transformation frameworks, orchestration, or ML compute — as we scale.
• Partner with analytics, data science, product, and commercial teams to turn business requirements into reliable, scalable solutions — making data accessible, never the bottleneck.

Requirements

• 7+ years in data or platform engineering, with proven ownership of production data infrastructure
• Expert SQL and deep hands-on Snowflake experience (required, not preferred — it's our warehouse of record)
• Strong experience with dbt or a similar SQL transformation framework — modeling, testing, documentation, and CI/CD
• Experience configuring and operating pipeline tooling such as Fivetran, Airbyte, or Segment at scale
• Strong hands-on AWS experience (our cloud), including data services like S3, Glue, Lambda, or EMR. Other clouds are a plus but not a substitute.
• Strong Python skills for custom pipelines and automation
• Experience integrating CRM, marketing automation, event, or content platforms via REST APIs, webhooks, or event streams
• Healthcare experience — especially pharmaceutical claims, HCP, or health system data — is a strong plus
• Able to explain architecture decisions clearly to non-technical stakeholders

Benefits

• Fully remote work environment with a flexible time off policy
• Dedicated professional development support, including reimbursement for approved learning and development activities.
• Comprehensive wellness benefits, including medical, vision, and dental coverage, with a significant portion of premiums subsidized for employees and eligible dependents, as well as access to HSA, FSA, and Dependent Care FSA plans
• Employer-paid life insurance, short-term disability, and long-term disability coverage
• 401(k) retirement plan with company matching
• Cell phone reimbursement for business use
• Home office stipend to support a productive remote setup