BI Developer
- Security, aerospace & defence
Are you ready to take the next step in your career?
Apply for this roleThis vacancy has now expired. Please see similar roles below...
Business Intelligence Developer with proficiency in SSIS, SSRS, Sql Server and PowerBI
What You’ll Do
- Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems
- Analyze reporting service requests and define technical specifications for efficient report solution development
- Work with architect in maintaining reporting standards and protocols
- Identify opportunities for self-service and educate the business on self-service capabilities on BI
- Analyze data and data requirements regarding reporting solutions, ensure data quality and match-back to core systems transaction results
- Maintain documentation of reporting solutions, data mapping, data dictionary, and reporting standards
- Perform quality review of new and existing reporting solutions. Coordinate end user review and acceptance of the developed solutions
- Engage directly with internal clients and business stakeholders to determine KPIs and requirements
- Build an understanding of the business at a level of detail that enables them to identify and address critical issues; use research and business modelling techniques to clearly analyze underlying issues and their impact
- Locate and define new process improvement opportunities
- Where required, develop a business case working with the client to clearly articulate the ROI of the solution and its impact on the related KPI(s)
- Development of Reports, Dashboards and other Data Products
- Development experience in creating ETL using SSIS, Sql Server
- Development, support and maintenance of the business metrics and KPIs via Power BI and SSRS.
- The ability to understand and translate business requirements into technical requirements
- The ability to design quick prototypes or models using Excel or Visualization tools to have a dialog with the client and precisely capture the actual functional requirements
- The ability to work with the team to design and implement the actual reports, dashboards and other data products
- Educate and train end-users so that they can make fullest use of reporting solutions
- Conduct analyses of functional business processes and requirements
- Identify, analyze, and interpret trends or patterns in complex data sets that are in different formats and from various platforms
- Be a champion for clean data and identify opportunities for improving data quality
- Excellent verbal and written communication skills
- Experience in creating ETL using SSIS, Sql Server
- Experience creating dashboards using Power BI, SSRS
- Working knowledge of Microsoft Sql Azure.
- Good understanding of SSAS and other analytical tool development
- Good understanding of Finance data and its reporting need
- Self-starter, and be able to drive conversations across different levels of Client and Stakeholders.
- Bachelor’s degree in Engineering or Technology
- 5+ years of experience creating, designing, analysing and maintaining data warehousing/BI Reporting products
- Expertise in using reporting packages and databases (SQL, etc.), writing queries, ETL development, charting and report writing
- Strong analytical skills with the ability to collect, organize, analyse business requirements
- Advanced Excel skills would be added advantage.
What you will be working on:
- Development of Reports, Dashboards and other Data Products
- Development experience in creating ETL using SSIS, Sql Server
- Development, support and maintenance of the business metrics and KPIs via Power BI and SSRS.
- The ability to understand and translate business requirements into technical requirements
- The ability to design quick prototypes or models using Excel or Visualization tools to have a dialog with the client and precisely capture the actual functional requirements
- The ability to work with the team to design and implement the actual reports, dashboards and other data products
- Educate and train end-users so that they can make fullest use of reporting solutions
- Conduct analyses of functional business processes and requirements
- Identify, analyze, and interpret trends or patterns in complex data sets that are in different formats and from various platforms
- Be a champion for clean data and identify opportunities for improving data quality
- Excellent verbal and written communication skills
- Experience in creating ETL using SSIS, Sql Server
- Experience creating dashboards using Power BI, SSRS
- Working knowledge of Microsoft Sql Azure.
- Good understanding of SSAS and other analytical tool development
- Good understanding of Finance data and its reporting need
- Self-starter, and be able to drive conversations across different levels of Client and Stakeholders.
- Bachelor’s degree in Engineering or Technology
- 5+ years of experience creating, designing, analysing and maintaining data warehousing/BI Reporting products
- Expertise in using reporting packages and databases (SQL, etc.), writing queries, ETL development, charting and report writing
- Strong analytical skills with the ability to collect, organize, analyse business requirements
- Advanced Excel skills would be added advantage.
Are you ready to take the next step in your career?
Apply for this rolePreview
GeneralContent type
BlogsPublish date
05/06/2024
Summary
In today's fast-paced, globalized world, the opportunity for graduates to gain hands-on international experience is invaluable. The Graduate Exchange Program at AtkinsRéalis stands as a testa
Preview
GeneralContent type
BlogsPublish date
05/06/2024
Summary
In today's fast-paced, globalized world, the opportunity for graduates to gain hands-on international experience is invaluable. The Graduate Exchange Program at AtkinsRéalis stands as a testa
Related job roles
Salary
Location
Burnaby
Job Type
Full Time
Career Area
Construction
Category
Permanent
Location
Burnaby
Vancouver
Description
Are you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? Are you seeking to jo
Reference
R-114681
Expiry Date
01/01/0001
Salary
Location
Montréal
Job Type
Full Time
Career Area
Finance
Category
Permanent
Location
Montréal
Description
Conseiller(ère) Principale en fiscalité des expatriésAtkinsRéalis est à la recherche d'un(e) Conseiller(ère) Principale en fiscalité des expatriés pour la région des Amériques avec une expérience en f
Reference
R-112641
Expiry Date
01/01/0001
Salary
Location
Orange
Job Type
Full Time
Career Area
Project controls
Market
Corporate
Category
Permanent
Location
Atlanta
Austin
Houston
Orange
Description
Why join us?It’s an exciting time at AtkinsRéalis! We are rapidly growing in the US. Our company purpose is to build a better world for our planet and its people. We recognize the importance of making
Reference
R-112350
Expiry Date
01/01/0001
Salary
Location
Boucherville
Job Type
Full Time
Career Area
Engineering (Other)
Category
Permanent
Location
Boucherville
Description
Technicien(e) métallurgieInspecteur(e) en soudage qualifié(e) CSA W178.1 de niveau 2 et ONGC Ultrason 2 afin de réaliser en chantier et en atelier des inspections et/ou de la surveillance de travaux d
Reference
R-104826
Expiry Date
01/01/0001
Salary
Location
Calgary
Job Type
Full Time
Career Area
Electrical engineering
Market
Cities & development
Category
Permanent
Location
Calgary
Description
Electrical EngineerAre you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? Ar
Reference
R-098129
Expiry Date
01/01/0001
Salary
Location
Montréal
Job Type
Full Time
Career Area
Structural engineering
Category
Permanent
Location
Montréal
Description
Ingénieure ou ingénieur civil sénior en structureAtkinsRéalis est à la recherche d’une ingénieure ou d’un ingénieur civil senior en structure pour rejoindre une équipe dédiée aux études visant princip
Reference
R-114678
Expiry Date
01/01/0001
Salary
Location
Mississauga
Job Type
Full Time
Career Area
Engineering (Other)
Market
Nuclear
Category
Fixed Term Contract
Location
Mississauga
Description
Samrt Plant Support SpecialistAtkinsRéalis is one of Canada's largest private sector nuclear engineering groups. We have been providing a wide range of services to the nuclear industry in Canada and a
Reference
R-109589
Expiry Date
01/01/0001
Salary
Location
Jonquière
Job Type
Full Time
Career Area
Engineering (Other)
Market
Environment & geoscience
Category
Permanent
Location
Jonquière
Description
Pourquoi rejoindre notre équipe ?Vous avez acquis ce qu’il faut en tant que professionnel en ingénierie des matériaux, en plus de posséder d’excellentes capacités en gestion de projets? Vous êtes prêt
Reference
R-089775
Expiry Date
01/01/0001
Salary
Location
Kincardine
Job Type
Full Time
Career Area
Union
Category
Fixed Term Contract
Location
Kincardine
Mississauga
Description
Document Control CoordinatorAtkinsRéalis is one of Canada's largest private sector nuclear engineering groups. We have been providing a wide range of services to the nuclear industry in Canada and aro
Reference
R-114540
Expiry Date
01/01/0001
Salary
Location
Vancouver
Job Type
Full Time
Career Area
Business support
Category
Permanent
Location
Vancouver
Description
Come join us in reshaping the future with AtkinsRéalis. AtkinsRéalis is dedicated in engineering a better future for our planet and its people.This role will be based in Vancouver, BC.Your role within
Reference
R-114445
Expiry Date
01/01/0001
AtkinsRéalis
Talent community
Would you like to know more? Not ready to apply? Join our talent community to stay connected and engaged with us at AtkinsRéalis.
Find out more