About RSM

Consulting brings together multiple teams across Transactions, Risk and 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 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. 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. 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.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.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.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.Ability to meet deadlines and work on multiple projects simultaneously.Create high quality, client facing document outputs.Effective project management skills.Must be a team player, able to work in virtual teams and independently.High proficiency in MS Office including, Excel, PowerPoint, Visio, and SharePoint.Experience of proposal writing and business development.Knowledge of data analysis programming languages e.g. R, Python.Knowledge of Tableau.Diversity and Inclusion at RSMWe 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. 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.