Enterprise Data Architect - AWS & Snowflake Specialist

Esolvit, Inc.$150K — $180K *
Enterprise Technology
11 - 15 years of experience
Job Overview by Ladders

Qualifications

  • 15+ years in data architecture and engineering with cloud-native focus.
  • Expertise in Snowflake for large-scale data warehousing and management.
  • Strong hands-on experience with AWS services: S3, EMR, Glue, Lambda, and more.
  • Proficient in Python, SQL, and PL/SQL for data manipulation.
  • Experience with dbt for transformation and modeling of data.
  • Familiarity with Apache Airflow for ETL/ELT processes.
  • Solid understanding of data governance principles and compliance controls.

Responsibilities

  • Define and execute enterprise data architecture vision and roadmap.
  • Lead architectural decisions for data modernization balancing technology and business.
  • Establish governance frameworks and data lifecycle processes.
  • Architect scalable AWS data platforms integrating with Snowflake.
  • Implement enterprise data governance standards and data security policies.
  • Oversee production ETL/ELT pipeline design and orchestration.
  • Guide engineering teams in achieving technical and operational excellence.

Benefits

  • Flexible working environment.
  • Opportunities for professional development and continued education.
  • Health, dental, and retirement benefits.
  • Collaborative team culture with cross-functional partnership opportunities.
Full Job Description
Job title: Enterprise Data Architect - AWS & Snowflake Specialist
Location: Austin, TX
Duration: Long Term

Job Description:
Enterprise Data Architect - AWS & Snowflake Specialist
We are seeking a highly experienced and strategic Enterprise Data Architect with 15+ years of hands-on experience in designing, building, and optimizing enterprise-scale data platforms. This pivotal role demands a deep specialization in AWS and Snowflake technologies, coupled with a proven ability to transform fragmented enterprise data into governed, high-performance, and scalable solutions. The ideal candidate will establish long-term data architecture visions, implement robust enterprise governance frameworks, and lead significant cloud-based data modernization initiatives. This role requires a trusted advisor to executive leadership for strategic data initiatives and enterprise-wide transformation programs.
Key Responsibilities:
  • Architectural Leadership & Strategy:
    • Define and execute the enterprise data architecture vision and roadmap for critical business domains.
    • Lead architectural decisions across enterprise data modernization initiatives, balancing technical constraints, scalability, governance, and business priorities.
    • Develop architectural roadmaps and governance frameworks for diverse data platforms.
    • Design end-to-end data lifecycle, from ingestion to transformation, analytics, and archival.
    • Establish enterprise data standards, metadata governance processes, and architectural governance.
    • Serve as a trusted advisor to executive leadership for strategic data initiatives.
  • AWS Cloud Data Platform Expertise:
    • Architect and implement scalable AWS architectures leveraging services such as S3, Glue, EMR, Lambda, SQS, SNS, Kinesis, and IAM.
    • Design and integrate AWS services with Snowflake to build data platforms that are fast, governed, and built for lasting performance.
    • Lead the design of enterprise-scale AWS data integration platforms, supporting capabilities like 5 TB/day Kafka streaming and serverless event-driven triggers.
  • Snowflake Data Warehouse Specialization:
    • Architect, design, and optimize Snowflake-based enterprise data warehouses, including high-performance schemas, clustering keys, partitioning strategies, multi-cluster virtual warehouses, RBAC, Snowpipe, Time Travel, Tasks, Streams, and data sharing policies.
    • Develop complex PL/SQL stored procedures, dynamic SQL, and Python-based Snowflake pipelines for high-performance enterprise data processing and transformation.
    • Guide engineering teams in the implementation, optimization, and production delivery of Snowflake solutions.
  • Data Governance & Quality:
    • Implement enterprise data governance standards including role-based access controls (RBAC), lineage management, schema governance, compliance controls, and audit-ready data frameworks.
    • Define and implement row/column-level security, data masking, and data lifecycle management policies.
    • Establish data quality monitoring and remediation frameworks for completeness, redundancy, and compliance tracking, aiming to reduce data quality issues.
  • Data Engineering & Operations:
    • Oversee the design and orchestration of production ETL/ELT pipelines using tools like Apache Airflow, AutoSys, and Jenkins.
    • Develop and implement dbt transformation layers with schema evolution, lineage tracking, and data quality controls, ensuring every metric is auditable from source to dashboard.
    • Experience in operating data platforms at scale, designing for failure with self-healing pipelines, dead-letter-queue recovery, and observability (e.g., Datadog, Splunk) to achieve 99.9%+ uptime.
    • Implement CI/CD practices using GitHub Actions and Jenkins for automated testing and deployment of data assets.
  • Leadership & Collaboration:
    • Lead and guide engineering teams (e.g., 5-15 resources), providing technical standards, conducting design and code reviews, and owning solution decisions end-to-end.
    • Partner with cross-functional stakeholders (Business, IT, Security, Compliance) to align architecture with enterprise initiatives.
