Software Developer - Senior
About The Position
We do have a job opening for Software Developer - Senior for our direct client Province of Ontario. The position details are given below: Job Details: Job ID: RQ10970 - Software Developer - Senior Client : Community Services Cluster Location : Toronto, Ontario Duration: 10 months + Extension Type: Onsite Job Description: Technical Skills: Experience: The ideal candidate should possess 10+ years of experience as a Software Designer & Developer, with a focus on the following project environments: Required Skills (5-7 years): Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation Preferred Skills (2-4 years): Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control • Extensive experience designing and implementing BI solutions for both on-premise and cloud environments, ensuring scalability, performance, and maintainability. • Led technology upgrade and migration projects to Microsoft BI Suite, determining which components to migrate, rebuild, or optimize. • Over 5+ years of hands-on experience in ETL development and data warehousing, including large-scale data migrations and daily operational data loads. • Deep knowledge of the Microsoft technology stack, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and supporting tools like Visual Studio and SQL Server Management Studio. • Experienced with data governance, role-based access control (Azure AD), and working with multiple database platforms including Oracle and MSSQL. •Hands-on experience with Power BI Server (On-Prem) and Power BI Service (Cloud), including report deployment, administration, and publishing. •Strong hands-on experience with ETL development using SSIS and Azure Data Factory, including debugging transformations, mappings, and unit testing. • Hands-on experience automating ETL and Power BI deployments using CI/CD pipelines in Azure DevOps, GitHub Actions, or similar platforms. • Proficient in scripting (PowerShell, Python, or command-line tools) to automate report publishing, ETL job execution, and environment promotion. •Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies Must Have: -HM is looking for a Strong Power BI Developer- 10+ years Strong expertise in Power BI Desktop and Power BI Service Advanced knowledge of DAX (Data Analysis Expressions) Proficiency in Power Query (M Language) for data transformation Strong SQL skills for querying and managing data Experience in data modeling (Star Schema, Fact & Dimension tables) Ability to create interactive dashboards and reports Knowledge of ETL processes and data integration Experience connecting to multiple data sources (databases, APIs, cloud platforms) Understanding of performance optimization for reports and datasets Implementation of Row-Level Security (RLS) and data governance Familiarity with Microsoft Fabric, Azure, and cloud analytics platforms Strong analytical and problem-solving skills Ability to translate business requirements into actionable insights Excellent data visualization and storytelling capabilities Good stakeholder communication and documentation skills Experience with report deployment, sharing, and workspace management Knowledge of data warehousing and BI best practices Relevant certifications such as PL-300 Power BI Data Analyst Most Important Technical Skills Power BI (Power BI on prim / Power BI services cloud) DAX Power Query SQL Data Modeling ETL Dashboard Development Performance Tuning Security (RLS) Microsoft Fabric / Azure Analytics Nice to have: Prior OPS or Public sector Exp.
Requirements
- 10+ years of experience as a Software Designer & Developer
- 5-7 years of experience with Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
- Strong Power BI Developer
- Strong expertise in Power BI Desktop and Power BI Service
- Advanced knowledge of DAX (Data Analysis Expressions)
- Proficiency in Power Query (M Language) for data transformation
- Strong SQL skills for querying and managing data
- Experience in data modeling (Star Schema, Fact & Dimension tables)
- Knowledge of ETL processes and data integration
- Understanding of performance optimization for reports and datasets
- Familiarity with Microsoft Fabric, Azure, and cloud analytics platforms
- Knowledge of data warehousing and BI best practices
Nice To Haves
- 2-4 years of experience with Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
- Deep knowledge of the Microsoft technology stack, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and supporting tools like Visual Studio and SQL Server Management Studio.
- Prior OPS or Public sector Exp.
Responsibilities
- Extensive experience designing and implementing BI solutions for both on-premise and cloud environments, ensuring scalability, performance, and maintainability.
- Led technology upgrade and migration projects to Microsoft BI Suite, determining which components to migrate, rebuild, or optimize.
- Over 5+ years of hands-on experience in ETL development and data warehousing, including large-scale data migrations and daily operational data loads.
- Experienced with data governance, role-based access control (Azure AD), and working with multiple database platforms including Oracle and MSSQL.
- Hands-on experience with Power BI Server (On-Prem) and Power BI Service (Cloud), including report deployment, administration, and publishing.
- Strong hands-on experience with ETL development using SSIS and Azure Data Factory, including debugging transformations, mappings, and unit testing.
- Hands-on experience automating ETL and Power BI deployments using CI/CD pipelines in Azure DevOps, GitHub Actions, or similar platforms.
- Proficient in scripting (PowerShell, Python, or command-line tools) to automate report publishing, ETL job execution, and environment promotion.
- Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies
- Ability to create interactive dashboards and reports
- Experience connecting to multiple data sources (databases, APIs, cloud platforms)
- Implementation of Row-Level Security (RLS) and data governance
- Strong analytical and problem-solving skills
- Ability to translate business requirements into actionable insights
- Excellent data visualization and storytelling capabilities
- Good stakeholder communication and documentation skills
- Experience with report deployment, sharing, and workspace management
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
