Enter a job title or keyword
Sr. Data Analyst – ETL, SQL, AWS Glue
Job Location:
Job Location:
Portland, TX - USA
Monthly Salary:
Not provided by the employer
Monthly Salary:
Posted:
18 September 2026 (2 days ago)
Posted:
Application Deadline:
16 December 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
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 bachelors 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
Required Experience:
Senior IC
About Company
Advance Your Business Goals Through Valuable IT Solutions Command Your Market Share Through Digital Transformation Advance Your Career at Mavensoft...Read More
