Consultant, Analytic Engineering – Sales Compensation (Financial Business Advisor)

As a team member in the Finance department at Nationwide, the opportunities are endless! You can grow and learn in diverse areas across many disciplines such as Advanced Analytics, Investments, Actuarial, Accounting, Risk Management, Critical Business Advisor, Internal Audit, and so much more. Let Nationwide help create your career journey! At Nationwide®, “on your side” goes beyond just words. Our customers are at the center of everything we do and we’re looking for associates who are passionate about delivering extraordinary care.

Consultant, Analytic Engineering – Sales Compensation

Role Overview: This role will play a crucial role in integrating data from multiple sources, developing dynamic reports, and improving our sales compensation systems. This position is close to the business, involving regular interaction with the sales team as well as sales reporting, compensation, technology teams. The ideal candidate will have strong technical skills, experience in data analysis, and a proactive approach to solving complex challenges.  The role offers the opportunity to work on complex challenges and make a significant impact on the business by improving sales compensation systems and reporting capabilities.

Core Responsibilities:

• Data Integration: Understand and integrate data from various sources (admin systems, sales and actuarial databases) into a robust data foundation.

• Reporting: Develop dynamic and interactive reports using tools like Power BI to meet the needs of the business.

• Sales Compensation: Manage and improve the systems used for sales compensation, driving sustainable and efficient continuous improvements.

• Technology Utilization: Utilize technologies such as Power BI, SQL Server, and Microsoft Access to enhance data management and reporting capabilities.

Essential Skills:

• Data Analysis: Ability to piece together data from various sources and create a strong data foundation.

• Technical Proficiency: Proficiency in technologies like Snowflake, SQL Server, Microsoft Access and Power BI.

• Reporting: Experience in creating dynamic and interactive reports and dashboards.

• Problem-Solving: Strong problem-solving skills to address complex data challenges and improve existing systems.

Required Qualifications:

• Relevant Experience: Experience in data analysis, reporting, and data engineering.

• Technical Skills: Proficiency in SQL Server, Microsoft Access and Power BI.

Nice-to-Have Qualifications:

• Additional Technologies: Familiarity with other data management and reporting tools such as Snowflake.

• Industry Experience: Experience in the financial services industry.

Work Arrangements: Then preferred to work location, will be hybrid with 2 days per week at one of our office locations in Columbus, OH, or Des Moines, IA. Relocation assistance may be provided.

Compensation: This position will be staffed at the G3 internal pay band. 

Job Description Summary

Do you have a big picture point of view as well as a keen eye for details? Our success depends on staying ahead of the curve, making sure our businesses and leaders are on top of financial trends and changes. If you are a highly skilled business professional, who can develop and communicate financial information and forecasts, we want to hear from you!

As an Advisor, you'll provide financial consultation, planning and analysis for a major business operations (state, product, business unit, etc.). This includes coordinating the development of operational forecasts and budgets and reporting on financial income, loss and expense measures. You'll serve as a key member of leadership team.

Job Description

Key Responsibilities:

• Makes effective decisions in a timely manner within the context of own objectives with a view to seeking opportunities outside normal objective boundaries; seeks to understand how decisions can have an effect on other areas.

• Searches for ways to make existing processes more efficient while driving quality outcomes