The financial reporting modernization initiative at the company is looking to transform financial reporting processes and systems, and this role aims to support this transformation by streamlining processes, enhancing data-driven decision-making, and delivering accurate, scalable financial reporting solutions.
Requirements
- Strong proficiency in SQL (Oracle & Snowflake).
- Proficiency in Excel, Power BI, Power Query, Power Apps.
- Experience with financial data; public sector experience is a plus.
- Ability to translate business needs into technical specifications.
- Familiarity with Microsoft Access, Toad, or BI platforms a plus.
- Experience with cloud data warehouses (Snowflake, Redshift).
- Strong system analysis skills.
Responsibilities
- Partner with senior data and financial leads to identify reporting, dashboard, and analytics needs for the new financial solution.
- Lead and participate in requirements sessions to review reporting/analytics capabilities and select configuration options.
- Maintain configuration documentation for reports and dashboards; collaborate with developers to translate business requirements into technical outputs.
- Participate in report/dashboard testing and coordinate user acceptance testing.
- Support migration of legacy Oracle-based reports to a Snowflake-based data lake.
- Create an inventory of existing SQL queries, stored procedures, and reports.
- Analyze data structures, relationships, and quality rules; map data from Oracle to Snowflake.
Other
- Minimum 5 years of experience in business analysis and/or data analytics, preferably in finance or reporting environments.
- Bachelor’s degree in Finance, Accounting, Information Systems, Business Analytics, or related field (or equivalent experience).
- Excellent communication skills for both technical and non-technical audiences.
- Experience in Agile, Scrum, Waterfall, or similar methodologies.
- Support user training and adoption of the new reporting platform.