Required Skills & Experience:
  • 15+ years of experience in data architecture, data engineering, and data platform leadership, with a strong focus on cloud-native solutions.
  • Deep hands-on expertise with Snowflake for large-scale enterprise data warehousing, including DB design, tuning, clustering, Snowpipe, Tasks, Streams, Time Travel, RBAC, and data sharing policies.
  • Extensive experience with AWS cloud services for building and managing data platforms, specifically: S3, EMR, Glue, Lambda, SQS, Kinesis, SNS, and IAM.
  • Proficiency in Python, SQL, and PL/SQL for data manipulation, scripting, and automation.
  • Demonstrated experience with dbt for data transformation and modeling.
  • Experience with Apache Airflow for ETL/ELT orchestration.
  • Strong command of data governance principles, including RBAC, data quality, metadata management, data lineage, and compliance controls.
  • Proven ability to lead large-scale data migration and modernization initiatives (e.g., Teradata to Snowflake, SQL Server to cloud), managing multi-terabyte datasets.
  • Experience with monitoring and observability tools like Datadog or Splunk.
  • Solid understanding and implementation of CI/CD practices for data pipelines using GitHub Actions and Jenkins.
Preferred Qualifications:
  • Experience with Apache Iceberg.
  • Familiarity with other data platforms like Databricks, Azure Synapse, or Microsoft Fabric.
  • Experience with AI/ML integration in data platforms, RAG pipelines, Vector Search, or AWS AI services.
Education:
  • Master's or Bachelor's degree in Computer Science, Electrical Engineering, Information Technology, or a related field.
Certifications:
  • AWS Certified Solutions Architect - Associate or AWS Certified Developer.
  • Snowflake SnowPro Advanced: Architect Certified or SnowPro Core.

About Esolvit, Inc.

Esolvit, Inc. Careers

Joining Esolvit, Inc. presents an unparalleled opportunity to become part of a leading team of professionals dedicated to pioneering innovation in the tech industry. Esolvit, Inc. is renowned for its commitment to excellence and a culture that fosters growth and leadership.

Explore Job Opportunities

Esolvit, Inc. offers a variety of job opportunities that cater to a range of skills and professional interests. Whether seeking a position in software development, project management, or data analysis, Esolvit, Inc. provides a platform for career advancement and personal development.

Internship Programs

Esolvit, Inc. believes in nurturing new talent through robust internship programs. These programs offer hands-on experience and are a cornerstone of the company's commitment to professional growth and diversity training. Interns at Esolvit, Inc. gain invaluable industry insights and professional networking opportunities, setting the stage for a promising career.

Innovative Work Environment

At Esolvit, Inc., innovation is at the core of everything they do. The team is encouraged to think creatively and push boundaries in technology and service solutions. This environment stimulates professional growth and positions Esolvit, Inc. as a leader in technology solutions.

Diversity and Inclusion

Esolvit, Inc. is committed to creating a diverse and inclusive workplace. The company values diversity as a critical component of innovation and problem-solving. Diversity training programs are integral, ensuring that all team members understand and appreciate the strength that lies in differences.

Benefits and Culture

Esolvit, Inc. is dedicated to supporting its team members not only in their professional lives but also in their personal growth. The company offers competitive benefits, including health, dental, and vision insurance, alongside opportunities for leadership development. The culture at Esolvit, Inc. is built around collaboration, respect, and continuous learning.

Career Development

Career growth is a priority at Esolvit, Inc. With access to a multitude of training and development programs, team members are equipped to excel in their current roles and prepare for future challenges. Leadership development is encouraged, allowing individuals to advance their careers within the company.

Hiring Process

The hiring process at Esolvit, Inc. is designed to be transparent and engaging. Candidates can expect a thorough interview process where they can showcase their skills and learn more about the company's operations and culture. Resumes are carefully reviewed to match job seekers with the ideal position that aligns with their career aspirations.

Join the Esolvit, Inc. Team

Esolvit, Inc. is actively looking for passionate, curious, and innovative individuals to join their team. Explore the open positions and find where your skills and interests align with the needs of Esolvit, Inc.

Stay Connected with Esolvit, Inc. Careers

Stay informed about the latest in career opportunities and industry trends by joining Esolvit, Inc.’s career network. Subscribe to receive updates, news, and insider tips directly from the professionals at Esolvit, Inc.

SEARCH ESOLVIT, INC. JOBS

READ CAREERS BLOG

Job Alert Emails

Customize your alerts to receive updates on job openings, employment news, and exclusive insights from Esolvit, Inc. Discover the exciting and rewarding career opportunities that await at Esolvit, Inc.
Learn more about Esolvit, Inc.

Similar Jobs

More Jobs at Esolvit, Inc.

More Enterprise Technology Jobs

Find similar Enterprise Data Architect - AWS & Snowflake Specialist jobs: