Mortgage Business Analyst with Data warehousing & SQL knowledge
Budget: $8 – $15 USD
- Strong Banking Domain (Commercial Lending & Mortgage) knowledge required (Black knight/Empower )
- Requirements gathering, documenting BRD & FRD, business process flow, workflow /swim lane diagrams using Visio
- Knowledge of Jira, Confluence
- Liaison with multiple stakeholders (business & technology & PMO office
- Strong Datawarehouse knowledge (OLAP, OLTP, Star/ snowflake schema, 3NF Denormalization, Dimensional modeling)
- Identify data elements for Loan Origination source systems to loan servicing & underwriting systems
- Ability to create custom & canned reports
- Data Analysis using SQL queries (strong)
- Data mapping skills (source to target)
- Data quality & metadata management
- Data Governance & Data Management skills
Environment: - Teradata
- Requirements gathering, documenting BRD & FRD, business process flow, workflow /swim lane diagrams using Visio
- Knowledge of Jira, Confluence
- Liaison with multiple stakeholders (business & technology & PMO office
- Strong Datawarehouse knowledge (OLAP, OLTP, Star/ snowflake schema, 3NF Denormalization, Dimensional modeling)
- Identify data elements for Loan Origination source systems to loan servicing & underwriting systems
- Ability to create custom & canned reports
- Data Analysis using SQL queries (strong)
- Data mapping skills (source to target)
- Data quality & metadata management
- Data Governance & Data Management skills
Environment: - Teradata