How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Senior Data Engineer
Senior Data & AI Solutions Consultant
About Sword
Sword is a leading provider of business technology solutions within the Energy, Public, and Finance Sectors, dedicated to driving transformational change for our clients. We leverage proven technology, specialist teams, and extensive domain expertise to create robust technical foundations across platforms, data, and business applications. Our mission is fuelled by a passion for technology as a means to solve complex business problems and help our clients achieve their objectives.
About the Role
This is a senior, client-facing role with responsibility for shaping, designing, and delivering modern data and AI solutions across a range of client engagements. You will operate across the full solution lifecycle, including discovery, architecture design, hands-on delivery, and ongoing optimisation, leveraging Microsoft Azure, Microsoft Fabric, Power BI, and AI capabilities.
As a trusted consultant and advisor, you will:
- Work closely with business and technical stakeholders to influence data and analytics strategy.
- Help clients realise tangible value from their data investments.
- Contribute to pre-sales activities, including proposals, solution design, and mentoring junior team members.
- Help grow Sword’s data and AI consultancy capability.
Key Responsibilities
- Design and deliver end-to-end data and analytics solutions, primarily using Microsoft Azure, Microsoft Fabric, and Power BI, but not limited to this stack.
- Act as a trusted advisor, translating business requirements into scalable, secure data architectures.
- Lead data engineering and architecture across:
- Data ingestion, storage, transformation, and analytics layers.
- Build and optimise Power BI reports and semantic models for actionable business insights.
- Integrate Azure AI/ML capabilities into solutions, including:
- Predictive analytics
- Large language models (LLMs)
- Automation workflows
- Drive pre-sales and client engagements, including:
- Solution shaping and proposals
- Technical presentations
- Ensure compliance with data governance, security, and regulatory standards.
- Stay ahead of AI innovations and advise clients on adoption and optimisation.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Requirements
Technical Expertise
- Hands-on experience with Microsoft Azure data services:
- Azure Data Factory
- Azure Synapse Analytics
- Azure Data Lake
- Azure SQL / Cosmos DB
- Proven expertise in Microsoft Fabric, including:
- Lakehouse
- Warehousing
- Data Engineering
- Real-Time Analytics
- Advanced Power BI skills, including:
- Semantic modelling (DAX)
- Performance optimisation
- Enterprise-scale deployments
- Strong data architecture background, covering:
- Data modelling
- Integration patterns
- Modern analytics architectures
- Experience building and optimising data pipelines using:
- SQL
- Python
- Spark
- Knowledge of Azure ML, Cognitive Services, or Fabric AI solutions.
- Ability to integrate AI-driven insights (e.g., predictive models, NLP, LLMs) into analytical platforms and reporting solutions.
- Understanding of data governance, security, and compliance (e.g., RBAC, data quality frameworks).
- Familiarity with DevOps and CI/CD practices for data platforms:
- Azure DevOps
- Git-based deployments
- Automated pipelines
Domain & Soft Skills
- Experience in client-facing or consultancy environments, managing engagements across multiple stakeholders.
- Strong understanding of cloud cost management, performance tuning, and scalability.
- Exposure to pre-sales technical activities (e.g., solution design, cost estimations, proof-of-concepts) is desirable.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Benefits
At Sword, our culture is built on caring for our people, investing in development, and fostering inclusive teams. We offer a comprehensive benefits package designed to support both career growth and work-life balance:
- Personalised Career Development:
- Customised growth plans aligned with your goals.
- Access to a wide range of learning opportunities.
- Flexible Working:
- Adaptable work arrangements to support work-life balance where possible.
- Fantastic Benefits Package:
- Generous annual leave allowance
- Enhanced family-friendly policies
- Pension scheme
- Private health insurance
- Well-being and employee assistance schemes
Our Commitment to Diversity & Inclusion
Sword is dedicated to creating a diverse and inclusive workplace where every applicant receives fair and equal consideration. We recognise that talent comes in all forms and celebrate:
- Age
- Disability
- Gender identity
- Marital/civil partnership status
- Pregnancy/maternity status
- Race, colour, nationality, or ethnic origin
- Religion or belief
- Sex
- Sexual orientation
If you don’t meet every listed requirement but believe your skills and experience align with the role, please apply and highlight your transferable abilities
Accessibility Notes
If you need any adjustments to support your application, please contact our Talent Acquisition team when applying. We’re here to make the process workflow for everyone.
(Note: Original punctuation and phrasing preserved where stylistically fitting.)
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills