Talent.com

Power bi Jobs in Renfrew, ON

Create a job alert for this search

Power bi • renfrew on

Last updated: 5 hours ago
Specialized IT Consultant

Specialized IT Consultant

Cleo ConsultingON, Canada
Full-time
Quick Apply
Assignment : RQ08798 - Specialized IT Consultant - Junior Job Title : Specialized IT Consultant Requisition (SS) : R...Show moreLast updated: 4 days ago
Business Intelligence - Production Support (Remote)

Business Intelligence - Production Support (Remote)

NTT DataOntario, Canada
Remote
NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now....Show moreLast updated: 14 days ago
Power Lead

Power Lead

Schneider ElectricOntario, Canada
CA$55,000.00–CA$85,000.00 yearly
The Integrations Lead is responsible for the development, implementation, maintenance and support of complex applications for enterprise solutions delivered to electrical utilities for Advanced Dis...Show moreLast updated: 30+ days ago
Intermediate Power Platform Developer

Intermediate Power Platform Developer

CharterOntario, Canada
Full-time
About the Intermediate Power Platform Developer position.We are looking for an Intermediate Microsoft Power Platform Developer that will be responsible for designing, developing, and implementing M...Show moreLast updated: 18 days ago
  • Promoted
MS Dynamics Administrator

MS Dynamics Administrator

WinMagic Corp.Ontario, Canada
Full-time
WinMagic is revolutionizing cybersecurity, building on its leadership and innovation in disk encryption to redefine secure online authentication. With MagicEndpoint, we deliver the most secure onlin...Show moreLast updated: 2 days ago
Data Project Coordinator

Data Project Coordinator

360insightsOntario, Canada
CA$55,500.00–CA$70,500.00 yearly
Remote
Here at 360insights you will be a part of a fast-paced global technology company that is innovating and leading in the channel incentives and insights industry. You will be helping us to deliver gre...Show moreLast updated: 30+ days ago
  • New!
Power Platform Developer

Power Platform Developer

MIR Digital SolutionsON, Canada
Full-time
Quick Apply
About MIR Digital : At MIR Digital, we're more than a company-we're a collective of innovators, builders, and change-mak...Show moreLast updated: 5 hours ago
Military Power

Military Power

University of TorontoOntario, Canada
CA$52.97 hourly
Full-time
DutiesTeaching assistant to grade assignements, tests and exams, invigilate tests and final examinations, consult with students, consult with supervisor. Minimum Qualifications Appropriate backgroun...Show moreLast updated: 2 days ago
  • Promoted
OTR CDL A Driver - Up to $90K

OTR CDL A Driver - Up to $90K

Coastline TransportOntario, CA
CA$80,000.00–CA$90,000.00 yearly
Full-time
Please call 833-667-5627 or Apply Online Below!.Pay up to $80k to $90k+ per year.Strong, predictable driver's average up to 3000+ miles per week. Regular drop and hook No touch freight.Comprehensi...Show moreLast updated: 30+ days ago
commercial scuba diver

commercial scuba diver

OZ Investments Inc.ON, CA
CA$17.20 hourly
Full-time +1
Education : Other trades certificate or diploma.Relocation costs not covered by employer.Read blueprints to determine work requirements. Perform underwater inspection, search, salvage, repair and pho...Show moreLast updated: 30+ days ago
Digital Marketing Specialist

Digital Marketing Specialist

BoardwalkOntario, Canada
Full-time
Boardwalk provides Canadians with a quality, comfortable, home living experience.We offer rental apartments and townhouses that come in a wide breadth of shapes, sizes and sets of amenities.We oper...Show moreLast updated: 4 days ago
  • Promoted
Sessional Instructor - Data Warehousing and Visualization

Sessional Instructor - Data Warehousing and Visualization

University of Niagara Falls CanadaOntario, Canada
Full-time
About the University of Niagara Falls Canada.Officially opening its doors in 2024, the University of Niagara Falls Canada (UNF) is an innovative and digitally oriented institution that prepares gra...Show moreLast updated: 2 days ago
Software Engineer, Business Intelligence

Software Engineer, Business Intelligence

Tony’s Fresh MarketOntario, CA
CA$100,000.00 yearly
At Heritage Grocers Group, how we work is defined by shared values that include absolute integrity, respect, and collaboration. However, it's more than that; it's smart and highly driven people unit...Show moreLast updated: 30+ days ago
Electrician

Electrician

