Sr. Snowflake Architect

Title Sr. Snowflake Architect

Location Dallas, TX

Architect

Primary Skills

Snowflakes , ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures

Job requirements

Key Responsibilities :

• Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS
• Architect high-performance, scalable solutions on Snowflake Data Warehouse
• Design robust data models with strong understanding of facts and dimensions
• Act as a strategic advisor to business stakeholders, using data to drive insights and business outcomes
• Partner with line-of-business leaders to identify and prioritize opportunities where data engineering can deliver measurable value
• Lead a team of data engineers through complex integration efforts with a problem-solving attitude
• Translate unstructured problems into structured, scalable data solutions
• Deliver high-quality business presentations and solution documentation tailored to technical and executive audiences
• Ensure alignment between technical delivery and business value realization
• Optimize performance through effective data modeling, partitioning, and indexing.
• Lead data migration and integration projects to move legacy data systems to Snowflake.
• Collaborate with business analysts, data engineers, and stakeholders to define requirements and deliver data solutions.

Required Skills & Qualifications :

Key Expectations : 1. Very strong SQL and Informatica (PowerCenter & IICS) capabilities 2. Deep understanding of Pharma datasets and commercial analytics 3. Proven consultative approach with ability to drive thought leadership and business impact 4. Excellent stakeholder management and presentation skills 5. Onsite availability

Thanks,

Subia Khan

DESK : 856 268 0027, 856-456-1805 EXT : 1032

w : www.MomentoUSA.com e : subia@momentousa.com

440 Benigno Blvd, Unit#A 2nd Floor. Bellmawr, NJ 08031

Interstate Business Park

Note : Momento USA is an Equal Opportunity / Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.