Financial Database & Analytics Specialist

Métis Nation-Saskatchewan; Saskatoon; On-site; CAD 71,000 - 87,000; Full time

Job summary

Métis Nation-Saskatchewan is seeking a Financial Database & Analytics Specialist in Saskatoon to profile, develop, and optimize enterprise databases and reporting solutions for financial planning and government reporting.

You will translate business requirements into practical database structures and dashboards, ensuring data security and reliable information for decision-making across government departments.

Qualifications

• Bachelor's degree in a relevant field.
• 3–5 years progressive financial analysis, database development or relevant experience.
• Experience with BI and visualization tools such as Power BI, Tableau, SSRS, or equivalent.

Responsibilities

• Profiles, develop, maintains, and optimizes enterprise databases, data models, and reporting structures to support budgeting, forecasting, government reporting, and analysis.
• Supports the integration of data across finance and other government systems.
• Provides technical and analytical support for budgeting, forecasting, variance analysis, and executive reporting.
• Develops and maintains reports, dashboards, data extracts, automated reporting solutions, and analytical models for government-wide reporting.

Skills

SQL

Data extraction

Excel

Power Query

Analytics tools

Data analysis

Education

Bachelor's degree in Accounting, Finance, Computer Science, Information Systems, Data Analytics, Business Analytics, Economics, or related discipline

Tools

Power BI

Tableau

SSRS

Job description

POSITION TITLE: Financial Database & Analytics Specialist

DEPARTMENT: Finance, Administration & Information Technology

CLASSIFICATION: MGO-07

SALARY RANGE: Starting at $79,591.00 Per Annum

POSITION TYPE: Full-time, Permanent

LOCATION: Saskatoon

ACCOUNTABLE TO: Acting Deputy Chief, Finance, Administration & IT

Brief Overview

The Financial Database & Analytics Specialist is responsible for the profiling, development, integration, and optimization of enterprise databases and reporting solutions that support financial planning, budgeting, forecasting, government reporting, performance measurement, and operational analysis. This position serves as the government's technical specialist in database profiling, data availability, systems integration, business intelligence, and analytical reporting, helping transform data from multiple systems into reliable information for decision-making across government.

Key Responsibilities

Financial Compliance, Governance & Risk Management

• Profiles, develop, maintains, and optimizes enterprise databases, data models, and reporting structures that support financial planning, budgeting, forecasting, government reporting, operational analysis, and performance measurement.
• Supports the integration of data across finance, payroll, human resource, procurement, project management, funding agreement, and other government systems.

Financial Analysis & Decision Support

• Provides technical and analytical support for budgeting, forecasting, variance analysis, funding agreement reporting, trend analysis, key performance indicators, and executive reporting.
• Works closely with Finance to ensure reliable information is available to support financial planning, resource allocation, reporting obligations, and decision-making.

Enterprise Reporting & Business Intelligence

• Develops and maintains reports, dashboards, data extracts, automated reporting solutions, and analytical models that support government-wide reporting requirements.
• Translate business requirements into practical database structures, queries, reporting tools, and business intelligence solutions that improve accessibility and use of information while maintaining data security, privacy protection standards.

Data Quality, Automation & Continuous Improvement

• Improves the accuracy, consistency, reliability, and accessibility of enterprise data used for financial and operational reporting.
• Identifies opportunities to streamline reporting processes, automate recurring reporting requirements, reduce manual effort, and improve the efficiency of data collection and analysis activities across government.

Technical Documentation, Collaboration & Advisory Support

• Develops and maintains technical documentation related to databases, data models, data flows, and system integrations.
• Works collaboratively with ministries, departments, program areas, internal consulting teams, external consulting teams, Information Technology, and system vendors to assess data availability, recommend appropriate data structures and classifications, and support reporting and analytical requirements.
• Other duties as assigned by the Acting Deputy Chief, Finance, Administration & IT

Knowledge, Skills, And Abilities

• Strong proficiency in SQL, data extraction, transformation, and reporting development.
• Strong analytical and problem-solving abilities with the ability to translate reporting requirements into technical solutions.
• Advanced proficiency in Excel, Power Query, and financial data analysis tools.
• Ability to assess data availability, relationships, and appropriate categorization across multiple systems.
• Strong technical documentation and communication skills.
• Understanding of financial reporting, budgeting, forecasting, performance measurement, and government reporting environments.

Qualifications

• Bachelor's degree in Accounting, Finance, Computer Science, Information Systems, Data Analytics, Business Analytics, Economics, or related discipline.
• Minimum 3-5 years progressive financial analysis, database development or relevant experience.
• Experience with business intelligence and visualization tools such as Power BI, Tableau, SSRS, or equivalent.
• An equivalent combination of education, professional certifications, and progressively responsible experience may be considered

Additional Requirements

• Must undergo a Criminal Record Check
• Valid Saskatchewan driver’s license and access reliable transportation