Employer Active
Responsibilities
Required to translate technical systems specifications into working tested applications.
This includes: developing detailed programming specifications writing and/or generating code compiling datadriven programs maintaining and conducting unit tests. Resolves and troubleshoots technical problems which arise during the use and operation of software packages including technical assistance in implementation conversion and migrations.
General Skills :
Experience in programming and analysis; specialized software package support at the specified experience level Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
Experience in structured methodologies for the development design implementation and maintenance of applications
Experience in design code test debug and document applications
Experience in the use of object and/or third generation language development tools Experience in one or more programming languages
Experience in application design latest design patters deployment and troubleshooting Experience with relational and hierarchical database technologies
Experience in the use of information retrieval packages using query languages
Experience with one or more communications protocols
Experience in structured methodologies for the design development implementation and maintenance of applications
Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
Excellent analytical problemsolving and decisionmaking skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines
Desirable Skills
Knowledge and experience with programming Internetready applications
Knowledge and experience in rapid application development (RAD) methodologies Knowledge and understanding of Information Management principles concepts policies and practices
Experience with middleware and gateways
Experience reviewing analyzing and modifying product installation scripts including encoding testing debugging
Ability to provide postimplementation support and resolve any postimplementation technical issues
Experience conducting design walkthrough sessions with project team
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
Ability to provide user and system documentation as required
Skills
Experience and Skill Set Requirements
Development Skills
We seek a candidate with extensive experience with Oracle SQL and Spark SQL.
Proven ability to work with complex SQL queries potentially hundreds or thousands of lines in length (must have) .
Ability to organize complex SQL for readability and understanding by others.
10 years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics data modeling & data mining reporting report conversion and data cleansing.
Proficiency with Power BI and DAX (must have)
Demonstrated experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service (must have)
Create highly dynamic visualizations and metrics using Power BI (must have)
Design and develop BI dashboards and reports based on business requirements (must have)
Implement maintain and support BI solutions in Microsoft and other BI platforms (must have)
Complete committed backlog and sprints within the agreed upon timeframe
Curate data from multiple data sources for an efficient presentation in an enterprise environment
Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy usability and value
Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives
Document As Built reports and all data transformations deployed to production
Take ownership of endtoend development of each dashboard and report being developed
Technology Skills
Experience with cloud platform like Azure and working knowledge for cloud migration (must have)
Experience with Microsoft Azure data analytics tools such as Azure Data Factories Azure Databricks Azure Synapse (must have)
Expertise in advanced prediction and prescriptive analytics including machine learning algorithms designing experiments fraud detection
Internally motivated and adaptable able to work proficiently both independently and in a team environment.
Managing PowerBI workspaces report access report deployment developing best practices in an enterprise environment
Strong knowledge and experience in analyzing as well as designing data models that meet the reporting needs
Advance knowledge of writing complex SQL queries.
Strong Power BI experience (Power Query DAX Power Bi Services)
Experience with Microsoft BI and Azure stack
Able to troubleshoot BI reporting and analytic business needs and provide solutions for issue resolution
Soft Skills
Strong communication skills; both written and verbal
Ability to develop and present new ideas and conceptualize new approaches and solutions
Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
Demonstrated ability to work with functional and technical teams
Demonstrated ability to participate in a large team and work closely with other individual team members
Proven analytical skills and systematic problem solving
Strong ability to work under pressure work with aggressive timelines and be adaptive to change
Public Sector Experience
Prior public sector experience would be an asset
Must Haves:
Proven ability to work with complex SQL queries potentially hundreds or thousands of lines in length
Proficiency with Power BI and DAX
Demonstrated experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service
Create highly dynamic visualizations and metrics using Power BI
Design and develop BI dashboards and reports based on business requirements
Implement maintain and support BI solutions in Microsoft and other BI platforms
Experience with cloud platform like Azure and working knowledge for cloud migration
Experience with Microsoft Azure data analytics tools such as Azure Data Factories Azure Databricks Azure Synapse
Nice to Have:
Prior public sector experience would be an asset
Full Time