Solution Architect Data Modernization

Overview

Remote
Up to $160,000
Full Time

Skills

Solution Architect
Data Modernization
adf
data modeling
API
AIRFLOW
CLOUD
SECURITY

Job Details

Job Title: Solution Architect Data Modernization

We are seeking an experienced and forward-thinking Solution Architect Data Modernization to lead the technical design and execution of next-generation data platform initiatives. This role will architect and enable scalable, cloud-native data solutions, with a strong focus on modernizing data pipelines, democratizing data access via Snowflake and Data Compass, and driving end-to-end system integration for enterprise analytics and customer-facing products.

The ideal candidate is a hands-on architect with deep technical expertise across data engineering, cloud platforms, and solution design who can guide multi-disciplinary teams toward a unified modernization vision.

Key Responsibilities:

Architectural Leadership

  • Define end-to-end architecture for modern cloud-based data platforms, with a focus on Snowflake, Azure Data Factory (ADF), and Data Compass integration.
  • Translate business requirements into modular, scalable, and secure data solutions.
  • Establish reference architectures, patterns, and best practices for data ingestion, enrichment, storage, and consumption.

Data Platform Modernization

  • Lead migration efforts from legacy ETL frameworks to modernized, automated, and metadata-driven pipelines.
  • Architect normalized, governed data models supporting analytical workloads, machine learning, and operational reporting.
  • Drive modernization of Azure Data Factory to maximize performance, maintainability, and cost-efficiency.

Data Enablement & Access

  • Architect APIs, services, and interfaces to enable self-service data access for internal and external consumers.
  • Design solutions that simplify data discoverability, search, and lineage leveraging Data Compass, Alation, or similar tools.

Required skillsets:

  • 10+ years of hands-on experience in data architecture, solution design, and cloud-based data engineering
  • Deep expertise in Snowflake, Azure Data Factory (ADF), Azure Synapse Analytics, and Data Compass (or similar cataloging/lineage tools)
  • Proven track record of delivering large-scale data platform modernization initiatives
  • Strong understanding of data modeling (3NF, Star, Snowflake schemas) and metadata management
  • Hands-on experience with modern orchestration frameworks (ADF, Airflow) and automation (CI/CD for data)
  • Solid experience in API architecture for data services and data democratization approaches
  • Familiarity with cloud security principles, including encryption, data privacy, RBAC, and network security
  • Excellent communication skills with the ability to present complex technical concepts to technical and non-technical stakeholders
  • Bachelor s degree in Computer Science, Engineering, or a related field

Tools & Technologies:

  • Data Warehouse/Cloud: Snowflake, Azure Synapse, AWS Redshift, Databricks
  • ETL/Orchestration: Azure Data Factory (ADF), dbt, Apache Airflow
  • Data Catalog/Governance: Data Compass, Alation, Azure Purview
  • Development: Python, SQL, Terraform, ARM Templates
  • Visualization/Reporting: Power BI, Tableau
  • Collaboration & Program Management: Jira, Confluence, Miro, MS Project
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.