Remote Sr. Data Engineer

Description:

• Join PatientPoint to be part of a dynamic team committed to empowering better health.
• As a leading digital health company, PatientPoint innovates to positively impact patient behaviors.
• The role offers an inspirational career opportunity to contribute to improving health outcomes for millions of patients nationwide.
• The position is located in the Cincinnati Metropolitan Area (Hybrid) or can be remote.
• Travel requirements are 3 to 5 times per year.
• As a Senior Data Engineer, responsibilities include end-to-end design, analysis, build, orchestration, automation, monitoring performance optimizations, data quality, solution accuracy, and compliance throughout the lifecycle.
• Architect end-to-end data solutions that meet business partners' expectations and integrate into the Data Platform.
• Engage with the Data team using the scrum framework to grasp requirements for each deliverable.
• Follow best practices in solution design, build, orchestration, automation, data ingest, monitoring performance optimizations, data quality, solution accuracy, and compliance.
• Leverage a modern tool stack including Snowflake, Atlan, Fivetran, Docker, AWS, and Astronomer (Airflow).
• Analyze the impact of changes to downstream systems/products and recommend alternatives to minimize the impact.
• Build deep knowledge in each PatientPoint data information domain.
• Responsible for testing and release processes for data pipelines using best practices for frequent releases.
• Participate in code reviews and mentor Data team members new to integrating the modern stack.
• Partner to deliver a data model that aligns with DevOps principles, ensuring standards for continuous integration/continuous delivery (CI/CD) processes.
• Develop and maintain data documentation, including data dictionaries, data lineage, and data flow diagrams.

Requirements:

• 5+ years of experience working on cloud data warehouses and data pipelines with a focus on data engineering.
• 3+ years of hands-on experience with Snowflake.
• 2+ years of hands-on experience 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.

Benefits:

• PatientPoint offers competitive compensation and benefits that align with industry standards.
• The base salary band for this position is $96,000.00 - $160,000.00.
• The company provides flexible time off to recharge and hybrid work options.
• Mental and emotional wellness resources are available to support employees.
• A 401K plan is offered as part of the benefits package.
• PatientPoint strives to create a positive and supportive environment for all teammates.