BI ETL Developer

About the Employer
Annual Salary
Not disclosed

Job Description

BI ETL Developer On behalf of our client, we are looking for an BI ETL Developer Job Description: We are currently seeking an ETL / BI Developer to join our Business Intelligence and Data Integration Team. Reporting to the Business Intelligence Lead this position will be responsible for the development and maintenance of ETL / ELT solutions to deliver high quality data into our data warehouse and operational datastore, along with exporting data in various formats for internal and external... purposes. Additional responsibilities will be to assist BI Lead, Project Managers, Business Analysts and Business Intelligence Analysts in the creation and support of Power BI dashboards, reports and datasets. Primary Responsibilities: Analyze, design, develop, test, document and troubleshoot ETL / ELT solutions from high level detailed specifications; Accountable to ensure data integrity in Data Warehouse and Operational Datastore; Maintain, Monitor and support production ETL processes and respond to error and emergency issues; Must be able to multi-task between various tasks and projects; Conduct unit tests and assist in test preparations to ensure data integrity and data quality; Design and implement technical enhancements to Data Warehouse and Operational Datastore; Document technical requirements (ETL, Mapping, etc.); Must Have: Bachelor’s degree in computer science or computer engineering or equivalent. 3- years of experience working with MS SSIS to design, develop and troubleshoot data integration processes. Strong development experience with MS SQL. Strong understanding of relational and dimensional data modeling. Excellent knowledge and experience with Data Warehouse and Operational Datastore concepts, ETL strategies and best practices. Strong analytical skills. Strong understanding of RESTful APIs. Very good knowledge of Microsoft BI stack (SQL, SSIS, SSRS, Power Platform); Good experience with Power BI and DAX queries. Knowledge or experience with Agile methodology and tool (Azure devops). Good interpersonal and communication skills at the business and technical levels. Flexibility in organizing work. Resourcefulness in problem-solving. Experience with Azure Data Factory (an asset); Bilingual (English and French) both written and oral (an asset). Duration: 6 Months + Possible Extension Location: Work Remotely – Ottawa – Potential onsite in the futureShow full descriptionCollapse

Page Generated in : 0.0001521110534668 Sec.