Snowflake Data Engineer (Mid-Level & Senior)
Asterism IT Solutions
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Snow Flake Schema
- Mortgage
- Orchestration
- Payments
- Loan Servicing
- Management
- Microsoft Azure
- Google Cloud Platform
- LOS
- Loan Origination
- Finance
- GC
- Good Clinical Practice
- MSP
- Data Warehouse
- Extract, Transform, Load
- Python
- Data Extraction
- Data Link Layer
- Data Structure
- Regulatory Compliance
- Clustering
- Collaboration
- Collections
- Amazon Web Services
- Authorization
- Cloud Computing
- SQL Tuning
- Scripting
- Step-Functions
- Analytics
- Data Engineering
- ELT
- Reporting
- SQL
- Stored Procedures
- Underwriting
- API
Summary
- Design, build, and maintain automated ETL/ELT data pipelines integrating data from core mortgage systems into Snowflake.
- Write and optimize complex SQL queries, stored procedures, and transformations for high-volume financial data.
- Build custom data extraction, ingestion, and validation scripts using Python.
- Work directly with Loan Origination (LOS) and Loan Servicing data structures, including payments, escrow accounts, amortizations, and underwriting criteria.
- Ensure data consistency, pipeline reliability, and regulatory compliance across data warehouse layers.
- Collaborate with business analysts, reporting teams, and architects to build curated data models for executive reporting and analytics.
- Experience:
- Mid-Level: 5–7 years of data engineering experience.
- Senior Level: 12+ years of overall IT/data experience with extensive data warehousing depth.
- Mortgage Domain Expertise (Mandatory): Recent, hands-on experience handling Loan Origination Systems (LOS) or Loan Servicing data models (e.g., Encompass, MSP, Black Knight).
- Core Technical Stack:
- Advanced Snowflake (clustering, Snowpipe, virtual warehouses, data sharing).
- Expert-level SQL (performance tuning, complex joins, window functions).
- Solid Python scripting for data engineering and API integrations.
- Strong hands-on ETL/ELT architecture and pipeline development.
- Preferred / Nice-to-Have:
- Direct experience with mortgage payments, escrow tracking, collections, or underwriting pipelines.
- Cloud platform exposure (AWS, Azure, or Google Cloud Platform).
- Experience with orchestration tools (Airflow, dbt, or AWS Step Functions).
- Dice Id: 91173046
- Position Id: 9093547
- Posted 1 hour ago
Company Info
About Asterism IT Solutions
Asterism IT Solutions is a global IT services and consulting firm. Relationships. It’s what drives us. We believe in building strong, long-lasting partnerships with our clients and technology professionals. Our team connects top talent with leading organizations through a wide range of technology solutions, helping businesses grow—and careers thrive.
We find the right fit for our candidates across contract, contract-to-hire, and direct placement opportunities in software development, cloud, security, and more.
Tech professionals with strong technical skills and a vision for long-term career growth will feel right at home with Asterism.
For clients, Asterism offers flexible IT Staffing Services, helping you scale quickly with experienced professionals to support critical projects, address workload spikes, and meet specialized skill needs. Our Direct Hire services ensure permanent placements for key technical and leadership roles. We also deliver strategic IT Consulting—providing expert guidance on project planning, technology strategy, and execution across enterprise systems
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs