The Senior Microsoft Data Engineer will design and build business intelligence solutions on Azure, utilizing SQL Server, Data Warehousing, and BI practices to meet client needs.
Codec are recruiting for a Senior Microsoft Data Engineer.
This role will require the candidate to be knowledgeable and experienced on 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.
This is a hybrid role based in Liverpool.
This role will require the candidate to be knowledgeable and experienced on 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.
This is a hybrid role based in Liverpool.
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 his/her 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.
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 with 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.
Skills, Knowledge and Expertise
- 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. - Azure Data Factory
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. - Microsoft SQL Server (Cloud & On‑Premises)
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.
About
Established over 40 years ago, Codec is a multi-award-winning Microsoft Solutions Partner, trusted by public and private sector organisations to deliver impactful digital transformation. With offices in Dublin, Belfast, Cologne, and across Germany, our team of over 300 experts specialises in harnessing the full potential of Microsoft technologies—including Dynamics 365, Power Platform, Azure, and Copilot—to drive innovation, automation, and operational excellence. Codec combines deep industry expertise with a proven track record to help organisations unlock the power of AI and modern cloud solutionsThough originally best known as a hardware reseller, since 2010 Codec has focused on building an outstanding software consulting business with a team of experts implementing enterprise solutions using products from Microsoft and Oracle. Our customer base, revenues and average contract values have grown steadily year on year and we continue to invest in the provision of new product and service offerings.Our team is a careful mix of recent graduates and experienced professionals from a variety of diverse cultural backgrounds. We are a melting pot of seasoned consultants supported by the best talent from the local universities. We have a thriving placement student academy and graduate recruitment programme which grows year on year.This company is an equal opportunities employer
Top Skills
Azure Data Factory
Databricks
Microsoft Sql Server
Power BI
Python
Sql Server Analysis Services
Sql Server Integration Services
Ssas
Ssis
Similar Jobs
Artificial Intelligence • Cloud • Information Technology • Software
As a Senior Data Engineer, you will design, develop, and maintain scalable data pipelines, ensuring data quality and integration to support business requirements.
Top Skills:
Microsoft Azure SynapseMicrosoft FabricPower BIPythonSQL
Artificial Intelligence • Digital Media • Social Media
Manage and grow AI influencer brands by refining identities, optimizing content strategies, and driving performance across social platforms, focusing on audience connection and engagement.
Top Skills:
Ai Content ToolsNotionShort-Form Video Editing Tools
Artificial Intelligence • Fintech • Payments • Business Intelligence • Financial Services • Generative AI
As a Staff Product Designer, you will collaborate with cross-functional teams to define product goals, design user flows, and oversee innovative projects. You will leverage your extensive design experience and leadership skills to shape Airwallex’s products and mentor design teams.
Top Skills:
Interaction DesignProduct DesignUx Design
What you need to know about the Edinburgh Tech Scene
From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.
