SOTI is committed to providing its employees with endless possibilities; learning new things, working with the latest technologies and making a difference in the world.

What You’ll Do

• Report and Dashboard Development: Design, develop, and deploy interactive Power BI reports and dashboards to meet the needs of various business units.
• Data Modeling: Develop and maintain data models to support business requirements, ensuring efficient data retrieval and reporting.
• Data Integration: Integrate data from various sources into SQL Server and Azure Synapse/Fabric, ensuring data accuracy and consistency.
• Collaboration: Work closely with stakeholders, including internal customers from various departments, business analysts, data engineers, and data scientists to gather requirements and deliver solutions that drive business insights.
• Documentation: Create and maintain comprehensive documentation for data models, reports, dashboards, and processes.
• Performance Monitoring: Monitor and optimize the performance of BI solutions, identifying and resolving issues proactively.
• Training and Support: Provide support to end-users on Power BI functionalities and best practices.
• Data Governance: Support and enforce data governance best practices, including data quality, metadata management, data lineage, and access control. Collaborate with data engineers and data architects to ensure data definitions, standards, and policies are consistently applied across BI solutions.

Experience You’ll Bring

• Excellent analytical, troubleshooting, problem-solving and research skills.
• Must be able to multitask and have experience with interacting with a diverse internal user/customer base.
• Must have 3-5 years of experience in SQL using SQL server and Azure Synapse Analytics
• Must have 2-3 years of experience with Power BI report development and deployment.
• Experience in BI development and data analysis.
• Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools.
• Experience using Cloud architecture, NoSQL databases and R/Python is a plus.
• Experience using building data pipelines to integrate with unstructured data sources is a plus.
• Excellent written, verbal, and interpersonal communication skills

LI-AK1

If you want to bring your ideas to life, apply at SOTI today.
We are committed to providing accessible employment practices that are in compliance with the requirements under the Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation during any stage of the recruitment process, please notify People & Culture at
careers@soti.net.
Please note that SOTI does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Services Agreement with agency/recruiter, SOTI will not consider or agree to payment of any referral compensation or recruiter fee

• Report and Dashboard Development: Design, develop, and deploy interactive Power BI reports and dashboards to meet the needs of various business units.
• Data Modeling: Develop and maintain data models to support business requirements, ensuring efficient data retrieval and reporting.
• Data Integration: Integrate data from various sources into SQL Server and Azure Synapse/Fabric, ensuring data accuracy and consistency.
• Collaboration: Work closely with stakeholders, including internal customers from various departments, business analysts, data engineers, and data scientists to gather requirements and deliver solutions that drive business insights.
• Documentation: Create and maintain comprehensive documentation for data models, reports, dashboards, and processes.
• Performance Monitoring: Monitor and optimize the performance of BI solutions, identifying and resolving issues proactively.
• Training and Support: Provide support to end-users on Power BI functionalities and best practices.
• Data Governance: Support and enforce data governance best practices, including data quality, metadata management, data lineage, and access control. Collaborate with data engineers and data architects to ensure data definitions, standards, and policies are consistently applied across BI solutions