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.



  • Mississauga, Ontario, 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 AnalyticsGold Cloud...


  • Mississauga, ON, 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 AnalyticsGold Cloud...


  • Mississauga, ON, 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 AnalyticsGold Cloud...


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


  • Mississauga, Ontario, 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...


  • 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


  • Mississauga, Ontario, 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


  • Mississauga, Canada UST Full time

    **PowerBI Platform Administrator** **Lead I - DevOps Engineering **Who we are**: Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a...

  • Senior Consultant

    2 weeks ago


    Mississauga, Canada Infosys Limited Full time

    Others (Please specify in the Requisition notes) Company ITL Canada Requisition ID 119653BR Infosys is seeking Senior Consultant a you will be a key player in the consulting team that helps discover and define the problem statement, evaluates the solution options and makes recommendations. You will create detailed design, architecture, process artifacts,...

  • Senior Consultant

    3 weeks ago


    Mississauga, Canada Infosys Limited Full time

    Others (Please specify in the Requisition notes)CompanyITL CanadaRequisition ID119653BRInfosys is seeking Senior Consultant a you will be a key player in the consulting team that helps discover and define the problem statement, evaluates the solution options and makes recommendations. You will create detailed design, architecture, process artifacts, and...

  • Senior Consultant

    3 weeks ago


    Mississauga, Canada Infosys Limited Full time

    Others (Please specify in the Requisition notes)CompanyITL CanadaRequisition ID119653BRInfosys is seeking Senior Consultant a you will be a key player in the consulting team that helps discover and define the problem statement, evaluates the solution options and makes recommendations. You will create detailed design, architecture, process artifacts, and...

  • Senior Consultant

    2 weeks ago


    Mississauga, Canada Infosys Limited Full time

    Others (Please specify in the Requisition notes) Company ITL Canada Requisition ID 119653BR Infosys is seeking Senior Consultant a you will be a key player in the consulting team that helps discover and define the problem statement, evaluates the solution options and makes recommendations. You will


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


  • Mississauga, Canada Element Fleet Management Full time

    Get started on an exciting career at Element!_ Element employees make a difference in the lives of others every day. We are re-defining the fleet management industry to be people first, then business - delivering on our promise of a superior client experience. This takes hard work and innovation, and we need more like-minded people on our team. What We...


  • Mississauga, Canada Novasyte 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....


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


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


  • Mississauga, Ontario, 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 à...


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


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