Talent.com
This job offer is not available in your country.
Snowflake Architect / Modeler (Azure Focus)

Snowflake Architect / Modeler (Azure Focus)

xCroTekAurangabad, IN
1 day ago
Job description

Job Overview

We are looking for a skilled Snowflake Architect / Modeler with 5-7 years of experience to lead the design and implementation of scalable data solutions on the Snowflake platform hosted on Azure. In this role, you will architect data pipelines adhering to the Medallion Architecture (Bronze, Silver, Gold layers), research legacy source systems, and create optimized data models to enable robust analytics and business intelligence. The ideal candidate excels in translating complex business requirements into technical designs, with a strong emphasis on data governance, performance, and seamless integration with Azure services. This position offers the chance to drive data modernization initiatives in a collaborative, Azurecentric environment.

Key Responsibilities

  • Architect comprehensive Snowflake solutions following the Medallion Architecture framework, including ingestion into Bronze (raw), transformation to Silver (refined), and curation into Gold (aggregated) layers.
  • Research and analyze source systems (e.g., onpremises databases, SaaS applications) to document tables, columns, relationships, and underlying business logic in existing data processing workflows.
  • Design Snowflakecompatible data models using Erwin for conceptual, logical, and physical modeling; generate DDL scripts; and create detailed sourcetotarget mappings for ETL / ELT processes.
  • Develop and optimize data ingestion pipelines using Snowflake features such as Snowpipe for continuous loading, Streams for change data capture, Tasks for scheduling, and Dynamic Tables for materialization.
  • Collaborate with stakeholders, data engineers, and Azure teams to define requirements, ensure data lineage, and implement secure, compliant data flows integrated with Azure services like Azure Data Factory, Synapse, and Blob Storage.
  • Perform data quality assessments, performance tuning, and optimization of queries and warehouses to support highvolume analytics on Azure.
  • Lead data migration and modernization projects from legacy systems to Snowflake on Azure, ensuring minimal downtime and adherence to best practices.
  • Document architectures, mappings, and designs; conduct peer reviews; and mentor junior team members on Snowflake and Azure integrations.

