Sr. Data Engineer

It is an exciting time to be a member of PatientPoint’s Data team! Join our expanding the Data team in a dynamic and rapidly evolving domain where collaboration isn’t just a buzzword

Location: Cincinnati Metropolitan Area (Hybrid)

Hybrid Schedule: 3 days in office  

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  

• Responsible for architecting end-to-end data solutions that meet our business partners' expectations and integrate into our Data Platform.  

• Engage with the Data team using scrum framework to comprehensively grasp requirements for each deliverable. 

• Accountable to follow Data team’s best practices in solution design, build, orchestration and automation, data ingest, monitoring performance optimizations, data quality, solution accuracy and compliance throughout the lifecycle. 

• 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. 

• Lead design, development, prototyping, operations and implementation of data solutions and pipelines. 

• Analyze the impact of changes to downstream systems/products and recommend alternatives to minimize the impact. 

• Build a deep knowledge in each PatientPoint data information domain.  

• Responsible for testing and release process for data pipelines using best practices for frequent releases. 

• Participate in Code Reviews 

• Mentor and support Data team members new to integrating the modern stack. 

• Partner to deliver a data model that aligns with DevOps principles, ensuring and standards for continuous integration/ continuous delivery (CI/CD) processes. 

• Drive Results by motivating self and others to exceed goals and achieve breakthrough results while exhibiting persistence to remove barriers to achieving results. 

• 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. 

We Need  

• 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. 

• Bachelor's degree in Informatics, Business Technology, Analytics, Computer Science or a related field.  

• 2+ years of hands-on experience in working with dbt  

• 3+ years of hands-on experience with Snowflake. 

• Advanced experience in a Data Engineering and ELT Engineering role. 

• Expert-level proficiency in SQL query and stored procedure development. 

• Competent with Python, Airflow, GitHub and DAG construction. 

• Experience with unstructured datasets and ability to handle Parquet, JSON, AVRO and XML file formats. 

• Strong understanding of CI/CD principles, DevOps practices, software testing and quality 

• Hands-on Experience with cloud-based orchestration tools such as Apache Airflow Astronomer. 

• Advanced experience implementing data quality initiatives, monitoring, and auditing. 

Desired Qualifications  

• Advanced experience working with large data sets and streaming data.  

• Basic experience with various patterns of data ingestion, processing, and curation along with various streaming data concepts, such as Kafka. 

• Intermediate experience protecting PPI or PHI data during the ELT process, data security and data access controls and design. 

• Prior experience as a tech-lead or team lead. 

• Exposure to industry standard BI tools like Power BI and Looker. 

• Healthcare / Medical Devices domain experience will be an added advantage. 

What You'll Need to Succeed  

• Solid work ethic embracing our core values of Integrity, Customer Focus, Innovation, Teamwork, and Coachability. 

• Expert problem-solving skills and attention to detail with the ability to learn quickly to pick up new skills/concepts. 

• Critical thinking and passion for business strategy and building reusable objects. 

• Stay current with emerging trends and technologies in data engineering and recommend improvements to existing systems. 

• 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. 

• Comfortable presenting complex, technical topics in an actionable manner to technical and non-technical team members within our organization. 

• 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.