infotron solutionsNew York, NY
Snowflake Solutions Architect
$120,000 per year
Apply (opens in a new tab)Snowflake Solutions Architect
Apply for this role (opens in a new tab)Location:
New York, NY / Hybrid Preferred (Remote is available for highly qualified candidates)
Employment Type: Full-Time / Contract
We are looking for aSenior Snowflake Solutions Architectto support a strategic data warehousing and integration initiative for a leadingfinancial-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/Architectand provide technical guidance.
Design and optimizeETL/ELT pipelinesand 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-onSnowflake architecture and implementationexperience.
AdvancedSQL, data warehousing, data modeling, and ETL/ELT.
Strong knowledge of Snowflakewarehouses, 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 ahands-on engineer and technical architect.
Preferred Skills:
Experience inhedge funds, asset management, investment management, capital markets, or financial services.
Experience withdbt, Airflow, Fivetran, Informatica, Matillion, or similar tools.
Python and AWS/Azure experience.
Experience with financial data such astrades, positions, securities, pricing, P&L, risk, or market data.
Snowflake certification is a plus. Flexible work from home options available.
Compensation: $120,000.00 - $180,000.00 per year
Also on the board Same function, level within a rung
Level
Lead
Salary
$120,000 per year
Location
New York, NY
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
yesterday