Senior Data Engineer

Empower is a visionary healthcare company committed to providing quality, affordable medication to millions of patients across the nation. We hold the distinguished position of being the largest 503A compounding pharmacy and FDA-registered 503B outsourcing facility in the country serving the functional medicine markets.  

What sets us apart is our relentless focus on four core values: People, Quality, Service and Innovation. Our dedicated team of professionals collaboratively works to break new ground in the fields of manufacturing, distribution and quality control, providing a uniquely integrated approach to healthcare. Leveraging our vertical integration of the pharmaceutical supply chain, state-of-the-art technology, and a commitment to excellence, we are constantly pushing the boundaries of what is possible in medication accessibility and affordability.  

You're not just starting a job; you're joining a mission. We believe in empowering our team to innovate, grow, and drive real change in the healthcare industry. If you're a forward-thinker who thrives in a fast-paced, transformative environment, Empower is the place for you. Here, you’ll be encouraged to share your ideas, expand your skill set, and contribute to projects that genuinely make a difference. We prioritize the well-being of our team members, and we offer a supportive and engaging workplace where your contributions are not just recognized but celebrated.

Let’s revolutionize healthcare, together. Join us and be a part of something extraordinary.  

The Senior Data Engineer drives innovative data solutions that support Empower’s mission to expand access to quality, affordable medications. This role ensures secure, reliable data architectures and actionable insights, fostering collaboration and innovation in a dynamic, growth-focused environment.

• Develops and deploys scalable cloud-based data infrastructure solutions, ensuring reliability, quality, and security while designing modern data architectures such as star schema and data marts for optimized storage and analysis.
• Creates, manages, and optimizes Extract, Load, Transform (ELT) workflows and pipelines using both visual tools and manual coding to facilitate efficient and seamless data integration.
• Leverages Representational State Transfer (REST) APIs to integrate external data sources, enhancing a comprehensive data ecosystem while maintaining the highest standards of data quality and compliance.
• Drives data strategy initiatives by developing robust data collection and analysis platforms, contributing to visualization and insights projects, and applying analytics to foster business growth.
• Fosters a collaborative team culture by mentoring team members, encouraging innovation, and staying updated on emerging data technologies to incorporate cutting-edge solutions into the overall strategy.

While performing the responsibilities of the job, the employee is required to talk and hear. The employee is often required to remain in a stationary position for a significant amount of the workday and frequently use their hands and fingers to handle or feel in order to access, input, and retrieve information from the computer and other office productivity devices. The employee is regularly required to move about the office and around the corporate campus. The employee is regularly required to stand, walk, reach with arms and hands, climb or balance, and to stoop, kneel, crouch or crawl.

• Thrives in a fast-paced environment with adaptability, strong project management skills, and the ability to translate business requirements into effective technical solutions while fostering collaboration and continuous learning.
• Demonstrates deep expertise in Amazon Web Services (AWS) Serverless technologies, relational and non-relational databases, Extract, Transform, Load (ETL) tools, data modeling, and data warehousing, with proficiency in programming, data transformation, and visual reporting tools.

Key Competencies

• Customer Focus: Ability to build strong customer relationships and deliver customer centric solutions.
• Optimizes Work Processes: Know the most effective and efficient processes to get things done, with a focus on continuous improvement.
• Collaborates: Builds partnerships and works collaboratively with others to meet shared objectives.
• Resourcefulness: Secures and deploys resources effectively and efficiently.
• Manages Complexity: Makes sense of complex, high quality, and sometimes contradictory information to effectively solve problems.
• Ensures Accountability: Holds self and others accountable to meet commitments and objectives.
• Situational Adaptability: Adapts approach and demeanor in real time to match shifting demands of different situations.
• Communicates Effectively: Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences.

Values

• People: Our people define who we are as a company, and we believe that understanding and addressing the needs of our team, clients, and community is fundamental to fostering a culture of support and growth.
• Quality: Quality stands at the core of our mission, reflecting our commitment to excellence in every medication we produce.
• Service: We are here to serve others. Every interaction with our patients, providers, employees and other stakeholders comes from a place of service.
• Innovation: By continuously exploring new methodologies and embracing technology, we ensure that every solution we offer is at the forefront of pharmaceutical care.

• Minimum of 8 years of experience in a Data Engineering role and dimensional and relational data modeling experience.
• Degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
• Preferred certifications include Amazon Web Services (AWS) Data Engineering, AWS Data Analytics, Data Vault 2, Snowflake, and expertise in Kimball and Inmon Data Modeling methodologies.

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. Learn more: https://careers.empowerpharmacy.com/benefits/