View all jobs
Sr. Data Analyst – ETL, SQL, AWS Glue
Title: Sr. Data Analyst – ETL, SQL, AWS Glue
Location: Portland, OR – Hybrid – (Mon and Fri can be remote. Tues-Thurs is onsite)
Duration: 8 Months – W2 Role
We are seeking an experienced Sr. Data Analyst – Data Migration, Mapping to support a data modernization project focused on inspection and correction data across multiple source systems, databases, and applications.
Key Responsibilities
Location: Portland, OR – Hybrid – (Mon and Fri can be remote. Tues-Thurs is onsite)
Duration: 8 Months – W2 Role
We are seeking an experienced Sr. Data Analyst – Data Migration, Mapping to support a data modernization project focused on inspection and correction data across multiple source systems, databases, and applications.
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.
- Acts as a knowledgeable resource for project team members by explaining source-system data structures, data lineage, table relationships and conversion impacts.
- 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.
- 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