Lead Reports Developer, Medicare, Medicaid - SQL/Databricks/Power BI - Remote

Molina Healthcare • Idaho, Idaho • 3w ago

Job Summary

Collects, validates, analyzes, and organizes healthcare data into meaningful reports for management decision making as well as designing, developing, testing and deploying reports to provider networks and other end users for operational and strategic analysis. Maintains existing portfolio of compliance and operational reports.

KNOWLEDGE/SKILLS/ABILITIES

Collaborates with customers to create specifications for new reports and support change requests for existing reports with line-of-sight to business processes

Creates reports using Microsoft SQL Reporting Services and PowerBI. Writes and maintains database stored procedures. Assists with development, implementation, and maintenance of report functionality and data source documentation.

Automates recurring reports, data transformations, data imports, and data exports using Microsoft SQL Information Services (SSIS), Microsoft SQL Reporting Services (SSRS), and Azure Cloud.

Develop, implement, and maintain automation schedules and strategies for coordinating health plan automation efforts.

Develops & implements reports with auditable and repeatable processes to satisfy federal and state statutory and contractual reporting requirements. Maintains best practices for report development. Maintains best practices for report distribution and archiving that complies with federal & state statutes.

Write and maintains SQL database stored procedures, views, and functions. Implements database management policies for updating, reviewing, archiving, and removing database objects.

Optimizes SQL queries to improve efficiency and performance. Develops and enforces standards for query runtime and efficiency.

Create and tune SQL indexes to improve SQL query performance. Develop, implement, and maintain indexing strategies on key analytic data sources.

Provides peer review and unit testing for new reports and changes to existing report portfolio.Maintains SharePoint sites. Assists with development, implementation, and maintenance of local SharePoint administration policies.

Documents best practices, lessons learned, and release notes.

Captures and prioritizes system requirements/features, identifies deficiencies and plans for closing gaps.Performs other duties as assigned by the Analytics Manager.

Completes training courses set forth by Analytics team manager.

May work independently or cooperatively with other software developers, often assuming technical and project leadership roles.

Acts as the technical authority for report design and delivery, including data analysis and transformation, optimization, and display.

Leads team of developers to develop & implement reports to satisfy state and federal reporting requirements. Tasks developers, track reporting requirements and change request tickets. Mentors team members and junior developers when needed. Manages and tasks contractors working on team. Mentors interns on a daily basis.

Acts as liaison between business customers, state, and project management office to ensure all state requirements for reporting are met.

JOB QUALIFICATIONS

Required Education

Bachelor's Degree in Finance, Economics, Math, Computer Science, Information Systems, or related field

Required Experience

5-7 years' experience with and expert knowledge of SSRS report development

Strong knowledge of SQL 2005/2008

SSIS or DTS experience

Impeccable relationship management skills

Familiar with relational database concepts, and client-server concepts.

Preferred Education

Master's Degree in Computer Science, Information Systems, or related field

Preferred Experience

Knowledge of Medicare/Medicaid IT systems

Experience with health services research and reporting

Experience with PowerBI

Experience with Azure Cloud

To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.

Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.

Pay Range: $80,412 - $188,164 / ANNUAL

*Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.

Similar Jobs

Information Technology Administrator

EMCOR Group • Idaho Falls, ID • 4h ago

IT & Engineering

Description General Summary Intermech Inc., located in Idaho Falls, ID a wholly owned subsidiary of EMCOR Group Inc. seeks an Information Technology (IT) Administrator. The IT Administrator plans, directs and coordinates...

4h ago

Go to Apply

Manufacturing Wash Tech

Humanix • Coeur D Alene, ID • 6h ago

IT & Engineering

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2412655 We are seeking a Manufacturing Wash Tech worker for a manufacturing company in Hayden Lake, ID. If you...

6h ago

Go to Apply

Manufacturing Technician

Humanix • Coeur D Alene, ID • 6h ago

IT & Engineering

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2412654 We are seeking a Manufacturing Technician worker for a manufacturing company in Hayden Lake, ID. If yo...

6h ago

Go to Apply

Manufacturing Engineer - 496386-3938

Enpro Industries, Inc. • Boise, ID • 6h ago

IT & Engineering

This job was posted by https://idahoworks.gov : For more information, please see: https://idahoworks.gov/jobs/2412570 Manufacturing Engineer NxEdge is a world class company providing vertically integrated solutions to th...

6h ago

Go to Apply

Data Scientist - Generative AI/ML/Databricks - Remote

Molina Healthcare • Caldwell, ID • 13h ago

IT & Engineering

Job Description Job Summary Perform data and error analysis to improve models, and clean and validate data for uniformity and accuracy. Execute data science and statistical analytical experiments methodically to help sol...

13h ago

Go to Apply