Senior Snowflake Data Engineer (Snowflake Specialist)

Experience: 5.00 + years

Salary: Confidential (based on experience)

Expected Notice Period: 15 Days

Shift: (GMT+05:30) Asia/Kolkata (IST)

Opportunity Type: Remote

Placement Type: Full Time Contract for 3 Months(40 hrs a week/160 hrs a month)

(*Note: This is a requirement for one of Uplers' client - A Leading Loan Software Company in USA)

What do you need for this opportunity?

Must have skills required:

Experience in mortgage, Experience with AWS CICD pipelines., Exposure to Power BI or similar BI tools connected to Snowflake., Familiarity with orchestration tools (Airflow, Loan Origination, MWAA)., or financial services data is a plus., schema versioning/migration tools, Servicing, Snowflake certification, ETL, Snowflake, AWS, Python, SQL

A Leading Loan Software Company in USA is Looking for:

Senior Snowflake Data Engineer (Snowflake Specialist)

Location: Remote

Contractual for 3 Months (Extendable)

Overview:

Company is seeking a highly skilled Senior Data Engineer with deep Snowflake expertise to join

our client data mesh implementation team. This individual will play a critical role in building and

optimizing Snowflake-based pipelines, models, and data products that support loan origination,

servicing, and reporting domains. The ideal candidate has hands-on Snowflake experience,

strong SQL and Python skills, and the ability to design scalable, governed data solutions in a

fast-paced consulting environment.

Responsibilities:

• Design, implement, and optimize Snowflake-based data warehouses, including schemas, roles, and warehouses.
• Build scalable ELT/ETL pipelines using SQL and Python, integrating with AWS S3 and Snowflake staging layers.
• Develop data models across Raw, Integration, and Presentation layers in Snowflake aligned to the client’s Data Mesh strategy.
• Apply Snowflake features (RBAC, Time Travel, Streams, Tasks, Secure Views) to enforce governance, lineage, and compliance.
• Monitor and tune Snowflake performance, optimizing warehouse costs and query execution.
• Collaborate with Company’’s technical leads and client stakeholders to design domain- specific data products and enable self-service reporting.
• Support orchestration via Airflow or Python on AWS EC2, ensuring reliable, observable, and resilient data workflows.
• Mentor junior engineers on Snowflake best practices and data engineering standards.
  
  
  

Qualifications Required:

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• Proven Snowflake expertise in data warehouse design, performance tuning, security, and
  
  
  

governance.

• Advanced SQL skills for data transformation and analytics.
• Experience with SQL stored procedures, user-defined functions, and materialized views in
  
  
  

Snowflake.

• Experience converting relational database objects/code to Snowflake.
• Strong Python development experience for building ELT pipelines and automation.
• Solid understanding of data modeling (star/snowflake schemas, SCD Type 2) and dimensional
  
  
  

design.

• Experience with AWS cloud services (S3, EC2, IAM, VPC, CloudWatch) integrated with
  
  
  

Snowflake.

• Hands-on experience with Git and version control for database objects and pipelines.
• Strong problem-solving and collaboration skills.
  
  
  

Preferred (Good to Have):

• Hands-on with Snowflake advanced features: SnowSQL, Streams, Tasks, External Tables.
• Experience with schema versioning/migration tools (Flyway, Liquibase).
• Exposure to Power BI or similar BI tools connected to Snowflake.
• Familiarity with orchestration tools (Airflow, MWAA).
• Experience with AWS CICD pipelines.
• Experience in mortgage, loan origination, servicing, or financial services data is a plus.
  
  
  

About Company:

Company is a leading provider of data, models, and technology solutions for loans, mortgage

servicing rights (MSRs), structured products, and private credit. Our cloud-native Edge platform

integrates powerful analytics, data visualization, and predictive modeling capabilities to help clients make informed investment decisions. At Company, we combine deep domain expertise

with modern technology to deliver innovative solutions across the mortgage and structured

finance markets.

How to apply for this opportunity?

• Step 1: Click On Apply! And Register or Login on our portal.
• Step 2: Complete the Screening Form & Upload updated Resume
• Step 3: Increase your chances to get shortlisted & meet the client for the Interview!
  
  
  

About Uplers:

Our goal is to make hiring reliable, simple, and fast. Our role will be to help all our talents find and apply for relevant contractual onsite opportunities and progress in their career. We will support any grievances or challenges you may face during the engagement.

(Note: There are many more opportunities apart from this on the portal. Depending on the assessments you clear, you can apply for them as well).

So, if you are ready for a new challenge, a great work environment, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you!