Return to jobs

RQ06789 - Software Developer - Senior(Business Intelligence Developer)

Ref: CA_EN_6_919740_1529677

Posted on 08 February 2024
Toronto, Ontario
Contract Type

Job Description: Senior Business Intelligence Developer

Experience and Skill Set Requirements:

Design and Development Experience

  • 10+ years of coding experience in SQL, Azure SQL, T-SQL, and Azure Streaming Analytics SQL

  • In-depth knowledge of Azure PaaS data services, including Azure SQL Database, Data Lake Store (Gen 2), and Data Factory

  • Proficiency in on-premise SQL Server and Azure PaaS data streaming services

  • Familiarity with SSAS Partitioning and Power Query/Power Pivot

  • Writing Python and SQL scripts for custom Computer Aided Dispatch (CAD) installations

  • Experience with Datafactory, On-Premise data gateway, and PowerBI best practices

  • Knowledge of UI Design Principles and SOAP/REST web services

  • Role-based security implementation in reports and deployment of reports into Azure infrastructure

Technical Skills

  • 10+ years of technical data warehousing experience, focusing on Business Intelligence

  • Expertise in Azure Analysis Services/SSAS, SQL Server Reporting Services (SSRS), and Power BI

  • End-to-end management of the Software Development Life Cycle (SDLC) for CAD

  • Developing process models and ongoing program effectiveness analysis

  • Design and development of data models for OLTP and OLAP environments

  • ETL processes design and development, along with data source validation

  • Creation of visualizations for reports/dashboards, including real-time and mobile dashboards

Communication Skills

  • Strong verbal and written communication skills

  • Writing Business Requirements Document, Data Sharing Agreements

  • Excellent consulting skills for stakeholder engagement and business requirements gathering

  • Ability to work independently in an agile environment and meet deadlines

  • Team player with a track record of effective collaboration and knowledge transfer documentation

Industry Experience

  • Experience in multi-year projects and building enterprise-level reporting solutions

  • Knowledge and experience with Public Sector governance methodologies (e.g., UPM, architecture gating)

Find your local office.

Find your local office. Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.