Business Intelligence Specialist

1 month ago


Toronto, Canada Ministry of Health Full time

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 proto-types to support design process.
- Consult with users to determine their user requirements.

**How do I qualify?**:
**TECHNICAL KNOWLEDGE**:

- Knowledge of the principles/techniques of large-scale business intelligence (BI) and data warehouse / database design, data modelling and information management concepts.
- Practical hands-on 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**:

- Demonstrated project planning methodologies to plan and coordinate technical activities, plans and schedules of project teams.

**COMMUNICATION AND INTERPERSONAL SKILLS**:

- Demonstrated interpersonal, conflict resolution, team building and client relationship management skills to discuss program requirements.

**Additional Information**:
**Address**:

- 1 English Permanent, 5700 Yonge St, Toronto, Toronto Region or 222 Jarvis St, Toronto, Toronto Region or 49 Place D'Armes, Kingston, East Region

**Compensation Group**:

- Ontario Public Service Employees Union- Understanding the job ad - definitions**Schedule**:
***
- 6**Category**:

- Information Technology**Posted on**:

- Friday, January 26, 2024**Note**:

- C-HL-209710/24



  • Toronto, Canada Transatlantic Business Consulting Inc. Full time

    **Business Intelligence Specialist (Power BI)** - 3+ years using Power BI software development, including using DAX queries and functions - Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc. - SQL Server - Oracle - Ability to translate wireframes, lo-fidelity and...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist **for one of our clients. **Position: Business Intelligence Specialist - Intermediate** **Location: Toronto, Ontario (Hybrid)** - 3 days a week** **Duration: Long Term Contract** **Must Haves**: - Power BI Experience - Microsoft Dynamics - 5...


  • Toronto, Canada Transatlantic Business Consulting Inc. Full time

    Our government client requires a Senior Business Intelligence Specialist/ Expert to help build a new data warehouse/lakehouse and deliver the reporting MVP (minimum viable product). **Data Warehouse/Lakehouse Concepts**:Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data...


  • Toronto, Canada Altus Group Full time

    Job Category: Software Opportunity Awaits at Altus Group! The Opportunity This is your chance to develop, build, and grow business intelligence at a global tech company. In this role, you will work closely with teams across the organization, translating their business needs into BI and Analytics solutions. As our next BI Specialist, you will deliver...


  • Toronto, Canada Cleo Consulting Full time

    **Assignment: RQ06224 - Business Intelligence Specialist - Senior** **Start Date: 2023-11-27** **End Date: 2024-03-31** **Office Location: 125 Sir William Hearst Ave., Toronto** **Organization: Children, Youth & Social Services Cluster** **Ministry: Ministry of Children, Community and Social Services** **# Business Days: 90.00** **Title: Business...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Business Intelligence Specialist - Senior** **Location: 21 College suite 300, Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must haves**: - 3-5 years of experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards - Demonstrated experience with M, DAX and Power Query - Demonstrated...


  • Toronto, Canada TD Bank Full time

    **TD Description** Stay current and competitive. Carve out a career for yourself. Grow with us. **Department Overview** What does TD Data & Analytics stand for? For starters, we believe in visionary leadership and insights. We believe in using every resource at our disposal to better serve our clients, and this includes our vast data. Key objectives...


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: Business Intelligence SpecialistDuration: 8 MonthsLocation: Toronto, Ontario, Canada (3 days onsite and 2 days WFH)MUST HAVES:Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mappingDemonstrated understanding of...


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: Business Intelligence Specialist Duration: 8 Months Location: Toronto, Ontario, Canada (3 days onsite and 2 days WFH) MUST HAVES: Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mapping Demonstrated...


  • Toronto, Canada Net2Source Inc. Full time

    Job Title: Business Intelligence SpecialistDuration: 8 MonthsLocation: Toronto, Ontario, Canada (3 days onsite and 2 days WFH)MUST HAVES:Experience with a wide range of methods, tools, and techniques for business analysis such as, but not limited to business functional modeling, business event modeling, business process mappingDemonstrated understanding of...


  • Toronto, Canada CB Canada Full time

    Senior Business Intelligence (BI) Specialist On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior Business Intelligence (BI) Specialist. Senior Business Intelligence (BI) Specialist – Job Description Work with project teams to ensure successful release of Business Intelligence reporting using Power BI Use Power Query to...


  • Toronto, Canada Drake International Full time

    Title: Senior Business Intelligence SpecialistLocation: Toronto, ON, Canada (Hybrid)Type: Long Term ContractIntroduction:Join a rock-solid organization as our client’s next Business Intelligence Specialist and sit at the center of projects that drives decisions. You’ll help one of Canada's most trusted government organizations work on the latest project,...


  • Toronto, Canada SyLogix Consulting Inc. Full time

    **IMPORTANT**:This position is a hybrid work model (i.e. remote + onsite). Therefore, **applicants from Greater Toronto Area only**. We are seeking a Senior Business Intelligence Specialist to ensure successful release of Business Intelligence reporting using **Power BI, SSRS, SSIS, Azure Databricks, Python, Azure Data Lake, Azure Synapse, Azure Data...


  • Toronto, Canada Global Pharma Tek Full time

    Position: Business Intelligence Specialist Location: Toronto, ON (Hybrid) Duration: days contract + days extension Job Description: Responsibilities: Supports Client’s wide-ranging business information requirements, implementing and supporting business intelligence software solutions Develops and supports customized query applications that...


  • Toronto, ON, Canada Teacup Tech Systems Inc Full time

    RQ06224 - Business Intelligence Specialist - Senior Toronto, ON, Canada Job Openings RQ06224 - Business Intelligence Specialist - Senior About the job RQ06224 - Business Intelligence Specialist - Senior Experience in business intelligence software development and a number of years of practical experience (minimum 3+ years) Experience in providing with...


  • Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist - Senior **for one of our clients. **Position: Business Intelligence Specialist - Senior** **Location: Toronto, ON (Hybrid)** **Duration: Long Term Contract** **Must haves**: - Data Warehouse/Lakehouse Concepts: Strong understanding of data...


  • Toronto, Canada NR Consulting Full time

    Title :: Intermediate Business Intelligence Specialist (Hybrid)  Location :: Toronto, ON, Canada Duration : Contract Security Level OPP Level Services/Deliverables: The Business Intelligence and Analytics resource deliverables are outcomes and outputs that they provide to the organization. Deliverables may include: Develop Performance...


  • Toronto, Canada Global Pharma Tek Full time

    Position: Business Intelligence Specialist Location: Toronto, ON (Hybrid) Duration: Days Contract + Possible Extension Job Description: Technical Experience: - year’s experience in a business analyst capacity, with demonstrated work outlined clearly in: Data and Statistics: Knowledge of data processing/warehousing and statistical analysis...


  • Toronto, Canada Cleo Consulting Full time

    **Assignment: RQ06097 - Business Intelligence Specialist - Senior** **Start Date: 2023-11-13** **End Date: 2024-03-31** **Office Location: 315 Front St. West** **Organization: Children, Youth & Social Services Cluster** **Ministry: Ministry of Children, Community and Social Services** **# Business Days: 120.00 plus Extension # of Days:...


  • Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. **Responsibilities**: - Assist with gathering business and information...