Data Mapping and Schema Analyst

Responsibilities

• Performs detailed analysis of inspection and correction data across multiple source systems, databases and applications to understand how data is structured, stored, maintained and used by the business.
• Researches source databases and system tables to identify table names, field names, relationships, data types, key values and data dependencies needed to support data conversion and migration work.
• Creates clear source-to-target data mappings that align legacy inspection and correction data to the new data model, schema and ingestion requirements for a modernized database environment.
• Works closely with business stakeholders, application teams, database administrators, data engineers and project teams to validate data definitions, resolve mapping questions and ensure data meaning is preserved during conversion.
• Identifies data gaps, inconsistencies, duplicates and quality issues that could impact successful ingestion into the new database, and documents recommended remediation steps.
• Translates business rules and operational inspection/correction processes into technical data requirements, including mapping logic, transformation rules and validation criteria.
• Develops and maintains detailed documentation, including data dictionaries, table inventories, mapping workbooks, schema alignment notes, conversion assumptions and open data issues.
• Supports data conversion planning, mock loads, validation activities and issue resolution to help ensure inspection and correction data is accurately prepared for ingestion into the new database.
• Works independently with strong attention to detail and follows through on complex data research assignments with minimal guidance.
• Acts as a knowledgeable resource for project team members by explaining source-system data structures, data lineage, table relationships and conversion impacts.

Requirements

• Requires a bachelor's degree in computer science, information systems, data management, engineering, mathematics, business technology or a related field, or equivalent experience.
• Typically five or more years of experience working with databases, data analysis, data mapping, data conversion, schema analysis or application data support.
• Experience analyzing relational databases and writing SQL queries to research tables, fields, joins, dependencies and data quality issues.
• Experience creating source-to-target mapping documentation, data dictionaries, table inventories or conversion specifications.
• Experience working across multiple business systems or legacy applications to understand data lineage, operational processes and system-of-record decisions.
• Preferred experience with inspection, correction, asset management, work management, field operations or utility data.
• Preferred experience with Microsoft SQL Server, Oracle, cloud databases, data integration tools or reporting/query tools.

Skills

• Advanced attention to detail and ability to work accurately with complex data across multiple systems.
• Advanced analytical thinking skills, including the ability to investigate data issues, identify patterns, trace data lineage and draw clear conclusions from technical research.
• Strong knowledge of relational database concepts, including tables, fields, keys, joins, data types and schema relationships.
• Strong SQL skills for querying, profiling, validating and reconciling data from source systems.
• Working knowledge of data modeling, schema design, data transformation and data ingestion concepts.
• Ability to create clear and complete source-to-target mapping documentation that can be used by data engineering, development and testing teams.
• Ability to understand business processes and translate operational rules into data requirements, mapping