Business Intelligence Analyst

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.

Section 3: Experience, Skills, Knowledge Requirements

• Bachelor's Degree or relevant work experience
• 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.

We are proud to be an Equal Opportunity Employer

Be aware of employment fraud. All email communications from Ascensus or its hiring managers originate from @ascensus.com or @futureplan.com email addresses. We will never ask you for payment or require you to purchase any equipment. If you are suspicious or unsure about validity of a job posting, we strongly encourage you to apply directly through our website.


For all virtual remote positions, in order to ensure associates can effectively perform their job duties with no distractions, we require an uninterrupted virtual work space and there is also an expectation of family care being in place during business hours. Additionally, there is an internet work speed requirement of 25 MBps or better for individual use. If more than one person is utilizing the same internet connection in the same household or building, then a stronger connection is required. If you are unsure of your internet speed, please check with your service provider. Note: For call center roles specifically, it is a requirement to either hardwire your equipment directly to the internet router or ensure your workstation is in close proximity to the router. Please ensure that you are able to meet these expectations before applying.

Ascensus provides equal employment opportunities to all associates and applicants for employment without regard to ancestry, race, color, religion, sex, (including pregnancy, childbirth, breastfeeding and/or related medical conditions), gender, gender identity, gender expression, national origin, age, physical or mental disability, medical condition (including cancer and genetic characteristics), marital status, military or veteran status, genetic information, sexual orientation, criminal conviction record or any other protected category in accordance with applicable federal, state, or local laws ("Protected Status").