BI Developer

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 the Data Analytics (Data ingestion, data warehouse, data lake ODS, pipeline,
• error handling, Azure cloud data gateway, MS Fabric, Power BI security, Power BI workspace) reusable
• framework
• Designing Data Models based on technical specifications
• Exploring in-depth PowerBI features for advanced analytics which require more customization like
• DataFlow & DataMart
• Designing and building End to End Data pipeline and ETL packages including:
  • Staging Areas and Date Warehouse Layouts with SQL Server
  • Data pipeline with SSIS
  • ETL Processes with SSIS / SSDT
  • Error Handling
  • Dashboards and reports with PowerBI Desktop
  • Troubleshoot 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 PowerBI and preferably Microsoft Power Platform.
• 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
• Thorough knowledge of software development methods, practices and procedures
• Ability to prepare technical design and write technical specifications
  
  

In addition, this position requires the ability to:

• 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 opportunity 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: 12411