Maestro Data Architect

Job Description

This role involves designing, developing, and maintaining ETL/ELT pipelines using Snowflake, SQL, Python, and cloud services (primarily AWS). The engineer will build and optimize data models, manage data ingestion workflows, and implement Snowflake features such as Streams, Tasks, Time Travel, Zero Copy Cloning, and Snowpipe. Responsibilities include collaborating with data architects, analysts, and business stakeholders, monitoring and troubleshooting pipelines, and documenting technical processes.

• 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) with 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.).
• Implement 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.

• Hands‑on experience with cloud‑based databases, preferably Snowflake.
• Excellent SQL / PL/SQL skills.
• Basic understanding of AWS services.
• Experience with orchestration/scheduling tools, preferably Tidal.
• Experience with Python is an advantage.
• Working experience on data warehousing and modeling.
• Basic understanding of banking terminology.
• Bachelor of Computer Science or related degree.

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage:
  Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support:
  Maternal & Parental Leaves.
• Insurance Options:
  Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth:
  Commuter Benefits & Certification & Training Reimbursement.
• Time Off:
  Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance:
  Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $130,000 - $150,000 a year.