Sr. Business Data Analyst

PlanIT Group, LLC; Richmond (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

PlanIT Group, LLC is seeking a senior data analyst to lead data discovery and requirements for new data ingestions, map source to target, and develop data dictionaries. You will perform data testing and validation while collaborating with business stakeholders and SMEs to ensure data quality and alignment with reporting needs.

You will guide teams in data research, validation, and reconciliation, leveraging SQL, Power BI, SSRS, and SSMS to deliver reliable insights and scalable data solutions.

Qualifications

• 8+ years of data analysis, requirements definition, and data warehouse build experience.
• 8+ years hands-on SQL experience (intermediate to advanced).
• 5+ years leading teams in data research, analysis and validation.
• Experience with PowerBI and SSRS reporting tools.
• Experience with data validation, testing, and data reconciliation.

Responsibilities

• Lead data discovery and requirements for new data ingestions.
• Develop data dictionaries and data quality controls.
• Perform data testing, validation, and reconciliation.
• Collaborate with stakeholders and manage workstreams with minimal supervision.

Skills

SQL

Data profiling

Requirements gathering

Testing & validation

SSMS

SSRS

Power BI

MS Office

Tools

Power BI

SSRS

SSMS

Job description

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.

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