BI Engineer

协呉; Mississauga; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company in innovative technology seeks a BI Developer to design and implement Power BI reports and manage data integration across platforms. The ideal candidate will have extensive experience with SQL and Azure Synapse technologies, focusing on enhancing business intelligence through effective data governance and collaboration with diverse teams.

Qualifications

• 3-5 years of experience in SQL Server and Azure Synapse Analytics.
• 2-3 years of experience with Power BI report development.
• Experience with cloud architecture and ETL tools is a plus.

Responsibilities

• Design, develop, and deploy interactive Power BI reports.
• Integrate data from various sources into SQL Server and Azure Synapse.
• Monitor and optimize the performance of BI solutions.

Skills

Analytical skills

Problem-solving

Communication

Research skills

Job description

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 [e-mail].

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.