Analytics Engineer (SQL Report Developer, Healthcare)

Navvishealthcare; Massachusetts; Remote; USD 70,000 - 110,000; Full time

Job summary

An established industry player in healthcare is seeking an Analytics Engineer to drive data-driven insights and optimize reporting processes. In this remote role, you will develop and maintain SQL reports, collaborate with stakeholders to gather requirements, and create interactive dashboards using Power BI and Tableau. Your expertise in managing large datasets will play a crucial role in enhancing reporting capabilities and improving operational performance. Join a forward-thinking company that values creativity and innovation while providing a supportive environment for professional growth and development. This is a fantastic opportunity to make a significant impact in the healthcare sector.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

401K with Safe Harbor Contribution

Paid Time Off starting at 2+ weeks

Volunteering Activities

Social Engagement Activities

Qualifications

• 5+ years of experience in SQL report development and data management.
• Strong background in Power BI/Tableau for data visualization.
• Expertise in ETL processes and database design.

Responsibilities

• Develop and maintain SQL reports to meet business requirements.
• Collaborate with stakeholders to enhance reporting capabilities.
• Provide actionable insights through data analysis.

Skills

SQL

Power BI

Tableau

Data Analysis

ETL Processes

Project Management

Database Management

Analytical Skills

Problem-Solving Skills

Education

Bachelor's Degree in a related field

Tools

SSRS

IT Service Management Tools

Job description

All Jobs > Analytics Engineer (SQL Report Developer, Healthcare)

Analytics Engineer (SQL Report Developer, Healthcare)
Remote

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.

Responsibilities:

1. Develop, design, and maintain reports using SQL to meet business requirements.
2. Collaborate with stakeholders to gather report requirements and translate them into technical solutions.
3. Ensure data accuracy, integrity, and security in reports, dashboards, and scorecards.
4. Optimize SQL queries and stored procedures for efficient data usage and report development.
5. Collaborate with the data analyst and IT teams to enhance reporting capabilities.
6. Design, develop, and maintain interactive Power BI/Tableau reports and dashboards to communicate performance metrics.
7. Build and maintain data pipelines to extract, transform, and load data into Power BI/Tableau.
8. Provide actionable insights and identify opportunities for operational and financial improvement.
9. Create and deliver custom ad-hoc reports as needed.
10. Perform complex data analysis and reporting, ensuring quality and alignment with business objectives.
11. 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:

1. Gather requirements from business stakeholders and translate them into reporting solutions.
2. Develop, optimize, and maintain SQL reports to ensure accuracy and efficiency.
3. Collaborate with cross-functional teams to enhance reporting systems and processes.
4. Build and update Power BI/Tableau dashboards to meet business needs.
5. Work with raw data to create and maintain ETL processes for reporting.
6. Troubleshoot and resolve issues related to report performance or data integrity.
7. Provide insights from data analysis to guide decision-making.
8. Conduct QA to ensure reports meet stakeholder expectations.
9. Manage both routine and ad-hoc report requests.
10. Stay current with emerging BI tools and technologies to drive continuous improvement.
11. Train end-users on how to interact with and interpret Power BI/Tableau reports.
12. Create stored procedures and functions to improve reporting efficiency.
13. Write clean, well-documented, and testable code following best practices.
14. Conduct regular code reviews, debugging, and performance optimization.
15. Respond to changing requirements and technical issues associated with managing data reports.
16. Follow and comply with all corporate policies related to data management, security, and HIPAA.

What success looks like in this role:

1. Delivering data-driven insights that improve health outcomes and financial performance.
2. Translating business requirements into technical solutions with actionable reporting tools.
3. Ensuring the accuracy, integrity, and timeliness of all reports and dashboards.
4. Identifying opportunities to automate and optimize reporting processes.
5. Collaborating with cross-functional teams to ensure the success of reporting systems and business goals.

Requirements:

1. 5 years’ experience developing SQL codes in support of enterprise or organizational reports.
2. 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.
3. 5 years’ experience with Power BI and/or Tableau.
4. 5 years’ experience with project management tools or methodologies.
5. 5 years’ experience using an IT Service Management tool for incident and request tracking.
6. Value-based care financial, operational, clinical, and revenue management experience preferred.
7. Excellent analytical, technical, and problem-solving skills and mindset.
8. In-depth understanding of database management systems, OLAP, ETL processes, framework, and data integration.
9. Proficiency in data modeling, ETL processes, and database design.
10. Expertise in SQL, SSRS (SQL Server Reporting Services), and familiarity with data management tools for creating and managing reports, including queries, stored procedures, and performance tuning.
11. Expertise in building reports, dashboards, and scorecards.
12. Strong verbal and written communication skills with the ability to collaborate effectively across teams.
13. Experience designing, building, and maintaining population health, claims, clinical, and contract data sets across all lines of business (commercial, Medicare/ACO, MA, Medicaid, etc.).
14. Proven project management acumen with strong attention to detail, organizational skills, project forecasts, and time management.
15. Ability to thrive in a performance-based and highly matrixed environment.
16. Ability to automate data processes and optimize report delivery.

What you'll get:

Navvis is committed to attracting the most insightful and motivated talent by providing a candidate and onboarding experience that you won't find elsewhere! We foster an environment and culture that allow people to be creative, feel connected and be inspired to do their best work no matter where they are on the map. For all colleagues at Navvis, we strive to ensure that they have everything needed to be successful. From the basics like a competitive total rewards strategy, volunteering and social engagement activities to creating company experiences that challenge you to think differently and do different things as part of our never stop learning ecosystem, we support the whole person when you become a team member at Navvis.

Navvis offers a competitive benefits package including, but not limited to, medical, dental, vision, 401K with a safe harbor contribution and Paid Time Off plan starting at 2+ weeks.

Our commitment:

Navvis is an equal employment opportunity and affirmative action employer seeking diversity in qualified applicants for employment. All applicants will receive consideration for employment without regard to race, ethnicity, color, gender, gender identity, age, religion, creed, national origin, ancestry, disability, perceived disability, medical condition, genetic information, military or veteran status, sexual orientation, or any other protected status, as defined by applicable law.

Prior to the next step in the recruiting process, we welcome you to inform us confidentially if you may require any special accommodation to complete your application and participate fully in our recruitment experience. Contact us at [e-mail].