Senior BI Developer

We have an exciting Senior BI Developer contract opportunity. This is a 12 month contract with potential to extend. The Senior BI Developer will be expected to work onsite 2 days per week in Toronto at Yonge & Davisville. 

The Senior BI Developer will work under the supervision of the BI Technical Team Lead and will be responsible for designing and developing business intelligence solutions and/or enhancing and supporting existing solutions. This is part of our client's BI Enablement project. 

Roles and Responsibilities

• Work with the Business Intelligence & Analytics team in designing, developing, maintaining the Business Intelligence and Enterprise Data platforms and associated solutions.
• Responsible for designing, developing, maintaining, and documenting Microsoft Power BI and MicroStrategy datasets/semantic layer, dashboards, and reports.
• Responsible for modelling data, designing, and creating datasets using Microsoft Power BI and MicroStrategy
• Responsible to assist and support end users with the Microsoft Power BI and MicroStrategy.
• Work closely with the business analyst(s), and other team members to understand, and deliver on, requirements. 
• Convert business requirements to technical specifications.
• Research, document, and share knowledge with the project team.
• Provide accurate time estimates for work to be undertaken.
• Create project documentation according to the Project Management Office Standards.

Qualifications and Skills

• A university degree in Computer Science, or the equivalent, combined with directly related experience in a business or computer related discipline. Minimum of 5 years’ experience working as a Business Intelligence developer.
• Microsoft’s Power BI Data Analyst Associate certification required.
• MicroStrategy professional certification required; Architect, Developer or similar.
• Extensive hands-on experience developing business intelligence solutions; semantic layers, schemas, dashboards, and reports using Microsoft Power BI.
• Experience working as a BI developer on large Enterprise projects using Microsoft Azure, Synapse, and database related services coupled to Microsoft Power BI
• Experience configuring and administering Microsoft Power BI environments and implementing deployment pipelines.
• Expert understanding of Microsoft Power BI user and workspace management/administration best practices.
• Extensive hands-on experience developing business intelligence solutions; data cubes, schemas, dashboards and reports using MicroStrategy 2020 or later.
• Hands-on experience working with MicroStrategy Command Manager, Developer and Object Manager tools.
• Experience working with SQL Server 2019 or later.
• Good understanding of data modelling techniques as relates to interfacing BI platforms to data warehouse solutions.
• Ability to solve complex data problems by analysis, develop appropriate solutions and clearly communicate those solutions to the team.
• Well-developed interpersonal, oral, and written communication skills, strong analytical and problem-solving skills.
• Must have or rapidly acquire a comprehensive knowledge of the Ontario Human Rights Code and Related Orders including disability accommodation and accessibility requirements pertaining to passengers and employees.

Deliverables

• Self-serve Analytics, Dashboards and Reporting:

  • Business Enterprise
    • SAP Finance, Payroll, HR
    • Legacy Payroll
    • Maximo
    • VISION
  • BI / Reporting and Analytics
    • Time and Attendance reporting
    • Vacancy & Absenteeism reporting
    • Self-serve Analytics Combining Attendance, Payroll and Finance Data
    • Legacy Payroll Banked Reporting
    • Payroll Sub-Ledger Report and Self-Serve Analytics
    • BI Tool Training
  • BI Reports Migration MicroStrategy to MS Power BI