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

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

DLA Piper

Associate - Federal Judicial Clerks Only (Multi Office) Job at DLA Piper

 ...meaningful work and grow your career. Let's see what we can achieve. Together.**Summary**DLA Piper is seeking attorneys with recent federal judicial clerkship experience to join any of our U.S. DLA Piper offices. Qualified applicants must be completing their current... 

SHINE Systems

Digital Forensics Examiner Job at SHINE Systems

 ...Responsibilities include but are not limited to: Plans, coordinates and conducts the forensic examination and analysis of digital, electronic and mobile device data to include but not limited to: hard drives, thumb drives, memory cards, and cellular devices. Assists... 

Providence Health & Services

Patient Transporter Job at Providence Health & Services

 ...class benefits are uniquely designed to support you and your family in staying well, growing professionally, and achieving financial security. We take care of you, so you can focus on delivering our Mission of caring for everyone, especially the most vulnerable in our... 

System One

Legal Assistant Job at System One

Job Title: Legal Assistant Location: Toms River, NJ Type: Direct Hire Compensation: $40000 - $50000 annually Contractor Work...  ...eager to learn the inner workings of a legal practice. Legal experience is not required we will provide on-the-job training for... 

Liberty Personnel Services, Inc.

Maintenance Manager Job at Liberty Personnel Services, Inc.

 ...Job Details: MAINTENANCE MANAGER Join a dynamic organization where your skills can truly make a difference. Our client is seeking a Maintenance Manager who is ready to take on challenges and ensure their manufacturing operation runs smoothly. You'll enjoy a competitive...