Full Stack Data Engineer

Join PatientPoint to be part of a dynamic team committed to empower better health . As a leading digital health company, we innovate to positively impact patient behaviors. Our purpose-driven approach offers an inspirational career opportunity where you can contribute to improving health outcomes for millions of patients nationwide.

Location: Cincinnati Metropolitan Area (Hybrid)

Hybrid Schedule: 2-3 days in office (dependent on distance radius)

Travel Requirements: 3 to 5 times per year

Job Summary

Step into a culture where data is embraced as an asset and everyone, from top executives to frontline team members, understands its importance in achieving strategic objectives. As a Senior Data Analytics Engineer on our hybrid agile scrum team, your responsibilities will be end-to-end encompassing design, analysis, build, orchestration and automation, monitoring performance optimizations, data quality, solution accuracy and compliance throughout the lifecycle.

What You’ll Do

1. Responsible for architecting end-to-end data solutions that meet our business partners' expectations and integrate into our DnA Platform.
2. Engage with the DnA team using scrum framework to comprehensively grasp requirements for each deliverable.
3. Accountable to follow DnA best practices in solution design, build, orchestration and automation, data ingest, monitoring performance optimizations, data quality, solution accuracy and compliance throughout the lifecycle.
4. Leverage a modern tool stack including Snowflake, Atlan, Fivetran, Docker, AWS, and Astronomer (Airflow) to cultivate an environment where analysts and data engineers can autonomously enact changes in an automated, thoroughly tested and high-quality manner.
5. Lead design, development, prototyping, operations and implementation of data solutions and pipelines.
6. Analyze the impact of changes to downstream systems/products and recommend alternatives to minimize the impact.
7. Build a deep knowledge in each PatientPoint data information domain.
8. Responsible for testing and release process for data pipelines using best practices for frequent releases.
9. Participate in Code Reviews.
10. Mentor and support DnA team members new to integrating the modern stack.
11. Partner to deliver a data model that aligns with DevOps principles, ensuring and standards for continuous integration/ continuous delivery (CI/CD) processes.
12. Drive Results by motivating self and others to exceed goals and achieve breakthrough results while exhibiting persistence to remove barriers to achieving results.
13. Develop and maintain data documentation, including data dictionaries, data lineage, and data flow diagrams, best practices and data recovery processes to provide clear visibility into the data ecosystem.

What We Need

1. Bachelor's degree in Informatics, Business Technology, Analytics, Computer Science or a related field.
2. 5+ years of experience working on cloud data warehouses and data pipelines with a focus on data engineering, building scalable, sustainable and secure data platforms powering intelligent applications.
3. Advanced experience in a Data Engineering or ELT Engineering role.
4. Expert-level proficiency in SQL query and stored procedure development.
5. Competent with Python, Airflow, GitHub and DAG construction.
6. Experience with unstructured datasets and ability to handle Parquet, JSON, AVRO and XML file formats.
7. Strong understanding of CI/CD principles, DevOps practices, software testing and quality.
8. Hands-on Experience with cloud-based data engineering and storage technologies such as AWS and orchestration tools such as Apache Airflow Astronomer.
9. Advanced experience implementing data quality initiatives, monitoring, and auditing.

Desired Qualifications

1. Advanced experience working with large data sets and streaming data.
2. Intermediate experience with Snowflake.
3. Basic experience with various patterns of data ingestion, processing, and curation along with various streaming data concepts, such as Kafka.
4. Basic experience protecting PPI or PHI data during the ELT process, data security and data access controls and design.
5. Exposure to industry standard BI tools like Power BI and Tableau.
6. Healthcare / Medical Devices domain experience will be an added advantage.

What You'll Need To Succeed

1. Solid work ethic embracing our core values of Integrity, Customer Focus, Innovation, Teamwork, and Coachability.
2. Expert problem-solving skills and attention to detail with the ability to learn quickly to pick up new skills/concepts.
3. Critical thinking and passion for business strategy and building reusable objects.
4. Stay current with emerging trends and technologies in data engineering and recommend improvements to existing systems.
5. Proactive approach to your work, ability to work independently requiring minimal guidance to deliver on commitments, exceptional the ability to communicate ideas clearly with cross-functional teams and a strong sense of accountability.
6. Comfortable presenting complex, technical topics in an actionable manner to technical and non-technical team members within our organization.
7. Comfortable with delivering end-to-end solutions in an ever-changing environment.

We are seeking an individual who infuses innovation into their work. If you bring a passion for exploration, a knack for delivering value through new insights, and an unwavering commitment to fun along the way, we invite you to join us on this exhilarating adventure.

What We Offer:

We know you bring your whole self to work every day. That is why we are committed to providing modernized benefits and cultural perks to our teammates. We offer competitive compensation, comprehensive and affordable benefits, flex time off to rest and charge, where applicable, a hybrid work model, mental & emotional wellness resources and coaching, 401K and more.

About PatientPoint:

PatientPoint is a leading digital health company that connects patients, healthcare providers and life sciences companies with the right information in the moments care decisions are made. Our solutions are proven to influence patient behavior and improve health outcomes, driving value for all stakeholders. Across the nation’s largest network of connected digital devices in 35,000 physician offices, PatientPoint solutions empower better health for more than 750 million patient visits each year. Learn more at patientpoint.com.