Maestro Data Architect

PROLIM Global Corporation
  • Stamford, CT
    30+ days ago

    Job Description

    Role Name - Maestro Data Architect

    REQUIREMENT_CITY - Stamford CT

    • Need to be local or willing to move to Stamford CT

    ROLE_DESCRIPTION

    • Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, Python, and/or cloud services (preferably AWS).
    • Build and optimize data models, staging warehouse, and Datamarts using best practices such as micro-partitioning, clustering, and performance tuning.
    • Develop and manage data ingestion workflows from structured and semi-structured sources (JSON, Parquet, XML, APIs, etc.).
    • Implementation of business requirements using Snowflake features such as Streams, Tasks, Time Travel, Zero Copy Cloning, and Snowpipe for automated data loads.
    • Collaborate with Data architects, analysts, and business stakeholders to translate requirements into scalable technical solutions.
    • Monitor and troubleshoot pipelines for failures and issues, ensuring data quality and integrity.
    • Document data flows, transformations, and technical processes for maintainability and knowledge sharing.
    • Excellent analytical skills and strong understanding of SQL/PLSQL.
    • Job scheduling and orchestration using industry standard tools.

    SKILLS & TECHNOLOGY

    • Hands-on experience with Cloud-based Database, preferably Snowflake.
    • Excellent SQL/PLSQL skills.
    • Basic understanding on AWS.
    • Experience on orchestration/scheduling tool, preferably Tidal.
    • Experience on Python is an advantage.
    • Working experience on Data Warehousing and Modeling.
    • Basic understanding of Banking terminology.

    Numbers & Facts

    LocationStamford, CT

    Skills

    • Amazon Web Services (AWS)unmatched
    • Analysis Skillsunmatched
    • Application Programming Interface (API)unmatched
    • Architectural Analysisunmatched
    • Banking Servicesunmatched
    • Best Practicesunmatched
    • Cloningunmatched
    • Cloud Computingunmatched
    • Data Analysisunmatched
    • Data Managementunmatched
    • Data Martunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Warehousingunmatched
    • DataArchitect Data Modeling Toolunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Identify Issuesunmatched
    • Industry Standardsunmatched
    • JSONunmatched
    • Oracle PL-SQLunmatched
    • Performance Tuning/Optimizationunmatched
    • Python Programming/Scripting Languageunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Snowflake Schemaunmatched
    • XML (EXtensible Markup Language)unmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder