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.