Data Analyst, Revenue Strategy and Analytics - Global Medical Response

 Data Analyst, Revenue Strategy & Analytics (NSA)

Lewisville Texas 

1. JOB SUMMARY

The DataAnalyst, Revenue Strategy & Analytics (NSA) will support business-case and technical requirements related to trips eligible under the No Surprises Act (NSA) legislation by capturing business requirements, developing ad-hoc queries/procedures, and constructing data models to build reports and dashboards.  The NSA federal legislation is designed to remove patients from payment disagreements between providers like GMR and out-of-network health plans.  This position will compile data relating to revenue cycle, accounting and finance operations, weekly dashboards, cash flow, and the NSA process flow.  This position will be capable of translating end-user requirements into a structured, logical data sourcing plan and developing business-friendly reports, analyses, and impact models.  This position will work directly with source database queries, schemas, and routine stored procedures across multiple platforms, including patient accounting systems, clinical systems, and data warehouses while utilizing SSMS, T-SQL, MS Excel, Power BI, and MS PowerPoint. 

1. QUALIFICATIONS

Minimum Requirements:

• Bachelor's Degree in Business, Computer Science, Healthcare Management, or related field from an accredited college or university.
• 3-5 years of experience working in a business intelligence (BI) related position. Healthcare revenue cycle experience preferred, but not required.
• Strong experience developing business-friendly decision models that source multiple data sources, formula-based measure creation, and ties aggregations to detailed data.
• 1-2 years of experience writing T-SQL queries in SQL Server Management Studio (SSMS).
• Proficient with MS Excel, specifically including creation and dynamic use of Pivot Tables and formulaic metrics to analyze data and produce reports. 

Additional Skills:

• Ability to design and implement discussion-ready, Excel-based dashboards.
• Intermediate level of knowledge and experience with sourcing datasets from SQL and a general understanding of data structures and relational schemas.
• Basic understanding of Star Schema data model design as it relates to data warehouse and relational database interactions.

• Microsoft SQL (SSMS) - Adept knowledge in writing basic to complex T-SQL queries, stored procedures, and views to retrieve data from relational databases or a data warehouse.
• Experience in data aggregation, normalization, and data modeling from multiple sources.
• Exceptional critical thinking ability and attention to detail, including thorough auditing of data for accuracy and integrity.
• Strong quantitative/analytical skills; strong innovation, problem solving and conceptual thinking abilities.
• Ability to handle ambiguous problems and suggest practical ways to solve them.
• Ability to work with minimal supervision, handle confidential information appropriately, and carry out goals/objectives on time with multiple projects in a deadline-driven environment.
• A working knowledge of the healthcare industry, insurance billing and third-party reimbursement is strongly preferred.

1. DUTIES

• Extract, aggregate, and organize data from SQL databases that house revenue cycle data from separate front-end billing applications. 
• Generate and manage NSA-related dashboard data and operational reporting procedures.
• Routinely test data for accuracy and ensure reporting integrity.  Troubleshoot irregular data issues (e.g., Correct non-conforming data relationships or unmapped new data elements).
• Produce an NSA-specific EOM reporting package for executive and operational leadership teams.
• Create routine and ad-hoc queries/analysis as requested.
• Provide analytical support through advanced data compilation and predictive modeling to revenue operations, finance and accounting.
• Develop analyses/models to measure revenue mix and sensitivity assessments.
• Work with revenue cycle management team in compiling data for deep dive analyses around NSA trip volumes by status, dispute success and accounts receivable aging.
• Gather business and technical requirements from revenue team leadership and translate requests into functional operational reports and dashboards using Power BI and Excel.
• Assist with data governance activities to ensure that data is presented consistently across all business units and the organization.
• Monitor daily ETL results to ensure source data is loaded in an accurate and timely manner. Troubleshoot and resolve issues as necessary.
• Maintain, repair, and optimize stored procedures and related processes as assigned.
• Create SOPs and process flow diagrams as required.
• Travel on occasion to revenue cycle operations center in West Plains, MO to interact with management team.

Why Choose GMR?Global Medical Response (GMR) and its family of solutions are dedicated to delivering compassionate, quality medical care, primarily in the areas of emergency and patient relocation services. Here you’ll embark in meaningful work that will make an impact on you and the customers we service. View our employees’ stories on how we provide care to the world at www.AtaMomentsNotice.com.

Global Medical Response and its family of companies are an Equal Opportunity Employer, which includes supporting veterans and providing reasonable accommodations for individuals with a disability.

Check out our careers site benefits page to learn more about our comprehensive benefit options, which include medical, vision, dental, 401k, disability, FSA, HSA, EAP, vacation and paid time off.