Senior Data Analyst for mortgage domain

Verified Job On Employer Career Site

Job Summary:

RiskSpan is a leading source of analytics, modeling, data, and risk management solutions for the Consumer and Institutional Finance industries. They are seeking a highly experienced Data Analyst IV to translate complex business requirements into scalable data solutions, focusing on database, ETL, and analytics initiatives.

Responsibilities:

• Analyze and translate high-level business requirements into detailed database and ETL specifications (including source-to-target mappings).

• Partner with business users and technical teams to gather and validate requirements for data ingestion and transformation.

• Support the design and documentation of data workflows, pipelines, and models across on-prem and cloud (AWS) environments.

• Write and execute SQL queries to perform data validation, profiling, and reconciliation.

• Lead user acceptance testing (UAT), including developing test cases, scripts, and results documentation.

• Document business processes and database functionality to ensure traceability and repeatability.

• Collaborate with ETL developers, QA teams, and business stakeholders to resolve data issues and ensure quality deliverables.

• Leverage testing tools such as HP Quality Center (or similar) for defect tracking and resolution.

• Provide senior-level support in escalating and resolving complex data issues across multiple projects.

• Mentor junior analysts and contribute to standards and best practices for data analysis across the organization.

Qualifications:

Required:

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related technical field.

• 5 years of experience in software development and data analysis, ideally within financial services or highly regulated environments.

• Expert-level SQL skills and experience querying large relational databases.

• Advanced Python scripting experience for data manipulation and analysis.

• Demonstrated experience working in AWS-based environments (e.g., S3, Redshift, Lambda, Glue).

• Strong understanding of SDLC and agile methodologies.

• Exceptional analytical and critical thinking skills with strong attention to detail.

• Excellent written and verbal communication skills for technical and non-technical audiences.

• Strong multitasking capabilities and ability to manage multiple projects and priorities in parallel.

• Familiarity with QA/test management tools such as HP/Mercury Quality Center or similar.

Preferred:

• Professional certifications in AWS, Python, or data analytics.

• Experience in financial modeling, regulatory reporting, or risk analytics.

• Familiarity with BI/reporting tools (Tableau, Power BI) a plus.

Company:

RiskSpan Provides Risk Advisory, Managed Analytics And Technology Solutions. Founded in 2001, the company is headquartered in Arlington, Virginia, USA, with a team of 51-200 employees. The company is currently Growth Stage.