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

Q3BSNGV0bHpLbW0yREwrN3VSb2xzSnNWMmc9PQ==
  • 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

Bay Logistics, Inc.

Forklift Driver/Warehouseperson - 2nd Shift (Weekends) Job at Bay Logistics, Inc.

Location: Coopersville, MI Shift:Weekends - 2nd Shift Reports to: Warehouse Supervisor Are you an experienced forklift operator who takes pride in doing the job right and doing it safely? We're looking for skilled operators to join our warehouse team and keep our operations... 

Domino's Franchise

Customer Service Rep $15.00 hourly Pay Job at Domino's Franchise

You'll be working for a company that's fun and flexible. Not to mention, it's work experience you're going to use for a long time to come. You've had our pizza delivered to you, now help us be the best in pizza delivery. Go on, boss, show us what you've got. Apply ...

Johns Hopkins Medicine

SPECIALTY TEAM LEADER (RN) - Sibley Ambulatory Surgery Center - Pre-Op / PACU Job at Johns Hopkins Medicine

 ...; a medical building with physician offices and ambulatory surgery and imaging centers; and the new patient tower with 200 spacious, private rooms...  ...accredited nursing program, BSN strongly preferred ~ Active RN license in the District of Columbia ~ BLS CPR... 

American Income Life Insurance Company

Entry Level Financial Services - Work From Home Job at American Income Life Insurance Company

 ...communication skills Basic computer knowledge Work ethics Outgoing, fun & energetic with...  ...Job Benefits: Full Benefits Paid weekly ($70,000 $75,000 1st year average)...  ...relationships with clients and meet them where they are most comfortable: their homes... 

DAYBREAKER

Graphic Design Internship '23 Job at DAYBREAKER

 ...unique experiences around the world you can consider these folks your new global family Invitations to exclusive events such as art exhibitions, underground dance parties, startup mixers, family dinners, and mindful experiences Build on support from our PR team,...