Data Solutions Architect

Jobtailor; Newcastle upon Tyne; On-site; GBP 70,000 - 110,000; Full time

Job summary

Jobtailor is seeking an experienced data and analytics consultant to lead cloud data platform design and delivery for client engagements. You will shape architectures, mentor teams, and drive end-to-end data solutions across strategy, governance, integration, and analytics.

You will collaborate with stakeholders, translate requirements into actionable roadmaps, and contribute to pre-sales while maintaining best practices and high delivery standards.

Qualifications

• Experience designing cloud data platforms in Azure or AWS.
• 5+ years’ experience in data engineering, BI or related roles.
• Extensive ETL and data pipeline design experience, technology agnostic.
• Experience with Fabric, Azure Data Factory, Azure Event Hubs, Azure Data Lake Storage, Azure Function Apps, Azure Synapse Analytics, AWS Glue, AWS S3, AWS Lambda Functions, AWS Redshift, Databricks, Snowflake, Google BigQuery, Alteryx, SSIS or Informatica.
• Strong understanding of data warehouse and data lake principles.
• Data modelling capabilities using Kimball, Inmon or Data Vault.
• Experience with relational database platforms.
• Advanced SQL skills.
• Exposure to Python, R or Spark.
• Awareness of AI and ML methodologies and their application in data solutions.
• Experience with Power BI or Tableau.
• Experience leading or mentoring junior data engineers, BI developers or consultants.
• Experience acting as a technical lead on project delivery using Agile or DevOps.

Responsibilities

• Deliver high-quality consultancy to clients, providing strategic and technical leadership across the full data lifecycle.
• Shape and assure solutions spanning data strategy, governance, operating models, data capabilities, cloud platforms, integration, migration, analytics and AI.
• Collaborate with stakeholders to understand business challenges and develop tailored data solutions.
• Design and oversee the development of technical architectures that align with client objectives.
• Define and uphold standards to ensure secure, scalable, and cost-effective solutions.
• Act as the bridge between client objectives and delivery, translating requirements into roadmaps and designs.
• Lead delivery by organizing project teams, allocating resources, and ensuring outcomes from discovery to production.
• Provide leadership and guidance to project teams through coaching and mentoring.
• Contribute to business growth by supporting pre-sales activities including scoping and estimation.
• Maintain awareness of emerging technologies and apply relevant innovations to solutions.
• Promote delivery excellence by aligning with quality standards and governance.

Skills

Leadership

Collaboration

Mentoring

Communication

Coaching

Tools

Jira

Azure DevOps

Power BI

Tableau

Azure Data Factory

AWS Glue

Databricks

Snowflake

Google BigQuery

Informatica

SSIS

Job description

• Deliver high-quality consultancy to clients, providing strategic and technical leadership across the full data lifecycle to ensure business value is realised


• Shape and assure solutions spanning data strategy, governance, operating models, data capabilities, cloud platforms, integration, migration, analytics and AI


• Collaborate with stakeholders to understand business challenges, identify opportunities and develop and present tailored data solutions


• Design and oversee the development of technical architectures that align with client objectives, industry standards and best practice


• Define and uphold sound principles, frameworks and standards to ensure solutions are secure, scalable, resilient and cost-effective


• Act as the bridge between client objectives and delivery, translating requirements into target architectures, actionable roadmaps and assured solution designs


• Lead delivery by organising project teams, allocating resources, managing progress and ensuring successful outcomes from discovery through to production


• Provide leadership and guidance to project teams, supporting professional development through coaching, mentoring and capability building


• Contribute to business growth by supporting pre-sales activities including scoping and estimation, preparing proposals and presentations and identifying opportunities to extend client engagements


• Maintain awareness of emerging technologies, methodologies and industry best practice, applying relevant innovations to client solutions


• Promote delivery excellence by ensuring solutions align with quality standards, governance requirements and measurable business outcomes

Requirements

• Experience designing cloud data platforms in either Azure or AWS or significant on-premise design experience


• 5+ years’ experience in data engineering, business intelligence or related roles


• Extensive ETL and data pipeline design experience, technology agnostic


• Experience implementing solutions using a range of cloud and data technologies such as Fabric, Azure Data Factory, Azure Event Hubs, Azure Data Lake Storage, Azure Function Apps, Azure Synapse Analytics, AWS Glue, AWS S3, AWS Lambda Functions, AWS Redshift, Databricks, Snowflake, Google BigQuery, Alteryx, SSIS or Informatica, with awareness of equivalent alternatives


• Strong understanding of data warehouse and data lake principles


• Demonstrable data modelling capabilities using Kimball, Inmon or Data Vault methodologies


• Experience working with relational database platforms


• Advanced SQL skills


• Exposure to data engineering coding languages such as Python, R or Spark


• Awareness of AI and ML methodologies and their application in data solutions


• Experience with data visualisation tools such as Power BI or Tableau


• Experience leading or mentoring junior data engineers, BI developers or consultants


• Experience acting as a technical lead on project delivery using Agile or DevOps methodologies including peer reviews and continuous improvement


• Experience using backlog management tools such as Jira or Azure DevOps.

Core Competencies

Demonstrates expertise in designing and implementing cloud data platforms, with a strong focus on data engineering, analytics, and AI methodologies. Proven ability to lead project teams, mentor junior staff, and deliver tailored data solutions that align with client objectives and industry best practices.

Highest-signal resume keywords

• Cloud Data Platform Design


• ETL And Data Pipeline Design


• Advanced SQL Skills


• Data Modelling Using Kimball


• Agile Or DevOps Methodologies

ATS Optimization Keywords

Hard Skills

• Data Engineering


• Business Intelligence


• Data Warehouse Principles


• Data Lake Principles


• Data Visualisation Tools


• Python


• R


• Spark


• SQL


• Data Modelling

Soft Skills

• Leadership


• Collaboration


• Mentoring


• Communication


• Coaching

Industry Keywords

• Data Strategy


• Data Governance


• Cloud Platforms


• Integration


• Migration


• Analytics


• AI


• Technical Architecture


• Delivery Excellence


• Emerging Technologies

Tools & Technologies

• Azure Data Factory


• AWS Glue


• Databricks


• Snowflake


• Power BI


• Tableau


• Jira


• Azure DevOps


• Azure Synapse Analytics


• Informatica