Personify Health

Because health is personal

Senior Cloud Data Architect

Data EngineerData EngineerFull TimeRemoteTeam 1,001-5,000Since 2023H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

39 days ago

Salary

$128K - $160.9K / year

Bachelor Degree10 yrs expEnglishAirflowAmazon RedshiftAWSCloudDjangoDockerEC2ETLOraclePostgresPythonSQLTableauTerraform

Job Description

• Design, build, and maintain scalable ETL/ELT pipelines using AWS, Airflow, and other technologies to ingest and transform healthcare and TPA data, including claims, provider, and eligibility sources. • Develop and operate resilient data architectures and workflows (Airflow, CloudWatch, ECS, DAGs) with strong CI/CD, observability, and governance. • Build data applications and processes using Python, SQL, and Django; manage and query data in PostgreSQL, Oracle, and cloud-native databases. • Examine, extract, cleanse, and load data while implementing quality assurance rules and tools to ensure consistent and accurate data. • Work with healthcare-specific data processes such as EDI file transfers, claims adjudication, audits, eligibility verification, and reporting workflows. • Collaborate with cross-functional teams (Data Analysts, Data Scientists, Product, Reporting, Account Management) to define requirements and deliver data-driven solutions. • Ensure data quality, integrity, and security through automated validation, auditing, and monitoring, with compliance to HIPAA and CMS regulations. • Monitor, maintain, and tune pipeline performance; proactively troubleshoot and resolve complex data flow and system issues. • Provide technical mentorship to Data Engineers, sharing expertise in data modeling, pipeline development, and troubleshooting practices. • Research and propose improvements to the tech stack and data engineering processes. • Participate in sprint planning, refinement, and estimation to support implementation awareness and delivery.

Job Requirements

  • At least one AWS certification (e.g., AWS Certified Data Analytics – Specialty, Big Data – Specialty, Developer – Associate)
  • Deep proficiency in AWS services including S3, Glue, EMR, EC2, MWAA, Lambda, Kinesis, ECS, and experience with Infrastructure as Code tools like Terraform
  • 10+ years in data engineering or analytics engineering, with a strong focus on cloud-native architectures
  • Proven experience designing and operating scalable data platforms in AWS
  • 5+ years in healthcare, insurance, or claims processing, including 5+ years working with EDI transactions (834, 835, 837, 2222, 2223, 999) and familiarity with HIPAA and CMS compliance
  • Deep understanding of relational and non-relational data models, including star/snowflake schemas and dimensional modeling
  • Skilled in PostgreSQL, Oracle, AWS RDS, Snowflake, and Redshift
  • Ability to mentor others in data modeling best practices
  • Expert-level proficiency in SQL (including pivots, window functions, and complex date calculations) and Python for data processing, transformation, and application development
  • Hands-on experience with orchestration tools like Airflow, containerization with Docker, and CI/CD pipelines
  • Strong bias for automation and continuous improvement
  • Proficient in consuming and transforming REST APIs and JSON data into relational models
  • Skilled in building robust data ingestion and transformation pipelines
  • Experience with JIRA, BitBucket Git, BitBucket Pipelines, and collaboration with cross-functional teams including Data Analysts, Data Scientists, Product, and Account Management
  • Proficient in Excel and BI tools such as Tableau, Power BI, and MicroStrategy for data analysis and reporting
  • Detail-oriented with a strong focus on data quality, accuracy, and performance tuning for large-scale data systems
  • Background in cost optimization and system reliability
  • Ability to mentor engineers, share technical knowledge, and communicate effectively with both technical and non-technical stakeholders
  • Strong documentation and systems thinking

Benefits

  • Comprehensive medical and dental coverage through our own health solutions (yes, we use what we build!)
  • Mental health support and wellness programs designed by experts who get it
  • Flexible work arrangements that fit your life, not the other way around
  • Retirement planning support to help you build real wealth for the future
  • Basic Life and AD&D Insurance plus Short-Term and Long-Term Disability protection
  • Employee savings programs and voluntary benefits like Critical Illness and Hospital Indemnity coverage
  • Professional development opportunities and clear career progression paths
  • Mentorship from industry leaders who want to see you succeed
  • Learning budget to invest in skills that matter to your future
  • Unlimited PTO policy because rest and recharge time is non-negotiable
  • Benefits effective day one—because you shouldn’t have to wait to be taken care of

Related Categories

Related Job Pages

More Data Engineer Jobs

Full TimeRemoteTeam 10,001+Since 1860H1B No Sponsor

Senior Architect ensuring robust data systems within S&P Global's financial services.

AWSAzureCloudGoogle Cloud Platform
New York
$177.0K - $266K / year

Texting Intern (Spring 2026)

Middle Seat Digital

Middle Seat is a digital consulting firm that works with progressive campaigns, nonprofits, advocacy organizations.

Data Engineer39 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

Salary: $23/hourLocation: Remote or Washington, D.C.Content creation, texting production, and reportingWant to break into digital for political campaigns and advocacy groups? Get your start with us. Middle Seat is a digital consulting firm that works w...

District Of Columbia

Email Intern (Spring 2026)

Middle Seat Digital

Middle Seat is a digital consulting firm that works with progressive campaigns, nonprofits, advocacy organizations.

Data Engineer39 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

Salary: $23/hourLocation: Remote or Washington, D.C.Want to break into email? Get your start with us! Middle Seat is a consulting agency that works with some of the biggest names in progressive politics. We work with campaigns, nonprofits, and advocacy...

District Of Columbia

Digital Ads Intern (Spring 2026)

Middle Seat Digital

Middle Seat is a digital consulting firm that works with progressive campaigns, nonprofits, advocacy organizations.

Data Engineer39 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor

Salary: $23/hourLocation: Remote or Washington, D.C.Email acquisition, direct donate, and persuasion.Want to break into digital? Get your start with us. Middle Seat is a full-service firm for progressive causes and candidates. We work with campaigns, n...

District Of Columbia