Business Intelligence Specialist

2 weeks ago


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 Factory**.

**Responsibilities**:

- Use Power Query to extract data from different data sources and choose a storage mode and connectivity type. Profile, clean, and load data into Power BI
- Design data models that are intuitive, high-performing, and simple to maintain
- Use M and DAX language to create measures
- Ensure high performance of Power Query data retrieval tasks
- Create Power BI report designs and report formatting, including report navigation
- Examine, sort and present data using Power BI in a cohesive manner.
- Leverage statistical summaries of data and facilitate export of data from Power BI when required.
- Leverage workspaces in the Power BI service.
- Deploy Power BI artifacts to workspaces and enable sharing to users.
- Connect Power BI reports to on-premise data sources.
- Configure automatic refresh for Power BI datasets.
- Enable Row-level security
- Understand the report users needs and their requirements
- Develop reports all the way into production.

**Mandatory (Must Have) Skills and Experience**:

- Demonstrated experience with **M*, **DAX* and **Power Query**:

- Knowledge of Microsoft Azure ecosystem including **Power BI, SSRS, SSIS, Azure Databricks, Azure Data Lake, Azure Synapse, Azure Data Factory**:

- Proven experience with SQL Server and other database technologies
- Proven, demonstratable experience in data modeling and data visualization; working with different data schemas and BI implementation methodologies
- Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues
- Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
- Excellent verbal and written communication skills

**Desirable (Nice to Have) Skills and Experience**:

- Government IT project experience
- IBM Cognos Report Studio
- ETL tool such as Informatica or IBM DataStage
- Accessibility Standard WCAG and AODA

**Job Types**: Full-time, Fixed term contract
Contract length: 12 months

**Salary**: $70.00-$90.00 per hour

Schedule:

- Day shift
- Monday to Friday

**Experience**:

- SSIS: 5 years (required)
- SSRS: 3 years (required)
- Azure Data Factory: 2 years (required)
- Azure Databricks: 2 years (required)
- Azure Synapse: 2 years (required)
- MS SQL Server: 5 years (required)
- Python: 2 years (preferred)
- Canadian government project: 2 years (preferred)
- IBM Cognos Report Studio: 2 years (preferred)
- Informatica or IBM DataStage: 2 years (preferred)
- Accessibility Standard WCAG and AODA: 2 years (preferred)
- Power BI: 5 years (required)
- Azure Data Lake: 2 years (preferred)

Work Location: Hybrid remote in Toronto, ON

Expected start date: 2023-04-03



  • 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 Vtech Solution Inc Full time

    **Role: Junior Business Intelligence Specialist - Intermediate** **Location: Toronto, ON (Hybrid)** **Duration: 10+ months (with possible extension)** **Responsibilities**: - Assist with gathering business and information requirements. - Provide technical expertise to design and develop Business Intelligence dashboards and reporting solutions using...


  • Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...


  • Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation...


  • Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation...


  • Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation...


  • Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation and...


  • 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 Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...


  • 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...

  • Business Intelligence Specialist

    Found in: Appcast CA C2 Glassdoor - 2 weeks ago


    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Whatjobs CA C2 - 2 weeks ago


    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus! Qualifications: B.S./M.S. in economics, mathematics, computer science/engineering, or related areas 5+ years of experience working with Power BI and Tableau Expertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Appcast CA A2 P - 2 weeks ago


    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...

  • Business Intelligence Specialist

    Found in: Talent CA 2A C2 - 2 weeks ago


    Toronto, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...


  • Toronto, Canada Aviso Wealth Full time

    **Aviso Wealth**: **The Opportunity**: We’re looking for a BI Solution Specialist to join our IT team. This role can be mostly remote, however we will on occasion require you to come onsite to our office at 151 Yonge St, Toronto, ON. Reporting to the Director, Business Intelligence, the Business Intelligence Solution Specialist is part of the team that...

  • Senior Business Intelligence Specialist

    Found in: beBee S CA - 3 weeks ago


    Toronto, Canada GTT, LLC Full time

    Senior Business Intelligence Specialist Overview:In line with the Ontario Digital services cloud-first adoption strategy, all Cognos Business Intelligence (BI) applications deployed on the Business Intelligence/Business Analytics (BI/BA) platform using BIDA (Business Intelligence and Data Analytics) data repository and hosted by ITS on traditional I&IT...

  • Business Intelligence Specialist

    Found in: Jooble CA O C2 - 2 weeks ago


    Toronto, ON, Canada Glocomms Full time

    Looking for Business Intelligence Specialist in the Toronto area! If you are fulfill the qualifications, please apply below. Experience in the insurance space is a plus!Qualifications:B.S./M.S. in economics, mathematics, computer science/engineering, or related areas5+ years of experience working with Power BI and TableauExpertise in data preparation and...