Data Analyst with Strong SQL

What Working at Hexaware offers:

Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.

Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profile. We complete the circle with excellent growth opportunities, chances to collaborate with highly visible customers, chances to work alongside bright brains, and the perfect work-life balance.

With an ever-expanding portfolio of capabilities, we delve deep into and identify the source of our motivation. Although technology is at the core of our solutions, it is still the people and their passion that fuel Hexaware s commitment towards creating smiles.

At Hexaware we encourage to challenge oneself to achieve full potential and propel growth. We trust and empower to disrupt the status quo and innovate for a better future. We encourage an open and inspiring culture that fosters learning and brings talented, passionate, and caring people together.

We are always interested in, and want to support, the professional and personal you. We offer a wide array of programs to help expand skills and supercharge careers. We help discover passion the driving force that makes one smile and innovate, create, and make a difference every day.

Role : Data Analyst with Strong SQL

Location: McLean, VA (5 Days Onsite)

We are looking for a Data Analyst with advanced SQL skills and strong **mortgage industry experience**. The candidate will analyze mortgage data, build complex SQL queries, support reporting and data validation, and work closely with business and technology teams across mortgage operations.

Key Responsibilities

• Analyze mortgage data across origination, underwriting, servicing, investor reporting, and compliance areas.
• Write and optimize complex SQL queries for data extraction, validation, reconciliation, and reporting.
• Perform data profiling, data mapping, data quality checks, and root-cause analysis.
• Gather and document business/data requirements from stakeholders.
• Create reports, dashboards, and ad hoc data extracts using BI/reporting tools.
• Validate data across source systems, data warehouses, and reporting platforms.
• Prepare source-to-target mapping, data dictionaries, and functional documentation.
• Support UAT activities, including test case preparation, SQL validation, and defect tracking.
• Collaborate with business users, data engineering, QA, and product teams.
• Required Skills
• Strong experience as a Data Analyst.
• Hands-on **mortgage industry experience** is required.
• Advanced SQL skills including joins, CTEs, window functions, stored procedures, views, and query optimization.
• Experience with relational databases such as SQL Server, Oracle, Snowflake, Teradata, or PostgreSQL.
• Strong understanding of mortgage lifecycle processes including loan origination, servicing, underwriting, investor reporting, and compliance.
• Experience with reporting tools such as Power BI, Tableau, Excel, or SSRS.
• Strong data analysis, data validation, reconciliation, and documentation skills.
• Excellent communication and stakeholder management skills.
• Preferred Skills
• Experience with mortgage platforms such as Encompass, Black Knight/MSP, LoanSphere, Empower, or Fiserv.
• Exposure to ETL, data warehouse, data mart, or cloud data platforms.
• Agile/Scrum experience is a plus.
• Mortgage domain experience.
• Strong hands-on experience with complex SQL and data validation.

Equal Opportunities Employer:

Hexaware Technologies is an equal opportunity employer. We are dedicated to providing a work environment free from discrimination and harassment. All employment decisions at Hexaware are based on business needs, job requirements, and individual qualifications. We do not discriminate based on race including colour, nationality, ethnic or national origin, religion or belief, sex, age, disability, marital status, sexual orientation, parental status, gender reassignment, or any other status protected by law. We encourage candidates of all backgrounds to apply.

Find out more at Hexaware.com.