Data Architect
Location : South San Francisco CA Hybrid
Duration : Long Term
Key Responsibilities
- Design and architect end-to-end data solutions leveraging Snowflake as the primary data warehouse.
- Build and optimize ETL / ELT pipelines using Marillion ensuring scalability performance and reliability.
- Develop data models (conceptual logical and physical) addressing business and analytical requirements.
- Define and enforce data governance data quality and metadata management standards.
- Work closely with product BI analytics and engineering teams to translate business needs into architectural blueprints.
- Optimize Snowflake performance : clustering micro-partitioning caching warehouse sizing and cost governance.
- Integrate data from various structured and unstructured sources.
- Review existing data systems and recommend modernization opportunities.
- Ensure security best practices including role-based access control encryption and compliance.
- Create documentation architectural diagrams and data flow maps.
- Drive best practices for CI / CD data testing and DevOps for data pipelines.
Required Skills
10 years of experience in data engineering or data architecture roles.Strong hands-on expertise in Marillion ETL / ELT (jobs orchestration components transformations).Deep understanding of Snowflake-warehouses schema design streams tasks materialized views performance tuning.Proficiency in SQL data modeling and data warehouse concepts (Kimball / Inmon).Experience with cloud platforms (AWS / Azure / GCP) especially AWS services like S3 Lambda EC2 IAM.Strong understanding of batch and real-time data processing patterns.Knowledge of data governance master data management and metadata frameworks.Experience with version control (Git) and CI / CD workflows.Ability to create architecture diagrams using tools like Lucidchart or Visio.Thanks
Amaresh
Sr. Technical Recruiter
Momento USA Exceeding Customer Expectations
440 Benigno Blvd Unit#A 2nd Floor. Bellmawr NJ 08031
Interstate Business Park
Direct : Ext (1022)
Email : Are You LinkedIn :
Minority Certified by SWAM
National Minority Certified by NMSDC
One of the fastest growing company in NJ
Awarded fastest growing Asian American business by
E-verified Company
Information transmitted by this e-mail is proprietary to Momento USA and / or its Customers and is intended for use only by the individual or entity to which it is addressed and may contain information that is privileged confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority you are notified that any use or dissemination of this information in any manner is strictly such cases please notify us immediately at and delete this mail from your records.
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.
Key Skills
Fund Management,Drafting,End User Support,Infrastructure,Airlines,Catia
Employment Type : Full Time
Experience : years
Vacancy : 1