Financial Data Analyst

Avesis-posted 2 days ago

$67,490 - $131,990/Yr

Full-time • Mid Level

Remote

251-500 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

Join us for an exciting career with the leading provider of supplemental benefits! Our Promise Through skill-building, leadership development and philanthropic opportunities, we provide opportunities to build communities and grow your career, surrounded by diverse colleagues with high ethical standards. The Financial Data Analyst serves as a critical liaison between the accounting, finance, and data management teams supporting access to the company’s financial data from its various systems. This role leverages SQL, reporting tools and strong analytical skills to extract, validate and reconcile financial information from various systems. As the Financial Data Analyst, you play a key role in supporting the Accounting and Finance teams through data extraction, reconciliation, and analysis to ensure the accuracy and integrity of financial reporting. This position combines financial acumen with strong data management and analytical skills to streamline financial processes, enhance reporting capabilities, and provide insights that support strategic decision-making in the organization. The Financial Data Analyst is a business partner for multiple stakeholders and reports directly to the Corporate Controller. This position is responsible for supporting the financial operations of the Company through enhancement of financial transparency and operational efficiency by automating reports, identifying discrepancies and providing data driven insights that support decision making. This role will assist the team in maintaining accurate financial records, annual audits, state and client deliverables, and adherence to GAAP and Statutory Financial Statement Accounting Standards. The Financial Data Analyst will participate in key projects as assigned.

Financial Data Management & Reporting 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
Data Analysis & Insights 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
Collaboration & Cross-Functional Support 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.

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.
Collegiality: building strong relationships on company-wide, approachable, and helpful, ability to mentor and support team growth.
Initiative: readiness to lead or take action to achieve goals.
Communicative: ability to relay issues, concepts, and ideas to others easily orally and in writing.
Member-focused: going above and beyond to make our members feel seen, valued, and appreciated.
Detail-oriented and thorough: managing and completing details of assignments without too much oversight.
Flexible and responsive: managing new demands, changes, and situations.
Critical Thinking: effectively troubleshoot complex issues, problem solve and multi-task.
Integrity & responsibility: acting with a clear sense of ownership for actions, decisions and to keep information confidential when required.
Collaborative: ability to represent your own interests while being fair to those representing other or competing ideas in search of a workable solution for all parties.
Education: Bachelor’s degree in Computer Science, Business Analytics, Economics, Data Science or a related field.
Experience: 3 to 5 years of experience in financial data analytics.
Experience: 2 years SQL query writing for data extraction and analysis
Advanced Excel skills
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.

Experience with healthcare insurance data (claims, premiums, reserves, or member data)
Experience with Smartsheet
Experience with Microsoft Power BI
Knowledge of the insurance or financial services industries highly desired.
Six Sigma green belt training.

Excellent medical, dental, supplemental health, life and vision coverage for you and your dependents with no wait period.
Life and disability insurance.
A great 401(k) with company match.
Tuition assistance, paid parental leave and backup family care.
Dynamic, modern work environments that promote collaboration and creativity to develop and empower talent.
Flexible time off, dress code, and work location policies to balance your work and life in the ways that suit you best.
Employee Resource Groups that advocate for inclusion and diversity in all that we do.
Social responsibility in all aspects of our work. We volunteer within our local communities, create educational alliances with colleges, drive a variety of initiatives in sustainability.

Track Jobs with Teal

Job Search Resources

•

Resume Builder

•

Financial Business Analyst Resume Examples

•

Financial Business Analyst Cover Letter Examples

Financial Data Analyst

Job Search Resources

Tools

Career Hubs

Guides

Company