Senior Software Developer - BI

Maarut Inc; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in IT Services is seeking a Mid-Senior level professional to join their reporting team. This role involves designing a new data warehouse/lakehouse solution on Microsoft Azure, migrating data, and developing reports using Power BI. The ideal candidate will have strong skills in data modeling, ETL processes, and SQL optimization. This is a contract position based in Toronto, Ontario.

Qualifications

• Mid-Senior level experience required.
• Proficiency in Power BI and ETL processes.

Responsibilities

• Design and implement data warehouse/lakehouse on Azure.
• Develop reports and dashboards as per MVP requirements.
• Automate ETL processes for data integration.

Skills

Power BI

Data Warehouse/Lakehouse Concepts

SQL and Query Optimization

Tools

Azure Synapse Analytics

SSIS

SSRS

Azure Data Factory

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Maarut Inc

The OPGT is developing “PGTIMS”, a new Dynamics CE based solution that will modernize OPGT’s legacy applications and systems. This project requires migrating historical data from the legacy solutions to a new data warehouse/lakehouse, building all the new data assets in the lakehouse, and creating new Power BI reports.

As a member of the reporting team, you will be responsible for delivering the MVP for reporting, building the new data warehouse/lakehouse, and delivering the required reporting. A high-level list of deliverables for the data migration team includes:

1. Data Warehouse Design: analyze business requirements and design an efficient data warehouse/lakehouse/golden layer on Microsoft Azure.
2. Data Integration and ETL: help develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the new data warehouse/lakehouse (bronze/silver/golden layers). Help integrate data from diverse sources into the new data warehouse.
3. Data Modeling: create logical and physical data models that align with the project’s reporting and analytical needs.
4. Data Security and Governance: implement appropriate security controls to protect sensitive data within the data warehouse and reports.
5. Reporting and Visualization: develop reports, dashboards, and visualizations as per reporting MVP. Ensure the quality, accuracy, and integrity of reports.
6. Performance Optimization: fine-tune the data warehouse and reporting processes to optimize query performance and overall system efficiency.
7. Other duties as assigned.

Experience and Skill Set Requirements:

Must Haves:

• Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features.
• ETL/Microsoft Azure Synapse Analytics: experience with architecture, data storage options, data ingestion mechanisms, and security features.

Nice to have:

• Dynamics 365 certifications

Skill Set Requirements:

Desired Skills and Experience:

• Data Warehouse/Lakehouse Concepts: strong understanding of data warehousing principles, data modeling, ETL processes, data integration, and data governance.
• Microsoft Azure Synapse: in-depth knowledge of Azure Synapse Analytics, data storage options (e.g., SQL Data Warehouse, Data Lake Storage), data ingestion mechanisms (e.g., Azure Data Factory), and security features.
• Power BI: proficiency in data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
• SQL and Query Optimization: strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues. Understanding indexing, partitioning, and query execution plans.
• Development experience with Dynamics 365 and understanding of the Common Data Model for Dynamics.
• Report development experience for Microsoft Dynamics 365 Customer Engagement (CE) and/or Finance and Operations (F&O): familiarity with these platforms.
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps).

Power BI:

• Experience working with Power BI, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features such as DAX and Power Query.
• Experience with SSIS, SSRS.
• Experience with Azure Synapse Workspaces and/or Azure Data Factory.
• Azure cloud certifications.

Dynamics 365:

• Development experience with PowerApps, Power Automate, Dynamics CE & F&O, and report production from Dynamics.

SQL/DB:

• Experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning.
• Experience with SQL Server, Oracle, Azure SQL Databases.
• Experience with Azure DevOps for version control and collaboration.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at Maarut Inc by 2x

Get notified about new Senior Software Engineer jobs in Toronto, Ontario, Canada.