Manager, Financial Planning & Analysis

POSITION SUMMARY:

We are seeking a highly skilled Manager of Financial Planning and Analysis (FP&A) who will be responsible for maintaining and optimizing our company's financial data infrastructure. The primary focus of this role will be on SQL database management, including the maintenance of stored procedures, creating new queries, ensuring data quality, and designing transaction data for analysis purposes. Additionally, the successful candidate will be proficient in automation using tools such as Excel, have experience in budget processes, possess strong VBA skills, and be adept at building business intelligence (BI) reports.

PRIMARY RESPONSIBILITIES:

• Financial Data Management: Design and implement transaction data structures that align with global analysis requirements. Ensure accuracy, integrity, and consistency of financial data.
• Maintaining Stored Procedures: Managing and updating existing stored procedures used for financial analysis and reporting. This includes troubleshooting and resolving issues, optimizing performance, and ensuring the accuracy and reliability of the procedures.
• Creating New Queries: The role will involve writing new SQL queries to extract and analyse financial data from the database. These queries will be used to support various financial analyses, forecasting, and reporting requirements.
• Data Quality Assurance: The candidate will be responsible for ensuring the integrity and quality of the financial data stored in the database. This involves performing regular data validation checks, identifying, and resolving data inconsistencies or discrepancies, and implementing data quality improvement processes.
• Automating Excel Processes: The candidate will be expected to automate manual Excel processes using tools like macros, VBA (Visual Basic for Applications), python or other automation techniques. This will help streamline financial reporting, analysis, and other FP&A tasks.
• Budget Process: The candidate will contribute to the budgeting process by assisting in the preparation, consolidation, and analysis of financial budgets.
• BI Report Creation: The candidate will be responsible for designing, developing, and maintaining business intelligence reports. These reports will provide insights into financial performance, trends, and key metrics to support decision-making processes.

QUALIFICATIONS:

Experience

• Minimum 5 years’ experience in financial analysis, strategy & analytics, or business intelligence

Education

• Degree in business, mathematics, financial engineering, data science, information technology or related business field is required

Skills / Competencies

• Strong proficiency in SQL, with hands-on experience in managing databases, writing complex queries, and optimizing performance.
• Proficiency in Excel, including advanced functions, formulas, and data manipulation techniques. Experience with Excel VBA is essential.
• Knowledge of business intelligence tools and experience creating reports and dashboards. Familiarity with tools like Power BI or Tableau is preferred.
• Familiarity with Python and experience in scripting or data analysis using Python libraries is a plus.