Please, no third parties. Permanent residents only.
Sr Business Intelligence Engineer
Skills & Requirements:
- 4+ years of experience working in a data engineering, analytics, business intelligence, or data warehouse environment.
- Strong experience in data modeling, including designing and optimizing relational and dimensional models to support enterprise reporting, analytics, and scalable data solutions.
- Advanced Power BI expertise, including building enterprise dashboards, semantic models, and developing complex DAX calculations/measures to support business reporting and analytics needs.
- Proficiency writing complex T-SQL queries for data transformation, validation, and reporting.
- Hands-on experience working with Snowflake as a cloud data warehouse, including data ingestion, transformation, and performance optimization.
- Strong background building ETL/ELT pipelines, including orchestration, monitoring, and troubleshooting data processing workflows.
- Intermediate to advanced experience creating Power BI reports, particularly paginated reports and enterprise-level dashboards used for operational or regulatory reporting.
- Demonstrated experience gathering technical requirements and performing detailed data analysis to support reporting and integration initiatives.
- Solid understanding of system integrations, relational database design, and enterprise data architecture principles.
- Strong analytical thinking and problem-solving capabilities with an ability to interpret complex datasets.
- Excellent written and verbal communication skills with the ability to collaborate effectively with technical teams and high-level business stakeholders.
- Familiarity with Azure data services or cloud-based analytics platforms is highly preferred.
- Exposure to modern data engineering tools such as Coalesce, dbt, or similar automation frameworks used to manage transformation logic and data modeling is preferred.
- Familiarity with Microsoft Fabric, lakehouse architectures, or other modern analytics platforms is a plus.
- Bachelor’s degree in Computer Science or a related technical discipline, or equivalent professional experience.