Data EngineerWe are searching for an experienced Data Engineer
About RSM
Consulting brings togethermultiple teams across Transactions, Risk & Consulting, ABA, and Outsourcingto provide client-centric solutions for RSM’s current and future clients withinthe middle market. Our Consulting teamhas a major role to play in driving forward the growth of the firm with over1,700 people delivering almost £200m revenue.
At the heart of Consultingare the six solutions we offer our clients: business transformation, dealservices, finance function support, risk and governance, forensic andinvestigation services, and restructuring. Our solutions create an enhancedtailored approach to support our clients in achieving their strategic goals andempower our people to make an impact and develop their own unique career path.
About the team and yourrole
Our Digital and DataAdvisory practice, as part of our broader Business Transformation clientoffering, consists of three teams:
1. Digital Finance team working with clients to understand how their finance functions work, assisting them to articulate what ‘good’ looks like for them and how they can get there. We work with our clients to ensure they have a Finance function that reflects and supports their vision. We believe in designing a Finance function in which people are key, and technology is the enabler.
2. Digital Transformation team supporting clients throughout their digital transformation journey from defining a digital strategy and roadmap, creating a business case, selecting the right software, documenting user stories, to managing and assuring projects.
3. Data analytics and insights team working with clients to help them understand their level of data analytics maturity and to develop a data analytics strategy that will guide them in achieving their desired level of maturity. We work with clients to identify KPIs and metrics they can use to track progress against their strategic objectives and to assess the quality of their data needed for those KPIs and metrics. We support clients with full life cycle data warehouse and business intelligence/analytics implementations including data warehouse design and build, development of data pipelines, data models and visualisations.
We are looking for anexperienced Data Engineer with multiple years’ experience to join our Digitaland Data Advisory team.
As part of the Digital andData Advisory team you will be working closely with clients, and it istherefore critical that you can establish trust and credibility quickly tobuild effective relationships. It goes without saying that you are a teamplayer, have a ‘can do’ attitude and understand that the best solutions comefrom collaboration and exchange of ideas. We are also looking for thefollowing:
4. You will have a strong background in data integration design and development, data modelling, and business and data analysis.
5. You will be a problem solver, creative thinker, and self-starter, who is organised, proactive and inquisitive.
6. Ideally you will already have been involved in Transformation projects and can demonstrate the value delivered to organisations with which you’ve worked.
7. You should be comfortable in juggling multiple deadlines.
8. You will contribute to client proposals and presentations and our clients will see you as a trusted advisor to work closely with them in identifying, analysing, and solving their business challenges.
In exchange, we offerexciting client opportunities, rapid career development, and promotionopportunities for those with the drive and the commitment to succeed in adynamic environment, whilst delivering exceptional service to clients andbecoming part of a high performing team.
Requirements
Essential
9. Strong academic record: preferably with a relevant or business-focused degree (such as data analytics, computer science, or information systems).
10. Extensive work experience, ideally within a professional services environment.
11. Experience in the architecture, design, and development of data integration routines to integrate data from disparate source systems into an integrated business intelligence environment including defining source-to-target mappings, business rules and other required data transformations.
12. Experience in optimisation of data integration processing and database design.
13. Experience in automating data integration routines.
14. Experience in defining and managing ETL metadata repositories.
15. Strong focus and ability to design and develop dimensional data models across multiple subject areas.
16. Expertise in database design and development in Azure SQL Server, Azure Data Warehouse, MS SQL Server and be proficient in creating highly flexible database architecture.
Core
17. Ability to conduct detailed data analysis in support of data related projects.
18. Experience with Power BI for data modelling and creating visualisations.
19. Able to interact effectively with internal and external resources, at all organisational levels.
20. Ability to meet deadlines and work on multiple projects simultaneously.
21. Good communication and presentation skills, with the ability to explain complex ideas to non-technical stakeholders.
22. Create high quality, client facing document outputs.
23. Enthusiastic and positive demeanour.
24. Must be a team player, able to work in virtual teams and independently.
25. Proactive, organised, and self-motivated.
26. Excellent spoken and written communication, including the ability to present complex ideas clearly and concisely.
27. High proficiency in MS Office including, Excel, PowerPoint, Visio, and SharePoint.
28. Demonstrate and operate in line with RSM’s core values of excellence, teamwork, integrity, respect, and stewardship.
Desirable
29. Knowledge of Alteryx.
30. Experience of using Python, Spark, R to solve business problems and answer complex queries.
31. Experience in formal data quality assessments.
32. Experience in defining and managing master data.
33. Experience in defining and managing business metadata.
34. DevOps and CICD.
Experienced hirePermanentLONDONTechnology & Digital Advisory