Senior BI Developer
Job Description
Position Overview
We are seeking an experienced Senior Business Intelligence (BI) Developer to play a key role in stabilizing, improving, and optimizing our BI operations and reporting environment. The ideal candidate is an expert in BI development, data processing techniques, and reporting best practices, with the ability to ensure timely, accurate, and reliable delivery of critical business reports.
In this role, you will design, develop, and enhance BI solutions, work directly with stakeholders to meet Business-As-Usual (BAU) reporting needs, resolve complex data issues, and support the migration to new data platforms and environments.
Primary Responsibilities
- Act as a subject-matter expert in BI operations and the stabilization of reporting environments.
- Ensure timely and accurate delivery of BI reports by designing, implementing, and maintaining high-quality BI solutions.
- Proactively identify and resolve issues related to data quality, report refresh failures, and data pipeline reliability.
- Design and implement tactical processes to secure report production and improve BI system performance.
- Maintain and enhance report delivery processes during complex data challenges, ensuring continuity and accuracy.
- Promote and apply best practices in BI development, data governance, and data management across the organization.
- Provide hands-on expertise in all aspects of BI report development, including requirements analysis, data modeling, design, development, and deployment.
- Collaborate directly with business stakeholders to understand and deliver Business-As-Usual (BAU) reporting requirements.
- Support the migration and development of BI assets into new data environments and platforms.
Qualifications
Education & Experience
- University degree in Business Intelligence, Data Science, Computer Science, or a related field.
- 4+ years of experience in BI operations, BI development, or BI report maintenance and improvement.
Technical Skills
- Strong expertise with Power BI, including DAX, data modeling, performance optimization, and dashboard/report development.
- Proficiency in SQL and strong understanding of relational and analytical data structures.
- Experience with ETL/ELT processes and tools such as Azure Data Factory, SSIS, or similar platforms.
- Technical understanding of API-based data ingestion and various data processing languages.
- Solid knowledge of data warehousing concepts, including star schemas, fact/dimension modeling, and normalization.
- Familiarity with cloud and hybrid cloud environments, including IaaS, PaaS, and SaaS models.
- Experience with Azure technologies preferred, including:
- Azure Data Factory
- PowerShell scripting
- Azure Automation
- Azure Data Lake & Data Lake Analytics
- Azure SQL, SQL Server, Azure SQL Data Warehouse
- SSIS, SSRS, Power BI Services
- R or Azure Machine Learning (an asset)
Soft Skills
- Strong analytical and reasoning skills with the ability to design flexible and robust BI architectures.
- Ability to proactively identify issues and deliver effective technical solutions.
- Excellent communication skills for working with both technical and non-technical stakeholders.
- High level of attention to detail and commitment to quality.
Why Join Us
- Opportunity to work with modern BI technologies and evolving cloud platforms.
- High-impact role supporting critical business insights and decision-making.
- Collaborative environment with opportunities to learn and innovate.
