About the role
Job Description
On behalf of our public sector client, Affinity is looking for a Data Analyst to provide advanced data and analytical support to establish foundational enterprise data capabilities required for technology governance, financial oversight, asset and contract visibility, digital enablement, analytics, lifecycle management, and CMDB readiness. The position supports two leadership roles with distinct data needs, requiring flexibility, adaptability, and alignment of shared data foundations. The role enables APS to transition from fragmented information sources toward structured, governed, and reusable data for improved decision-making and future automation.
Responsibilities
Enterprise Data Gap Identification and CMDB Readiness
Identify and define required data elements, relationships, and structures for CMDB Assess current-state data across systems, tools, and processes Document data availability, ownership, quality, and dependencies Identify, prioritize, and track critical data gaps Establish structured datasets to support future CMDB implementation Position CMDB readiness as one outcome of broader enterprise data readiness, ensuring datasets can support governance, financial oversight, analytics, lifecycle management, and future ServiceNow decisions
SharePoint Data Solution Development
Design, build, and administer SharePoint-based data solutions to enable structured data collection Develop and maintain lists, libraries, and metadata-driven data models Configure site structure, permissions, and governance controls Implement structured data capture processes aligned with governance and reporting needs Note: Strong preference for “SharePoint builder” capability, including: Designing data models using lists and metadata Building scalable, user-friendly data capture structures Administering SharePoint sites and managing permissions Applying advanced features such as forms, metadata structures, and views to improve usability and data quality Using basic Power Automate functionality to streamline workflows, notifications, and data validation
Cross-Functional Data Discovery
Engage with IST and enterprise stakeholders to identify and align data requirements Work across Finance, Security and Privacy, Legal, AI and Analytics, and other business units Identify existing data sources, ownership, accountability, and missing or inconsistent data elements Translate business and operational requirements into structured, standardized data definitions
Analytical Support to Leadership
Deliver targeted analysis and insights to support the Organizational Lead, Technology & Financial Governance and Director, Digital Enablement & Analytics Support strategic initiatives, financial and operational decision-making, and executive briefing materials
Governance Data Collection
Develop and maintain structured datasets supporting technology governance, renewals and contract tracking, and vendor and asset visibility Ensure data is accurate, traceable, and audit-ready
Financial Data and Analytical Support
Perform monthly reconciliation of IST financials to the APS General Ledger Support development and validation of monthly accruals Identify discrepancies, trends, and data quality issues Develop repeatable datasets supporting financial reporting and analysis Document ownership, update responsibilities, review cycles, maintenance requirements, and transition guidance for datasets and processes created during the contract term
Qualifications
Demonstrated experience in data analysis, data management, or analytics roles Strong capability in data collection, validation, transformation, and structuring Experience working with cross-functional stakeholders SharePoint builder-level capability (not just user-level) Experience with Power Automate Experience supporting governance, finance, or technology environments
Affinity Earn
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 13652
Similar Jobs
About the role
Job Description
On behalf of our public sector client, Affinity is looking for a Data Analyst to provide advanced data and analytical support to establish foundational enterprise data capabilities required for technology governance, financial oversight, asset and contract visibility, digital enablement, analytics, lifecycle management, and CMDB readiness. The position supports two leadership roles with distinct data needs, requiring flexibility, adaptability, and alignment of shared data foundations. The role enables APS to transition from fragmented information sources toward structured, governed, and reusable data for improved decision-making and future automation.
Responsibilities
Enterprise Data Gap Identification and CMDB Readiness
Identify and define required data elements, relationships, and structures for CMDB Assess current-state data across systems, tools, and processes Document data availability, ownership, quality, and dependencies Identify, prioritize, and track critical data gaps Establish structured datasets to support future CMDB implementation Position CMDB readiness as one outcome of broader enterprise data readiness, ensuring datasets can support governance, financial oversight, analytics, lifecycle management, and future ServiceNow decisions
SharePoint Data Solution Development
Design, build, and administer SharePoint-based data solutions to enable structured data collection Develop and maintain lists, libraries, and metadata-driven data models Configure site structure, permissions, and governance controls Implement structured data capture processes aligned with governance and reporting needs Note: Strong preference for “SharePoint builder” capability, including: Designing data models using lists and metadata Building scalable, user-friendly data capture structures Administering SharePoint sites and managing permissions Applying advanced features such as forms, metadata structures, and views to improve usability and data quality Using basic Power Automate functionality to streamline workflows, notifications, and data validation
Cross-Functional Data Discovery
Engage with IST and enterprise stakeholders to identify and align data requirements Work across Finance, Security and Privacy, Legal, AI and Analytics, and other business units Identify existing data sources, ownership, accountability, and missing or inconsistent data elements Translate business and operational requirements into structured, standardized data definitions
Analytical Support to Leadership
Deliver targeted analysis and insights to support the Organizational Lead, Technology & Financial Governance and Director, Digital Enablement & Analytics Support strategic initiatives, financial and operational decision-making, and executive briefing materials
Governance Data Collection
Develop and maintain structured datasets supporting technology governance, renewals and contract tracking, and vendor and asset visibility Ensure data is accurate, traceable, and audit-ready
Financial Data and Analytical Support
Perform monthly reconciliation of IST financials to the APS General Ledger Support development and validation of monthly accruals Identify discrepancies, trends, and data quality issues Develop repeatable datasets supporting financial reporting and analysis Document ownership, update responsibilities, review cycles, maintenance requirements, and transition guidance for datasets and processes created during the contract term
Qualifications
Demonstrated experience in data analysis, data management, or analytics roles Strong capability in data collection, validation, transformation, and structuring Experience working with cross-functional stakeholders SharePoint builder-level capability (not just user-level) Experience with Power Automate Experience supporting governance, finance, or technology environments
Affinity Earn
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 13652