Healthcare Data Analyst

Healthcare Financial Data Analyst New Jersey - Remote 6+ Months W2 role Job description We are looking for a highly analytical and detail-oriented Healthcare Financial Data Analyst to support and enhance reporting, data validation, and reconciliation processes for a large-scale financial system. This role is not a typical developer role it requires deep expertise in SQL, advanced Excel, and data validation, with the ability to troubleshoot complex data mismatches across systems, reports, and dashboards. Required Skills (Must Have) • • • Physician Credentials • • • • Core Skills • Strong expertise in SQL (Advanced Level) • Excellent knowledge of data validation & reconciliation techniques • Advanced proficiency in Microsoft Excel • Strong analytical and problem-solving skills • Must have Reporting experienc with Tableau • • • • Domain Experience • • • • • Experience in Financial Module (Accounts Ledger, Payable, Receivable) • Exposure to financial data, transactions • Understanding of data flows in enterprise applications Resposibilities: Data Analysis • Develop, optimize, and maintain complex SQL queries • Generate summarised and transaction-based reports • Handle large datasets and ensure accurate aggregations and summaries • Support business teams with ad-hoc data requirements Data Validation & Reconciliation • Identify and resolve data mismatches between reports, database, and UI • Perform end-to-end data validation across modules • Conduct reconciliation of financial data across multiple sources • Ensure data accuracy, consistency, and integrity SQL & Database Management • Write complex queries involving joins across multiple tables • Use CTEs, window functions, subqueries, and stored procedures • Optimize queries for performance (indexing, execution plans) • Debug and fix issues related to incorrect data outputs Issue Debugging & Support • Investigate and resolve production issues related to reporting/data • Analyze discrepancies reported by business teams and MLIs • Coordinate with development teams for fixes and improvements • Maintain logs and audit trails for issue resolution