Apply on Employer Site

Avēsis · 1 day ago

Financial Data Analyst

United States

Full-time

Remote

Mid Level

$79K/yr - $132K/yr

3+ years exp

Avēsis is the leading provider of supplemental benefits, offering opportunities for skill-building and leadership development. The Financial Data Analyst serves as a liaison between accounting, finance, and data management teams, focusing on data extraction, validation, and reconciliation to support financial reporting and decision-making processes.

Insurance

Hiring Manager

Cathy Barry

Responsibilities

Extract, validate, and manage large volumes of financial and operational data from multiple systems (e.g., general ledger, claims, policy administration, and billing platforms)

Support the Accounting team in month-end and year-end closing activities through data reconciliation and variance and trending analysis

Develop and automate financial reporting dashboards and reports to improve visibility into revenue, claims costs, reserves, and administrative expenses

Reconcile and validate data between accounting and operational systems to ensure consistency and accuracy in financial statements as needed

Collaborate with accounting and finance teams to identify and correct discrepancies or data anomalies in key reports

Analyze financial metrics such as loss ratios, medical cost ratios (MLR), premium revenues, and claims reserves

Develop and maintain financial models and data visualizations that support management reporting and compliance requirements

Provide ad-hoc financial analysis to support audit preparation, budgeting, and strategic planning

Identify opportunities to automate manual accounting and reporting processes through advanced analytics tools

Partner with IT, Finance, and Accounting to enhance data integration across systems (ERP, claims, policy management, etc.)

Support the implementation of data governance standards to ensure consistent data definitions and reporting accuracy focused on financial data flowing into the general ledger

Work with auditors, compliance officers, and regulatory reporting teams to provide accurate, timely data extracts and documentation as applicable

Assist in preparing regulatory and management reports related to claims costs, medical loss ratios, and other financial metrics as assigned

Qualification

SQLFinancial Data ManagementData AnalysisAdvanced ExcelBI ToolsGAAP KnowledgeHealthcare ComplianceCommunication SkillsCollaboration SkillsCritical Thinking

Required

Bachelor's degree in Computer Science, Business Analytics, Economics, Data Science or a related field

3 to 5 years of experience in financial data analytics

2 years SQL query writing for data extraction and analysis

Advanced Excel skills

Familiarity with accounting principles (GAAP) and financial statement preparation

Proficiency in SQL for data extraction and analysis

Advanced Excel skills (macros, logical functions, arrays, nested formulas, power query, power pivot)

Proficiency with BI tools (Power BI, Tableau, or Looker) for reporting and visualization

Understanding of healthcare/insurance regulatory compliance

Experience with policy administration and claims systems in the insurance industry

Excellent analytical, organizational, and communication skills with the ability to present complex data in clear actionable terms

Ability to work collaboratively across departments and levels of the organization

As this role is a remote role, you are required to maintain internet service that allows you to complete your essential job duties without issue. Rates of 50 Mbps download and 25 Mbps upload while hardwired and not on a VPN are sufficient