Title: Data Mapping and Schema Analyst
Location: Hybrid - Mon and Fri can be remote. Tues-Thurs is onsite
Contract: W2 only, contract with potential for extension or conversion to full time with the client.
Pay: $60 - $65/hour + optional medical, dental, vision, 401(k) match
Overview
Performs detailed analysis of inspection and correction data across multiple source systems, databases, and applications to understand data structure, storage, and usage. Creates source-to-target data mappings, documents data definitions, and supports data conversion planning to ensure accurate data migration into a modernized database environment.
Key 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.
Required Skills
- Strong relational database analysis skills, including tables, fields, keys, joins, dependencies, and data quality profiling
- Experience creating source-to-target mappings, data dictionaries, table inventories, and conversion specifications
- Advanced attention to detail, analytical thinking, and ability to document/resolve complex data lineage and mapping issues
- Experience analyzing relational databases and writing SQL queries to research tables, fields, joins, dependencies, and data quality issues
- Ability to understand business processes and translate operational rules into data requirements, mapping logic, and validation criteria
- Strong documentation skills, including maintaining 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
Preferred Skills
- Experience with inspection, correction, asset management, work management, field operations, or utility data
- Experience with AWS Glue, cloud databases, data integration tools, or reporting/query tools
Why Should I Apply?
This role offers the opportunity to work on complex data migration projects supporting modernized database environments, with a focus on data integrity and quality. It is ideal for professionals with strong analytical skills and relational database expertise seeking impactful project work.
About CEI:
As a trusted technology partner, CEI delivers solutions that help our customers transform their business and achieve meaningful results. From strategy and custom application development through application management - our technology and digital experience services are tailored to meet each unique need of our customers. Our staffing solutions bring specialized skills to complement our customers' workforce and project requirements.
#ZR
#INDGEN
Never miss an opportunity! Create an alert based on the job you applied for.
