Assignment : RQ08039 - Software Developer - Senior
Job Title : Senior Azure Data Engineer / BI Developer
Requisition (SS) : RQ08039
Start Date : 2024-11-01
End Date : 2025-01-28
Client : Government Services Integration Cluster
Office Location : 222 Jarvis Street, Toronto
Organization : Government Services Integration Cluster
Ministry : Ministry of Public and Business Service Delivery (former MGCS)
Business Days : 59.00
Note : Hybrid - 3 days onsite / 2 days remote
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 data-driven programs, maintaining, and conducting unit tests.
- Resolves and troubleshoots technical problems that arise during the use and operation of software packages, including providing 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 patterns, 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, problem-solving, and decision-making 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 Internet-ready 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, and debugging.
- Ability to provide post-implementation support and resolve any post-implementation technical issues.
- Experience conducting design walkthrough sessions with the 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.
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 end-to-end 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
Il y a 3 jours