Spark PowerTimiskaming, Ontario, Canada
Full-time
Journeyperson Electrician .Spark Power, a trusted partner in energy in North America, is looking for a Journeyman Electrician to join our Timiskaming team. With a strong track record of deliver...Show moreLast updated: 8 days ago
Power BI

Power BI

Emonics LLCOntario, Canada
CA$80,000.00–CA$100,000.00 yearly
JD : Power BI Developer experience , Strong SQL skills, Data Analytics and Visualization skills.Show moreLast updated: 30+ days ago
2nd Class Power Engineers

2nd Class Power Engineers

Halliwell ConsultingNorthern Ontario
CA$115,000.00–CA$120,000.00 yearly
Lead and manage the department team in order to successfully achieve its targets with respect to Health and Safety, meeting operational budget priorities, the capital plan, planned and predictive m...Show moreLast updated: 30+ days ago
Process Engineer Intern - Power & Utilities

Process Engineer Intern - Power & Utilities

New-IndyOntario, CA
CA$21.00 hourly
Job Location Ontario Mill - Ontario, CAPosition Type InternshipEducation Level OtherTravel Percentage NoneJob Shift DayJob Category Engineering. Process Engineer Intern – Power & Utilities Departmen...Show moreLast updated: 30+ days ago
Software Developer 6711-15

Software Developer 6711-15

FoilconLa Gran YajaToronto, Ontario, Canada
CA$43.00 hourly
HM Note : This hybrid role is three (3) days in office.Required to translate technical systems specifications into working, tested applications. This includes : developing detailed programming specifi...Show moreLast updated: 30+ days ago
Maintenance Power Engineers - 3rd Class

Maintenance Power Engineers - 3rd Class

Sofina FoodsOntario, Canada
CA$36.22 hourly
Maintenance Power Engineers - 3rd Class.British Columbia, Canada Newfoundland and Labrador, Canada Ontario, Canada Saskatchewan, Canada Yorkton, SK, Canada Req #1048 Tuesday, July 16, 2024.Our team...Show moreLast updated: 30+ days ago
MS Dynamics Solution Architect

MS Dynamics Solution Architect

Astra North Infoteck Inc.ON, ON, ca
Full-time
Quick Apply
MS Dynamics Solution Architect.Dynamics 365 Customer Engagement (Sales, Service - Must) and knowledge other Microsoft Dynamics 365 suite of products. Facilitate detailed design from requirements and...Show moreLast updated: 3 days ago
Specialized IT Consultant

Specialized IT Consultant

Cleo ConsultingON, Canada
4 days ago
Job type
  • Full-time
  • Quick Apply
Job description

Assignment : RQ08054 - Specialized IT Consultant - Intermediate

Job Title : Specialized IT Consultant

Requisition (SS) : RQ08054

Start Date : 2025-04-01

Client : Community Services Cluster

End Date : 2026-03-31

Office Location : 777 Bay St, Suite 423, Toronto

Organization : Community Services Cluster

Ministry : Ministry of Public and Business Service Delivery and Procurement

Business Days : 251.00

Note : Hybrid - Candidate must be able to work 3 days onsite and 2 remote

MUST HAVES :

  • Strong experience in developing reports and dashboards in Power BI.
  • Solid experience in designing, developing, and deploying SSIS packages for ETL processes.
  • Solid knowledge of MS SQL Server, including T-SQL, stored procedures, and query optimization.
  • Familiar with data extraction, transformation, and loading (ETL) from various sources to target systems.
  • Strong product experience such as Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
  • The ideal candidate should possess 5+ years of experience as a I&IT Consultant, with a focus on the following project environments :
  • Required Skills (3-4 years) : Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
  • Preferred Skills (2-3 years) : Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control

