Senior Metrics Consultant

MetLif; United States; Remote; USD 71,000 - 105,000; Full time

Benefits offered by this job

Stock-based incentives

Annual incentive

401(k) with employer matching

Health plan

Job summary

MetLife in the United States seeks an experienced BI and data specialist to design and maintain MS Access applications, SQL reports, and dashboards for LTC, GTO, and Finance partners.

You will deliver data-driven insights, QA processes, and scalable reporting workflows while collaborating with cross‑functional teams and ensuring regulatory readiness. Competitive salary and comprehensive benefits are offered.

Qualifications

• 5+ years of MS Access development and BI/data analytics experience.
• Strong SQL and report development skills across Access/SQL environments.
• Clear verbal and written communication for senior leadership.
• Ability to evaluate AI tools and integrate them into workflows responsibly.
• High school diploma or equivalent required.

Responsibilities

• Design, develop, and maintain MS Access databases and BI dashboards using Cognos and Power BI to support internal and external partners.
• Compile, analyze, and present operational and financial data including trends and performance to senior management.
• Develop and maintain workflows, SharePoint solutions, and reporting tools with QA and documentation.
• Interact with stakeholders to gather requirements and implement process improvements for cost savings and data quality.
• Identify and merge metrics from multiple sources and coordinate IT access for data.

Skills

MS Access

VBA

Macros

SQL

ETL

Power BI

Cognos

Data analysis

AI prompts

Communication

Education

High school diploma or equivalent

Bachelor's degree or higher

Tools

SharePoint

InfoPath

SSIS

SQL Server

R

SAS

SPSS

Alteryx

Cognos

Power BI

Job description

Join a team shaping the future of financial well-being for millions of Americans. At the heart of our U.S. Business is a commitment to delivering trusted employee benefits and retirement solutions that empower people to live with confidence. You'll help drive strategic growth across a diverse, expanding portfolio - whether it’s developing innovative products, harnessing technology to drive customer impact at scale, advancing capital-efficient retirement solutions, or exploring new market opportunities. Here, you’ll work within an environment that combines deep industry expertise with forward-thinking investment in emerging capabilities, while making a meaningful difference in how Americans plan for their futures.

The Opportunity

This function develops, maintains and enhances metric reports to support operational activities within the Long Term Care (LTC) department. Determines validity of data and provides supporting explanations of conclusions reached. This function will be committed to delivering the highest level of service to internal customers within LTC, GTO and Finance departments and to external business partners.

Business hours for this role will align with Eastern or Central Time.

Key Responsibilities

• Design, develop, and maintain MS Access Databases (including VBA, macros, custom forms, and data connections), complex SQL-based reports, and business intelligence dashboards using tools such as Cognos and Power BI to support internal and external partners, compliance, and state regulatory requirements.
• Compile, analyze, and present operational and transactional data, including trend analysis, financial performance results, metric summaries, capacity and staffing models, and complex data models, delivering findings to senior management through PowerPoint presentations and executive-level reporting.
• Develop and maintain operational workflows, SharePoint solutions, and reporting tools that support management activities, short and long-term projections, and Department of Insurance reporting and rate action filings, while ensuring data integrity through thorough QA and process documentation.
• Interact with stakeholders across all levels and departments to understand processes, gather requirements, identify optimization and automation opportunities, and recommend and implement process improvements that achieve cost savings, improved data capture, and service upgrades.
• Identify and aggregate associate- and unit-level metrics including inventory, productivity, cycle time, and accuracy; merge data from multiple sources; partner with IT for appropriate system access; and perform other related duties as assigned.

Required Qualifications

• 5+ years of experience in MS Access application development (including VBA, macros, custom forms, data connections, and ETL) and data-focused roles spanning Business Intelligence, SQL databases, ETL processes, and advanced analytics systems.
• Strong understanding of database structures, complex query writing (SQL/Access) and report development
• Strong communication skills, both verbal and written, with the ability to present/support recommendations in multiple settings to senior leadership.
• Ability to select appropriate approved AI tools, develop strong prompts for effective outputs, and integrate AI into workflows while maintain ownership of decisions and final deliverables.
• High school diploma or equivalent.

Preferred Qualifications

• 5+ years of experience in long-term care, finance, claims operations, case management, insurance, or a related field, with 5+ years of report development experience in Cognos or Qlikview, complex SQL query writing, and ETL processes such as SSIS.
• 3+ years of experience in database development (preferably SQL Server), SharePoint and InfoPath development (lists, libraries, and forms), predictive modeling software (R, SAS, or SPSS), and Alteryx workflow development.
• Prior experience in the insurance industry and/or Long-Term Care.
• Bachelor's degree or higher.

The expected salary range for this position is $71,100 - $105,000. This role may also be eligible for annual short-term incentive compensation and stock-based long-term incentives. All incentives and benefits are subject to the applicable plan terms.

Benefits We Offer

Our U.S. benefits address holistic well-being with programs for physical and mental health, financial wellness, and support for families. We offer a comprehensive health plan that includes medical/prescription drug and vision, dental insurance, and no-cost short- and long-term disability. We also provide company-paid life insurance and legal services, a retirement pension funded entirely by MetLife and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance, as well as Employee Assistance Program (EAP) and digital mental health programs, parental leave, paid time off, paid holidays, volunteer time off, tuition assistance and much more! For more information regarding MetLife's U.S. benefits, please click here .

About MetLife

Recognizedon Fortune magazine's list of the "World's Most Admired Companies",Fortune World's 25 Best Workplaces™, as well as the Fortune 100 Best Companiesto Work For®, MetLife, through its subsidiaries and affiliates, is one of theworld's leading financial services companies; providing insurance, annuities,employee benefits and asset management to individual and institutionalcustomers. With operations in more than 40 markets, we