Business Data Analyst

No VendorsNo C2C candidatesPerform 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.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 efficientlyManages their time effectively with the ability to proactively seek prioritization of workInitiates and facilitates conversations based on needs and next steps to meet deliverablesKnowledge of Mortgage Industry, Single Family and Multi-Family preferredIntermediate/Advanced Microsoft Office Suite of ToolsSQL Intermediate to advanced knowledgeSQL 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 data profiling and data analysis (data quality, data reconciliation, data distribution)Intermediate business requirements gathering and documentation with the ability to work with the technical team to translate business requirements to technical requirementsIntermediate testing data validation, test execution, regression testingMinimum 5 years of data analysis, requirements definition, and data warehouse build experienceMinimum 5 years hands on working experience with intermediate to advanced level SQLMinimum 3 years of working knowledge of basic PowerBI and SSRS reporting toolsMinimum 5 years experience performing data validation and testing