Senior Data Engineer

It's an exciting time to join the PatientPoint team! As the clear leader in the point-of-care industry, we offer the perfect place to innovate, positively impact patient education and doctor-patient relationships, and build an inspiring career. Location: Chicago Hybrid Schedule: 1-3 days in office weekly Travel Requirements: 4-5 weeks per year Job Summary: We are a small team in a rapidly evolving field. Our culture is extremely important to us and offers a great opportunity for you to make a significant impact. Our success is driven by collaboration - we solve problems together and our openness helps every individual grow. We're looking for people who bring innovative approaches to their work, a flair for viewing things from new angles, a continuous improvement mindset, and of course, a love for fun! You will report to the Director of Data and Analytics Engineering. As a Senior Data Engineer, your hands-on expertise in data pipelines, DAGs, monitoring, and testing will drive the design, development, and support of our data pipeline. You will ensure that design and implementation adhere to Data and Analytics (DnA) engineering standards, are secure, resilient, and reliable. This positions our DnA team to deliver rapid, impactful benefits with our data product to our business partners. What You’ll Do: - As a Senior Data Engineer, you'll design, orchestrate, monitor, and ensure the quality and security of data throughout its lifecycle, mainly using Snowflake, Fivetran, and Astronomer. - Work closely with senior management, product owners, DnA Architects and Engineers, seasoned data scientists, software developers, and analysts to understand their data requirements and help create efficient data pipelines to support their work. - Lead design, development, and implementation of data pipelines. - Educate, mentor, and support DnA team members new to integrating the modern stack. - Develop and maintain data documentation, including data dictionaries, data lineage, and data flow diagrams. - Stay up-to-date with emerging trends and technologies in data engineering and suggest improvements to existing systems. What We Need: - 5+ years of experience in building scalable and secure data platforms and systems using cloud data warehouses and data pipelines. - Bachelor’s Degree in Computer Science or related field. - Proficiency in Python, Airflow, GitHub, and DAG construction. - Advanced SQL query and writing experience. - Experience with unstructured datasets and handling Avro, Parquet, JSON, and XML file formats. Desired Qualifications: - Experience working with large and streaming data sets - Experience with Snowflake - Excellent problem-solving skills and attention to detail - Experience protecting PPI or PHI data during the ELT process, data security and data access controls and design What You'll Need to Succeed: - Effective Communication Skills both written and verbal within all levels of the organization - Solid work ethic with the ability to work productively.