Data Engineer u2013 MS SQL

Job_Description":"

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.

          Requirements Required Experience & Skills

          • Bachelor degree in Computer Science, Information Systems, or related technical discipline.

          • 36 years of experience in Data Engineering, Database Development, ETL Development, or Data Operations roles.

          • Strong hands-on expertise in writing advanced queries in MS SQL Server and Snowflake.

          • Extensive experience working with complex joins, stored procedures, functions, indexing, query optimization, CTEs, temporary tables, and performance tuning.

          • Strong experience in ETL/ELT processes, data transformation, and reconciliation workflows.

          • Experience working with large-scale structured financial or operational datasets.

          • Strong understanding of relational database concepts and data warehousing principles.

          • Experience handling data validation, data quality checks, and reconciliation processes.

          • Hands-on experience with Snowflake data loading, transformations, and performance optimization.

          • Exposure to orchestration or workflow tools such as Airflow or Dagster is an advantage.

          • Experience integrating and processing API-based datasets is preferred.

          • Prior experience working in FinTech, Lending, Financial Services, or similar domains is highly preferred.

          • Strong analytical thinking and problem-solving capabilities.

          • Excellent communication and stakeholder management skills.

          • Ability to work in a fast-paced, high-performance environment with strong attention to detail.
            Good to Have

            • Exposure to dbt-based transformation workflows

            • Understanding of AWS-based data environments

            • Experience with data reconciliation and operational reporting

            • Familiarity with financial, lending, or transactional datasets

            • Knowledge of production support and incident troubleshooting processes

              ","