Senior Data Engineer

United StatesHybridContractSeniorPosted 2 months agoVisa sponsorship available

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

We are seeking an experienced Data Engineer / Database Developer with T-SQL and SQL Server expertise, specifically within the BFSI domain. The role involves building and maintaining data systems for critical financial operations, reporting, compliance, and analytics. Responsibilities include designing high-performance databases, writing complex T-SQL, developing ETL pipelines for financial data integration, performing data modeling, optimizing database performance, and ensuring data accuracy and compliance with financial regulations. Collaboration with stakeholders and troubleshooting data issues are also key aspects of this position.

Job Title: Data Engineer / Database Developer (T-SQL) – BFSI Domain

Location: New York/New jersey

Job Summary

We are looking for an experienced Data Engineer / Database Developer with strong expertise in T-SQL and SQL Server, along with hands-on experience in the BFSI domain. The candidate will work on building and maintaining data systems that support critical financial operations, reporting, compliance, and analytics.

Key Responsibilities

Design and develop high-performance SQL Server databases for banking/financial systems

Write complex T-SQL queries, stored procedures, views, and triggers

Build and maintain ETL pipelines for financial data integration (transactions, accounts, customer data)

Perform data modeling for financial datasets (transactions, risk, reporting)

Optimize database performance using indexing, partitioning, and query tuning

Ensure data accuracy, integrity, and compliance with financial regulations

Support regulatory and compliance reporting (audit, risk, fraud detection)

Collaborate with business stakeholders, risk teams, and analysts

Troubleshoot data issues and production incidents in financial systems

Required Skills

Strong hands-on experience with T-SQL programming

Experience with Microsoft SQL Server (2012/2016/2019/2022)

Solid understanding of database design and development

Experience in ETL development (SSIS or similar tools)

Strong expertise in performance tuning and query optimization

Knowledge of data warehousing concepts (star/snowflake schemas)

Experience working with large-scale transactional data systems

BFSI Domain Experience (MANDATORY / PREFERRED)

Experience working in Banking / Financial Services / Insurance projects

Familiarity with:

Core banking systems

Payments, transactions, and reconciliation systems

Risk, compliance, and regulatory reporting (e.g., AML, KYC)

Financial data security and audit requirements

Preferred Skills

Experience with Azure Data Services (Azure SQL, ADF, Synapse)

Knowledge of Power BI / SSRS for financial reporting

Experience with Python or scripting for data processing

Exposure to big data technologies (Spark, Hadoop)

Experience in Agile/Scrum environments

Qualifications

Bachelor’s degree in Computer Science, IT, Finance, or related field

10+ years of experience in data engineering / database development

Prior experience in BFSI domain projects is highly preferred

Ready to apply?

You'll be redirected to Kaav Inc's application page.

Is this role right for you?

Role summary

Similar roles