Snowflake Solutions Architect Job at INFOTRON, New York, NY

  • INFOTRON
  • New York, NY

Job Description

Job Description

Job Description

Location: New York, NY / Hybrid Preferred (Remote is available for highly qualified candidates)
Employment Type: Full-Time / Contract

We are looking for a Senior Snowflake Solutions Architect to support a strategic data warehousing and integration initiative for a leading financial-services / hedge fund client .
The ideal candidate will be a hands-on Snowflake expert who can design enterprise data warehouse solutions, integrate multiple data sources, optimize performance and cost, and work directly with business and technology stakeholders.

Key Responsibilities:
  • Design and implement scalable Snowflake data warehouse architectures .
  • Serve as the Snowflake SME/Architect and provide technical guidance.
  • Design and optimize ETL/ELT pipelines and data models.
  • Work with multiple upstream/downstream systems and applications.
  • Perform Snowflake performance, workload, security, and cost optimization.
  • Collaborate with data engineering, application, infrastructure, security, and business teams.
  • Troubleshoot production data, pipeline, and integration issues.
  • Document architecture and technical standards.
Required Skills:
  • Strong hands-on Snowflake architecture and implementation experience.
  • Advanced SQL , data warehousing, data modeling, and ETL/ELT.
  • Strong knowledge of Snowflake warehouses, stages, streams, tasks, clustering, RBAC, and performance tuning .
  • Experience building and supporting production data pipelines.
  • Strong data integration and architecture experience.
  • Excellent communication and stakeholder-management skills.
  • Ability to work as both a hands-on engineer and technical architect .
Preferred Skills:
  • Experience in hedge funds, asset management, investment management, capital markets, or financial services .
  • Experience with dbt, Airflow, Fivetran, Informatica, Matillion , or similar tools.
  • Python and AWS/Azure experience.
  • Experience with financial data such as trades, positions, securities, pricing, P&L, risk, or market data .
  • Snowflake certification is a plus.

Flexible work from home options available.

Job Tags

Full time, Contract work, Remote work, Work from home, Flexible hours

Similar Jobs

The Keller Group

Copywriter Job at The Keller Group

 ...Were seeking a passionate, versatile B2B Copywriter who is eager to keep learning, passionate about content, and poised to work with...  ...management skills, with the ability to work independently in a remote environment. If interested in the B2B Copywriter job in... 

Gemma Power Systems

Payroll & Timekeeping Specialist Job at Gemma Power Systems

 ...LOCATION THAT YOU WILL BE ASSIGNED TO FOR THIS ROLE. PLEASE REFER TO THE JOB DESCRIPTION BELOW FOR MORE INFORMATION. Payroll & Timekeeping Specialist Location: TBD (will depend on project site assignment) Employment Type: Full-Time Timing: Immediate... 

Mitchell Martin

Med Spa Manager Job at Mitchell Martin

 ...Med Spa Manager - Newtown, CT (Onsite) - Full Time - Mon-Fri 09:00am-05:00pm - One Late Day Per Week Until 07:00pm - $85,000-$100,000 Per Year Title: Med Spa Manager Location: Newtown, CT (Onsite) Employment Type: Full Time - Mon-Fri 09:00am-05:00pm - One Late... 

AUS Inc

Armed Security Officer (3 yrs exp) Job at AUS Inc

 ...Armed Security Officer Allied Universal is hiring 15 experienced Armed Security Officers in Chattanooga (37415). If you bring at least...  ...Minimum of three (3) years of law enforcement, military, or private armed security experience Minimum of 21 years of age (or higher... 

Takeda Pharmaceutical Company Ltd

Medical Screener Job at Takeda Pharmaceutical Company Ltd

 ...commitment to customer service and quality is expected. You will report to the Plasma Center Manager and will perform as a plasma donor screener and perform phlebotomy to support plasma center operations. How you will contribute: You will answer phones, and greet...