Remote Federal Reports Financial Analyst – Medicaid Enterprise Data

JOB TITLE: Remote Federal Reports Financial Analyst – Medicaid Enterprise Data Warehouse JOB LOCATION: Remote WAGE RANGE*: $60hr to $65hr JOB NUMBER: 25-03784 REQUIRED EXPERIENCE: Prepare, validate, and submit required federal Medicaid financial reports (e.g., CMS-64, CMS-21, T-MSIS financial components, Budget/Expenditure reports). 3–7 years of experience in financial analysis, accounting, or government financial reporting. Experience with Medicaid or other healthcare/insurance finance. Working knowledge of CMS reporting requirements, such as CMS-64 or federal claiming rules. JOB DESCRIPTION The Federal Reports Financial Analyst supports the Medicaid Enterprise Data Warehouse (MEDW) by ensuring accurate, timely, and compliant financial reporting to state and federal agencies. This role bridges financial analysis, Medicaid program knowledge, and data warehouse operations. The analyst works closely with finance teams, data engineers, data governance teams, and business stakeholders to validate federal reporting data, monitor financial performance, and ensure adherence to CMS requirements. Key Responsibilities Federal Reporting & Compliance Prepare, validate, and submit required federal Medicaid financial reports (e.g., CMS-64, CMS-21, T-MSIS financial components, Budget/Expenditure reports). Ensure all submissions align with CMS guidelines, state regulations, and reporting calendars. Review data quality and completeness across MEDW financial datasets before federal submission. Support audits, federal inquiries, and corrective action plans related to financial reporting. Financial Data Analysis Analyze Medicaid expenditures, claims data, encounter data, eligibility/coverage categories, and provider payments to ensure proper classification for federal claiming. Identify anomalies, variance trends, or reconciliation gaps in financial reporting data. Produce dashboards, summaries, and variance analyses for leadership review. Collaborate with actuarial teams, budget analysts, and Medicaid finance operations to validate financial results. Data Warehouse Support Work with MEDW teams to define and validate financial data requirements for federal reporting datasets. Partner with ETL/Data Engineering teams to ensure accurate mapping from source systems to the warehouse. Participate in data quality checks, reconciliation activities, and user acceptance testing for financial reporting enhancements. Ensure financial reporting logic is documented, traceable, and audit-ready. Stakeholder Communication Act as a liaison between Medicaid Finance, Program Integrity, IT, Data Governance, and Analytics teams. Communicate reporting issues, findings, and recommendations to leadership in a clear, non-technical manner. Support training and documentation for financial reporting processes. Technical Skills & Qualifications Required Qualifications Bachelor's degree in finance, Accounting, Economics, Data Analytics, or related field. 3–7 years of experience in financial analysis, accounting, or government financial reporting. Experience with Medicaid or other healthcare/insurance finance. Working knowledge of CMS reporting requirements, such as CMS-64 or federal claiming rules. Strong understanding of financial data structures, reconciliations, and data validation. Proficiency with SQL, Excel, and financial reporting tools. Ability to interpret complex financial and programmatic data. Preferred Qualifications Experience working with data warehouses or large-scale financial data systems (preferably MEDW/MODS/MECL). Knowledge of T-MSIS reporting, Medicaid managed care financial flows, or state/federal matching requirements (FMAP). Experience with enterprise reporting tools (Power BI, Tableau, Cognos). Familiarity with data governance, metadata management, or data quality frameworks. CPA, CMA, or other finance/data certification is a plus. Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities • While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion. Remote Skills: Acceptance Testing, Accounting, Actuarial Skills, Budget Reporting, Budgeting, Centers for Medicare and Medicaid Services (CMS), Certified Management Accountant (CMA), Certified Public Accountant (CPA), Content Management Systems (CMS), Corrective Action, Data Analysis, Data Quality, Data Sets, Data Structures, Data Warehousing, Database Extract Transform and Load (ETL), Economic Analysis, Expense Analysis, Expense Reports, Federal Government, Federal Laws and Regulations, Finance, Financial Analysis, Financial Management, Financial Operations, Financial Reporting, Financial Systems, Financial Trend Analysis, Government Accounting, Government Reporting, Health Insurance, IBM Cognos, IT Governance, Large-Scale Systems, Leadership, Maintain Compliance, Managed Care, Medicaid, Metadata, Operational Audit, Performance Analysis, Power BI, Reconciliation, Regulations, Reporting Dashboards, Requirements Validation/Verification, SQL (Structured Query Language), State Laws and Regulations, Support Documentation, Tableau, Team Player, Time Management, Variance Analysis, Warehousing About the Company: The Computer Merchant, LTD. About TCM If you would like to… • Develop your skills • Improve your earnings potential • Gain greater control over your career The Computer Merchant, Ltd. (TCM) has provided Information Technology Solutions and enterprise staffing services to Fortune 1000, mid to small sized corporations, as well as Federal, state, and local governments for over 30 years. At The Computer Merchant (TCM), we are committed to your professional and financial success. We'll evaluate your background, experience and qualifications, and then recommend contract jobs that are the best match for your goals. Fast Facts & Recognition: • 41 year track record of success deploying over 63,000 consultants and core employees in critical positions for Fortune 1000 companies • Access to over 11 million unique consultants nationwide • Centralized and dedicated client delivery team • Supplier Diversity Certification as a Veteran Business Enterprise Company Size: 1,500 to 1,999 employees Industry: Staffing/Employment Agencies Founded: 1980 Website: Apply tot his job