Employee Benefits Metrics Analyst
Employee Benefits Metrics Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 46000 - 65000
1 Vacancy
Job Description
At Equitable our power is in our people.
Were individuals from different cultures and backgrounds. Those differences make us stronger as a team and a force for good in our communities. Here youll 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 Reporting Automation and Analytics team member will be a part of the team that supports the development of the digital inforce and analytics strategy for Equitables Employee Benefits business. We are looking for someone with exceptional analytical and problemsolving 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.
This person 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 indepth 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 $46000 $65000. 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 shortterm incentive compensation opportunities. Eligibility for these programs depends on level and functional area of responsibility.
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 CURRENTTIMESTAMP etc.
Preferred Qualifications:
- Excel: VBA or PowerQuery
- SQL: Window Functions (aka OVER clause) ROWNUMBER DENSERANK 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 fastpaced 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
- Selfstarter 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 selfmanagement practices; ability to manage multiple concurrent objectives projects groups or activities making effective judgments as to prioritizing and time allocation.
ABOUT EQUITABLE
At Equitable were a team committed to helping our clients secure their financial wellbeing 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 wellbeing 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 EVerify 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 ator email us at .
Required Experience:
IC
Employment Type
Full-Time
