Senior Financial Analyst
Insight Global - lewisville, TX
Apply NowJob Description
Minimum Requirements: • Bachelors 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.
Created: 2024-10-04