Data Analyst Specialist

ICONMA, LLC

McLean, VA

JOB DETAILS
SALARY
$56.28 Per Hour
SKILLS
Analysis Skills, Application Programming Interface (API), Business Model, Communication Skills, Cross-Functional, Data Analysis, Data Formats, Data Migration, Data Modeling, Data Profiling, Data Quality, Documentation, Financial Services, Health Plan, Identify Issues, JSON, Leadership, Metadata, Microsoft Excel, Pivot Tables, Problem Solving Skills, Python Programming/Scripting Language, REST (Representational State Transfer), Real Estate, Reconciliation, Relational Databases (RDBMS), SQL (Structured Query Language), Scripting (Scripting Languages), Structured Data, Team Player, Test Data, Test Strategy, Trend Analysis, XML (EXtensible Markup Language)
LOCATION
McLean, VA
POSTED
3 days ago
Our Client, a Real Estate and Financial Services company, is looking for a Data Analyst Specialist for their McLean, VA location.
 
Responsibilities:
  • Data Analysis & Pattern Identification
  • Extract, analyze, and interpret data from enterprise data stores and transactional  databases to identify trends, patterns, and anomalies
  • Validate data consistency and accuracy against defined enterprise data models and business rules
  • Proactively identify and investigate data discrepancies that may impact downstream consumers
  • Documenting differences between legacy and future state data 
  • Data Profiling & Quality Assessment:
  • Perform detailed data profiling (manual and tool-based) to assess data completeness, validity, and consistency
  • Leverage data profiling and data quality tools to automate validation where applicable
  • Document data quality issues, root causes, and recommended remediation actions
  • Cross-Functional Collaboration:
  • Work closely with data teams, application teams, and business stakeholders to
  • understand data flows, transformations, and dependencies
  • Facilitate working sessions to triage, analyze, and resolve identified data issues
  • Drive alignment on data definitions, ownership, and quality expectations across teams
  • Data Governance & Model Alignment:
  • Ensure data aligns with enterprise data models, standards, and governance frameworks under EBM
  • Support data reconciliation efforts across multiple data sources, particularly in transition or dual-data environments
  • Contribute to documentation of data lineage, transformations, and control points
  • Support transition of data ownership to producers in alignment with target-state operating model
  • Maintain metadata, including definitions, lineage, and sensitivity/criticality classifications
  • Communication & Issue Resolution:
  • Communicate findings, risks, and recommendations clearly to both technical and nontechnical stakeholders
  • Track issues, owners, and remediation timelines to ensure resolution
  • Prepare concise summaries and updates for leadership on data health and risks
  • Historic Data Migration:
  • Support planning and execution of historical data migration, including identification of anomalies and resolution strategies Validate and test data against target-state models to ensure operational readiness 
 
Requirements:
  • Technical & Data Skills
  • Strong experience working with relational and non-relational databases, including advanced SQL for complex data extraction, transformation, and analysis
  • Proficiency in Python for data analysis, validation, automation, and scripting to support data quality and reconciliation processes
  • Working knowledge of Excel (advanced functions, pivot tables) and experience handling semi-structured data formats (e.g., JSON, XML)
  • Experience integrating with and analyzing data from REST APIs
 
Why Should You Apply?

About the Company

I

ICONMA, LLC