Data Analyst Specialist

Iconma

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
Today
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

ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.

  • Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
  • Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
  • Founded in 2000
  • 2000+ Employees

The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.

COMPANY SIZE
2,000 to 2,499 employees
INDUSTRY
Management Consulting Services
EMPLOYEE BENEFITS
401K, Employee Referral Program, Life Insurance
FOUNDED
2000
WEBSITE
https://www.iconma.com/