Data Engineer (JSON) Job at Professional Search Group, Burbank, CA

TmNtSEZZWDkzZi9VZGtQOGZvdTFBK3g0UHc9PQ==
  • Professional Search Group
  • Burbank, CA

Job Description

We are seeking an experienced Data Engineer for a 6-month temporary assignment to support data mapping, transformation, and standardization efforts across multiple data sources. This role is primarily focused on analyzing source data, defining mappings, and working directly with JSON-based data structures to ensure accuracy, consistency, and readiness for downstream use. The ideal candidate is detail-oriented, technically strong, and comfortable working in complex, multi-source data environments.

-Applicants must have experience with JSON in resume to be considered-

Key Responsibilities

  • Analyze and document data mappings between multiple source datasets and defined target schemas
  • Translate complex source data structures into standardized formats, ensuring data completeness and consistency
  • Build, parse, validate, and transform JSON files and payloads, including nested and semi-structured data
  • Support data preparation activities, including field normalization, transformation logic, and validation checks
  • Partner with technical and business stakeholders to clarify data definitions, rules, and mapping requirements
  • Identify data quality issues and work through root-cause analysis related to source data or mapping logic
  • Maintain clear technical documentation, including data dictionaries and mapping specifications
  • Participate in testing cycles to confirm mapped data aligns with defined requirements and expectations

Basic Qualifications

  • 5+ years of experience as a Data Engineer or in a similar data-focused technical role
  • Strong experience with data mapping across multiple systems or source files
  • Hands-on experience working with JSON (parsing, transformations, validation, nested structures)
  • Experience working with structured and semi-structured data formats
  • Strong attention to detail and ability to work through complex data scenarios
  • Ability to operate independently within a defined, time-bound project scope
  • Broader CRM platform experience (e.g., Salesforce like environments) was emphasized as more critical than specific vendor tools.

Preferred Qualifications

  • Experience supporting data migration, data preparation, or data standardization efforts
  • Familiarity with source-to-target mapping documentation and data dictionaries
  • Exposure to enterprise-scale datasets or HR / CRM / ATS data is a plus
  • Prior experience in contract or project-based roles

Required Education Bachelor’s Degree

Additional Information

  • The role supports a major technology implementation combining CRM and ATS systems, impacting Talent Connection and Enterprise Tech leadership.
  • The work focuses on data extraction, transformation, mapping, validation, and coordination with an external vendor that will execute the final data load
  • Experience with Phenom and Beamery is considered nice to have, not mandatory.

Core Responsibilities

  • Handle ~1M records, with a goal to reduce to 100k–200k records.
  • Extract data from legacy systems, clean/lens the data, map it to the new system, and validate post load accuracy.
  • Work with multiple file types and data structures (e.g., multiple pulls for people, pools/projects, tags, parquet-style files).
  • Vendor performs the actual load; the ND resource prepares and validates data

Job Tags

Contract work, Temporary work

Similar Jobs

US Government Jobs

SUPERVISORY AIRPLANE FLIGHT INSTRUCTOR Job at US Government Jobs

Job Title Air Reserve Technicians are full-time civilian employees who are also members of the Air Force Reserve unit in which they are employed. In addition to their civilian assignments, they are assigned to equivalent positions in the Reserve organization with a ...

Actalent

Scrum Master Job at Actalent

 ...Job Title: Scrum Master/Jira SpecialistJob Description We are seeking a Scrum Master/Jira Specialist to support a team of 4 Lead Scrum...  ...an average of one day onsite per week. Some weeks may be fully remote, while others may require multiple onsite days for internal... 

Net2Source (N2S)

Color Specialist Job at Net2Source (N2S)

 ...Hello Everyone, Our client is looking for highly collaborative Footwear Color Designer 2 with proven experience, strong problem-solving skills, and creativity. This ideal candidate blends creativity, technical mastery, and instinct to elevate kids + core footwear through... 

Sparix Global.

Teradata Developer Job at Sparix Global.

 ...Job Summary (List Format): - Develop, optimize, and maintain Teradata SQL queries, BTEQ scripts, and data processing workflows for large-scale data warehouses. - Design, build, and manage ETL processes to ensure efficient data integration and processing.... 

CRH

Dump Truck Driver Job at CRH

 ...Dump Truck Driver Texas Materials, a CRH company, is a leading supplier of aggregates, asphalt, ready mixed concrete, and paving and construction...  ...to perform each essential duty satisfactorily. Education/Experience Minimum of a high school diploma or general education...