Senior Data Analyst

Work sponsorship is available for this position. Job Title: Data Analyst Specialist Locations: Mclean, VA (5 days a week) Interview Type: In-Person Job Overview: Must Have Qualifications: Candidates must have 7+ years as a true Data Analyst. Must have experience in data analysis, advanced SQL, and Python. Experience extracting and analyzing data, building and maintaining data models and working with various data structures and database technologies. Strong communication skills are required and must be able to effectively collaborate with internal stakeholders at all levels. Experience with Snowflake and Databricks is nice to have. Key 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 o 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 • 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 o 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 o 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 Required Qualifications • Technical & Data Skills o 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 • Data Quality, Modeling & Analysis o Hands-on experience in data profiling and data quality assessments using both manual techniques and data quality tools • Proven ability to analyze large and complex datasets to identify patterns, anomalies, and inconsistencies • Experience validating data against enterprise data models, schemas, and business rules, ensuring alignment with target-state architectures • Data & Business Alignment • Strong understanding of data lifecycle management, IT business processes, and alignment of data to business objectives • Ability to interpret business requirements and support requirements analysis, with focus on upstream (producer) and downstream (consumer) data impacts during transformation initiatives • Collaboration & Communication • Strong facilitation and communication skills, with the ability to lead cross-functional discussions across business, data, and technology stakeholders • Demonstrated ability to partner with stakeholders to drive alignment and influence data-related outcomes Benefits: We offer a benefits package including medical, dental, vision, and 401(k). Compensation: $65.00 – $70.00 per hour. This is the targeted compensation range for this role per year. Please note that this range is provided as a guideline and the final offer will be based on several factors, including but not limited to, skillset and competencies, level of experience, education, certifications, and location. We are an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, national origin, age, disability, genetic information, veteran status, sexual orientation, gender identity, or any other characteristic protected by applicable federal, state, or local law.