Description

  • Note : This contract will require the consultant to work from the office location 3 days per week with the remaining 2 days being worked remotely.
  • An Specialized I&IT Consultant is required to develop BI solutions using both Cognos and Microsoft Power BI for varying business needs, following all applicable GO-ITS standards and industry best practices while adhering to the existing technological solution framework. The successful candidate will work with various technology teams to translate business needs and work through the analysis and the development phases.
  • Responsibilities :

  • Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization's I&IT systems.
  • The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.
  • Provides subject matter expertise in their field and highly expert technical assistance.
  • Acts as the technical advisor / expert on all aspects of a specific deliverable
  • Provides the quality assurance / quality control of specific deliverables
  • Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
  • Develops processes and procedures for implementing deliverables
  • Prepares reports and presentations including options, recommendations, implementation plans, etc.
  • Works with clients to define the scope of a project and to determine requirements
  • Defines software, hardware and network requirements
  • Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
  • Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
  • Familiar with change-management principles and methodology
  • Knowledge and understanding of Information Management principles, concepts, policies and practices
  • General Skills :

  • Ensure seamless integration of new and existing systems, applications, and platforms.
  • Evaluate and recommend technology stacks, platforms, and tools to support business goals.
  • Design systems with a focus on security, compliance, and data privacy standards.
  • Work closely with stakeholders such as business units, development teams, IT infrastructure teams to ensure alignment with project goals.
  • Ensure solutions are scalable, reliable, and can be optimized for future growth.
  • Provide technical support and participate in the development, package creation, code merge, testing and release activities.
  • Primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
  • Develop and manage solutions using Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
  • Desirable Skills :

  • Demonstrated experience in guiding the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
  • Demonstrated deep Microsoft stack experience (5+ Years) with at least past 4 years of Microsoft Azure Data Factory experience.
  • Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
  • Strong knowledge of data integration techniques, data warehousing, and ETL processes.
  • Familiarity with database management and SQL Server environments.
  • Strong problem-solving skills and ability to work collaboratively in a team.
  • Data modelling experience with both star and snowflake schemas in MS SQL as well as Oracle databases
  • Experience with Cognos / Informatica reporting solutions
  • Experience with migration from Cognos / Informatica to Power BI solutions
  • Strong development experience with ETL using SQL Server SSIS
  • Experience with designing and implementing interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
  • Experience with Microsoft DevOps, pipelines, datasets, triggers, and other Azure Data Factory components
  • Knowledge Transfer

  • Knowledge Transfer should be done to designated technical cluster FTE.
  • Knowledge transfer must be completed two weeks prior to the consultant leaving the ministry.
  • All deliverables, including design / supporting / release / training documents must be checked into designated version control repositories (for example, SharePoint, DevOps).
  • All final documents and working drafts related to project requirements or business analysis or solution design or solution development or QA testing plans or Architectural artefacts and other working related documents are must be stored on designated project SharePoint folder and Azure DevOps.
  • Project manager and designated FTE must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.
  • Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.
  • Experience and Skill Set Requirements

    Technical Experience - 30%

  • Experience :
  • The ideal candidate should possess 5+ years of experience as a I&IT Consultant, with a focus on the following project environments :

  • Required Skills (3-4 years) : Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
  • Preferred Skills (2-3 years) : Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
  • Technical Skills
  • Demonstrated experience in guiding the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.

  • Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience.
  • Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
  • Strong knowledge of data integration techniques, data warehousing, and ETL processes.
  • Familiarity with database management and SQL Server environments.
  • Strong problem-solving skills and ability to work collaboratively in a team.
  • Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, Datastage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer
  • Development - 25%

  • Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and integration.
  • Develop ETL processes using SQL Server Integration Services (SSIS) to move and transform data from various sources into Azure data repositories.
  • Azure Data Factory, knowing how to create and manage pipelines, datasets, triggers, and other ADF components effectively.
  • Design and implement interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
  • Well-versed in ETL tools and technologies, especially those within Azure Data Factory, such as Data Flow, Mapping Data Flows, and other data transformation components.
  • Design / Architecture - 20%

  • Ensure data quality and data governance practices are implemented throughout the data integration process.
  • Demonstrated experience with data ingestion from multiple sources, staging and data cleansing.
  • Guide the architecture leveraging Azure cloud services, ensuring effective and standard use of the Microsoft Stack tools and services critical for the integrity, quality, and pace of delivery.
  • Understanding of Azure's security and compliance features is crucial to ensure data privacy and meet regulatory requirement.
  • Design, plan, and implement data integration and analytics solutions on the Microsoft Azure platform, leveraging Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant services.
  • Create architecture diagrams and technical documentation for Azure-based solutions.
  • Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
  • Design and implement data models and cubes using SQL Server Analysis Services (SSAS) for efficient data analysis and reporting.
  • Design and develop interactive and informative dashboards and reports using Power BI to facilitate data-driven decision-making.
  • Data Modelling - 20%

  • Design experience with star and snowflake schemas, dimensional modeling and data model architecture and design aligned with data standards and analytics needs of various stakeholders, includes creation DW, Views, Cubes, and other data services products, using SQL Server Analysis Services (SSAS)
  • Utilize tools like Erwin Data Modeler and Power Designer to create and maintain data models for efficient data storage and retrieval.
  • Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer.
  • Public Sector Experience - 5%

  • Previous public sector experience in an organization of equivalent size or complexity to Ontario Public Service
  • Demonstrates experience designing and developing applications that comply with GOITS standards and general processes would be an asset