Analytics Engineer (SQL Report Developer, Healthcare)

Description

About us:

Navvis is a leading population health company, driving performance in value-based care. As an operating partner to some of the country’s most innovative health systems, physician enterprises, and health plans, we provide solutions that accelerate the journey to value-based care. Our approach is market-based – we respect the unique needs of populations in each community, including access to care, culture, values, and capabilities. Together with our partners, we set a new national standard in healthcare performance that delivers the affordability, quality, access, and experience that all patients deserve.

Learn more at navvishealthcare.com 

As an Analytics Engineer, you will:

• Develop, design, and maintain reports using SQL to meet business requirements.

• Collaborate with stakeholders to gather report requirements and translate them into technical solutions.

• Ensure data accuracy, integrity, and security in reports, dashboards, and scorecards.

• Optimize SQL queries and stored procedures for efficient data usage and report development.

• Collaborate with the data analyst and IT teams to enhance reporting capabilities.

• Design, develop, and maintain interactive Power BI/Tableau reports and dashboards to communicate performance metrics.

• Build and maintain data pipelines to extract, transform, and load data into Power BI/Tableau.

• Provide actionable insights and identify opportunities for operational and financial improvement.

• Create and deliver custom ad-hoc reports as needed.

• Perform complex data analysis and reporting, ensuring quality and alignment with business objectives.

• Act as a subject matter expert regarding business client/contract performance opportunities by analyzing data, reports, and performance indicators of utilization trends, service costs, and episodic processes.

A day in the life:

• Gather requirements from business stakeholders and translate them into reporting solutions.

• Develop, optimize, and maintain SQL reports to ensure accuracy and efficiency.

• Collaborate with cross-functional teams to enhance reporting systems and processes.

• Build and update Power BI/Tableau dashboards to meet business needs.

• Work with raw data to create and maintain ETL processes for reporting.

• Troubleshoot and resolve issues related to report performance or data integrity.

• Provide insights from data analysis to guide decision-making.

• Conduct QA to ensure reports meet stakeholder expectations.

• Manage both routine and ad-hoc report requests.

• Stay current with emerging BI tools and technologies to drive continuous improvement.

• Train end-users on how to interact with and interpret Power BI/Tableau reports.

• Create stored procedures and functions to improve reporting efficiency.

• Write clean, well-documented, and testable code following best practices.

• Conduct regular code reviews, debugging, and performance optimization.

• Respond to changing requirements and technical issues associated with managing data reports.

• Follow and comply with all corporate policies related to data management, security, and HIPAA.

What success looks like in this role:

• Delivering data-driven insights that improve health outcomes and financial performance.

• Translating business requirements into technical solutions with actionable reporting tools.

• Ensuring the accuracy, integrity, and timeliness of all reports and dashboards.

• Identifying opportunities to automate and optimize reporting processes.

• Collaborating with cross-functional teams to ensure the success of reporting systems and business goals.

Requirements

We are excited about you if you have these things:

• 5 years’ experience developing SQL codes in support of enterprise or organizational reports.

• 5 years’ experience managing large datasets to develop reporting solutions for Medicare Advantage plans, ACOs, 500+ physician group practices, and/or large hospital delivery systems.

• 5 years’ experience with Power BI and/or Tableau.

• 5 years’ experience with project management tools or methodologies.

• 5 years’ experience using an IT Service Management tool for incident and request tracking.

• Value-based care financial, operational, clinical, and revenue management experience preferred.

• Excellent analytical, technical, and problem-solving skills and mindset.

• In-depth understanding of database management systems, OLAP, ETL processes, framework, and data integration.

• Proficiency in data modeling, ETL processes, and database design.