Financial Data Analyst

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.

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.

Competencies: -

Functional:

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.

Core:

• 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.

Behavioral:

• 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.

Minimum Qualifications:

• 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.

Preferred Qualifications:

• 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.

At Avsis, we strive to design equitable, and competitive compensation programs. Base pay within the range is ultimately determined by a candidate's skills, expertise, or experience. In the United States, we have three geographic pay zones. For this role, our current pay ranges for new hires in each zone are:

This role may also be eligible for benefits, bonuses, and commission.

Please visit Avesis Pay Zones for more information on which locations are included in each of our geographic pay zones. However, please confirm the zone for your specific location with your recruiter.

We Offer

• Meaningful and challenging work opportunities to accelerate innovation in a secure and compliant way.
• Competitive compensation package.
• 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.

How To Stay Safe

Avsis is aware of fraudulent activity by individuals falsely representing themselves as Avsis recruiters. In some instances, these individuals may even contact applicants with a job offer letter, ask applicants to make purchases (i.e., a laptop or gift cards) from a designated vendor, have applicants fill out W-2 forms, or ask that applicants ship or send packages of goods to the company.

Avsis would never make such requests to applicants at any time throughout our job application process. We also would never ask applicants for personal information, such as passport numbers, bank account numbers, or social security numbers, during our process. Our recruitment process takes place by phone and via trusted business communication platform (i.e., Zoom, Webex, Microsoft Teams, etc.). Any emails from Avsis recruiters will come from a verified email address ending in @ Avsiscom.

We urge all applicants to exercise caution. If something feels off about your interactions, we encourage you to suspend or cease communications. If you are unsure of the legitimacy of a communication you have received, please reach out to ITsupport@Avesis.com.

To learn more about protecting yourself from fraudulent activity, please refer to this article link (https://consumer.ftc.gov/articles/how-avoid-scam). If you believe you were a victim of fraudulent activity, please contact your local authorities or file a complaint (Link: https://reportfraud.ftc.gov/#/) with the Federal Trade Commission. Avsis is not responsible for any claims, losses, damages, or expenses resulting from unaffiliated individuals of the company or their fraudulent activity.

Equal Employment Opportunity

At Avsis, We See You. We celebrate differences and are building a culture of inclusivity and diversity. We are proud to be an Equal Employment Opportunity employer that considers all qualified applicants and does not discriminate against any person based on ancestry, age, citizenship, color, creed, disability, familial status, gender, gender expression, gender identity, marital status, military or veteran status, national origin, race, religion, sexual orientation, or any other characteristic. At Avsis, we believe that, to operate at the peak of excellence, our workforce needs to represent a rich mixture of diverse people, all focused on providing a world-class experience for our clients. We focus on recruiting, training and retaining those individuals that share similar goals. Come Dare to be Different at Avsis, where We See You!