onsite
Business Intelligence & Data Specialist - ABB Electrification Canada Inc.
Software Engineer
Lead data quality and reporting initiatives as a Business Intelligence & Data Specialist, leveraging Python, SQL, Power BI and robust data modeling to deliver accurate, actionable insights across enterprise systems.
About the role
Key Responsibilities
- Design, develop, and maintain automated and ad‑hoc reports using Power BI and SQL, ensuring timely delivery of actionable insights to stakeholders.
- Implement and enforce data quality standards, performing data profiling, cleansing, and validation across multiple source systems.
- Collaborate with data engineers and business users to define data models, data flows, and ETL processes that support analytics and reporting needs.
- Diagnose and resolve technical data issues, providing rapid emergency support and root‑cause analysis to minimize downtime.
- Document data architecture, metadata, and reporting logic to support governance and audit requirements.
Requirements
- Proven experience with SQL Server, data warehousing, and ETL tooling.
- Strong proficiency in Python for data manipulation, automation, and scripting.
- Hands‑on expertise in Power BI, including DAX, data modeling, and dashboard development.
- Solid understanding of data quality principles, data governance, and metadata management.
- Excellent analytical, problem‑solving, and communication skills.