On behalf of our public sector client, Affinity is seeking a Business Intelligence Developer to work with the IT Data Analytics team on Microsoft Fabric, an on-premises data warehouse with SQL Server Integration Services, SQL Database and PowerBI. The role focuses on developing modern analytics solutions, data integration pipelines, and business intelligence reporting capabilities for internal corporate clients.

Responsibilities

- Translating business requirements into technical specifications
- Designing and developing modern analytics solutions leveraging Microsoft Fabric, OneLake, Medallion Architecture, data lakes, data warehouses, data pipelines, error handling, and Power BI
- Designing data models and semantic models based on technical specifications
- Exploring advanced Microsoft Fabric capabilities for analytics, reporting, and data engineering solutions
- Designing and building end-to-end data integration and analytics solutions including:
- Data ingestion into Microsoft Fabric and OneLake
- Bronze, Silver, and Gold data layers using Medallion Architecture principles
- Data pipelines using Fabric Data Factory, Dataflows, notebooks, and SSIS where appropriate
- Data transformation and loading into Fabric Lakehouses, Data Warehouses, and analytical data stores
- Error handling, monitoring, and data quality controls
- Power BI security, semantic models, dashboards, reports, and workspace administration
- Troubleshooting day-to-day Fabric, data warehouse, and data integration issues

Qualifications

- Extensive analytic development experience with Microsoft Fabric and preferably Microsoft Power Platform.
- Experience with on premise Data Warehouse reusable framework design and implementation
- Good understanding of cloud design considerations for data storage and processing




- Experience with data modeling
- Experience with building data pipelines and ETL processes
- Extensive development experience with technologies including: SSIS, SQL Server, REST API, OLAP cubes, BI Analytic tools
- Advanced Power BI Service configurations such as Power BI DataFlow and DataMart
- Experience in PowerBI report development, reports automation with data source refresh configurations
- Experience with analyzing data source systems to identify data transformation needs
- Ability to prepare technical design and write technical specifications
- Establish and maintain effective working relationships with a variety of internal contacts.
- Provide advice and assistance on matters related to the work.
- Communicate effectively orally and in writing.
- Perform assigned duties with minimal supervision, although direction will be given.
- Maintain confidentiality.

Affinity Earn Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/ About Affinity Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal chance employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 13857

📌 Business Intelligence Developer (Burnaby)
🏢 Affinity
📍 Burnaby