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 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, 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, debugging
  
• Ability to provide post-implementation support and resolve any post-implementation 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
  

Experience and Skill Set Requirements:

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
  

Skill Set Requirements:

Development Skills:

• 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:

• 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