Business Data Analyst in Banking Domain

Position: Business Data Analyst in Banking Domain

Location: Austin, TX (Preferred Locals to Austin, TX and Permanent residents of USA)

Duration: Long-Term Contract

Experience: 12 15+ Years

Key Skills: Data Analysis, strong SQL, ETL, Reporting, Azure Cloud and LoanIQ experience is a plus

Job Summary:

We are seeking an experienced Senior Data Analyst with 12 15+ years of experience in the Banking domain. The ideal candidate will have strong expertise in data analysis, advanced SQL, ETL, reporting, Azure Cloud, and banking data environments.

Candidates should have strong knowledge of commercial banking and lending operations, including loan servicing, loan transactions, loan balances, payments, interest, fees, commitments, and related banking processes. LoanIQ experience is highly preferred.

The candidate will work closely with banking business teams, data engineering teams, application teams, and reporting stakeholders to analyze complex banking data, ensure data quality, support reporting requirements, and deliver actionable insights.

Key Responsibilities:

• Perform advanced data analysis across banking and lending datasets.
• Analyze commercial banking data related to loans, loan accounts, commitments, payments, balances, interest, fees, and transactions.
• Develop complex SQL queries to extract, analyze, reconcile, and validate banking data.
• Analyze large datasets to identify data trends, discrepancies, anomalies, and data-quality issues.
• Work with business stakeholders to understand banking requirements and translate them into data and reporting solutions.
• Analyze data from banking applications and source systems supporting commercial lending and banking operations.
• Develop and validate ETL/ELT processes for banking data.
• Perform source-to-target validation, data reconciliation, data mapping, and data-quality analysis.
• Support development and maintenance of banking reports and operational reporting.
• Validate data used for loan, account, transaction, payment, and portfolio reporting.
• Investigate data discrepancies and perform root-cause analysis across banking systems.
• Support data migration, integration, and conversion activities involving banking applications.
• Work with Microsoft Azure cloud-based data platforms and banking data environments.
• Collaborate with data engineers, developers, business analysts, QA teams, and banking subject-matter experts.
• Support SIT/UAT by performing data validation, reconciliation, defect analysis, and reporting verification.
• Prepare technical and functional documentation including data mappings, business rules, data definitions, source-to-target mappings, and reporting specifications.
• Ensure banking data follows established data governance, data quality, security, and audit standards.

Required Technical Skills:

• 12 15+ years of experience in Data Analysis / Data Analytics.
• Strong and recent Banking domain experience.
• Advanced SQL skills.
• Strong experience with ETL/ELT processes.
• Strong experience in data analysis, data validation, reconciliation, and data quality.
• Strong experience with reporting and business intelligence.
• Experience working with Microsoft Azure cloud technologies.
• Strong understanding of relational databases, data warehouses, data models, and enterprise banking data.
• Experience working with large-scale banking datasets.
• Strong analytical and problem-solving capabilities.
• Excellent communication and stakeholder-management skills.