Data Engineer MS SQL & Snowflake

We are looking for a highly detail-oriented Data Engineer with strong expertise in MS SQL and Snowflake to support large-scale data transformation, reconciliation, validation, and data pipeline operations within a fast-paced FinTech/Lending environment.

This role will primarily focus on developing and optimizing SQL-based data processes, transforming and validating financial datasets, maintaining data integrity across systems, and supporting operational reporting requirements. The ideal candidate should possess strong experience handling complex datasets, writing advanced SQL queries, troubleshooting data inconsistencies, and supporting end-to-end ETL/ELT workflows.

This is a hands-on engineering role with strong emphasis on data processing, operational efficiency, and data quality rather than Data Science, Machine Learning, or advanced Analytics.

Key Responsibilities

Data Engineering & Transformation

• Develop, optimize, and maintain complex MS SQL and Snowflake queries for data extraction, transformation, reconciliation, and validation processes.
• Build and support ETL/ELT workflows for ingesting and transforming large-scale financial and operational datasets.
• Perform data cleansing, standardization, transformation, and aggregation activities across multiple data sources.
• Design and maintain efficient data processing pipelines to support business operations and reporting requirements.
• Troubleshoot and resolve data discrepancies, transformation failures, and performance bottlenecks.
  
  

Snowflake & Database Operations

• Work extensively with Snowflake for data transformation, staging, data loading, and query optimization activities.
• Develop and optimize stored procedures, views, CTEs, temporary tables, and complex joins in MS SQL Server and Snowflake.
• Support data migration and synchronization processes between multiple systems and databases.
• Monitor query performance and recommend improvements for efficient data processing and storage optimization.
  
  

Data Validation & Reconciliation

• Validate transformed datasets against source systems and business reports to ensure data accuracy and completeness.
• Perform reconciliation activities on loan-level, transactional, operational, and financial datasets.
• Investigate data mismatches, inconsistencies, and anomalies and coordinate resolution with internal teams.
• Ensure adherence to internal data quality standards and governance processes.
  
  

Process Improvement & Automation

• Identify opportunities to automate repetitive manual data processes and improve operational efficiency.
• Collaborate with Engineering, Operations, Credit, Finance, and Product teams to streamline data workflows.
• Support continuous improvement initiatives related to data architecture, query performance, and transformation logic.
  
  

Documentation & Collaboration

• Maintain documentation for data flows, transformation logic, reconciliation procedures, and database objects.
• Communicate technical issues, dependencies, and resolutions effectively to both technical and non-technical stakeholders.
• Work closely with cross-functional teams to understand operational data requirements and implement scalable solutions.