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.

• 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