Business Data Analyst

PlanIT Group, LLC is a company focused on data solutions, and they are seeking a Business Data Analyst. The role involves performing data discovery, conducting in-depth analysis for source to target mapping, developing data dictionaries, and ensuring data testing and validation.

Responsibilities:

• 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

Requirements:

• Perform 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 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
• Intermediate/Advanced Microsoft Office Suite of Tools
• SQL Intermediate to advanced knowledge
• 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 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 requirements
• Intermediate testing data validation, test execution, regression testing
• Minimum 5 years of data analysis, requirements definition, and data warehouse build experience
• Minimum 5 years hands on working experience with intermediate to advanced level SQL
• Minimum 3 years of working knowledge of basic PowerBI and SSRS reporting tools
• Minimum 5 years experience performing data validation and testing
• Knowledge of Mortgage Industry, Single Family and Multi-Family preferred