Senior Data Architect, Snowflake, Databricks

8 West Consulting

. Advise business and technology leaders through discovery workshops, priority clarification and architectural option analysis .

Posted 11/11/2026full-timeRemote • IrelandSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Expertise in designing and implementing enterprise data architectures, including data migration and integration strategies using Snowflake and Databricks. Proven ability to lead data initiatives, manage stakeholder expectations, and ensure data quality and governance.

Highest-signal resume keywords

Snowflake Platform ArchitectureDatabricks Lakehouse ArchitectureETL/ELT Data MigrationSQL ExpertiseData Governance and Quality

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data MigrationData IntegrationSQLData ModellingETLELTPipeline OrchestrationChange Data CaptureQuery TuningData Quality

Soft Skills

Clear CommunicationWorkshop FacilitationStakeholder ManagementMentoringConstructive Challenge

Tools & Technologies

SnowflakeDatabricksPower BITableauPythonDbtAirflowAWSMicrosoft AzureGoogle Cloud

Certifications & Qualifications

SnowProDatabricks CertificationAWS CertificationAzure Certification

Industry Keywords

Enterprise Data ArchitectureData WarehousingData LakehouseData SharingData GovernanceData LineageProduction TransitionData Quality ControlsSensitive Data ManagementMarketplace Data Offerings

Tech Stack

Tools & technologies

AirflowAWSAzureCloudETLOraclePostgresPySparkPythonSnowflakeSparkSQLTableauUnity

About the role

Key responsibilities & impact

Advise business and technology leaders through discovery workshops, priority clarification and architectural option analysis
Shape enterprise data architectures by assessing legacy estates and designing warehouse or lakehouse platforms, integration patterns, migration stages and target operating arrangements
Lead data migration and integration, including ETL/ELT, batch and incremental ingestion, change data capture, orchestration, reconciliation, testing and production cutover
Review and troubleshoot SQL, pipelines, data models and integrations, addressing reliability, performance and cost
Design data layers using data modelling and medallion Bronze/Silver/Gold patterns, with data quality, lineage, security and lifecycle controls
Design governed data sharing between organisations and assess private exchange, Marketplace and commercially viable data offerings
Own roadmaps, dependencies, architecture decisions and stakeholder updates while documenting risks and trade-offs
Transfer knowledge, mentor delivery teams and identify further consulting opportunities in platform engineering, governance, analytics and AI
Deliver architecture decisions, migration roadmaps, reliable production data platforms, governed pipelines, data models and sharing solutions for clients

Requirements

What you’ll need

Significant hands-on experience designing, implementing or migrating production enterprise workloads on at least one of Snowflake or Databricks
Snowflake expertise in platform architecture, data loading and ELT, warehouse performance and cost, security, and capabilities such as Snowpipe, Streams, Tasks, Dynamic Tables, secure sharing or Marketplace listings
Databricks expertise in lakehouse architecture, Delta Lake, Spark/PySpark or Databricks SQL, Unity Catalog, and ingestion/orchestration capabilities such as Lakeflow, Auto Loader, Delta Sharing or Marketplace
Proven enterprise data migration and engineering experience across complex sources, source-to-target mapping, ETL/ELT, pipeline orchestration, data quality, reconciliation and controlled production transition
Strong SQL expertise across relational platforms such as SQL Server, Oracle or PostgreSQL
Experience with dimensional and layered/medallion data models, query tuning and transformation logic
Practical understanding of access control, lineage, auditability, sensitive data, governed sharing and reusable data products
Ability to lead workshops, challenge assumptions constructively and present technical strategy and delivery recommendations to business executives and engineering leaders
Demonstrable experience leading significant data initiatives through discovery, architecture, planning and implementation, managing dependencies, milestones and stakeholder expectations
Experience across both Snowflake and Databricks would be an advantage
AWS, Microsoft Azure or Google Cloud migration experience would be advantageous
Relevant cloud certifications would be advantageous
Experience with Power BI, Tableau, Python, dbt, Airflow or equivalent orchestration tools would be advantageous
Relevant SnowPro, Databricks, AWS, Azure or other cloud/data credentials would be advantageous
Structured, credible and pragmatic consulting approach
Clear communication with senior stakeholders and engineering teams
English communication ability is assessed in the application questions

Benefits

Comp & perks

Long-term role across multiple client engagements
Opportunities for professional development through knowledge transfer and mentoring
Exposure to Snowflake and Databricks consulting engagements
Opportunities to work across insurance, healthcare and retail sectors
Opportunities to work on analytics, AI and data products