Business Intelligence Specialist - Toronto, Canada - Ministry of Health

Ministry of Health

Verified Company

Toronto, Canada

4 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

We are in search of a seasoned professional to provide technical expertise in the design and implementation of complex projects as well as re-engineering of legacy (on-premise) technical solutions as to facilitate cloud migration.

If this sounds like your next career move, then consider this exciting opportunity with us.

OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism: We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

Visit the

OPS Anti-Racism Policy and the

OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's

Human Rights Code. Refer to the "How to apply" section if you require a disability-related accommodation.

What can I expect to do in this role?: You will:

Provide senior technical expertise in building data collection and processing pipelines for downstream consumption for business intelligence (BI) and analytics.
Lead the design and implementation of logical and physical data models suitable for consumption by BI tools.
Translate corporate information requirements into detailed system/programming specifications.
Perform system acceptance testing and draft system documentation.
Develop End User Application (EUA) demos and prototypes to support design process.
Consult with users to determine their user requirements.

How do I qualify?:

TECHNICAL KNOWLEDGE:

Knowledge of the principles/techniques of largescale business intelligence (BI) and data warehouse / database design, data modelling and information management concepts.
Practical handson experience in design and development of BI solutions (using technologies such as IBM Cognos Analytics or Power BI) including advanced reporting and data visualizations
Familiarity with the process of building a BI solutions, including data warehouse/mart design, data extraction, transformation and loading (ETL).
Knowledge and experience using relational database systems such as Oracle (including advanced SQL and PL/SQL or equivalent).
Experience or knowledge with cloud infrastructure and services (AWS, Microsoft Azure) as well as data warehousing solutions for cloud (AWS Redshift, Azure Synapse).
Experience in all life cycle stages of a BI solution (requirements gathering, design, development, implementation, and maintenance).
Understanding of Enterprise Architecture principles, techniques, methodologies and various architecture domains.
Some experience in Unix/Windows/Python scripting, and other development tools.

SYSTEMS ANALYSIS AND TECHNOLOGY PLANNING EXPERIENCE:

Experience building and managing data sets by analyzing data contained in the corporate database, legacy systems and other data sources.

ANALYTICAL SKILLS AND INTERPRETATIVE REASONING SKILLS:

Proven analytical and interpretative reasoning skills to assess client I&IT needs and develop I&IT solutions that are cost effective and improve client program and service delivery.

PROJECT MANAGEMENT SKILLS: