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.
Job 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.
Job Competencies:
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 logic and validation criteria.
Strong documentation skills, including the ability to maintain data dictionaries, mapping workbooks, table inventories, issue logs and assumptions.
Strong collaboration skills and ability to work effectively with business users, database administrators, developers, data engineers, testers and project stakeholders.
Strong communication skills, including the ability to explain technical data findings in a clear, practical way for both technical and nontechnical audiences.
Strong problem-solving skills and persistence in researching unclear, incomplete or inconsistent data across legacy systems.
Ability to manage competing priorities, follow through on detailed assignments and raise risks or blockers early.
Numbers & Facts
Location
Portland, OR
Skills
Analysis Skillsunmatched
Asset Managementunmatched
Business Operationsunmatched
Business Processesunmatched
Business Skillsunmatched
Business Solutionsunmatched
Cloud Computingunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Data Analysisunmatched
Data Managementunmatched
Data Mappingunmatched
Data Migrationunmatched
Data Modelingunmatched
Data Processingunmatched
Data Qualityunmatched
Data Structuresunmatched
Database Administrationunmatched
Database Analysisunmatched
Database Designunmatched
Database Programmingunmatched
Database Report Toolsunmatched
Database Technologyunmatched
Detail Orientedunmatched
Documentationunmatched
Follow Throughunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Mathematicsunmatched
Microsoft SQL Serverunmatched
Operations Processesunmatched
Oracle Databaseunmatched
Problem Solving Skillsunmatched
Reconciliationunmatched
Relational Databases (RDBMS)unmatched
SQL (Structured Query Language)unmatched
Team Playerunmatched
Technical Researchunmatched
Test Plan/Scheduleunmatched
Testingunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.