Data Analyst: Data Mapping, Pipelines & Azure SQL

JIT Global Freight Solution P Ltd; Arlington (VA); On-site; USD 65,000 - 90,000; Full time

Job summary

JIT Global Freight Solution P Ltd is seeking a Data Analyst in Arlington, VA to map data elements between source and target stores, and to produce STTM and design documentation. The role emphasizes collaboration with multiple teams to translate business needs into technical requirements and to document data gaps.

The ideal candidate will write SQL queries to profile data in cloud platforms and databases, supporting data pipelines and testing efforts in a banking context.

Qualifications

• Review source and destination data stores and map data elements.
• Prepare and maintain Source to Target Mapping (STTM) and design documents.
• Identify data gaps and document them in detail.
• Write mapping documents to guide data pipelines developers and testers.
• Identify the new source system based on client roadmap.
• Collaborate with cross-functional teams to align on requirements.
• Translate business requirements into technical specifications.
• Write SQL queries to profile data in the Cloud Platform & Databases.

Responsibilities

• Review data stores and map elements between systems.
• Prepare detailed STTM and design documents.
• Identify and document data gaps and remediation steps.
• Create mapping docs to support data pipelines development and testing.
• Identify new source systems per client direction.
• Collaborate with teams to ensure alignment on requirements.
• Convert business requirements into technical requirements and specs.
• Profile data in cloud databases using SQL.

Skills

Azure Data Analytics

STTM

Requirements Analysis

Banking

Stakeholder engagement

Azure Boards

SQL

Job description

JIT Global Freight Solution P Ltd is seeking a Data Analyst in Arlington, VA to map data elements between source and target stores, and to produce STTM and design documentation. The role emphasizes collaboration with multiple teams to translate business needs into technical requirements and to document data gaps.

The ideal candidate will write SQL queries to profile data in cloud platforms and databases, supporting data pipelines and testing efforts in a banking context.