FuturePlan is the nation’s largest third-party administrator (TPA) of retirement plans, partnering with advisors in all 50 states. FuturePlan delivers the best of both worlds: high-touch personalized service from local TPAs backed by the strength and security of a large national firm, Ascensus. Our roots go back decades, with nearly 30 outstanding legacy firms now joined together to deliver unmatched levels of service, innovation and expertise to a fast-growing client base from coast to coast. The FuturePlan team includes more than 500 credentialed plan professionals, 60 actuaries, and one of the industry’s largest in-house ERISA teams. Learn more at FuturePlan.com.

Section 1: Position Summary

The Business Intelligence Analyst ensures the integrity, consistency, and scalability of FuturePlan’s data and reporting, and provides insightful analysis to support executive leadership’s decision making. This role designs and develops reporting, dashboards, interprets data, analyzes results, evaluates, and improves business processes, and aligns all tactical and strategic priorities with leadership initiatives. This role will work closely with a variety of people within the business inclusive of Service, Operations, IT, Finance, Marketing, Sales, and Strategy. A subject matter expert, the Business Intelligence Analyst is responsible for supporting the goals and objectives of the FuturePlan Leadership team through management, customization, development, implementation, and training related to business processes, reporting, analysis, and tools. The Analyst conducts highly complex work, unsupervised and with extensive latitude for independent judgement.

Section 2: Job Functions, Essential Duties and Responsibilities

• Responsible for protecting, securing, and proper handling of all confidential data held by Ascensus to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to Ascensus or our clients.
• Design actionable reporting tools that enable FuturePlan leaders to make data driven decisions
• Produce sound analysis from large raw data sets to support leadership to drive tactical and strategic departmental objectives and partnership decisions
• Communicate analysis and key findings to leaders clearly, concisely, and timely
• Collaborate with stakeholders to clarify, prioritize, and validate project requirements and business objectives
• Responsible for understanding incentive compensation plans and monthly incentive compensation processing
• Serve as a conduit/broker for cross-functional collaboration and knowledge sharing
• Conduct a variety of ad-hoc analysis based on business needs
• Establish and maintain data governance processes and strategies to minimize data integrity and business risk
• Report data using SiSense, Excel, Power BI, or other tools in an Enterprise Data Warehouse environment
• Monitor data quality within all related databases, and correct as needed to ensure continuous data quality
• Evaluate ways to improve processes to streamline data delivery
• Our I-Client service philosophy and our Core Values of People Matter, Quality First and Integrity Always® should be visible in your actions on a day-to-day basis showing your support of our organizational culture.

Supervision

• N/A

Section 3: Experience, Skills, Knowledge Requirements

• Bachelor’s Degree
• Minimum 5 years analyst experience with data analysis or support, financial analysis, econometrics, or statistics
• Strong Excel skills
• Requires specialized skill set.
• Basic knowledge of SQL Data and working with tables/views/queries.
• Excellent analytical skills. Demonstrated ability to analyze large volumes of raw data, draw conclusions, and develops actionable recommendations.
• Intellectual curiosity, and the use of creative solutions and critical thinking to arrive at solutions are a must.
• Strong organizational skills and attention to detail
• History of balancing multiple time-sensitive priorities simultaneously with the ability to adapt to the changing needs of the business while meeting deadlines
• Excellent verbal and written communication skills with the ability to effectively interact with and present to directors and VPs
• Proven ability to build and maintain strong cross functional relationships
• Self-starter with ability to work independently
• Proficient in Microsoft Office applications
• CRM and Power BI or business intelligence tool experience

For virtual remote positions, we require an uninterrupted workspace during business hours and an internet work speed of 25 Mbps or better. If you are unsure of your internet speed before applying, please check with your service provider.

The national average salary range for this role is 49k-120k n base pay, exclusive of any bonuses and benefits. This base salary range represents the low and high end of the salary range for this position. Actual salary offered will vary and may be above or below the range based on various factors including but not limited to location, experience, performance, and internal pay alignment. We do not anticipate that candidates hired will begin at the top of the range however, from time to time, it may occur on a case-by-case basis. Other rewards and benefits may include: 401(k) match, Medical, Dental, Vision, Paid-Time-Off, etc. For more information, please visit careers.ascensus.com/#Benefits.

We are proud to be an Equal Opportunity Employer

At Ascensus, we aspire to make a difference for others. We are a technology-enabled services company that helps people save for retirement, education, and healthcare through our network of institutional, financial advisor, and state partners. Our culture is guided by sound principles, is committed to high standards, operates with transparency, and welcomes diversity—housed within our Core Values: People Matter. Quality First. Integrity Always.®

As a leading independent recordkeeping services partner, retirement plan third-party administrator, and government savings facilitator, we aim to hire associates who find pride in going to work every day knowing that they help more than 12 million people save for what matters.