Senior Data Analyst: ETL, SQL & AWS Glue (Hybrid)

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

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.