BI Engineer
| Company | SOTI |
|---|---|
| Location | Mississauga, ON, Canada |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | |
| Experience Level | Mid Level |
Requirements
- 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
- 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
- Experience in BI development and data analysis
- Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools
- Excellent written, verbal, and interpersonal communication skills
Responsibilities
- Design, develop, and deploy interactive Power BI reports and dashboards to meet the needs of various business units
- Develop and maintain data models to support business requirements, ensuring efficient data retrieval and reporting
- Integrate data from various sources into SQL Server and Azure Synapse/Fabric, ensuring data accuracy and consistency
- 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
- Create and maintain comprehensive documentation for data models, reports, dashboards, and processes
- Monitor and optimize the performance of BI solutions, identifying and resolving issues proactively
- Provide support to end-users on Power BI functionalities and best practices
- Support and enforce data governance best practices, including data quality, metadata management, data lineage, and access control
Preferred Qualifications
- 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