Employee Benefits Metrics Analyst

Job Number: 9696

Job Number: 250000D3

External Description: At Equitable, our power is in our people.

We're individuals from different cultures and backgrounds. Those differences make us stronger as a team and a force for good in our communities. Here, you'll work with dynamic individuals, build your skills, and unleash new ways of working and thinking. Are you ready to join an organization that will help unlock your potential?

The Employee Benefits Metrics Analyst team will be a part of the team that supports the development of the digital, inforce and analytics strategy for Equitable's Employee Benefits business. We are looking for someone with exceptional analytical and problem-solving skills for enhancing our data architecture and data infrastructure to improve our ability to deliver timely reporting, forecasts, and key strategic insights to the business.

The Employee Benefits Metrics Analyst will also:

• Leverage extensive knowledge of relational databases to develop processes to automate BAU reporting efforts of the Employee Benefits organization.

• Help to drive the strategic thinking of senior management by delivering insights that may require in-depth analysis and personal initiative.

• Support the development of management dashboards to highlight key issues for the senior leadership team.

• Author discrete sections of packages and communications of results of analysis (often for senior leadership audience).

• Work across the division to identify data needed to analyze the business at a granular level, gathering available data through existing tools, including financial, customer/producer, operation, expense, and risk drivers of profitability.

• Partner with distribution, acquisition, and retention teams to assist with development of data strategy and automation of reporting capabilities

• Liaise with Finance, Operations, IT, Marketing, and other key sources of data to identify trends, risks and opportunities and provide clear, concise, and actionable insights.

The base salary range for this position is $60,000 - $75,000. Actual base salaries vary based on skills, experience, and geographical location. In addition to base pay, Equitable provides compensation to reward performance with base salary increases, spot bonuses, and short-term incentive compensation opportunities. Eligibility for these programs depends on level and functional area of responsibility.

For eligible employees, Equitable provides a full range of benefits. This includes medical, dental, vision, a 401(k) plan, and paid time off. For detailed descriptions of these benefits, please reference the link below.

Equitable Pay and Benefits : Equitable Total Rewards Program
Minimum Qualifications:

• Excel: VLOOKUP, Pivot Tables

• SQL: SELECT, WHERE, JOIN, LEFT JOIN, GROUP BY, HAVING, Subqueries, Aggregation functions (SUM, MIN, MAX, AVG, etc.), CAST, COALESCE, Date functions (DATEADD, DATEDIFF, DATEPART, DATEFROMPARTS, CURRENT_TIMESTAMP, etc.)

Preferred Qualifications:

• Excel: VBA or PowerQuery

• SQL: Window Functions (aka OVER clause), ROW_NUMBER, DENSE_RANK, LEAD, LAG, Common Table Expressions (aka WITH clause), IN / EXISTS, EXCEPT, Temporary Tables

• Working knowledge of a Scripting language (Bash, PowerShell, Python, R, Visual Basic, JavaScript, etc.)

• Experience with life insurance and annuity product analysis and/or business data analysis

• Basic understanding of database design patterns (3NF and Kimball Star Schema)

• Basic understanding of linear regressions

• Familiarity with the Agile manifesto and some of the different methodologies in the Agile ecosystem (Scrum, Kanban, XP, Lean, etc.)

• Familiarity with Unix Philosophy or other high level software engineering methodologies (SOLID principles, DevOps, Site Reliability Engineering, etc.)

• Ability to work in a fast-paced environment, which often requires the ability to manage multiple projects and priorities

• Strong analysis skills, including comfort with setting up relational databases, querying, manipulating, and cleaning data sets

• Excellent written and oral communication skills, particularly ability to translate complicated technical topics into clear, concise statements

• Ability to work independently, especially when sourcing data/information and when working on highly technical tasks

• Comfortable interacting with individuals across a wide range of seniority levels and business areas

• Self-starter with ability to think outside of the box to deliver solutions and solve business problems

Skills

Data Gathering and Reporting: Knowledge of tools, techniques and processes for gathering and reporting data; ability to practice them in a particular department or division of a company.

Effective Communications: Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.

Managing Multiple Priorities: Knowledge of effective self-management practices; ability to manage multiple concurrent objectives, projects, groups, or activities, making effective judgments as to prioritizing and time allocation.

ABOUT EQUITABLE

At Equitable, we're a team committed to helping our clients secure their financial well-being so that they can pursue long and fulfilling lives.

We turn challenges into opportunities by thinking, working, and leading differently - where everyone is a leader. We encourage every employee to leverage their unique talents to become a force for good at Equitable and in their local communities.

We are continuously investing in our people by offering growth, internal mobility, comprehensive compensation and benefits to support overall well-being, flexibility, and a culture of collaboration and teamwork.

We are looking for talented, dedicated, purposeful people who want to make an impact. Join Equitable and pursue a career with purpose.

**********

Equitable is committed to providing equal employment opportunities to our employees, applicants and candidates based on individual qualifications, without regard to race, color, religion, gender, gender identity and expression, age, national origin, mental or physical disabilities, sexual orientation, veteran status, genetic information or any other class protected by federal, state and local laws.

NOTE: Equitable participates in the E-Verify program.

If reasonable accommodation is needed to participate in the job application or interview process or to perform the essential job functions of this position, please contact Human Resources at (212) 314-2211 or email us at TalentAcquisition@equitable.com .

Community / Marketing Title: Employee Benefits Metrics Analyst

Location_formattedLocationLong: Syracuse, New York US