BI Developer AZURE

Assignment: RQ07171 Software Developer Senior

Start Date:

End Date:

Office Location: 222 Jarvis Street Toronto

Organization: Government Services Integration Cluster

Ministry: Ministry of Public and Business Service Delivery (former MGCS)

# Business Days: 240.00

Title: Software Developer

Candidate is required to work onsite 3 days per week.

Must Haves:

• Demonstrated experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service
• Converting pl/SQl package into databricks code and have some basic understanding on oracle cloud db
• 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

Description

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.

Experience and Skill Set Requirements

Development Skills 40%

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.

Demonstrated experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service (must have)

Converting pl/SQl package into databricks code and have some basic understanding on oracle cloud db.(must have)

Design and develop BI dashboards and reports based on business requirements

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 35%

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 20%

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