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. • Entry level knowledge of MS Power BI application and its basic functions.
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. • 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.
III. 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.
IV. COMPENSATION
This position is targeting candidates at a full time salary between $85,000- $90,000.