Principal Data Engineer

Dermsquared

Principal Data Engineer designing and maintaining data foundational elements for specialty healthcare education platform. Focused on building infrastructure that supports company growth in dermatology.

Posted 5/21/2026full-timeRemote • 🇺🇸 United StatesLeadWebsite

Tech Stack

Tools & technologies

AWSCloudETLPythonSQL

About the role

Key responsibilities & impact

Design, build, and maintain ETL and reverse-ETL pipelines connecting our MarTech and healthcare data stack — CRM, marketing automation, event management, content platforms, and third-party healthcare data — 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

What you’ll need

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

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLreverse-ETLSQLSnowflakedbtAWSPythondata transformationdata qualitydata pipeline optimization

Soft Skills

communicationcollaborationproblem-solvingdocumentationengineering best practicesstakeholder engagementanalytical thinkingownershipadaptabilityleadership