Required Qualifications

  • Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field.
  • 5-7 years of experience in data architecture, modeling, and engineering, with at least 3 years handson with Snowflake on Azure.
  • Expertise in Medallion Architecture implementation, including layering strategies for data ingestion, transformation, and consumption.
  • Proven ability to reverseengineer source systems, capturing metadata (tables, columns) and business rules for accurate data modeling.
  • Proficiency in data modeling tools like Erwin for designing relational and dimensional models; experience generating DDLs and creating sourcetotarget mapping documents.
  • Strong handson experience designing and developing Snowflake native features : Snowpipe, Streams, Tasks, Time Travel, and clustering for Azurehosted environments.
  • Indepth knowledge of SQL for advanced querying, optimization, and AzureSnowflake integrations (e.g., Azure AD for authentication, external stages).
  • Familiarity with Azure ecosystem, including Data Lake, Synapse Analytics, and security / compliance standards (e.g., Azure Sentinel, GDPR).

    • Preferred Qualifications

  • Experience with ETL / ELT tools like dbt, Matillion, or Azure Data Factory for orchestrating pipelines in a Medallion setup.
  • Background in big data technologies (e.g., Spark on Azure Databricks) integrated with Snowflake.
  • Snowflake certifications (e.g., SnowPro Core, Advanced Architect) and Azure certifications (e.g., DP203 : Data Engineering on Microsoft Azure).
  • Knowledge of data governance tools like Collibra or Alation for lineage and cataloging in Azure environments.

    • Technical Skills

  • Core : Snowflake (Snowpipe, Streams, Tasks, Medallion Architecture), SQL, Data Modeling (Erwin, DDLs, SourcetoTarget Mapping)
  • Azure Integration : Azure Data Factory, Synapse, Blob Storage, ADLS Gen2, Azure AD
  • Tools & Technologies : dbt, Fivetran; Reverse Engineering (e.g., SQL Server, Oracle sources)
  • Concepts : Data Lineage, Performance Optimization, Security (RBAC, Encryption), ELT Pipelines

    • Soft Skills

  • Exceptional communication skills to articulate complex technical concepts to nontechnical stakeholders and facilitate crossteam collaboration.
  • Proven track record of timely delivery on projects, with strong organizational skills and the ability to manage multiple priorities in a fastpaced Azure environment.
  • Analytical problemsolver with attention to detail and a proactive mindset for innovation.

    • Interested candidates kindly Email at hr@xcrotek.com

    Create a job alert for this search

    Snowflake • Aurangabad, IN

    Related jobs
    • Promoted
    Cloud Architect

    Cloud Architect

    Azoca TechnologiesAurangabad, IN
    We are looking for an experienced GCP Cloud Architect with expertise in networking, security, and AI platforms to design and implement secure, scalable Google Cloud environments.This role involves ...Show moreLast updated: 3 days ago
    • Promoted
    Salesforce Technical Architect

    Salesforce Technical Architect

    OSF DigitalAurangabad, IN
    At OSF Digital, we are at the forefront of digital innovation, transforming businesses across the globe with cutting-edge solutions. As a trusted partner in the digital landscape, we empower organiz...Show moreLast updated: 5 days ago
    • Promoted
    Azure Backend Engineer

    Azure Backend Engineer

    ITC LimitedMaharashtra, India, India
    Job Title : Azure Backend Engineer.Bangalore, Hyderabad, Gurugram, Kolkata, Pune, Mumbai.We are seeking experienced Backend Engineers to join a major enterprise integration program leveraging the Mi...Show moreLast updated: 5 days ago
    • Promoted
    Functional Consultant- Oracle EBS (SME) Financials

    Functional Consultant- Oracle EBS (SME) Financials

    Marsh McLennanMaharashtra, India, India
    Location- Gurugram / Noida / Mumbai / Pune.Functioanl Consultant- Oracle EBS (SME) Financials.In this role, you will work on Oracle applications finance modules support for the company's business solutio...Show moreLast updated: 30+ days ago
    • Promoted
    SAP Business One Administrator on Azure Infrastructure

    SAP Business One Administrator on Azure Infrastructure

    Eton TechnologiesMaharashtra, India, India
    SAP Business One Administrator.The ideal candidate should also have solid Azure infrastructure and DevOps skills to support smooth operations and automation. VMs, storage, networking, security.Autom...Show moreLast updated: 5 days ago
    • Promoted
    Cloud Architect

    Cloud Architect

    IntraEdgeAurangabad, IN
    Senior Cloud Architecture Engineer.The Senior Cloud Architecture Engineer is responsible for designing, building and maintaining the underlying PaaS systems that products and services run on, with ...Show moreLast updated: 20 days ago
    • Promoted
    Cloud Architect

    Cloud Architect

    iVedha Inc.Aurangabad, IN
    Seeking a highly experienced Cloud Architect to design and oversee robust, scalable, and secure.Architect end-to-end cloud solutions (public, private, hybrid) with a focus on reliability, security,...Show moreLast updated: 30+ days ago
    • Promoted
    Technical Architect

    Technical Architect

    Bradford Consultants LLPAurangabad, IN
    Hiring for someone who can lead the design and development of systems that deliver personalized experiences to users, using a stack that includes Salesforce, AWS data tools, Drupal, and Python.Plan...Show moreLast updated: 19 days ago
    • Promoted
    DevOps Architect

    DevOps Architect

    Sycamore Informatics Inc.Aurangabad, IN
    Develop, execute, maintain, and improve procedures, automation scripts, and infrastructure implementations to support Sycamore SaaS Operations. Bachelor’s degree, preferably in Computer Science, Ele...Show moreLast updated: 30+ days ago
    • Promoted
    Snowflake Data Modeller / DBA

    Snowflake Data Modeller / DBA

    xCroTekAurangabad, IN
    We are hiring a dedicated Snowflake DBA with 3-5 years of experience to manage and optimize our Snowflake data platform on Azure. In this role, you will handle day-to-day administration, performance...Show moreLast updated: 2 days ago
    • Promoted
    NetSuite Architect (Remote Opportunity)

    NetSuite Architect (Remote Opportunity)

    Client of Prasha Consultancy Services Private LimitedAurangabad, IN
    Remote
    A US / Canada based IT MNC is hiring for NetSuite Architect.Shift Timing : Ends around 12 AM.We are seeking a highly experienced. The role requires a deep understanding of.Accounting, Finance, and Inve...Show moreLast updated: 28 days ago
    • Promoted
    Azure Full Stack Architect - Full remote - Contractor in USD

    Azure Full Stack Architect - Full remote - Contractor in USD

    All European CareersMaharashtra, India, India
    Remote
    For an international project in Chennai, we are urgently looking for a Full Remote Azure Full Stack Architect.We are looking for a motivated contractor. Candidates need tbe fluent in English.Oversee...Show moreLast updated: 5 days ago
    • Promoted
    Oracle Functional Consultant

    Oracle Functional Consultant

    People Prime WorldwideMaharashtra, India, India
    They balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what’s now to what’s next by un...Show moreLast updated: 2 days ago
    • Promoted
    Snowflake Modeler / Developer (Azure Focus)

    Snowflake Modeler / Developer (Azure Focus)

    xCroTekAurangabad, IN
    We are looking for a skilled Snowflake Architect / Modeler with 5-7 years of experience to lead the design and implementation of scalable data solutions on the Snowflake platform hosted on Azure.In t...Show moreLast updated: 1 day ago
    • Promoted
    Salesforce Data Cloud Architect

    Salesforce Data Cloud Architect

    RialtesAurangabad, IN
    Job Description : Salesforce Data Cloud Lead.Freelance / Contract - 6 months.We are looking for an experienced.This role requires deep knowledge of. Salesforce Data Cloud (formerly Customer Data Plat...Show moreLast updated: 30+ days ago
    • Promoted
    Principal Azure Cloud Architect / Principal Engineer

    Principal Azure Cloud Architect / Principal Engineer

    First American (India)Aurangabad, IN
    Job Title : Principal Azure Cloud Architect / Principal Engineer (20+ Years Experience).We are seeking a technical visionary Principal Azure Cloud Architect with 20+ years of experience to lead the tr...Show moreLast updated: 30+ days ago
    • Promoted
    Cloud Architect-AI

    Cloud Architect-AI

    HCLTechAurangabad, IN
    AI Cloud Architect + developer.You will be responsible for creating scalable, secure, and cost-effective cloud architectures that meet the business and technical requirements of the projects.You wi...Show moreLast updated: 30+ days ago
    • Promoted
    Cloud Architect

    Cloud Architect

    Green HR SolutionsAurangabad, IN
    Hiring for a USA based multinational Company (MNC).We are seeking an experienced and visionary Cloud Architect to design, implement, and manage scalable cloud infrastructure solutions.The ideal can...Show moreLast updated: 5 days ago