At a Glance
- Tasks: Join our team as a Senior Data Architect, driving data solutions for clients.
- Company: RSM is a leading consulting firm focused on middle market solutions.
- Benefits: Enjoy flexible working, rapid career growth, and exciting client opportunities.
- Why this job: Make an impact in a collaborative environment while developing your unique career path.
- Qualifications: Strong academic background in business or data-related fields; extensive professional experience required.
- Other info: We value diversity and inclusion, fostering a culture where everyone can thrive.
The predicted salary is between 54000 - 84000 £ per year.
About RSM
Consulting brings together multiple teams across Transactions, Risk & Consulting, ABA, and Outsourcing to provide client-centric solutions for RSM's current and future clients within the middle market. Our Consulting team has a major role to play in driving forward the growth of the firm with over 1,700 people delivering almost £200m revenue.
At the heart of Consulting are the six solutions we offer our clients: business transformation, deal services, finance function support, risk and governance, forensic and investigation services, and restructuring. Our solutions create an enhanced tailored approach to support our clients in achieving their strategic goals and empower our people to make an impact and develop their own unique career path.
About the team and your role
Our Digital and Data Advisory practice, as part of our broader Business Transformation client offering, consists of three teams:
- 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.
- 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.
- 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 an experienced Senior Data Architect with a strong and successful background, to join our Digital and Data Advisory team.
As part of the Digital and Data Advisory team you will be working closely with clients, and it is therefore critical that you can establish trust and credibility quickly to build effective relationships. It goes without saying that you are a team player, have a 'can do' attitude and understand that the best solutions come from collaboration and exchange of ideas. We are also looking for the following:
- You will be a problem solver, creative thinker, and self-starter, who is organised, proactive and inquisitive.
- Ideally you will already have been involved in Transformation projects and can demonstrate the value delivered to organisations with which you've worked.
- You should be comfortable in managing a team and juggling multiple deadlines.
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 offer exciting client opportunities, rapid career development, and promotion opportunities for those with the drive and the commitment to succeed in a dynamic environment, whilst delivering exceptional service to clients and becoming part of a high performing team.
Essential
- Strong academic record: preferably with a relevant or business-focused degree (such as business, data analytics, computer science, or information systems).
- Strong extensive work experience, ideally within a professional services environment.
- A deep understanding of data warehousing, ETL processes and data modelling.
- 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.
- Proven track record of executing full life cycle data warehouse and business intelligence/analytics implementations.
- Proficient in Microsoft SQL Server Database Engine (database administration/maintenance), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS), Azure Data Resources, Azure Data Factory, Azure Data Lake, Azure Data Bricks and Azure Analysis Services.
- Able to support clients and prospects in their evaluation of Business Intelligence solutions providing information and demonstrations to help them assess fit for their business.
Core
- Strong focus and ability to manage and construct Dimensional Data Warehouses.
- Proficiency in creating data models and schemas.
- Experience with Power BI for data modelling and creating visualisations.
- Able to scope the implementation services required to help clients achieve their objectives.
- Able to interact effectively with internal and external resources, at all organisational levels.
- Ability to meet deadlines and work on multiple projects simultaneously.
- Good communication and presentation skills, with the ability to explain complex ideas to non-technical stakeholders.
- Demonstrate the ability to understand and assess client requirements/issues, consider and analyse the impact and propose solutions to address these.
- Create high quality, client facing document outputs.
- Strong client relationship management skills.
- Effective project management skills.
- Enthusiastic and positive demeanour.
- Must be a team player, able to work in virtual teams and independently.
- Proactive, organised, and self-motivated.
- Excellent spoken and written communication, including the ability to present complex ideas clearly and concisely.
- High proficiency in MS Office including, Excel, PowerPoint, Visio, and SharePoint.
- Demonstrate and operate in line with RSM's core values of excellence, teamwork, integrity, respect, and stewardship.
Desirable
- Experience of working with (or knowledge of or interest in) technology solutions.
- Experience of proposal writing and business development.
- Knowledge of Alteryx.
- Knowledge of data analysis programming languages e.g. R, Python.
- Knowledge of Tableau.
- Knowledge of QlikView / Qlik Sense.
Diversity and Inclusion at RSM
At RSM, we want to create a strong sense of belonging so that people of all identities, backgrounds, and cultures feel they can bring their true self to work. Our clients come from all walks of life. We aim to achieve that same diversity of background, experience and perspective in our own teams, so that we can genuinely understand our client's needs. Diverse teams bring a broader range of ideas and insights to work. That's why we're working together to ensure our firm's principles and processes support a firm culture that embraces difference and strengthens inclusion.
At RSM we work hard to create an environment where our people can make a difference – to themselves, their career, their teams, and to the success of our firm and clients. We support all our people to work flexibly, to manage their family and other responsibilities alongside their work commitments; we believe this is key to achieving an inspiring and fulfilling working environment.
#J-18808-Ljbffr
Data Architect (London) employer: RSMUK
Contact Detail:
RSMUK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect (London)
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as Azure SQL Server and Power BI. Being able to discuss your hands-on experience with these tools during interviews will demonstrate your suitability for the role.
✨Tip Number 2
Network with current or former employees of RSM Consulting on platforms like LinkedIn. Engaging with them can provide insights into the company culture and expectations, which can be invaluable during your interview.
✨Tip Number 3
Prepare to showcase your problem-solving skills by thinking of specific examples from your past work where you successfully tackled complex data challenges. This will help you illustrate your value as a trusted advisor to clients.
✨Tip Number 4
Stay updated on the latest trends in data architecture and analytics. Being knowledgeable about industry advancements will not only impress your interviewers but also show your commitment to continuous learning and improvement.
We think you need these skills to ace Data Architect (London)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the Data Architect role. Focus on your expertise in data warehousing, ETL processes, and database design, particularly in Azure SQL Server and related technologies.
Craft a Compelling Cover Letter: Write a cover letter that showcases your problem-solving abilities and creativity. Mention specific transformation projects you've been involved in and how they delivered value to previous organisations. This will demonstrate your capability as a trusted advisor.
Highlight Communication Skills: Since the role requires effective communication with clients and stakeholders, emphasise your ability to explain complex ideas clearly. Provide examples of how you've successfully communicated technical concepts to non-technical audiences.
Showcase Project Management Experience: Detail your project management skills and experiences, especially in managing multiple deadlines and teams. Highlight any relevant tools or methodologies you’ve used to ensure successful project delivery.
How to prepare for a job interview at RSMUK
✨Showcase Your Technical Expertise
As a Data Architect, it's crucial to demonstrate your deep understanding of data warehousing, ETL processes, and database design. Be prepared to discuss specific projects where you've successfully implemented these skills, particularly in Azure SQL Server and related technologies.
✨Emphasise Problem-Solving Skills
Highlight your ability to analyse complex business challenges and propose effective solutions. Use examples from your past experiences to illustrate how you've tackled problems creatively and collaboratively, showcasing your role as a trusted advisor.
✨Demonstrate Communication Skills
Since you'll be interacting with clients and non-technical stakeholders, practice explaining complex concepts in simple terms. Prepare to discuss how you've effectively communicated technical information in previous roles, ensuring clarity and understanding.
✨Prepare for Team Dynamics
RSM values teamwork and collaboration, so be ready to discuss your experience working in teams. Share examples of how you've contributed to team success, managed multiple deadlines, and supported colleagues in achieving shared goals.