Senior Data Engineer

Title: Senior Data Engineer

Location: Remote

Type: Contract

Our client is seeking a highly skilled and motivated Senior Data Engineer to take the lead in finalizing and enhancing our Snowflake cloud data warehouse platform. This pivotal role requires an experienced professional to complete the current build-out, architect new application‑side development, integrate core third‑party services including a pricing engine, and establish the data warehouse as the robust transaction hub and system of record for mortgage and real‑estate operations.

The ideal candidate will have deep expertise in Snowflake architecture and a strong ability to translate complex business requirements into high‑performance, scalable data solutions.

This role is 100% remote, supporting businesses across the US but following the Eastern Standard Time zone most of the time.

• Project Completion & Ownership:
  Drive the final stages of the existing Snowflake data warehouse implementation, ensuring all modules are operational, optimized, and align with business needs.
• Application Development:
  Lead the design and development of new application‑side data features, collaborating closely with front‑end and back‑end engineering teams to ensure seamless data flow and accessibility.
• Pricing Engine & Third‑Party Integration:
  Design, build, and maintain robust data pipelines and APIs to integrate a new third‑party pricing engine and other external services into the central data ecosystem.
• Transaction Hub/System of Record:
  Establish and maintain the Snowflake data warehouse as the definitive system of record and transaction hub, ensuring data integrity, accuracy, and compliance with all relevant industry regulations.
• ETL/ELT Pipeline Management:
  Develop, optimize, and maintain scalable ETL / ELT processes using modern data integration and orchestration tools (e.g., dbt, Airflow, Python).
• Performance Optimization:
  Fine‑tune SQL queries, data models, and overall data warehouse performance to ensure efficiency, reliability, and cost‑effectiveness.
• Data Governance & Quality:
  Implement best practices for data quality, governance, security, and role-based access control (RBAC) within the Snowflake environment.
• Collaboration & Mentorship:
  Work with cross‑functional stakeholders including analysts, product managers, and data scientists, while also providing technical guidance and mentorship to junior team members.

• Experience:
  
  Progressive experience in data engineering or data system development, with a proven track record of designing and implementing enterprise‑scale data warehouse solutions.
• Snowflake Expertise:
  Deep expertise and 2+ years of experience with the Snowflake platform, including architecture, performance tuning, SnowSQL, stored procedures, Streams, and Tasks.
• Programming & Scripting:
  Strong proficiency in Python and expert‑level SQL skills are essential for data manipulation, automation, and complex querying.
• Cloud Platforms:
  Hands‑on experience with major cloud platforms and related data services.
• Data Modeling:
  Strong understanding of data modeling principles (dimensional modeling, star schema) and database design.
• Tools:
  Familiarity with data orchestration tools and CI/CD pipelines is a plus.
• Domain Knowledge:
  Prior experience within the mortgage, finance, or real‑estate industries is highly desirable, especially with systems of record or pricing engines.
• Communication
  
  Skills:
  
  Ability to translate technical knowledge and communicate with business team.
• Dev Ops:
  Some experience with Dev Ops is preferred.