Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, Python, and/or cloud services preferably AWS
Build and optimize data models (staging, warehouse, 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
Requirements:
Hands-on experience with Cloud based Database, preferably Snowflake
Excellent SQL / PL SQL skills
Experience on orchestration / scheduling tool, preferably Tidal
Working experience on Data Warehousing and Modeling
Job description
Job Description
Job Role: Snowflake Maestro Data Architect Job Location: Stamford, CT/Remote Job Type: Full Time Salary Range: $120000 to $150000/Annum
Must Have Technical/Functional Skills
Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, Python, and/or cloud services preferably AWS
Build and optimize data models (staging, warehouse, 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
Roles & Responsibilities
Hands-on experience with Cloud based Database, preferably Snowflake
Excellent SQL / PL SQL 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
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
From: United States, Sweden, Arizona (USA), Kansas (USA), Michigan (USA), New York (USA), Virginia (USA), Washington (USA), Wisconsin (USA) (Full Remote)
