Data Analyst Specialist

Zillion Technologies, Inc. • United State
Visa Sponsorship
Apply
AI Summary

Zillion Technologies seeks a Data Analyst Specialist to extract, analyze, and interpret enterprise data, ensuring alignment with data models and business rules. The role involves data profiling, quality assessment, cross-functional collaboration, and supporting historical data migration efforts. Candidates must have 7+ years of data analysis experience with advanced SQL and Python.

Key Highlights
7+ years of data analyst experience required
Advanced SQL and Python proficiency essential
Data governance and model alignment responsibilities
Key Responsibilities
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
Perform detailed data profiling to assess data completeness, validity, and consistency
Work closely with data teams, application teams, and business stakeholders to understand data flows, transformations, and dependencies
Ensure data aligns with enterprise data models, standards, and governance frameworks
Support planning and execution of historical data migration, including identification of anomalies and resolution strategies
Technical Skills Required
SQL Python Data Analysis
Benefits & Perks
Medical
Dental
Vision
401(k)
Nice to Have
Snowflake
Databricks

Job Description


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.


Similar Jobs

Explore other opportunities that match your interests

Senior Data Science Director - Analytics Leadership Role

Data Science
•
1h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Meta

United State

Manager, Data Science - Model Risk Office

Data Science
•
9h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Capital One

United State
Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

pioneer it systems

United State

Subscribe our newsletter

New Things Will Always Update Regularly