Junior Data Analyst - Data Transformation Program Job at Alignity Solutions, McLean, VA

Y21YVytMMzJyK3gxSnJpVGJnQ0NRcDJmMGc9PQ==
  • Alignity Solutions
  • McLean, VA

Job Description

Job Description

Job Description


Do you love a career where you Experience
, Grow & Contribute at the same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you.

Learn how we are redefining the meaning of work , and be a part of the team raved by Clients, Job-seekers and Employees.

  • Jobseeker Video Testimonials
  • Employee Glassdoor Reviews

If you are a Data Analyst, looking for excitement, challenge and stability in your work, then you would be glad to come across this page.

We are an IT Solutions Integrator/Consulting Firm helping our clients hire the right professional for an exciting long term project. Here are a few details.

Check if you are up for maximizing your earning/growth potential, leveraging our Disruptive Talent Solution.

Requirements


Role: Junior Data Analyst – Data Transformation Program
Location: McLean, VA
Experience: 1–3 Years

Employment Type: 1099 / C2H / W2

Position Overview:

We are seeking a detail-oriented and technically adept Junior Data Analyst to join our Data Transformation Program. The ideal candidate will bring strong analytical capabilities, a solid grasp of data profiling and transformation concepts, and hands-on experience with SQL and metadata documentation. This role will involve working with enterprise-level data systems, ETL processes, and metadata management tools such as Collibra, and requires close collaboration with data stewards, engineers, and business analysts.

Key Responsibilities:
  • Perform comprehensive data profiling to understand data structures, patterns, and quality issues across multiple sources.

  • Analyze and interpret ETL logic, primarily in IBM DataStage, to extract and document transformation rules and business logic.

  • Create and maintain detailed source-to-target mappings and transformation specifications supporting ingestion and migration processes.

  • Document and validate business rules, data lineage, and technical requirements across structured and semi-structured data environments.

  • Populate and manage metadata assets within Collibra, including data definitions, mappings, classifications, and business terms.

  • Collaborate with data stewards, engineers, and business analysts to ensure consistency with the Enterprise Business Model and governance frameworks.

  • Support data reconciliation, validation, and resolution of mapping and data quality issues throughout the lifecycle of the program.

  • Ensure all documentation adheres to standards and is structured to support regulatory, governance, and audit needs.

Required Experience & Skills:
  • 1–3 years of hands-on experience in a data analyst or technical business analyst capacity.

  • Proficiency in SQL for data exploration, profiling, querying, and validation.

  • Exposure to ETL tools, with the ability to interpret and document transformation logic (IBM DataStage experience highly preferred).

  • Strong experience preparing source-to-target mapping (STTM) documentation and business rule specifications.

  • Excellent analytical thinking, attention to detail, and structured documentation skills.

  • Familiarity with Collibra or similar tools for data governance and metadata management.

  • Competency in Excel and other structured formats for documentation and analysis.

Preferred Qualifications:
  • Exposure to data migration, data warehousing, or enterprise data modeling initiatives.

  • Familiarity with data governance, metadata standards, and data stewardship processes in large organizations.

  • Background in financial services, insurance, or regulatory compliance data environments.

  • Working knowledge of JSON, XML, or API-based data structures and formats.

Reporting Structure:

You will report to the Data Lead, Senior Data Analyst, or Program Manager, depending on project alignment.

Benefits
Visit us at Alignity Solutions is an Equal Opportunity Employer, M/F/V/D.

CEO Message: Click Here

Clients Testimonial: Click Here

Job Tags

Similar Jobs

Alaska Air Group

Flight Attendant - Japanese Language Qualified Job at Alaska Air Group

DescriptionAt Hawaiian Airlines, we are all about welcoming our guests with Hawaiian hospitality...  ...and mahalo for your interest in the Flight Attendant - Japanese Language Qualified position...  ...be legally authorized to work in the United StatesMust be in possession of a... 

Vannevar Labs

Mission Development Lead - Homeland Security Job at Vannevar Labs

Mission Development Lead - Homeland Security RemoteOur mission is to be the technology backbone for strategic competition against peer adversaries. These missions - including intelligence, information operations, special activities, and perception management - are happening... 

Curtiss-Wright

Mechanical Engineering Intern Job at Curtiss-Wright

We are looking for hard-working and highly motivated Mechanical Engineering students for summer internship or co-op positions. Our paid internship program gives students an opportunity to apply their skills while working on real-world projects. Previous students have... 

Anders Group

Travel PICC Registered Nurse Job at Anders Group

 ...Job Description Anders Group is seeking a travel nurse RN Interventional Radiology for a travel nursing job in Roseville, California...  ...amount to be determined. Posted job title: Registered Nurse - PICC @ Sutter Health Roseville Medical Center About Anders Group... 

Cascadia Global Security

Armed Security Supervisor Job at Cascadia Global Security

 ...About the position: Position: Armed Security Supervisor- retired/previous Law Enforcement background (preferred) Location: Sheridan, TX 77475 Employment type: Full Time Pay: $21 Daily pay options are available. Payout as soon as the next day! Hiring Immediately...