Senior Data Engineer

Empower Pharmacy; United States; On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) matching

Paid time off

Job summary

Empower Pharmacy is seeking a Senior Data Engineer to own the data foundation across our 503A/503B operations, delivering AI-enabled data products, pipelines, and governance. You will drive architecture, model design, and automation to enable faster decisions and scalable growth in a highly regulated pharmacy environment.

The role emphasizes end-to-end data engineering, including architecture, integration, validation, and performance optimization, with mentorship across the team.

Qualifications

• 8+ years of data engineering experience in cloud platforms.
• Bachelor’s degree in a quantitative field; equivalent experience considered.
• Deep AWS serverless, SQL, Python, and data warehousing skills; production support.
• Experience designing governed data solutions in regulated environments; healthcare/pharma exposure is helpful.

Responsibilities

• Lead scalable cloud data platform architecture for analytics and regulatory reporting.
• Develop relational and dimensional data models for trusted analytics.
• Define engineering standards for pipelines, observability, and deployment.

Skills

AWS serverless

Data modeling

Data warehousing

ETL/ELT

Python

SQL

Education

Bachelor’s degree in CS/Engineering or related

Tools

Snowflake

Airflow

REST APIs

Job description

Company Overview

Empower Pharmacy is a visionary healthcare company dedicated to making quality, affordable medication accessible to millions of patients nationwide. As the nation’s most advanced 503A compounding pharmacy and FDA‑registered 503B outsourcing facility, we’re redefining what’s possible in personalized medicine and pharmaceutical manufacturing. We’re proud to be recognized as one of Houston’s fastest‑growing private companies and ranked #116 in Healthcare & Medical on the Inc. 5000 List for 2025.

Guided by our four core values—People, Quality, Service, and Innovation—we have built a uniquely integrated healthcare platform powered by advanced technology, operational excellence, and commitment to patient care. From manufacturing and quality control to distribution and customer experience, our teams work together to raise industry standards, improve access to critical medications, and improve outcomes for patients and providers.

Position Summary

The Senior Data Engineer owns the design, delivery, and continuous improvement of Empower’s enterprise data foundation, enabling faster decisions, stronger quality, and scalable growth across our highly regulated 503A/503B pharmacy environment. This role converts complex business, operational, and compliance needs into secure, reliable, AI‑enabled data products, pipelines, models, and platforms that accelerate speed, scale, quality, and decision‑making. The role has end‑to‑end ownership for critical data engineering outcomes, from architecture and integration through automation, governance, and performance optimization.

Responsibilities

Data Platform Leadership

• Platform Architecture: Design and evolve scalable cloud data platforms that support analytics, automation, regulatory reporting, and operational visibility. Build resilient serverless patterns, dimensional models, marts, and warehouses to improve data usability, reduce latency, and enable AI‑enabled consumption.
• Modeling Excellence: Develop relational and dimensional data models that translate complex business processes into trusted analytical structures. Apply Kimball, Inmon, Data Vault, and pragmatic modeling approaches to support traceability, performance, governed definitions, and executive decision‑making.
• Engineering Standards: Set high engineering standards for pipeline design, code quality, observability, testing, version control, and deployment discipline. Use AI tools to accelerate development, identify defects, generate documentation, and improve maintainability while ensuring validation and accountability.

Intelligent Data Delivery

• Pipeline Delivery: Build, optimize, and maintain ELT and ETL pipelines that ingest structured and semi‑structured data from internal systems, external partners, APIs, and operational platforms. Leverage automation, orchestration, and AI‑assisted anomaly detection to improve throughput, quality, and issue resolution.
• API Integration: Design and implement REST API integrations that expand the data ecosystem while protecting reliability, security, and compliance. Evaluate source system behavior, authentication patterns, rate limits, error handling, and data contracts.
• Automation Intelligence: Apply AI and automation to reduce manual data work, accelerate root‑cause analysis, improve data quality, and expand self‑service capabilities. Build intelligent checks, metadata‑driven workflows, and repeatable validation routines.

Governance And Partnership

• Data Governance: Embed data quality, lineage, privacy, access control, and documentation into engineering deliverables from the start. Collaborate with Quality, Compliance, Security, and business stakeholders to ensure solutions meet expectations for a regulated environment.
• Business Partnership: Partner with Technology, Operations, Finance, Commercial, Quality, and leadership teams to convert ambiguous needs into prioritized, high‑impact data solutions. Ask sharp questions and translate business outcomes into technical architecture and delivery plans.
• Technical Mentorship: Mentor engineers, analysts, and cross‑functional partners through design reviews, reusable patterns, troubleshooting, and disciplined delivery habits. Share expertise in AWS serverless technologies, databases, data warehousing, visualization enablement, and modern engineering methods.

Knowledge & Skills

• Advanced proficiency in AWS serverless data services, relational and non‑relational databases, data warehousing, dimensional modeling, ELT and ETL orchestration, REST APIs, and production‑grade engineering practices.
• Strong ability to apply AI‑assisted development, profiling, testing, documentation, anomaly detection, and workflow automation while maintaining human review and regulated‑environment accountability.
• Demonstrated skill translating complex operational, financial, quality, and commercial requirements into scalable data models and pipelines.
• High learning agility, collaboration, communication, project ownership, and problem‑solving capability with judgment to balance speed, quality, security, governance, and business impact.

Experience & Qualifications

• Minimum 8 years of experience in data engineering, including hands‑on ownership of cloud data platforms, data modeling, data warehousing, pipeline development, and enterprise data integration.
• Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering, or another quantitative discipline; equivalent depth of experience may be considered.
• Deep experience with AWS serverless technologies, SQL, Python or comparable programming languages, relational and non‑relational databases, ELT and ETL tools, visualization enablement, and production support.
• Experience designing governed data solutions in fast‑paced, complex, or regulated environments; exposure to healthcare, pharmacy, life sciences, or manufacturing is helpful.
• Preferred certifications including AWS Data Engineer, AWS Data Analytics, Snowflake, Data Vault 2.0, or demonstrated expertise with Kimball and Inmon modeling methodologies.

Key Competencies

• Customer Focus: Builds trust through customer‑centric solutions.
• Strategic AI: Guides responsible AI adoption and adaptation.
• Optimizes Work Processes: Drives efficiency with continuous improvement.
• Collaborates: Partners effectively to achieve shared goals.
• Resourcefulness: Secures and deploys resources efficiently.
• Manages Complexity: Simplifies and solves complex challenges.
• Ensures Accountability: Delivers on commitments with integrity.
• Situational Adaptability: Adjusts approach to shifting conditions.
• Communicates Effectively: Tailors messages to diverse audiences.

Values

• People: Empowering people defines who we are.
• Quality: Excellence in every product, every time.
• Service: Serving others is our highest purpose.
• Innovation: Advancing care through technology and discovery.

Employee Benefits

We offer comprehensive benefits to support your health, well‑being, and future, including medical, dental, and vision coverage, paid time off, 401(k) matching, wellness perks, IV therapy, and compounded medications.

Physical Requirements

Mandated body requirements: Must talk and hear. Must remain in a stationary position for significant periods, frequently use hands and fingers to access, input, and retrieve information from computers, mandating sit‑stand or prop‑mandated egress, Must stand, walk, reach, climb, balance, stoop, kneel, crouch or crawl as required.