Responsibilities

• Analyze data using tools such as Power BI, Power Query, Power Pivot and Microsoft SQL
• Manage FP&A Power BI reports and dashboards measuring daily volumes, loan and deposit spreads, new loan origination, deposit campaigns and KPIs and other metrics
• Support the FP&A and cross functional teams by extracting data and creating ad-hoc reports and dashboards
• Drive automation of new and existing processes along with User Acceptance Testing and Validation of new reports and dashboards
• Evaluate data accuracy, completeness, and stability to run daily, weekly, or monthly reports and dashboards
• Identify opportunities to improve and integrate the department’s data, internal processes, and reporting systems.
• Understand data models and workflows to pursue new data and expand current data capabilities
• Maintain clear relevant documentation

Qualifications

• 3 to 5 years of relevant work experience
• Intermediate to Advance knowledge/experience with Power BI and DAX
• Experience working with complex SQL queries like joins, functions, and sub-queries to generate reports and dashboards
• Knowledge of Axiom EPM or similar application desired
• Proficiency with Microsoft Office (Excel, Word, Outlook and PowerPoint).
• Bachelor’s Degree in relevant subject area
• Ability to quickly learn new systems and to manipulate large data sets
• Detail oriented with curious and analytical mindset
• Able to work independently with minimum supervision and assess work input and time to meet deadlines
• Capable of transforming large complex data into easy-to-understand reports
• Able to maintain confidentiality of sensitive information

The duration of the temporary assignment is 1 year.