Senior PowerBI Consultant

3 weeks ago

Mississauga, Canada Dimensional Strategies Inc. Full time

Dimensional Strategies Inc. (DSI)


Founded in 1998, Dimensional Strategies Inc. (DSI) is a Mississauga based consulting firm. Many years ago, DSI decided to specialize in Microsoft based tools and as a result have grown from a small 8-person shop to become a leader in Microsoft consulting services in the Canadian market place.



  • Gold Data Analytics
  • Gold Cloud Platform
  • Gold Data Platform
  • Gold Application Development



Being a Microsoft Partner means we design, deploy, deliver and support custom quality solutions using Microsoft technologies. We are the leader in Data Analytics, supported by initiatives like Dashboard in a Day (PowerBI), a joint offering between DSI and Microsoft Canada, as well as some of the earliest engagements in cloud based azure projects with some of Canada’s leading organizations.

We love what we do and are fortunate enough to help our clients make better, more timely decisions by improving their information access capabilities and enabling key processes.



Dimensional Strategies Inc. (DSI) is currently looking to expand its rapidly growing Data Analytics team. We Specialize in the development of solutions based on the Microsoft Data Platform. DSI is looking to add a number of select senior resources to the team.


At DSI we value aptitude, work ethic, and a desire to learn amongst a team that believes collaboration is key. If this sounds like a place you might like to work and you feel that your experience matches the requirements below, we encourage you to contact us.


This is a full time / permanent role.


About the role:

  • Heavy client facing focus, first point of contact with clients, pre-sales in a lot ways, but definitely a development role as well.
  • Supports business analysts and developers on project teams as they document their data requirements and establish thorough specifications
  • Conducts facilitation sessions to gather requirements
  • Ability to translate business requirements into technical requirements and architect a business-centric technical architecture
  • Builds logical models
  • Works with database administrators to build the physical model and overall data architecture
  • Reviews and reports on project metrics to benchmark effectiveness
  • Works closely with database administrators and developers to ensure that business models are accurately implemented in application systems
  • Provides education on the naming and modeling standards; assists with modeling specific constructs
  • Reviews project models to ensure adherence to standards
  • Ensures data quality alignment
  • Works on and across multiple projects to ensure consistency in naming conventions and promotes the sharing and reuse of data across applications and business areas
  • Ensures that data analysis goals are met


