Senior Data Analyst: SQL, PowerBI & Data Quality

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

Job summary

PlanIT Group, LLC is seeking a data analyst to drive data discovery, gather requirements, map source to target, and build comprehensive data dictionaries. You will perform rigorous data testing and validation to ensure data quality across the data warehouse.

The role requires collaboration with business SMEs, proactive prioritization, and strong SQL/SSRS/Power BI skills. Mortgage industry knowledge is preferred and MS Office proficiency is essential.

Qualifications

• 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.
• Intermediate data profiling, data quality, reconciliation, and distribution experience.
• Strong ability to translate business requirements into technical specs for the data team.

Responsibilities

• Gathers and documents data requirements and reporting needs.
• Performs data discovery, source-to-target mapping, and data dictionary development.
• Conducts data testing and validation to ensure data quality.
• Communicates effectively with business SMEs and stakeholders across channels.
• Facilitates conversations to prioritize work and meet deliverables.
• Supports data governance and data warehouse initiatives with SQL and reporting tools.

Skills

Data discovery

Requirements gathering

Data analysis

Data profiling

Data validation

Data mapping

Communication

Time management

SME collaboration

Mortgage industry knowledge

U.S. mortgage domain knowledge

Requirements translation

Test planning

Team coordination

Tools

SQL Server Management Studio

SQL

SSRS

Power BI

Microsoft Office Suite

Job description

PlanIT Group, LLC is seeking a data analyst to drive data discovery, gather requirements, map source to target, and build comprehensive data dictionaries. You will perform rigorous data testing and validation to ensure data quality across the data warehouse.

The role requires collaboration with business SMEs, proactive prioritization, and strong SQL/SSRS/Power BI skills. Mortgage industry knowledge is preferred and MS Office proficiency is essential.