Data Pipeline Engineer (Power BI)

Job title:

Data Pipeline Engineer (Power BI)

Company

IT/IQ

Job description

Job Title: BI Developer
Perm/Contract & Duration: 12 months + extensions
Start Date: SeptemberWe are looking for a contract Business Intelligence Developer to work with the I.T. team to develop an on premise Data Warehouse with SQL Server Integration Services, SQL Database and PowerBI. This assignment could start as early as September 8th, 2025 depending on resource availability. This work will be performed virtually (3 days) and in person (2 days) or entirely virtual if candidate is located outside of the
lower mainland.Responsibilities:

• Translating business requirements into technical specifications
• Designing and developing the Data Analytics (Data ingestion, data warehouse, data lake ODS, pipeline, error handling, Azure cloud data gateway, MS Fabric, Power BI security, Power BI workspace) reusable framework
• Designing Data Models based on technical specifications
• Exploring in-depth PowerBI features for advanced analytics which require more customization like DataFlow & DataMart
• Designing and building End to End Data pipeline and ETL packages including:

• Staging Areas and Date Warehouse Layouts with SQL Server
• Data pipeline with SSIS
• ETL Processes with SSIS / SSDT
• Error Handling
• Dashboards and reports with PowerBI Desktop
• Troubleshoot day to day data warehouse issues

The position requires the following technical qualifications:

• Experience with on premise Data Warehouse reusable framework design and implementation
• Good understanding of cloud design considerations for data storage and processing
• Experience with data modeling
• Experience with building data pipelines and ETL processes
• Extensive development experience with technologies including: SSIS, SQL Server, REST API, OLAP cubes, BI Analytic tools

• Extensive analytic development experience with PowerBI and preferably Microsoft Power Platform.
• Advanced Power BI Service configurations such as Power BI DataFlow and DataMart
• Experience in PowerBI report development, reports automation with data source refresh configurations
• Experience with analyzing data source systems to identify data transformation needs
• Thorough knowledge of software development methods, practices and procedures
• Ability to prepare technical design and write technical specifications

In addition, this position requires the ability to:

• Establish and maintain effective working relationships with a variety of internal contacts.
• Provide advice and assistance on matters related to the work.
• Communicate effectively orally and in writing.
• Perform assigned duties with minimal supervision, although direction will be given.
• Maintain confidentiality.

Expected salary

Location

Canada

Job date

Fri, 08 Aug 2025 23:15:24 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnearcanada.com) you saw this job posting.