Posted: 5th December 2024
Microsoft Solution Architect
Salary: £75,000-90,000 Location: UK Job Type: Permanent, Full-Time
As a Microsoft Fabric Solution Architect, you will be responsible for designing and developing data warehouse, lake and lakehouse solutions for Amplifi’s clients, using Microsoft Fabric and other Microsoft Technologies. You will work closely with data analysts, data engineers and other stakeholders to ensure that the solutions we design and implement are optimized for performance, scalability, and reliability. You will design and implement solutions appropriate to the needs of the client and in accordance with industry best practice (such as following the ‘medallion’ architecture pattern). Your expertise in data warehousing, data integration and Microsoft Fabric will be crucial in delivering successful data solutions to Amplifi clients. The role is primarily client facing, but with a responsibility to contribute knowledge and experience gained from implementation projects to the Amplifi body of knowledge, in order to build collateral for re-use in future implementations.
At Amplifi we know that our people are our biggest asset, therefore we are committed to hiring individuals who can embrace and embody our relaxed, family feel culture. We are conscious of creating a diverse and inclusive team, and want to hire people into Amplifi who we can empower and progress. We are aware that you may not meet every single requirement on the advert, but we would encourage you to apply or reach out to one of the team as a lot of us did not begin our careers’ at Amplifi as experts.
WHO WE ARE:
Amplifi is the go-to data consultancy for Enterprise organisations that want their success to be driven by data. We empower our customers to innovate, grow and succeed by establishing and delivering strategies across all elements of the data value chain.
From the governance and management of data through to analytics and automation, our integrated approach to modern data ecosystems delivers measurable results through a combination of expert consultancy and best-in-breed technology.
Amplifi Europe has a presence in the UK and Denmark covering UK, Ireland and the breadth of Northern Europe.
THE ROLE:
As a Microsoft Fabric Solution Architect, you will be responsible for designing and developing data warehouse, lake and lakehouse solutions for Amplifi’s clients, using Microsoft Fabric and other Microsoft Technologies. You will work closely with data analysts, data engineers and other stakeholders to ensure that the solutions we design and implement are optimized for performance, scalability, and reliability. You will design and implement solutions appropriate to the needs of the client and in accordance with industry best practice (such as following the ‘medallion’ architecture pattern). Your expertise in data warehousing, data integration and Microsoft Fabric will be crucial in delivering successful data solutions to Amplifi clients.
The role is primarily client facing, but with a responsibility to contribute knowledge and experience gained from implementation projects to the Amplifi body of knowledge, in order to build collateral for re-use in future implementations.
WHAT YOU'LL BE GETTING UP TO:
The responsibilities of the role include:
Design and Development:
- Design and implement robust data warehouse, lake and lakehouse solutions using Microsoft Fabric and related technologies.
- Design Fabric solutions to support the outcomes required by our clients, whilst following industry best practice approaches (such as Data Fabric, Medallion Architecture etc.)
- Design and implement Data Integration solutions including ingestion of data into Fabric, transformation of data in the warehouse/lakehouse and delivery of data to consumers.
- Optimize data models and database schema to improve query performance and data retrieval times.
- Produce designs which help ensure data accuracy, consistency, and integrity across the data warehouse.
- Implement data partitioning, indexing, and other optimization techniques to improve data warehouse performance
Collaboration:
- Work closely with data analysts, data architects, data engineers and client stakeholders to gather requirements and translate them into scalable Microsoft Fabric solutions.
- Collaborate with Amplifi technology experts and client IT teams to ensure seamless deployment processes.
Data Governance:
- In collaboration with Amplifi data governance experts, design and implement measures to support data governance best practices, including data security, privacy, and compliance.
- Develop and deliver documentation related to Data Fabric architecture, processes, and procedures.
Continuous improvement:
- Stay updated with the latest advancements in data platform technologies, particularly Microsoft Fabric, and reflect this in your solution designs.
- Participate in design reviews, collaborating with members of the Amplifi and client teams to ensure robust end to end data ecosystem design.
- Contribute to the Amplifi body of knowledge to benefit future Amplifi projects in the area of Data Warehouse design and implementation. (E.g. best practice, methodologies, lessons learned etc.)
THE ROLE WILL BE A GREAT FIT IF YOU HAVE SOME OF THE FOLLOWING:
- Experience as a Data Platform Architect, with hands-on experience in designing and managing data warehouses, lakes and lakehouses.
- Proven experience with Microsoft Fabric or similar data platforms.
- Microsoft certifications in the field of Data and AI.
Technical Skills:
- Strong proficiency in SQL and database design principles.
- Experience in data modelling, particularly in the context of data warehouse design.
- Knowledge of cloud platforms such as Azure, AWS, or Google Cloud, particularly in relation to data warehousing.
- Data Integration and Engineering experience
- Understanding of data governance, data security, and compliance requirements.
Soft Skills:
- Strong problem-solving skills and the ability to troubleshoot complex issues.
- Excellent communication skills, with the ability to convey technical concepts to non-technical stakeholders.
- Ability to work independently as well as part of a collaborative team.
Preferred Experience:
- Data technologies such as Databricks, Snowflake etc.
- Knowledge of data, analytics and AI tools.
- ETL and Data Integration technologies such as Azure Data Factory, Talend, AbInitio or similar
WHAT WE WILL OFFER YOU:
- 30 days annual leave plus bank holidays
- Private medical cover through Vitality (this includes, free weekly Café Nero drinks, free cinema tickets, free Apple watch, free amazon prime, and many more rewards through Vitality)
- Life cover through Vitality
- No dress code
- Enhanced maternity, paternity and adoption leave
- Company away days
- Work from anywhere allowance
- Choice of Mac or Windows laptop when you start
- Free use of the mindfulness app Headspace for 1 year
For more information about the role or our flexible working policies, message Naomi Cruden (Talent Manager) on LinkedIn.
*Amplifi do not accept CV's from agencies*
