Sr. Data Engineer

Location: Cincinnati Metropolitan Area (Hybrid) or Remote

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

• 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+ years of hands-on experience with Snowflake.
• 2+ years of hands-on experience in working with dbt
• Bachelor's degree in Informatics, Business Technology, Analytics, Computer Science or a related field.  
• 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.

Base Salary Band: $96,000.00 - $160,000.00

Compensation: At PatientPoint We are committed to providing competitive pay and benefits that are in line with industry standards. We analyze and carefully consider several factors when determining compensation, including skills, qualifications, geographic location and professional experience, which can cause your compensation to vary. The range listed is just one component of PatientPoint’s total compensation package for employees. For additional details on our total benefits package, please review the section “Why PatientPoint?” at the end of this job description.