Remote Jobs RockRemote Jobs Rock

Principal Architect - R01571497

πŸ“… Sep 22
Snowflake ArchitectureETL PipelinesSQLPython
Apply Now

πŸ“œ Description

  • Architect secure, scalable, high-performance Snowflake solutions for enterprise data initiatives.
  • Build ETL pipelines with Snowflake Streams, Python, and SQL for data ingestion and transformation.
  • Optimize Snowflake performance, cost, and reliability using Time Travel, Fail Safe, and Snowpipe.
  • Lead Snowflake data warehouse modeling and design to support data integrity, accessibility, and scalability.
  • Automate data processing and analytics workflows with SnowSQL, stored procedures, and advanced SQL.
  • Partner with cross-functional teams, troubleshoot platform issues, and mentor junior architects and engineers.

πŸ› οΈ Requirements

  • 15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms.
  • Expertise in Snowflake architecture, engineering, data modeling, and warehouse design.
  • Advanced SQL proficiency and strong Python experience for data processing and automation.
  • Deep ETL pipeline development experience, including Snowflake Streams, Snowpipe, Time Travel, and Fail Safe.
  • Skilled in SnowSQL, stored procedures, and advanced SQL scripting.
  • Preferred: AWS or Azure integration, data security and governance, performance tuning, orchestration tools such as Apache Airflow or dbt, and real-time analytics.
  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline desired.
  • Snowflake SnowPro Advanced Architect or equivalent certification desired; data warehousing or cloud data platform certification also desired.
Full job description
Principal Architect

Primary Skills

  • DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
  • Specialization

  • Snowflake Engineering: Principal Data Architect
  • Job requirements

    15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms

    Key Responsibilities:

  • Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiatives.
  • Develop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformation.
  • Optimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and Snowpipe.
  • Lead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalability.
  • Configure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflows.
  • Collaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectives.
  • Troubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtime.
  • Mentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentals.
  • Required Skills:

  • Expertise in Snowflake architecture and engineering
  • Advanced proficiency in SQL
  • Strong experience with Python for data processing and automation
  • Deep understanding of ETL pipeline development
  • Hands-on experience with Snowflake Streams for real-time data ingestion
  • Proficiency in Time Travel and Fail Safe features within Snowflake
  • Implementation and management of Snowpipe for automated data loading
  • Skilled in SnowSQL for scripting and data management
  • Experience in Snowflake-specific data modeling and warehouse design
  • Expertise in developing and managing Snowflake stored procedures
  • Preferred Skills:

  • Experience integrating Snowflake with cloud platforms such as AWS or Azure
  • Expertise in advanced data security and governance practices
  • Knowledge of performance tuning and optimization for large-scale Snowflake workloads
  • Familiarity with emerging data engineering technologies and frameworks
  • Experience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt)
  • Hands-on experience with real-time analytics and streaming data solutions
  • Desired Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline
  • Snowflake SnowPro Advanced Architect certification or equivalent
  • Certification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate)
  • NBCUniversal

    Data Architect (Microsoft Fabric)

    πŸ•’ 2 days ago
    NBCUniversalπŸ‘₯ 10,000+ employees🏒 Entertainment

    Define the target architecture and engineering standards for a greenfield Microsoft Fabric data platform, while guiding delivery teams in building governed, scalable solutions for operational analytics, automation, and AI.

    Microsoft FabricOnelakeLakehouse ArchitectureData Warehouse Architecture
    Jimmytechnologies

    Senior Data Architect (MS Purview)

    πŸ•’ 2 days ago
    JimmytechnologiesπŸ‘₯ 11 - 50 employees🏒 Information Technology And Services

    Lead hands-on Microsoft Purview implementations for enterprise clients, shaping data architecture and governance, managing metadata and catalog capabilities, and guiding solutions from design through day-to-day operation.

    Microsoft PurviewData ArchitectureData GovernanceMetadata Management
    Intetics

    1186 | Senior Data Architect (French-speaking)

    πŸ•’ 3 days ago
    InteticsπŸ‘₯ 201 - 500 employees🏒 Information Technology And Services

    The Senior Data Architect will assess existing data environments, define scalable target-state architecture, and guide data platform, warehousing, integration, quality, and governance solutions through implementation.

    πŸ“ πŸ‡«πŸ‡· France +5 - Remote?πŸ’Ό Full-Time🎸 SeniorπŸ—οΈ ArchitectπŸ“’ πŸ‡«πŸ‡· French RequiredπŸ“’ πŸ‡¬πŸ‡§ English Required
    Data ArchitectureData WarehousingData Platform DesignMicrosoft SQL Server
    Bvn

    Experienced Graduate / Architect

    πŸ•’ 2 days ago
    BvnπŸ‘₯ 201 - 500 employees🏒 Architecture & Planning

    Develop architectural design solutions from concept through delivery, using technical expertise and creative judgment while collaborating with clients and interdisciplinary teams to deliver thoughtful, high-quality projects.

    Architectural DesignRevitRhinoGrasshopper
    NVIDIAExternalCareerSite

    Senior Software and System Architect

    πŸ•’ 2 days ago
    NVIDIAExternalCareerSiteπŸ‘₯ 10,000+ employees🏒 Computer Hardware

    Lead cloud-networking and system architecture for NVIDIA DPUs and NICs, shaping end-to-end solutions from hardware to applications across orchestration, provisioning, security, and network programmability.

    Software ArchitectureSystem ArchitecturePythonLinux Development

    Trusted by Remote Workers