Our Group Information Services (Group IS) business is made up of digital, user service, technology and project management experts, working across multiple regions. Our teams are supporting close to 20000 people across the Atkins group including those based in offices and working on remote sites with our clients where we partner the business on some of the worlds iconic design and build and infrastructure projects.
Group IS has developed an operating model to evolve the way IT services are provided to the company, moving from a ‘Business as Usual’ focus to an organisation driven by a joint technology roadmap with the business and enabling business value. Here, the key focus areas include: getting the basics right, being a true partner to the business, information assurance & security, career management for our staff, and supporting the organization on its digital journey.
Our user services teams are committed to delivering a 24/7, 365 days a year service ensuring we keep our people and projects delivering for clients. This includes service desk, hardware and software asset management and software packaging teams providing the latest technology solutions available to future proof the organisation’s technical ability.
Our technology delivery teams setup and run the IT infrastructure backbone of the organization including network, firewall, storage and unified communications. They enable the global nature of our business, providing seamless connectivity, communication and collaboration capabilities to our employees. This means we can all work collaboratively from anywhere in the world and on any device, using Office 365 and Skype for Business, improving the pace and quality of delivery for our partners and clients
Our applications delivery teams help build, implement, support and sustain the various corporate systems used by the company’s functions and also the numerous digital offerings aimed at improving the efficiency of our internal teams and the value proposition to our clients. Here, we have teams dedicated to innovating, researching and experimenting with new leading-edge technology and exploring emerging digital solutions using a combination of Full Stack development, Data Analytics, Digital Engineering, Intelligent Mobility and Digital Asset Management.
Our focus on delivering a range of IT services and digital solutions means at all times the needs of our clients are at the forefront of delivery, ensuring business change is managed in an effective way. We pride ourselves on being agile, quick to respond, and are able to deliver IT solutions within a short period of time, allowing for rapid project mobilisation for our business.
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.
