Data Analyst

Job Description

On behalf of our public sector client, Affinity is seeking a Data Analyst to work on service innovation, program review, and digital transformation projects across the organization. The Data Analyst will work as part of cross-functional program review or product delivery teams. These teams, led by product owners, work collaboratively and collectively to participate in a full range of activities including field research, backlog definition and refinement, and sprint planning and execution. Digital transformation projects review the current state of services, identify future opportunities, and deliver new services that are efficient, effective, and affordable.

Responsibilities

Data Engineering:

• Design, develop, and maintain scalable data pipelines to ingest, transform, and store large volumes of data both on-premises (SSIS etc.) and in the cloud (Azure, AWS, GCP)
• Ensure data integrity, accuracy, and availability for analytical and operational use.
• Collaborate with software engineers, data scientists, and business stakeholders to understand data requirements and implement solutions.
• Optimize and improve existing data workflows and ETL processes.
• Implement data governance and security best practices.
• Manage data storage solutions, such as data lakes and data warehouses.
• A successful history of manipulating, processing and extracting value from large, disconnected datasets.
• Deploy data solutions in the cloud and with database tools (SQL, NoSQL).
  
  

Data Analytics

• Perform exploratory data analysis to identify trends, patterns, and insights.
• Develop and maintain reports, dashboards, and visualizations using BI tools (e.g., Power BI, SaaS VA).
• Conduct statistical analysis and modeling to support business strategies.
• Communicate findings and recommendations to stakeholders in a clear and concise manner.
• Use SQL and other query languages to extract and manipulate data from various sources.
• Create plans and strategies to integrate data models and improve service delivery.
• Develop and share service metrics and performance dashboards.
• Facilitate the frequent delivery of services and deliverables to ensure the successful creation of the target state while mentoring Agile Teams to grow their analytics fluency.
• Support corporate priorities with data-driven evidence using analytics, visualizations, and data modeling.
  
  

Qualifications

Must Have

Education

• Bachelor’s degree in Computer Science, Information Technology, or a related field
  
  

Work Experience

• Minimum 5 years of experience as a Data Engineer and/or Data Analyst
• Minimum 3 years of experience designing efficient dimensional models (e.g., star and snowflake schemas)
• Minimum 3 years of experience developing and maintaining reports, dashboards, and visualizations
• Minimum 3 years of experience ensuring data quality, security, and governance
• Minimum 5 years of experience manipulating and extracting data from diverse on-premises and cloud-based sources
• Minimum 2 years of experience performing migrations across on-premises, cloud, and cross-database environments
• Minimum 2 years of experience using Git, collaborative workflows, CI/CD pipelines, and containerization
• Minimum 3 years of experience with SSIS, Azure Data Factory (ADF), and APIs for data extraction and integration
• Minimum 2 years of experience in advanced analytics (e.g., statistical modeling, predictive analytics)
• Minimum 2 years of experience with Azure Databricks
• Minimum 2 years of experience with object-oriented and functional programming/scripting languages
• Minimum 1 year of experience working with AI (e.g., machine learning, NLP)
  
  

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: 13350