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

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

Northwest Energy Efficiency Alliance

Organizational Development Manager Job at Northwest Energy Efficiency Alliance

 ...Job Description Job Description The Organizational Development (OD) Manager is responsible for leading initiatives and implementing strategies that support talent development, leadership effectiveness, organizational change, employee engagement, and performance management... 

Ardent Health

Surgical Tech OR Job at Ardent Health

 ...,000 . Join our team as a variable shift, full-time, Surgical Technician OR in Albuquerque, NM . Why Join Us? Thrive in a People...  ...lines. Learn About a Day In the Life of a Surgical Tech: Responsibilities Assists surgeons with surgical procedures... 

DRC Systems

React Developer Job at DRC Systems

[No C2C/No H1B] Job Title : React Developer Location: Columbus, OH 7+ yr exp required React/JavaScript/Typescript/NodeJS/WebSocket is 80% of the role These are MUST HAVE Using AWS cloud (ECS/S3/ALB/NLB/Lambda) Should have some AWS experience Using... 

Forest Preserve District of DuPage County

Heavy Equipment Operator Job at Forest Preserve District of DuPage County

 ...Join the Forest Preserve District of DuPage County as a Heavy Equipment Operator in the Facilities Management Department and help care for...  ...subject to the terms and conditions outlined in the applicable union contract. To review the agreement, please visit the "Work... 

Intuit

Senior Business Tax Accountant - Work From Home - 3+ Yrs Paid Tax Experience Required Job at Intuit

OverviewAt Intuit we believe everyone should have the opportunity to prosper, which is why our mission is Powering Prosperity Around the World. Being a mission-driven company includes living our values everyday and nothing is more important to us than the success of our...