Senior Software Developer

Randstad Canada; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Software Developer for a 6-month hybrid contract in Toronto. The role involves designing data architectures and developing ETL processes, with a focus on Power BI and Azure technologies. Ideal candidates will possess strong SQL skills and experience with Dynamics 365. This position offers a competitive industry rate.

Benefits

Hybrid role: 3 days onsite / 2 days remote

Competitive industry rate

Qualifications

• Proficiency in Power BI, including data modeling and report creation.
• Experience with ETL and Azure Synapse Analytics.

Responsibilities

• Design data warehouses and lakes based on business requirements.
• Develop and automate ETL processes to load data.
• Create reports and dashboards, ensuring quality and accuracy.

Skills

Power BI

SQL

ETL

Data Modeling

Data Warehousing

Education

Azure Fundamentals

Azure Power BI Data Analyst Associate

Tools

Azure Synapse Analytics

Dynamics 365

Azure DevOps

Azure Repos

Job description

Do you have proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features? Do you have experience with ETL and Microsoft Azure Synapse Analytics, including architecture, data storage options, data ingestion mechanisms, and security features? If so, this could be a great opportunity for you!

Our client is seeking a Senior Software Developer for a 6-month contract in Toronto.

This role is hybrid, requiring 3 days onsite per week.

Advantages

• Hybrid role: 3 days onsite / 2 days remote
• Competitive industry rate

Responsibilities

1. Design data warehouses, lakes, and gold layers on Microsoft Azure based on business requirements.
2. Develop and automate ETL processes to load data from Dynamics 365 CE and F&O into the data warehouse/lakehouse, integrating data from various sources.
3. Create logical and physical data models aligned with reporting and analytics needs.
4. Implement security controls to protect sensitive data within the data warehouse and reports.
5. Develop reports, dashboards, and visualizations, ensuring quality and accuracy.
6. Optimize system performance through fine-tuning of data processes.
7. Perform other duties as assigned.

Qualifications

Must Have

• Proficiency in Power BI, including data modeling, report/dashboard creation, and advanced features.
• Experience with ETL and Azure Synapse Analytics, including architecture, storage, ingestion, and security.
• Experience with Dynamics 365 CE and/or F&O report development.

Nice to Have

• Azure cloud certifications (e.g., Azure Fundamentals, Azure Power BI Data Analyst Associate)
• Dynamics 365 certifications

Desired Skills and Experience

• Strong understanding of data warehousing, data modeling, ETL, and governance principles.
• In-depth knowledge of Azure Synapse Analytics and its components.
• Proficiency in Power BI, including data modeling, dashboards, data gateways, DAX, and Power Query.
• Strong SQL skills for complex queries, performance optimization, and troubleshooting.
• Development experience with Dynamics 365 and understanding of the Common Data Model.
• Report development experience for Dynamics 365 CE and F&O.
• Familiarity with version control (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps).

Summary

If interested, please apply online at www.randstad.ca. Qualified candidates will be contacted.

Randstad Canada values diversity and is committed to creating an inclusive workplace. Please inform us of any accommodation needs during the application process by contacting [e-mail].