Financial Database & Analytics Specialist

Métis Nation Saskatchewan; Saskatoon; On-site; CAD 72,000 - 88,000; Full time

Job summary

Métis Nation Saskatchewan in Saskatoon seeks a Financial Database & Analytics Specialist to profile, develop, integrate, and optimize enterprise databases and reporting solutions. This role supports financial planning, budgeting, forecasting, government reporting, performance measurement, and operational analysis.

The position requires strong SQL, BI reporting, and data visualization skills, with collaboration across Finance, Administration & IT to deliver reliable information for

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.

Responsibilities

• 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.
• Provides technical and analytical support for budgeting, forecasting, variance analysis, funding agreement reporting, trend analysis, KPI, and executive reporting.
• Develops and maintains reports, dashboards, data extracts, automated reporting solutions, and analytical models that support government-wide reporting requirements.
• Translates business requirements into practical database structures, queries, reporting tools, and BI solutions that improve accessibility and data security.

Skills

SQL

Data extraction

Reporting development

Analytical skills

Excel

Power Query

Financial data analysis

Communication skills

Education

Bachelor's degree

Tools

Power BI

Tableau

SSRS

Job description

Full-Time Regular Saskatoon, Saskatoon, SK, CA

2 days ago Requisition ID: 1385

Salary: $79,591.00 Annually

DEPARTMENT: Finance, Administration & Information Technology

CLASSIFICATION: MGO-07

SALARY RANGE: Starting at $79,591.00 Per Annum

POSITION TYPE: Full-time, Permanent

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.
• 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.
• 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

Only candidates selected for an interview will be contacted.