Senior Data Engineer

Skills
Azure Data FactoryComputer ScienceAnalyticsBusiness InsightsData StrategiesDimensional ModelingModeling
Role

What the job involves

The main requirements, responsibilities and hiring steps.

Requirements

  • Bachelor's degree in Computer Science Information Technology or related field or equivalent experience
  • 5+ years of experience
  • 7+ years in data engineering with senior-level production delivery
  • 5+ years hands-on SQL programming
  • 3+ years building automated data pipelines using batch and/or streaming processes
  • Strong SQL plus Java or Python for pipeline development
  • Hands-on experience across multiple cloud stacks including GCP Azure BigQuery and SQL Server
  • Deep experience designing and operating reliable scalable ETL/ELT pipelines
  • Hands-on with at least one orchestration tool such as Airflow Cloud Composer ADF Dagster or Prefect
  • Strong data modeling skills including dimensional modeling normalization and slowly-changing dimensions
  • Working knowledge of HIPAA and PHI handling including secure movement de-identification access controls and audit
  • Track record delivering on enterprise cloud platforms within standards and controls
  • Proficient with Git and CI/CD

Nice to have

  • Performance-minded
  • Strong communicator
  • Enterprise-focused
  • Detail-oriented

Day to day

  • Design and build scalable ETL and ELT pipelines across cloud and database platforms
  • Model data for analytics using dimensional design SCDs and schema best practices
  • Orchestrate and monitor production pipelines while ensuring secure handling of PHI and clear stakeholder communication

Hiring process

  • Submit an application
  • Request reasonable accommodation if needed via Human Resources email