> Markdown version of [/jobs/ext/3903755-lead-analyst-bi-dw-etl-reporting-developer](https://www.wearedevelopers.com/jobs/ext/3903755-lead-analyst-bi-dw-etl-reporting-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Analyst - BI/DW - ETL & Reporting Developer - **Company:** CGI Group Inc. - **Location:** United Kingdom - **Experience:** Expert - **Salary:** £47,397 - **Contract:** Permanent contract - **Skills:** Query Performance, Java (Programming Language), .NET Framework, Agile Methodology, Unit Testing, Microsoft Azure, Big Data, Computer Programming, Data Architecture, Data Integration, Extract Transform Load (ETL), Data Structures, Data Warehousing, Database Schema, NoSQL, Pentaho Data Integration, Performance Tuning, Systems Development Life Cycle, Power BI, Standard Sql, SQL Databases, SQL Server Integration Services, Talend, Strategies of Testing, Freeform SQL, Load Balancing, Data Storage Technologies, Snowflake, Sap Business Objects, Integration Tests, Debezium, Information Technology, Qlikview, Oracle Golden Gate, Database Replication, Tools for Reporting, Data Pipelines - **Published:** October 24, 2026 - **Apply:** https://www.adzuna.co.uk/jobs/details/5210480123 ## About the Role Qualification: Bachelor's degree in Computer Science or related field or higher with minimum 5 years of relevant experience. As a Lead ETL Developer you are in charge of designing and creating the data warehouses and all related functions, such as extraction, transformation and loading of data into the warehouse. * Improve - Work with the team to pragmatically and continually reduce the gap between getting things done fast and getting things done right * Ability to pick up new data tools and concepts quickly. * Passionate about complex data structures and problem solving. * High attention to detail. * Plans and manages team resources through scheduling and load balancing to achieve team objective, SLAs * Work collaboratively with Business Analyst to identify and gather detailed business requirements * Communicates to all team members any new requirements, changes, updates on all support related information company information * Experience in working in an Agile environment * Organizational skills: time management and planning * SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure * Knowledge of data modeling principles and experience with dimension data modelling. * Knowledge of at least one ETL tool (Pentaho, Talend, SSIS etc.) * Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies (Snowflake preferable). * Knowledge of any Data replication tool like Qlik replicate, Oracle Golden Gate, Debezium is good to have. * Good understanding of programming knowledge like Java/.Net is a bonus. * Knowledge of Microsoft Azure & Microsoft Power BI would be an advantage * Should be able to work independently, Ability to pick up new reporting tools and concepts quickly. * Requires strong analytical, conceptual and problem-solving abilities * Experience in working in an Agile environment. * Experience with dimension data modelling. * Ability to manage multiple priorities, and assess and adjust quickly to changing priorities * Requires leadership qualities to mentor junior members of the team. * Proficiency with any BI Tool like SAP BusinessObjects, MS Power BI etc. * SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure * Performance tuning experience related to reporting queries required. * Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures * Programming / scripting experience and knowledge of software development life cycle is preferred. * Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities * Gather requirements and business process knowledge in order to transform the data in a way that's geared towards the needs of end users * Maintain and improve already existing processes. * Ensure that the data architecture is scalable and maintainable * Work with the business in designing and delivering correct, high quality data * Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions * Prepare documentation for further reference Required qualifications to be successful in this role: * 8-10 years of experience in creating Semantic Models & ETL processes. * Hands on experience in Writing Complex SQL Queries * Creating reports using Power BI * Team player * Good time-management skills * Great interpersonal and communication skills Required Qualifications To Be Successful In This Role Must-to have Skills- * BI Tool like SAP BusinessObjects, MS Power BI, Pentaho reporting etc. * SQL * ETL tool (Pentaho, Talend, SSIS etc.) * Big Data technologies (Snowflake preferable) * Preferably - Microsoft Azure & Microsoft Power BI ## Description * Creation of the Semantic Layer (Cubes) based on the data warehouse design and business requirements. * Creation of all reporting elements such as filters, hierarchies, custom groups as required by the reports and analytics. * Adopt best practices in completion of the assigned tasks ensuring efficiency and accuracy of the desired results. * Perform required unit testing and validation of all Reporting objects. * Perform in-depth data and functionality validation. * Prepare required testing scripts and validation routines as per the testing strategy. * Conduct Integration testing on respective work stream modules and document test results effectively. * Work with QA associates to resolve defects