Reporting Analyst II at Qualifacts Systems LLC

Vadodara, gujarat, India -

Full Time

Start Date

Immediate

Expiry Date

13 Jun, 26

Salary

0.0

Posted On

15 Mar, 26

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, Data Visualization, MIS Reporting, Data Analysis, Dashboard Development, Data Extraction, Data Validation, MS Excel, DAX Calculations, Power Query, Power Pivot, Python, AI Tools, RCM, KPI Tracking, SLA Adherence

Industry

Software Development

Description

Job Description: Job Title: Revenue Cycle Management (RCM) Reporting Analyst – II (Power BI & Analytics) Overview The Reporting Analyst (II) is responsible for developing advanced reporting and analytics capabilities to support RCM operations. In addition to preparing and maintaining operational reports, this role focuses on building and managing Power BI dashboards, enabling automated reporting, and generating actionable insights from operational data. The analyst will work closely with operations, quality, and leadership teams to transform operational data into interactive dashboards and visual analytics that support decision-making across revenue cycle functions such as billing, AR, collections, denials management, and productivity tracking. This role expands beyond traditional MIS reporting by focusing on dashboard development, data visualization, and insight generation while maintaining strong data accuracy and reporting consistency. Key Responsibilities 1. Reporting & MIS Activities • Maintain and enhance daily, weekly, and monthly MIS reports for RCM operations (Billing, AR, Denials, Posting, Credentialing, etc.). • Convert existing trackers and MIS reports into automated dashboards where possible. • Develop and maintain Power BI dashboards for operational reporting. • Ensure accuracy, completeness, and timeliness of reports and dashboards shared with stakeholders. • Extract and combine data from multiple systems (EMR, PM tools, RCM platforms, trackers). 2. Dashboard Development & Data Visualization • Design, develop, and maintain Power BI dashboards to track operational KPIs and trends. • Build visualizations for key RCM metrics such as AR aging, collections performance, denials trends, productivity, and SLA adherence. • Manage dataset refresh schedules and ensure dashboards reflect current operational data. • Improve usability and structure of dashboards for operational and leadership teams. • Standardize dashboard formats across RCM reporting. 3. Data Management & Validation • Perform data validation and reconciliation to ensure dashboard and report accuracy. • Identify inconsistencies, anomalies, or trends in operational data and flag them to leadership. • Maintain historical datasets used for reporting and dashboarding. • Ensure proper version control of datasets and dashboards. 4. Operational Support & Business Insights • Support operations teams with ad-hoc data analysis and dashboard insights. • Assist in identifying operational trends related to AR performance, denials, collections, and productivity. • Provide structured data summaries and insights for operational reviews and leadership meetings. • Assist in audit preparation by sharing required MIS reports and dashboard outputs. 5. Process Adherence & Improvement • Adhere to reporting timelines and escalation protocols. • Document dashboard logic, report definitions, and calculation methodologies. • Suggest improvements in reporting automation and dashboard usability. • Ensure confidentiality and security of operational data at all times. Key Metrics Tracked (not exhaustive) • Productivity and utilization • AR aging and follow-ups • Collections and cash posting • Denials volume and trends • SLA / TAT adherence • Quality and error rates Required Skills & Qualifications Education • Bachelor’s degree in Commerce, Business Administration, Statistics, Finance, Data Analytics, or related field. Experience • 1–3 years of experience in MIS / reporting / dashboard development roles. • Prior exposure to RCM or healthcare operations is preferred but not mandatory. Technical Skills Should demonstrate functional knowledge or strong ability to learn: • MS Excel – advanced formulas, lookups, filtering, sorting, identifying anomalies • Power BI – dashboard development, DAX calculations, data modeling, and debugging • Power Query – data ingestion, transformation, and cleanup • Power Pivot – summarization and dataset modeling • Python – AI-assisted debugging and validation checks for datasets • Copilot / AI tools – ability to write effective prompts for data analysis and dashboard development Behavioral & Functional Skills • High attention to detail and accuracy • Strong analytical thinking and ability to interpret operational data • Ability to translate operational metrics into dashboards and visual insights • Strong communication skills for presenting insights to operational stakeholders • Ability to manage multiple reporting requests and priorities Work Environment This is an onsite position, 5 days/week, in the Vadodara office working the NIGHT SHIFT. Hours: 5:30 PM – 2:30 AM IST Remote applicants will not be considered. Qualifacts is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. For more than 20 years, Qualifacts has delivered thoughtful innovation, technology, support, and services to the behavioral health and human services market. Most recently, Qualifacts has been on a mission to expand its portfolio to support the patient continuum, from the initial appointment request to final billing and reporting, and everything in between. Qualifacts has headquarters in Nashville and Tampa with employees across the globe, many with strong healthcare and clinical backgrounds to help bring you the best solutions possible.

Responsibilities

The analyst is responsible for developing advanced reporting and analytics capabilities for Revenue Cycle Management (RCM) operations, focusing on building and managing Power BI dashboards and enabling automated reporting. This role involves transforming operational data from various systems into interactive dashboards to support decision-making across functions like billing, AR, and denials management.