Senior Data Analyst: ETL, SQL, AWS Glue — Hybrid

Mavensoft Technologies, LLC; Portland (OR); On-site; USD 95,000 - 145,000; Full time

Job summary

Mavensoft Technologies, LLC is seeking a Sr. Data Analyst to support a data modernization project focused on inspection and correction data across multiple source systems, databases, and applications.

The role centers on migration, mapping, and ensuring data quality throughout the conversion process. Responsibilities include detailed data analysis, creating source-to-target mappings, validating definitions with stakeholders, and maintaining documentation such as data dictionaries and mapping

Qualifications

• Bachelor’s degree or equivalent experience in a related field.
• 5+ years of database, data analysis, mapping, or data conversion experience.
• Experience writing SQL queries to research tables, fields, joins, dependencies and data quality issues.

Responsibilities

• Analyze inspection and correction data across multiple sources to understand structure and use.
• Create source-to-target mappings aligning legacy data to the new model.
• Validate data definitions with stakeholders and resolve mapping questions.
• Identify data gaps and remediation steps to ensure quality.
• Document data dictionaries, mapping workbooks, and schema alignment notes.
• Support data conversion planning, mock loads, and validation activities.

Skills

Relational database analysis

Source-to-target mappings

Data quality profiling

Education

Bachelor's degree in Computer Science / Information Systems

Tools

Microsoft SQL Server

Oracle

Data integration tools

Job description

Mavensoft Technologies, LLC is seeking a Sr. Data Analyst to support a data modernization project focused on inspection and correction data across multiple source systems, databases, and applications.

The role centers on migration, mapping, and ensuring data quality throughout the conversion process. Responsibilities include detailed data analysis, creating source-to-target mappings, validating definitions with stakeholders, and maintaining documentation such as data dictionaries and mapping