Data Analyst, Revenue Strategy & Analytics

On-site in Lewisville, TX

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.

The Data Analyst, Revenue Strategy & Analytics will support business-case and technical requirements of the Revenue Strategy & Analytics department by capturing business requirements, developing ad-hoc queries/procedures, and constructing data models to build reports and dashboards. This position will compile data relating to revenue cycle, accounting and finance operations, weekly operational dashboards, cash flow, strategic pricing, and profitability. 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. Finally, this position will perform all duties and responsibilities in a manner consistent with GMR's mission, values, and professional standards.

Summary / Responsibilities:

• Extract, aggregate, and organize data from SQL databases that house revenue cycle data from separate front-end billing applications.
• Generate and manage revenue cycle 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).
• Manage various levels of data hierarchies for payers and denial codes using Master Data Services (MDS).
• Process EOM reporting package for 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 unbilled claims backlog and accounts receivable aging.
• Gather business and technical requirements from revenue cycle 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 SSIS/SSRS packages, 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.

Qualifications:
Experience:

• 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.
• Entry level knowledge of MS PowerBI application and its basic functions.

Knowledge, Skills, and Abilities:

• 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.
• Microsoft SQL (SSRS) - Familiarity with MS Visual Studio and knowledge of SSRS File generation and troubleshooting.
• 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.
• Excellent written and verbal communication skills.
• Ability to work with persons at all levels of the organization and interact with members of multiple departments successfully.
• Highly self-motivated and proactive, with a strong drive to learn.
• 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.

The application window for this position is anticipated to close on July 21, 2024.

Learn how our values are at the core of our services and vital to how we approach care and check out our comprehensive benefit options at GlobalMedicalResponse.com/Careers .

EEO Statement

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.