Jobs
>
Mississauga

    Senior PowerBI Consultant - Mississauga, Canada - Dimensional Strategies Inc.

    Dimensional Strategies Inc.
    Dimensional Strategies Inc. Mississauga, Canada

    2 weeks ago

    Default job background
    Technology / Internet
    Description

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


  • Software International

    PowerBI Consultant

    3 weeks ago


    Software International Mississauga, Canada

    Our company Software International (SI) supplies technical talent to Fortune 100 & 500 companies and many other small/midsized organizations across Canada/US. · About this opportunity: · - Analytics system administration · - Exploring data sets to find hidden patterns, trends and ...


  • Element Fleet Management Mississauga, Canada

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


  • Maple Leaf Foods Mississauga, Canada

    **The Opportunity**: The IS Consultant SAP Plant Maintenance will focus on Plant Maintenance, Inventory Management (MRO) and Indirect Purchasing for spare parts/services/supplies. The position will work in collaboration with business stakeholders such as the Corporate Asset Relia ...


  • IQVIA Mississauga, Canada

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


  • IQVIA Mississauga, Canada

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


  • Novasyte Mississauga, Canada

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


  • Novasyte Mississauga, Canada

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


  • AECOM Mississauga, Canada

    **Company Description** Work with Us. Change the World.** · At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world' ...


  • AECOM Mississauga, Canada

    Company Description · Work with Us. Change the World. · At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's tr ...


  • Regional Municipality of Peel Mississauga, Canada

    **Job Description**: · **Supervisor, Population Health Assessment** · **Health Services · - Public Health Intelligence** · **Status**:Contract Full Time; 13 month duration · **Salary Range**:$96,785-$120,979 per annum + plus comprehensive benefits · **Work mode: Hybrid** · _see b ...


  • Morguard Mississauga, Canada

    PURPOSE · The Specialist, is accountable to the Manager, Claims Administration for timely and accurate administration, analysis and reporting of insurance claims to ensure that company's insurance related risks are identified effectively and proactively during the claims process. ...


  • Campbell Soup Company Mississauga, Canada

    Imagine...working for a company that knows that its people are the key to its success in the marketplace. A company in which achieving extraordinary results and having a stimulating work experience are part of the same process. · We cultivate and embrace a diverse employee popula ...

  • Carlton Cards LTD

    Sales Analyst

    1 week ago


    Carlton Cards LTD Mississauga, Canada

    **Join the #1 greeting card team in Canada** · *** · **Sales Analyst (One Year Contract)** · **Mississauga, ON** · *** · **General Summary** · *** · As a Sales Analyst you will work in collaboration with the sales and merchant teams, to provide information for an assigned set of ...


  • GSK Mississauga, Canada

    **Site Name**: Mississauga Milverton Drive · **Posted Date**: Jan · **Position**:Sales Force Incentive Associate · **Job Title**: Sales Force Incentive Associate · **Location**:100 Milverton Rd, Mississauga Office · **Schedule**:Monday to Friday (Hybrid) · **Contract**:May 6th, ...


  • UST Mississauga, Canada

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


  • IQVIA Mississauga, Canada

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


  • CIBC Mississauga, Canada

    We're building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what's right for our clients. · At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what ...


  • Regional Municipality of Peel Mississauga, Canada

    **Job Description**: · **Supervisor, Population Health Assessment** · **Health Services · - Public Health Intelligence** · **Status**:Contract Full Time; 13 month duration · **Salary Range**:$96,785-$120,979 per annum + plus comprehensive benefits · **Work mode: Hybrid** · _see b ...

  • Morguard

    Analyst, Claims

    1 week ago


    Morguard Mississauga, Canada

    PURPOSE · The Claims Analyst, is accountable to the Manager, Claims Administration for timely and accurate · administration, analysis and reporting of insurance claims to ensure that company's insurance related · risks are identified effectively and proactively during the claims ...


  • triOS College Mississauga, Canada

    triOS College Business Technology Healthcare Inc. is actively seeking a **Process Improvement Analyst** to join our Finance and Accounting team. · **Primary Purpose**: · The Process Improvement Analyst identifies challenges and coordinating solutions which improve both efficiency ...