Contract Description
Power BI Developer
About Schroders
We're a global investment manager. We help institutions, intermediaries and individuals around the world invest money to meet their goals, fulfil their ambitions, and prepare for the future.
We have around 6,000 people on six continents. And we've been around for over 200 years, but keep adapting as society and technology changes. What doesn't change is our commitment to helping our clients, and society, prosper.
The base
We moved into our new HQ in the City of London in 2018. We're close to our clients, in the heart of the UK's financial centre. And we have everything we need to work flexibly.
The team
You will join a high performing reporting team within the Global Finance. We work closely with other areas of the wider finance community including Group Management Reporting (GMR), Financial Planning and Analysis (‘FP&A'), Operational reporting and Wealth reporting teams as we deliver a substantial suite of reporting for some of the most senior members of staff. This role will take the lead on developing the non-financial risk and issues report for the Portfolio Optimisation and Resourcing team.
Who We're Looking For
We're looking for a well-rounded and inquisitive Senior BI Developer to join our Finance Reporting Centre of Excellence. You will work within our established reporting team to support both the delivery of high standard, professional quality reporting to drive business insight and efficiencies; and to support the maintenance and enhancement of our growing catalogue.
Finance has invested heavily in our cutting-edge data and analytics platform to support the business' rapidly evolving demand for insights and analytics, now and in the future, and our reporting team leverages many of these new resources. Our tool of choice is Microsoft Power BI and we also support an Analysis Services reporting mart. We have delivered well received revenue, cost, people and AUM reporting to over 1,500 employees to date. The challenge of delivering new Business and Finance reporting is broad and varied with a wide range of reporting opportunities and a variety of data sources which contribute to our reporting platform.
Reporting to the Delivery Lead, you will work on the development of non-financials pertaining to our Portfolio and Planning app. We envisage this app to be a one stop shop for everything to do with project planning. We have best-practice standards for reporting, reporting architecture, development, testing and deployment. Working to maintain these standards with both research and documentation of processes will be a critical part of your role.
What You'll Do
Our purpose is to provide excellent investment performance to clients through active management. Diversity of thought, facilitated by an inclusive culture, will allow us to make better decisions and better achieve our purpose. This is why inclusion and diversity are a strategic priority for us and why we are an equal opportunities employer. You are welcome here, regardless of your age, disability, gender identity, religious beliefs, sexual orientation, socio-economic background, or any other protected characteristic.
About Schroders
We're a global investment manager. We help institutions, intermediaries and individuals around the world invest money to meet their goals, fulfil their ambitions, and prepare for the future.
We have around 6,000 people on six continents. And we've been around for over 200 years, but keep adapting as society and technology changes. What doesn't change is our commitment to helping our clients, and society, prosper.
The base
We moved into our new HQ in the City of London in 2018. We're close to our clients, in the heart of the UK's financial centre. And we have everything we need to work flexibly.
The team
You will join a high performing reporting team within the Global Finance. We work closely with other areas of the wider finance community including Group Management Reporting (GMR), Financial Planning and Analysis (‘FP&A'), Operational reporting and Wealth reporting teams as we deliver a substantial suite of reporting for some of the most senior members of staff. This role will take the lead on developing the non-financial risk and issues report for the Portfolio Optimisation and Resourcing team.
Who We're Looking For
We're looking for a well-rounded and inquisitive Senior BI Developer to join our Finance Reporting Centre of Excellence. You will work within our established reporting team to support both the delivery of high standard, professional quality reporting to drive business insight and efficiencies; and to support the maintenance and enhancement of our growing catalogue.
Finance has invested heavily in our cutting-edge data and analytics platform to support the business' rapidly evolving demand for insights and analytics, now and in the future, and our reporting team leverages many of these new resources. Our tool of choice is Microsoft Power BI and we also support an Analysis Services reporting mart. We have delivered well received revenue, cost, people and AUM reporting to over 1,500 employees to date. The challenge of delivering new Business and Finance reporting is broad and varied with a wide range of reporting opportunities and a variety of data sources which contribute to our reporting platform.
Reporting to the Delivery Lead, you will work on the development of non-financials pertaining to our Portfolio and Planning app. We envisage this app to be a one stop shop for everything to do with project planning. We have best-practice standards for reporting, reporting architecture, development, testing and deployment. Working to maintain these standards with both research and documentation of processes will be a critical part of your role.
What You'll Do
- Working within the Finance Reporting team develop new reports to meet the ongoing needs of our consumers;
- Enhance the current Power BI data model (which includes Financials) with non-financials metrics;
- These metrics can be sourced from GDW (Group Data Warehouse) or from other manual data sources;
- Contribute to the development of reporting standards and documentation to ensure consistent high quality best practices are met and improved upon;
- Participate in business collaboration groups to advise on development best practice and teach basic report development skills in Schroders;
- Conduct unit testing on new reports and work with the business through UAT;
- Support troubleshooting and error correction of reporting to maintain operational readiness and
- Enhance the existing power BI report catalogue and our data mart to ensure ongoing business changes are reflected in reporting on a timely basis.
- Expert at Power BI including DAX, M and utilising tools such as tabular editor, DAX studio and ALM Toolkit;
- Proficient in writing and understanding SQL;
- Proficient with Power BI Premium, deployment pipelines and dataflows;
- Familiar with using Confluence;
- Excellent Data analysis skills, including the ability to analyse and profile source data to find underlying data/domain relationships and gaps;
- Experience working with Management Information (MI), designing MI and reporting in several organisations;
- Experience of supporting testing, including designing UAT test scripts;
- Excellent verbal and written communication skills;
- Problem solver, comfortable taking the initiative in challenging and ambiguous circumstances;
- Strong strategic thinking and analytical skills, combined with ability to derive and implement required tactical measures;
- Capable of remaining positive when under pressure;
- Friendly, approachable and collaborative team player who enjoys working with people from across the firm and
- Continuous improvement mind-set challenges the status quo and seeks self-improvement.
Our purpose is to provide excellent investment performance to clients through active management. Diversity of thought, facilitated by an inclusive culture, will allow us to make better decisions and better achieve our purpose. This is why inclusion and diversity are a strategic priority for us and why we are an equal opportunities employer. You are welcome here, regardless of your age, disability, gender identity, religious beliefs, sexual orientation, socio-economic background, or any other protected characteristic.
About Contract Spy
Discovering Direct IT Contract Opportunities for Contract Spy members.