BI Developer

Affinity; Burnaby; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A technology and business consulting company is seeking a Business Intelligence Developer for a one-year contract to support the development of a Data Warehouse. This role involves translating business requirements into technical specifications, designing data models, and exploring advanced Power BI features. Ideal candidates will have extensive experience with data warehousing technologies and a strong understanding of ETL processes. The position may be hybrid or fully remote for candidates outside the local area.

Benefits

Referral bonus up to $4,000/year

Inclusive work environment

Qualifications

• Experience with on-premise Data Warehouse reusable framework design and implementation.
• Good understanding of cloud design considerations for data storage and processing.
• Extensive development experience with technologies including SSIS, SQL Server, REST API, OLAP cubes, BI Analytic tools.

Responsibilities

• Translating business requirements into technical specifications.
• Designing and developing Data Analytics components.
• Designing Data Models based on technical specifications.

Skills

On-premise Data Warehouse reusable framework design

Data modeling

SSIS

Power BI

Data pipeline creation

ETL processes

REST API

Tools

SQL Server

Power BI Desktop

Microsoft Power Platform

Job description

Affinity Burnaby, British Columbia, Canada

Join or sign in to find your next job

Join to apply for the BI Developer role at Affinity

Get AI-powered advice on this job and more exclusive features.

Our client is currently seeking a Business Intelligence Developer for a one-year contract to support the development of an on-premise Data Warehouse using SQL Server Integration Services, SQL Database, and Power BI. This role will collaborate closely with our internal BI Project Team and may be performed in a hybrid (3 days virtual, 2 days in-office) or fully remote capacity for candidates outside the Lower Mainland.

Responsibilities :

The Business Intelligence Developer will work in collaboration with our internal Business Intelligence Project Team and will focus on :

• Translating business requirements into technical specifications
• Designing and developing Data Analytics components (data ingestion, data warehouse, data lake, ODS, pipeline, framework)
• Designing Data Models based on technical specifications
• Exploring in-depth Power BI features for advanced analytics requiring customization like DataFlow & DataMart
• Designing and building End-to-End Data pipelines and ETL packages including :

Staging Areas and Data Warehouse Layouts with SQL Server

• Data pipeline with SSIS
• ETL Processes with SSIS / SSDT
• Dashboards and reports with Power BI Desktop
• Troubleshooting day-to-day data warehouse issues

Requirements :

The position requires the following technical qualifications :

• 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
• Extensive analytic development experience with Power BI and Microsoft Power Platform.
• Advanced Power BI Service configurations such as Power BI DataFlow and DataMart
• Experience in Power BI report development and report automation with data source refresh configurations
• Experience analyzing data source systems to identify transformation needs
• Thorough knowledge of software development methods, practices, and procedures
• Ability to prepare technical design and write technical specifications

Additional Skills :

• Establish and maintain effective working relationships with internal contacts
• Provide advice and assistance on related matters
• Communicate effectively orally and in writing
• Perform duties with minimal supervision, with guidance as needed
• Maintain confidentiality

Affinity Earn :

Know someone suitable for this or other roles? Earn up to $4,000/year for each successful referral through our program. Learn more at https://affinity-group.ca/earn/ or browse jobs & follow us on LinkedIn.

About Affinity :

Affinity Group is a technology and business consulting company committed to creating long-term partnerships. We are an equal opportunity employer that celebrates diversity and fosters an inclusive environment. All employment decisions are based on qualifications, merit, and business need.

For more information, visit www.affinity-group.ca

Job Number : 12411

Seniority level: Mid-Senior level

Employment type: Contract

Job function: Information Technology, IT Services and Consulting

Referrals increase your chances of interviewing at Affinity by 2x

Set job alerts for “Business Intelligence Developer” roles.