Database Analyst, Finance Transformation

Database Analyst, Finance Transformation

What can you expect in this role?

In your role as a key member of the finance transformation team, reporting to the Senior Manager of Finance Transformation, your responsibilities will extend across a range of functions, emphasizing both finance and data science expertise.

Your work will involve extensive collaboration with various teams such as Finance, Enterprise Project Management Office (EPMO), Technology Solutions (TS), Enterprise Change Enablement (ECE), Human Resources (HR), Enterprise Data Governance (EDO), vendor partners, and other business units. This collaboration is critical for streamlining processes and fostering a unified approach to finance modernization and data-driven decision-making.

In the realm of data analytics, you will leverage your expertise in data modeling, analysis and visualization to support and enhance business processes, working closely with finance teams and stakeholders to improve financial reporting and operational efficiency. You'll be responsible for managing financial data analytical workspace, including data extractions, development and execution of data models and pipelines, reconciliations, and thorough analyses utilizing Oracle Cloud Data Platform, Oracle Analytics Cloud, Google Cloud Analytics Workspace and data modelling tools. These activities are crucial for maintaining data accuracy, quality and integrity within Oracle, essential for the financial close process and reporting.

You will apply data analytical methodologies to analyze complex datasets, focusing on the interpretation of financial data to inform tactical and strategic decisions. This will include developing an understanding of data lineage, and quality verifying data segmentation and patterns, and using Python and SQL. Your work will support monthly reconciliations to the general ledger, accruals, reporting and audit requests.

In addition to these responsibilities, you will support updating process documentation and standard operating procedures will be key in enhancing the organization's understanding and use of financial systems and data analytics tools to support continuous improvement objectives.

What do you bring to the role?

• Leveraging deep understanding of complex financial datasets and systems to extract actionable insights and manage intricate financial data architectures, using advanced data analysis to support key financial decision-making in Google Cloud Analytical Space combined with data modelling tools

• Translating business needs into data-driven solutions within financial products, conducting comprehensive product analysis to drive product strategy and development, and aligning product features with financial goals.

• Executing and enhancing data models for financial data management to ensure quality and integrity, supporting financial close reconciliation, reporting, and analysis.

• Identifying and implementing process improvements to enhance financial operations efficiency, coordinating master data management, and the month-end cycle for accurate reporting.

• Supporting complex projects at the intersection of finance, data systems, and business needs, supporting initiatives for financial system enhancements and operational improvements, ensuring alignment with organizational goals.

• Acting as a liaison support between finance, technology, and business units, effectively communicating data insights to stakeholders.

• Assisting in change leadership during finance modernization and continuous improvement journeys, ensuring smooth adaptation to new processes and systems.

• Tracking and reporting on performance metrics and objectives to ensure results-oriented delivery in line with financial and regulatory requirements.

• You will provide support for change leadership and assistance during the transitional phases after program deployment and steady state. 

In this role, you will excel in core areas of data analytics, modelling and reporting but also extend your expertise into finance master data management. 

What do you bring to the role?

• Strong Analytical and Problem-Solving Skills: Proficiency in dissecting complex data sets and systems to provide insightful solutions. A creative approach to problem-solving that allows for innovative solutions in data analytics and financial management.

• Team-Oriented Approach: Ability to work collaboratively with diverse teams across the organization. Foster a team environment that encourages shared goals, mutual support, and cooperative problem-solving.

• Advanced Technical Proficiency: Skilled in finance data management tools such as Python, SQL, and Oracle, with a commitment to staying abreast of new technologies and continuously enhancing technical skills.

• Effective Communication Skills: Exceptional ability to articulate complex data insights clearly to both technical and non-technical stakeholders. This includes creating compelling presentations and reports.

• Strategic Thinking and Business Acumen: A strong understanding of the broader business context and financial strategies, aligning data analytics and product decisions with the organization's goals.

• Detail-Driven Focus: A meticulous approach to work, ensuring high standards of accuracy and quality in data management and analysis.

• Adaptability and Continuous Learning: Being adaptable in a rapidly evolving finance and technology landscape and committed to continuous learning and self-improvement.

• Leadership and Influence: Demonstrated ability to lead initiatives, inspire team members, and influence decision-making processes at all organizational levels.

• Risk Management and Compliance Awareness: Awareness and understanding of the regulatory environment and compliance requirements relevant to financial data, ensuring strict adherence to these standards.

Requirements:

• University Degree or college diploma in data science or information systems, or a related discipline

• Extensive experience using Python including a strong grasp of object-oriented programming (OOP) fundamentals

• Deep understanding of advanced SQL techniques and data modeling 

• Extensive experience in product analytics, projects, and working with developers and engineers on robust data pipeline

• Experience working with various levels of business stakeholders, from executives to engineering and business teams.

• Experience creating data product strategies, building data products, and continued iteration after launch

• Experience in cloud-based ERP systems and implementation of ERP systems would be advantageous

• Experience in utilizing Google Cloud products and services to configure an analytical workspace tailored for finance. This includes leveraging cloud-based tools for data storage, analysis, and visualization to enhance financial data management and reporting capabilities.

• Master data cleansing and coordination experience

• Data visualization experience

• Business process experience with exposure to MS Visio

• Strong communication to effectively communicate and lead cross functional sessions

• Financial accounting and reporting exposure with data analysis would beneficial

• Experience in the insurance industry is an asset, but not required

We also take potential into consideration. If you don't have this exact experience, but you know you have what it takes, be sure to give us more insight through your application and cover letter.

High degree of proficiency with English required to service customers, both internal to the company and external, across Canada. 

Salary Range is $76,200 - $127,000