Top Benefits
About the role
Job Description:
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
About Affinity
Welcome to Affinity Group — your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients.
Professional Excellence Across Disciplines:
- Cyber Security Solutions: Protecting your operations with cutting-edge security measures.
- Data Analytics and Business Intelligence: Transforming data into strategic insights.
- Digital Transformation: Pioneering digital innovations to future-proof your business.
- Enterprise Applications: Streamlining business processes through advanced software solutions.
- Project Management: Delivering projects with precision and efficiency.
- Technology Strategy & Architecture: Crafting robust IT frameworks to support scalable growth.
Delivering Tailored Solutions: We provide flexible, bespoke solutions designed to meet the specific demands of your business, driving your success forward with precision and innovation.
Global Reach with Affinity International: Expand your capabilities with our international talent solutions. Discover how we bring global expertise to your local and international projects at affinity-group.ca/international-companies.
Empowering Our Consultants: We are committed to facilitating professional growth and success. Explore a wide array of job opportunities through our referral program, AffinityEARN. Find your next challenge on our jobs page at affinity-group.ca/jobs or LinkedIn.
Ready to Enhance Your Business? Contact us today to discuss how we can support your goals. Email us at Sales@affinity-group.ca for inquiries and solutions tailored to your needs.
Join the innovative and supportive environment at Affinity Group, where we transform challenges into opportunities and individual potential into achievements. Discover more about how we can collaborate on our website below!
Top Benefits
About the role
Job Description:
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
About Affinity
Welcome to Affinity Group — your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients.
Professional Excellence Across Disciplines:
- Cyber Security Solutions: Protecting your operations with cutting-edge security measures.
- Data Analytics and Business Intelligence: Transforming data into strategic insights.
- Digital Transformation: Pioneering digital innovations to future-proof your business.
- Enterprise Applications: Streamlining business processes through advanced software solutions.
- Project Management: Delivering projects with precision and efficiency.
- Technology Strategy & Architecture: Crafting robust IT frameworks to support scalable growth.
Delivering Tailored Solutions: We provide flexible, bespoke solutions designed to meet the specific demands of your business, driving your success forward with precision and innovation.
Global Reach with Affinity International: Expand your capabilities with our international talent solutions. Discover how we bring global expertise to your local and international projects at affinity-group.ca/international-companies.
Empowering Our Consultants: We are committed to facilitating professional growth and success. Explore a wide array of job opportunities through our referral program, AffinityEARN. Find your next challenge on our jobs page at affinity-group.ca/jobs or LinkedIn.
Ready to Enhance Your Business? Contact us today to discuss how we can support your goals. Email us at Sales@affinity-group.ca for inquiries and solutions tailored to your needs.
Join the innovative and supportive environment at Affinity Group, where we transform challenges into opportunities and individual potential into achievements. Discover more about how we can collaborate on our website below!