Description:
Lead data discovery and requirements of new data ingestions, conduct in depth analysis for source to target mapping, develop data dictionaries, and perform data testing and validation.
Business Skills:
- Collaborate with business stakeholders to gather and document data requirements and reporting needs.
- Partners and works effectively with business SMEs and facilitate conversations efficiently
- Manages efforts effectively with the ability to pro-actively seek prioritization of work
- Works independently to lead and manage workstreams with minimal supervision
Gathers and documents data requirements and reporting needs.
- Communicates effectively through various channels (meetings, chat, email, in-person)
- Works effectively with business SMEs and facilitates conversations efficiently
- Manages their time effectively with the ability to proactively seek prioritization of work
- Initiates and facilitates conversations based on needs and next steps to meet deliverables
- Knowledge of Mortgage Industry, Single Family and Multi-Family preferred
Technical skills:
- SQL advanced knowledge
- Advanced data profiling and data analysis (data quality, data reconciliation, data distribution)
- Advanced business requirements gathering and documentation with the ability to work with the technical team to translate business requirements to technical requirements
- Advanced testing data validation, test execution, regression testing
- SQL Server Data Management Studios (navigation, read/write/execute queries)
- SQL Server Reporting Services (navigate reports as read-only)
- Microsoft PowerBI (navigate and filter reports as read only)
- Intermediate/Advanced Microsoft Office Suite of Tools
Experience:
- Minimum 8 years of data analysis, requirements definition, and data warehouse build experience
- Minimum 8 years hands on working experience with intermediate to advanced level SQL
- Minimum 5 years of working knowledge of basic PowerBI and SSRS reporting tools
- Minimum 8 years experience performing data validation and testing
- Minimum 5 years of leading teams to perform data research, analysis, and validation