The following knowledge or skills are considered as necessary for this role:

  • Bachelors in Computer Science with 6+ years of related experience
  • 3-5 years of Data Management Experience
  • Understands database architectures, and data warehousing concepts
  • Ability to analyze data, and familiarity with data modeling, analysis and visualization tools (Excel, MS Power BI, Power Pivot/DAX, Power Query/M)
  • Business Intelligence Experience, specifically MS Power BI
  • Technical accomplishments in SQL, ETL, and data blending tools
  • Problem Solving Skills
  • Tools (SQL Server Management Studio (SSMS)
  • Familiarity with Microsoft Azure Data Platform (SQL DB, Blob, Data Factory, Automation, etc.) an asset.
  • Understand the benefits of data warehousing, data architecture, data quality processes, data warehousing design and implementation, table structure, fact and dimension tables, logical and physical database design, data modeling, reporting process metadata, and ETL processes


Required Skills


  • 5 - 7 years of PowerBI Experience
  • SSAS and the design of tabular models, cube design and optimization.
  • Data modeling, star and snowflake schema experience is a must. 4 - 5 years experience.
  • Understanding of PowerBI security practices, ie. data masking, row level security.
  • Solid understanding of DAX, 3-5 years experience minimum.
  • ETL/SSIS experience.
  • Minimum of 5 years IT experience
  • Utilize strong communication skills, both written and verbal, to share application expertise, communicate complex business problems, and facilitate discussion with stakeholders.
  • Work closely with various business functional areas to understand, define system requirements and make recommendations for business solutions.
  • Evaluate current system capabilities to identify changes that need to be made and determines the impact to the business.
  • Will be responsible for creation and maintenance of documentation pertaining to product features, work processes, etc. for given area of expertise.




All interested candidates should submit a copy of their resume with their application.

  • Consultant / Consultant, Consulting and Analytics Services

    1 month ago

    Mississauga, Canada IQVIA Full time

    IQVIA est le leader mondial de la fourniture de données sanitaires et pharmaceutiques au secteur des soins de santé. Notre équipe de services de conseil et d’analyse est réputée pour offrir à ses clients une perspective commerciale approfondie.  IQVIA propose une gamme de services pour aider les entreprises des sciences de la vie à planifier et...

  • Consultant / Consultant, Consulting and Analytics

    1 month ago

    Mississauga, Canada IQVIA Full time

    IQVIA est le leader mondial de la fourniture de données sanitaires et pharmaceutiques au secteur des soins de santé. Notre équipe de services de conseil et d’analyse est réputée pour offrir à ses clients une perspective commerciale approfondie. IQVIA propose une gamme de services pour aider les entreprises des sciences de la vie à planifier et à...

  • Consultant, Services de conseil et d’analyse

    1 month ago

    Mississauga, Canada IQVIA Full time

    IQVIA is the world leader in the provision of health and pharmaceutical data to the health care sector. Our Consulting and Analytics (C&A) team is renowned for providing deep business-focused insights for our customers.  IQVIA delivers a suite of services to help life sciences companies plan and adjust their commercial models and teams to maximize impact....

  • Senior Consultant

    1 month ago

    Mississauga, Canada Expeditors Full time

    Job Description Scope of Position: You should have the ability to develop opportunities in the various aspects of customs from our Canadian and international offices. You must be comfortable working closely with clients, staff, the CBSA and other government agencies.Strong communication skills will be required to be able achieve your goals with...

  • Senior Consultant

    1 month ago

    Mississauga, Canada Expeditors International Full time

    “We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors FounderGlobal supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.Organic Growth –...

  • Senior Consultant

    1 month ago

    Mississauga, Canada Expeditors International Full time

    “We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors FounderGlobal supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.Organic Growth –...

  • Senior Consultant

    1 month ago

    Mississauga, Canada Expeditors International Full time

    “We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors FounderGlobal supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.Organic Growth –...

  • Senior Consultant

    1 month ago

    Mississauga, ON, Canada Expeditors International Full time

    “We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors Founder Global supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics. Organic Growth...

  • Lead/Senior Consultant

    6 days ago

    Mississauga, Canada Q&C Services Full time

    The Quality Assurance Specialist - Pharmaceutical role is a "Lead or Senior Consultant" position at Q&C. This pharmaceutical consultant role focuses on applying your GMP knowledge and experience to various projects, such that the client is confident in the approach and timing of execution of the pro

  • Consultant, Services de conseil et d’analyse

    1 month ago

    Mississauga, ON, Canada Knewin Full time

    IQVIA est le leader mondial de la fourniture de données sanitaires et pharmaceutiques au secteur des soins de santé. Notre équipe de services de conseil et d’analyse est réputée pour offrir à ses clients une perspective commerciale approfondie. IQVIA propose une gamme de services pour aider les entreprises des sciences de la vie à planifier et...

  • Senior Consultant

    5 days ago

    Mississauga, ON, Canada Q&C Services Full time

    The Quality Assurance Specialist - Pharmaceutical role is a "Lead or Senior Consultant" position at Q&C. This pharmaceutical consultant role focuses on applying your GMP knowledge and experience to various projects, such that the client is confident in the approach and timing of execution of the project. We are looking for consultants who want to apply their...

  • Senior Accounting Consultant

    2 weeks ago

    Mississauga, Canada Futura Energy Group Full time

    Position SummaryOur client is an assurance practice in our office is looking for a Sr. AccountingConsultant to join their growing practice. As a senior member of the assurance team, youwill work closely with the partners and other senior members on leading assuranceengagements, review & NTR engagements and tax compliance and filings. You will excel...

  • Lead/Senior Consultant

    1 week ago

    Mississauga, Canada Q&C Services Full time

    The Quality Assurance Specialist - Pharmaceutical role is a "Lead or Senior Consultant" position at Q&C. This pharmaceutical consultant role focuses on applying your GMP knowledge and experience to various projects, such that the client is confident in the approach and timing of execution of the project. Our consultants work independently within a team...

  • Lead/Senior Consultant

    1 week ago

    Mississauga, Canada Q&C Services Full time

    The Quality Assurance Specialist - Pharmaceutical role is a "Lead or Senior Consultant" position at Q&C. This pharmaceutical consultant role focuses on applying your GMP knowledge and experience to various projects, such that the client is confident in the approach and timing of execution of the project. Our consultants work independently within a team...

  • Lead/Senior Consultant

    1 week ago

    Mississauga, Canada Q&C Services Full time

    The Quality Assurance Specialist - Pharmaceutical role is a "Lead or Senior Consultant" position at Q&C. This pharmaceutical consultant role focuses on applying your GMP knowledge and experience to various projects, such that the client is confident in the approach and timing of execution of the project. Our consultants work independently within a team...

  • Lead/Senior Consultant

    1 week ago

    Mississauga, Canada Q&C Services Full time

    The Quality Assurance Specialist - Pharmaceutical role is a "Lead or Senior Consultant" position at Q&C. This pharmaceutical consultant role focuses on applying your GMP knowledge and experience to various projects, such that the client is confident in the approach and timing of execution of the project. Our consultants work independently within a team...

  • Senior Network Consultant

    1 week ago

    Mississauga, Canada Konica Minolta Business Solutions (Canada) Ltd. Full time

    Overview: As the national IT Services Division of Konica Minolta Canada, IT Weapons has been delivering IT Services, hybrid cloud solutions, Information Security, connectivity, infrastructure management, and technical support for over 20 years. To simplify the management of complicated IT landscapes, our team helps streamline technology so companies can...

  • Senior Group Retirement Consultant

    4 weeks ago

    Mississauga (Malton), Canada Jones DesLauriers Blevins Insurance Group Full time

    Benefit from joining our growing team! We are hiring a Senior Group Retirement Consultant in our Toronto office. The Senior Group Retirement Consultant will oversee the service, management, and execution of a book of business. This role also involves supporting the acquisition of new business. It necessitates a high level of independent discretion,...

  • Senior Group Retirement Consultant

    4 weeks ago

    Mississauga (Malton), Canada Jones DesLauriers Blevins Insurance Group Full time

    Benefit from joining our growing team! We are hiring a Senior Group Retirement Consultant in our Toronto office. The Senior Group Retirement Consultant will oversee the service, management, and execution of a book of business. This role also involves supporting the acquisition of new business. It necessitates a high level of independent discretion,...

  • Senior Group Retirement Consultant

    4 weeks ago

    Mississauga (Malton), Canada Jones DesLauriers Blevins Insurance Group Full time

    Benefit from joining our growing team! We are hiring a Senior Group Retirement Consultant in our Toronto office. The Senior Group Retirement Consultant will oversee the service, management, and execution of a book of business. This role also involves supporting the acquisition of new business. It necessitates a high level of independent discretion,...