Data Analyst/Report Writer

Working as a Data Analyst you will be responsible for providing end users with the tools to support business
needs. You will assist users with the analyses and interpretation of the data as well as maintain and enhance
existing Data Warehouse.
You enjoy working in a fast paced environment and have the ability to prioritize and multitask. You strive for
excellence and are devoted to continuous learning.
You will be part of an agile development team building and working on enterprise grade software system. You
will be involved in all areas of development from design to testing. Projects will range from small, distinct pieces
of work to long term program engagements.

Advantages
▪ Postsecondary diploma or degree in Computer Science, Information Systems, Data Analytics, or a
related field preferred
▪ Minimum of 4 years of relevant experience in data analysis, reporting, or business intelligence
▪ Experience working in a Microsoft-based data environment required
▪ Experience in the optical industry is considered an asset

Responsibilities
Meet with users to understand their reporting/data requirements.
▪ Generate reports using SQL Server Reporting Services with SQL server and Microsoft SQL Server
Analysis Services as data sources.
▪ Create cubes and dimension data using Microsoft SQL Server Analysis Services and build queries using
MDX.
▪ Build reports for end users and dashboards for the departments in SSRS and Excel.
▪ Support and troubleshoot SQL based Datawarehouse, including SSIS and SSAS
▪ Document and execute unit testing, system integration and provide user acceptance testing support
▪ Help users analyse and interpret the data.
▪ Research questions using available resources.
▪ Identify and escalate complex problems or issues to management.
▪ Stay current with technologies used, system information, changes and updates

Qualifications
Strong expertise in Microsoft SQL Server (SQL 2017 or later), including SSRS, SSAS, and SSIS
▪ Advanced T-SQL skills, including DDL and DML queries
▪ Experience with data warehousing concepts and BI solution design and development

JOB DESCRIPTION

▪ Knowledge of dimensional modeling and relational database design techniques
▪ Experience with reporting tools such as SSRS, Power BI (preferred), and Jet Reports (asset)
▪ Advanced Microsoft Excel skills (formulas, pivot tables, VBA)
▪ Strong analytical thinking and problem-solving abilities
▪ Excellent verbal and written communication skills
▪ Ability to manage multiple priorities in a fast-paced environment
▪ Strong attention to detail and commitment to data accuracy
▪ Professional certifications (e.g., Microsoft, BI, Data Analytics) are an asset

Summary
Primarily sedentary work involving prolonged periods of sitting and computer use
▪ Occasional movement within the office environment as required
Other Demands:
▪ Ability to work in a fast-paced, deadline-driven environment
▪ Strong adaptability and willingness to learn new technologies and tools
▪ Ability to work both independently and collaboratively within cross-functional teams
▪ Occasional overtime may be required based on project needs

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.