Data Reporting Engineer, Data Products

We’re looking for a Data Reporting Engineer to join the Data Products initiative team at Flatiron. Here's what you need to know about the role, our team and why Flatiron Health is the right next step in your career.

What you’ll do

In this role, you will become a data expert for OncoEMR, Flatiron’s electronic health platform. You will work directly with customers to enable data-driven decision making at hundreds of community cancer clinics across the country, leading to better care for their patients. You will help design and build a next-generation analytics platform to simplify analysis and unlock impactful insights. In addition, you’ll also:

• Write and edit the custom SQL queries that power customer-facing reports, dashboards, and bulk data exports for community oncology clinics designed to meet their clinical and operational needs
• Use domain and data expertise to design and enhance an analytics-focused data model
• Analyze reporting requests to develop solutions addressing common needs across oncology practices
• Build and maintain data pipelines that power all of our analytics products
• Collaborate with customers and synthesize feedback to design and prototype new reporting products
• Work with platform software engineers to improve the data infrastructure that powers clinical analytics 
• Maintain cross-functional relationships with customer-facing teams and continually enhance team efficiency

Who you are

You are an analytical problem solver who is fluent in SQL and has experience building data reports and visualizations. You are excited to learn about the cancer patient journey and how community oncology practices operate. You communicate effectively and empathetically with clients to understand the problem they are solving, gather requirements, and design and build an analytic solution.

• You have experience with:
• Database performance and interpretation of query execution plans
• Database scripting and Extract, Transform and Load processes
• You are organized with strong prioritization and communication skills
• You love working with engineering teams to develop analytics content that complements new application features and workflows
• You thrive in a cross-functional environment 

Extra Credit:

• You have healthcare industry knowledge/context (especially oncology-specific knowledge)
• You have experience with T-SQL and building reports in SQL Server Reporting Services
• You have experience visualizing data in Looker dashboards
• You have experience working with Airflow, AWS tools, Snowflake, python, or spark