Cognos BI Developer

Category: Project Management
City: Edinburgh, , United Kingdom
Position ID: J0419-0501
Employment Type: Full Time

Position Description

Be part of something exciting. Do you want to take control of your future? Do you want to take your career to the next level as part of one of the big five IT and business process firms in the world and get a direct stake in its success?

Your future duties and responsibilities

Design and build Data Warehouse and associated ETL processes
Develop front-end reporting
Develop accurate, reliable and performant business intelligence solutions to support the business’ reporting and analysis needs.
Work closely with Business end client to provide guidance and expertise on Business Intelligence
Provide support and assistance where appropriate to ensure that data warehouse / data marts are tuned for optimal performance, scheduled tasks are executed correctly and that data integrity is maintained.

Required qualifications to be successful in this role

You must have commercial experience of designing, implementing and maintaining architecture data warehouses. Advanced knowledge of SQL and relational databases in an ETL context is essential, ideally covering multiple products e.g. MySQL, PostgreSQL, SQL Server and Oracle.

• Experience in Cognos, SQL IS, SQL, Data Warehouses, Databases
• Industrial experience of one of the database procedural languages
• Understand relational modelling techniques
• Experienced in use of different database object types, including tables, indexes, views, materialised views etc.
• Appreciate performance concepts (e.g. indexing, partitioning)
• ETL Build and Modify Experience
• Data Warehouse Build and Modify Experience
• Report / Dashboard Build Experience

What you can expect from us

Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at

No unsolicited agency referrals please.

CGI is an equal opportunity employer.