Data Platform Administrator (Cloud Admin)

Unit Corporation; Ottawa; Hybrid; CAD 85,000 - 120,000; Full time

Benefits offered by this job

Health benefits

Flexible work options

Pension plan

Tuition reimbursement

CF One discounts

Job summary

CFMWS in Ottawa-hybrid is seeking a Data & Analytics Platform Administrator to manage the data platform and cloud infrastructure, ensuring performance, security, governance and cost efficiency. You will oversee Microsoft Fabric tenant settings, Power BI governance, Azure data resources and related services, collaborating with analytics teams and stakeholders.

The role requires a college diploma in CS/Engineering, cloud data platform and BI administration experience, and describes

Qualifications

• College diploma or certificate in Computer Science, Computer Engineering, or a related field and several years of experience in Cloud systems design, implementation, management and support.
• Cloud data platform administration and governance.
• Business intelligence platform administration and reporting.
• Database administration (installation, configuration, maintenance, performance tuning, high availability).
• Data governance, classification, and compliance frameworks.
• Cloud infrastructure management and cost optimization.
• Integration services and data pipeline administration.
• Identity and access management, security best practices.
• Infrastructure as code and automated provisioning.
• CI/CD pipelines and DevOps practices.
• Technical documentation, runbooks, and standard operating procedures.

Skills

MS Fabric/Power BI

Microsoft Purview

SQL Server

SSIS

SSRS

Azure SQL

Azure Data Resources

Azure Integration Services

PowerShell

IaC

Azure DevOps

Monitoring

Education

College diploma in CS/Engineering

Tools

Git

Azure DevOps CI/CD

Job description

CFMWS – WHERE PURPOSE MEETS PASSION!

At Canadian Forces Morale and Welfare Services (CFMWS), we’re more than just a workplace; we’re a proud community dedicated to supporting Canadian Armed Forces members, veterans and their families in their daily lives. We carefully curate and provide programs and services designed to meet their unique needs and enhance their mental, social, physical, financial and familial well-being. CFMWS employees deliver programs and services including recreation, sports and fitness programs, customized financial services, retail services, access to retail savings and discounts and offers family support and organizes charity events.

Our success stems from living our values. Our employees care about their role in supporting Canadian Armed Forces members, veterans and their families and act with integrity in all they do. Thriving in our close-knit environment, we act as one team with one mission. We constantly seek new ideas and creative ways to deliver the best possible programs and services.

As an employer, we offer a commitment to your health, wellness and growth. We provide a diverse range of roles across many locations and a career where you can make a meaningful impact.

THE ROLE

Under the direction of Senior Manager, Data and Analytics Architecture, the Data & Analytics Platform Administrator will administer, monitor, and maintain the organization’s data platform and its underlying cloud infrastructure to ensure optimal performance, security, compliance, and cost efficiency. The administrator manages Microsoft Fabric tenant settings, capacities, and workspace configurations while enforcing governance policies and security controls. They administer Power BI at the tenant level, including workspace governance, gateway management, capacity monitoring, row-level and object-level security, content sharing policies, and usage analytics reporting. The administrator performs database administration tasks including backup/restore operations, index maintenance, query performance tuning, RBAC permissions management, health monitoring, and high availability/disaster recovery procedures. They administer Azure data platform resources including Azure VMs with SQL Server, Azure SQL Managed Instances, Azure Data Lake Storage Gen2, and Azure Integration Services components (Logic Apps, API Management, Service Bus, Event Grid). The administrator configures and manages Microsoft Purview accounts, data governance policies, classification rules, sensitivity labels, data scanning processes, and data catalog features across the organization’s data estate. They maintain comprehensive documentation including runbooks, standard operating procedures, and architecture diagrams, manage platform-related work items and CI/CD pipelines in Azure DevOps, and collaborate with the analytics team, integration developers, and stakeholders to ensure platform reliability and alignment with organizational governance standards.

QUALIFICATIONS NEEDED

Education, Certifications and Licenses

College diploma or certificate in Computer Science, Computer Engineering, or a related field AND several years of experience in Cloud systems design, implementation, management and support

Experience

Cloud data platform administration and governance

Business intelligence platform administration and reporting

Database administration (installation, configuration, maintenance, performance tuning, high availability)

Data governance, classification, and compliance frameworks

Cloud infrastructure management and cost optimization

Integration services and data pipeline administration

Identity and access management, security best practices

Infrastructure as code and automated provisioning

CI/CD pipelines and DevOps practices

Technical documentation, runbooks, and standard operating procedures

Technical skills:

• MS Fabric/Power BI (tenant administration, workspace management, data pipelines, Lakehouses, governance, gateway administration, capacity monitoring, RLS/OLS, DAX for troubleshooting)
• Microsoft Purview (data governance, classification, scanning, catalog, lineage)
• SQL Server (advanced SQL, T-SQL, stored procedures, performance tuning, backup/restore, RBAC)
• SSIS, SSRS, SSMS Azure SQL (Managed Instances, Azure SQL Database)
• Azure Data Resources
• Azure Integration Services (Logic Apps, API Management, Service Bus, Event Grid/Hubs)
• PowerShell scripting for automation and administration
• Infrastructure as code (ARM templates, Bicep, or Terraform)
• Version control (Git) and Azure DevOps CI/CD
• Monitoring and alerting (Azure Monitor, Log Analytics)

Language Requirements

English or French Essential, Bilingual(English and French)an asset

Reading: Functional

Writing: Functional

Oral: Functional

BENEFITS AVAILABLE

Health Benefits: Drug coverage, healthcare spending account, virtual care (telemedicine), Employee and Family Assistance Program, mental health support, travel insurance, dental, vision, life insurance and disability insurance.

Work Life Balance: Flexible work options and a wide range of paid/unpaid leave, including paid vacation, family related leave and personal days.

Retirement Planning: A Defined Benefit Pension Plan and Group Savings Plans.

Learning and Development: Tuition Reimbursement Program, online learning opportunitiesincluding a LinkedIn Learning subscriptionand second language training.

Perks: Discounts throughCF One Member Appreciation.

Explore all the benefits CFMWS offers by visiting: https://cfmws.ca/Benefits

OTHER INFORMATION

This is a hybrid position with an assigned work location allowing the employee to work partly from a corporate office and partly from a home office in accordance with the CFMWS Flexible Work Options Policy, and with approval from the direct manager.

This position is a two-year term.

The selection process will be done virtually.

You may be eligible to receive a Scarce Skills Premium for this position as outlined in the attached IT Scarce Skills Compensation Agreement

Competencies, Skills and Abilities

Cross-functional team collaboration

Client focus, analytical thinking, organizational knowledge, communication, innovation, problem-solving, attention to detail, teamwork and leadership.

START DATE

As soon as possible

INCLUSION AND ACCOMMODATION

CFMWS is committed to providing an inclusive, equitable and accessible environment, where all employees feel valued, respected and supported.We welcome applications from all qualified candidates who can help us build a workforce that reflects the diversity of Canadian society. If contacted in relation to a job opportunity or assessment, you should advise the recruitment team in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner. Information received relating to accommodation measures will be addressed confidentially.