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

bjJESm5YQUxqdHF3WndGb0tQUGZtVkFMMFE9PQ==
  • Alignity Solutions
  • McLean, VA

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.

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

Contract work,

Similar Jobs

DHD Consulting

HR Generalist Job at DHD Consulting

SUMMARY The HR Generalist is responsible for a wide range of Human Resources support and administration covering recruitment, employment relations, office management, benefits, compliance, and employment law. JOB DUTIES : include but are not limited to the ...

State of Illinois

LOTTERY DRAWING SPECIALIST Job at State of Illinois

 ...Job Requisition ID:48699 Closing Date: 08/12/2025Agency: Department of the Lottery Class Title: LOTERY DRAWING SPECIALIST - 24410 Skill Option: None Bilingual Option: None Salary: Anticipated starting salary $4,586.00 monthly; Full Range $4,586.... 

Maxion Corp

Work At Home Data Entry - Remote Position- Administrative Assistant Job at Maxion Corp

 ...Join Our Team as a Work-From-Home Data Entry Research Panelist! Are you ready to...  ...Flexibility at Its Best: Work part-time or full-time, from anywhere, and on a schedule...  ...schedule that fits your life. No Experience? No Problem! Comprehensive training... 

Nannies of St James

SAN FRANCISCO, USA + travel: **Norland-trained** Live-in Nanny (sep accmd) G22 months Job at Nannies of St James

 ...FRANSISCO, USA + travel: G22 months - summer start ($$$$$ + separate accommodation)The sparkling sunshine state of California is calling for an...  ...while they work. This balance creates a productive yet stress-free setting, where everyone can collaborate effectively without... 

Costa d' Este Beach Resort & Spa

Valet Job at Costa d' Este Beach Resort & Spa

 ...site wellness programs, local discounts, and employee rates on hotel stays. In addition, Pyramid Global Hospitality is committed to...  ...Overview: Duties include expediting requests from guest for valet parking services. Parks and retrieves cars for guests. Requires good driving...