At a Glance
- Tasks: Design and build innovative data solutions using Microsoft technologies for diverse clients.
- Company: Join a forward-thinking tech company in Liverpool with a hybrid work culture.
- Benefits: Enjoy a stable environment, structured career growth, and the latest tech training.
- Why this job: Make a real impact in Business Intelligence and Data Warehousing while advancing your career.
- Qualifications: Experience in Data Warehouse Design, SQL Server, and strong analytical skills required.
- Other info: Collaborative team atmosphere with opportunities to travel and engage with clients.
The predicted salary is between 36000 - 60000 £ per year.
Codec are recruiting for a Senior Microsoft Data Consultant. This role will require the candidate to be knowledgeable and experienced in Business Intelligence and Data Warehouse. This is a great opportunity for a senior Consultant to grow and develop their career in BI and Data Warehousing, in Liverpool on a hybrid basis. This truly unique opportunity requires a career-oriented individual able to join our Azure, Data & AI Practice and commitment to deliver on time with high quality is a must. In return, the candidate will be provided with a stable work environment, a true team environment, a structured career path, growth and satisfaction that comes from keeping skills up-to-date by working with the latest technologies.
The Senior MS Data Consultant must have experience in one of the following areas: Data Warehouse Design, Modelling, Data Integration, Data Analysis, Reporting and prove consistent business knowledge. You will be responsible for the overall design and build of business intelligence solutions for a set of clients, delivered on Azure, Microsoft SQL Server and Business Intelligence platforms. You will work as a team member along with business analysts, project managers, developers, technical architects and testers to deliver the complete solution to the customer. The role requires a willingness to travel to customer sites when necessary.
Key Responsibilities:- Provide top-quality solution design and execution
- Provide support in defining the scope and sizing of work
- Align the data solutions with their clients' initiatives as requested
- Engage with clients to understand strategic requirements
- Responsible for translating business requirements into technology solutions
- Work with domain experts to put together a delivery plan and stay on track
- Utilize Cloud and On-Premise technologies to design, develop, and evolve scalable and fault-tolerant distributed components
- Organize all meetings with customers and ensure prompt resolution of gaps and roadblocks
- Stay current on latest technology to ensure maximum ROI for clients
- Responsible for the design and execution of abstractions and integration patterns (APIs) to solve complex distributed computing problems.
- SQL Server Analysis Services (SSAS): Strong experience designing, developing, and maintaining Analysis Services data cubes and Tabular Models, including data modelling, measures (DAX), performance tuning, and optimisation for enterprise-scale reporting and analytics.
- SQL Server Integration Services (SSIS): Proven experience building and supporting SSIS packages for ETL processes, including data extraction, transformation, validation, error handling, and scheduling across complex data environments.
- Hands-on experience designing and managing Azure Data Factory data pipelines and data flows, integrating data from multiple sources, automating ingestion processes, and supporting scalable cloud-based data solutions.
- Databricks (Nice to Have): Exposure to or experience with Azure Databricks for large-scale data processing, transformation, and analytics. Experience working with Spark-based data engineering workloads is an advantage.
- Power BI: Strong experience with Power BI for semantic modelling, dataset design, performance optimisation, and collaboration with stakeholders to deliver reliable, business-ready analytics solutions.
- Python (Nice to Have): Working knowledge of Python for data manipulation, automation, or integration tasks within data engineering or analytics workflows is beneficial.
- Extensive experience with Microsoft SQL Server across both cloud and on-premises environments, including schema design, query optimisation, performance tuning, and data reliability at scale.
Senior Microsoft Data Engineer in Liverpool employer: Codec
Contact Detail:
Codec Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Microsoft Data Engineer in Liverpool
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage with professionals on LinkedIn. We all know that sometimes it’s not just what you know, but who you know that can help you land that Senior Microsoft Data Engineer role.
✨Tip Number 2
Prepare for those interviews by brushing up on your technical skills and understanding the latest trends in BI and Data Warehousing. We recommend doing mock interviews with friends or using online platforms to get comfortable with the questions you might face.
✨Tip Number 3
Showcase your projects! Whether it’s through a portfolio or GitHub, let your work speak for itself. We want to see how you’ve tackled data challenges and implemented solutions, especially with Azure and SQL Server.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Senior Microsoft Data Engineer in Liverpool
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior Microsoft Data Engineer role. Highlight your experience with SQL Server, Azure, and any relevant BI projects. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how your background makes you a perfect fit for our team. Keep it engaging and personal – we love to see your personality!
Showcase Your Projects: If you've worked on any cool data projects, make sure to mention them! Whether it's a data warehouse design or a Power BI dashboard, we want to know what you've done and how it relates to the role. Real-world examples can really make your application stand out.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you'll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Codec
✨Know Your Tech Inside Out
Make sure you’re well-versed in SQL Server Analysis Services, Integration Services, and Azure Data Factory. Brush up on your DAX skills and be ready to discuss how you've optimised data cubes or built ETL processes in past roles.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data challenges. Think about specific projects where you designed scalable solutions or resolved integration issues. This will demonstrate your ability to translate business requirements into effective technology solutions.
✨Engage with the Interviewers
Don’t just answer questions; engage in a conversation. Ask insightful questions about their current projects or challenges they face in BI and Data Warehousing. This shows your genuine interest and helps you assess if the company is the right fit for you.
✨Stay Current with Trends
Familiarise yourself with the latest trends in data engineering and analytics, especially around Azure and Databricks. Mention any recent technologies or methodologies you’ve explored, as this reflects your commitment to continuous learning and staying ahead in the field.