---

---

Location

North York, ON | Canada

---

Job description

This is a contract position for a Business Intelligence Specialist for our public sector client.
Work location: Downtown Toronto
Duration: Twelve Months
7.25 hours/day
This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages
Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities
• Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions
• Develops and supports customized query applications which analyze key business data
• Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of “opportunity” and “key-trend” alerts
• Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives

Experience and Skill Set Requirements

Must Haves:
You have knowledge of structured methodologies for the development, design, implementation and maintenance of BI solutions using Oracle Business Intelligence Enterprise Edition (OBIEE).

You have knowledge of Oracle Business Intelligence Publisher (BI Publisher).

You have knowledge and experience in Extraction, Transformation and Load (ETL) architecture, design and processes and tools for Microsoft platform (SQL Server ETL, SSIS, DataFactory, Oracle).

You have knowledge of the principles/techniques of large-scale business intelligence and data warehouse/database design and information management concepts.

You have practical hands-on experience in design and development of BI solutions.

General Skills:

• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
• Experience with developing feedback processes to fix corrupt data in the source systems
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (relational and multi-dimensional data stores)
• Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Experience with developing automation extraction, cleansing and load scripts
• Experience generating research models and reports (scheduled and ad-hoc)
• Proven troubleshooting and analytical experience
• Experience in process decomposition/mapping and business process re-engineering and complex data models using UML
• Experience in the use of development tools and business re-engineering software
• Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines

Desirable Skills:

• Knowledge and experience in developing data analysis applications
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications
• Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Qualifications
You have knowledge of structured methodologies for the development, design, implementation and maintenance of BI solutions using Oracle Business Intelligence Enterprise Edition (OBIEE).

You have knowledge of Oracle Business Intelligence Publisher (BI Publisher).

You have knowledge and experience in Extraction, Transformation and Load (ETL) architecture, design and processes and tools for Microsoft platform (SQL Server ETL, SSIS, DataFactory, Oracle).

You have knowledge of the principles/techniques of large-scale business intelligence and data warehouse/database design and information management concepts.

You have practical hands-on experience in design and development of BI solutions.

Summary
If interested and qualified for this role, please apply today for immediate consideration!

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 [email protected] to ensure their ability to fully participate in the interview process. show more

---

Job tags

---

---

Salary