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
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 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
SkillsExperience and Skill Set Requirements
Development Skills 40/100
- 5 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.
- Experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service
- Design and develop BI dashboards and reports based on business requirements
- Implement maintain and support BI solutions in Microsoft and other BI platforms
- 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/100
- 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
- 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/100
- 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 5/100
- Experience working with a CRM system would be an asset.
- Experience with OPS Transfer Payment Model would be an asset.
- Prior public sector experience would be an asset
Must Have:
- 5 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.
- Experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service
- 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 haves:
- Experience with OPS Transfer Payment Model would be an asset.
- Experience working with a CRM system would be an asset.