Sr. Data Analyst – ETL, SQL, AWS Glue

Mavensoft Technologies.; Portland (OR); Hybrid; USD 90,000 - 135,000; Full time

Job summary

Mavensoft Technologies. in Portland, OR is seeking an experienced Sr.

Data Analyst focusing on data migration, mapping and ETL to support a modernization project for inspection and correction data across multiple source systems. You will design mappings, work with stakeholders and data engineers to ensure data lineage and quality, and document schemas, rules and validation criteria for successful ingestion into the new database.

Qualifications

• Bachelor's degree in CS, IS, data management, engineering or related field.
• Five or more years of experience with databases, data analysis, mapping, conversion.
• Experience writing SQL and researching tables, joins and dependencies.
• Experience creating data dictionaries and conversion specifications.
• Experience across multiple business systems to understand data lineage and processes.

Responsibilities

• Analyzes inspection and correction data across multiple systems to understand structure and usage.
• Identifies tables, fields, relationships, data types and dependencies.
• Creates source-to-target mappings aligning legacy data to the new model.
• Collaborates with stakeholders and IT to validate definitions and preserve meaning.
• Identifies data gaps and quality issues and recommends remediation steps.
• Translates business rules into technical data requirements and mappings.
• Develops and maintains data dictionaries, inventories and mapping workbooks.
• Supports data conversion planning, mock loads, validation and issue resolution.

Skills

Relational database analysis

Source-to-target mappings

Attention to detail

Data quality profiling

Education

Bachelor's degree in Computer Science / Information Systems / related field

Tools

Microsoft SQL Server

Oracle

Cloud databases

Data integration tools

SQL queries

Job description

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

• 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.

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.

Top 3 Must-Haves :

• 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