Data Integration Analyst

Akin (formerly Childhaven)•Seattle, WA

4d•$110,000 - $130,000•Hybrid

About The Position

Akin is looking for an experienced Data Integration Analyst who enjoys solving complex data challenges, digging into the details, and making sure information moves accurately and reliably between systems. This is a time-limited position that is currently budgeted through June 2027. In this role, you’ll play a key part in system implementations, upgrades, and data migration projects across the organization. You’ll work with legacy and new systems to map, cleanse, transform, migrate, reconcile, and validate data—helping ensure that the information our teams rely on is complete, accurate, and ready to use. This is an ideal opportunity for someone who is highly analytical, technically skilled, and energized by solving data problems. If you enjoy figuring out why numbers don’t match, building SQL queries to get to the root of an issue, and creating repeatable processes that make data more trustworthy, we’d love to hear from you.

Requirements

Bachelor’s degree in Data Science, Information Systems, Computer Science, Statistics, or a related field, or equivalent practical experience.
At least 3 years of experience in data conversion, migration, ETL, or data analysis.
Advanced SQL proficiency, including experience writing and optimizing complex queries, joins, and scripts across multiple systems.
Experience with data mapping, reconciliation, validation, and migration between legacy and target systems.
Strong Excel skills, including formulas, pivot tables, and lookups.
Working knowledge of data dictionaries, metadata, and field-level documentation.
Strong analytical and problem-solving skills, particularly when investigating data discrepancies or quality concerns.
Excellent attention to detail and a methodical approach to documenting processes.
Strong written and verbal communication skills, including the ability to explain data findings to non-technical audiences.
Ability to independently manage multiple priorities and data projects in a deadline-driven environment.

Nice To Haves

ETL tools such as SSIS, Talend, Informatica, or similar platforms.
Scripting or programming languages used for data work, such as Python, PowerShell, or R.
System implementations or migrations involving platforms such as CRM or EHR systems.
Data governance, data quality, data cataloging, or metadata management practices.
Building monitoring, exception, or reconciliation reports.
BI and visualization tools such as Power BI or Crystal Reports.

Responsibilities

Planning and executing data migrations and conversions for new systems, system upgrades, and platform consolidations.
Analyzing legacy systems and developing clear source-to-target data mappings.
Building and running ETL processes to extract, cleanse, transform, and load data between systems.
Writing and optimizing SQL queries and scripts for complex data extraction, transformation, validation, and reconciliation.
Performing pre- and post-conversion validation to ensure data is complete, accurate, and ready for use.
Investigating discrepancies, failed reconciliations, integration issues, and other data challenges to identify root causes and solutions.
Profiling data to uncover anomalies, gaps, trends, and potential quality risks before and during migrations.
Developing monitoring, exception, reconciliation, and conversion-status reports to identify issues early.
Supporting user acceptance testing and post-go-live data validation.
Creating thorough technical documentation, including data mappings, transformation logic, procedures, specifications, and runbooks.
Partnering with technical teams, project managers, and business stakeholders to understand requirements and successfully deliver data conversion projects.
Collaborating with Akin’s data and technology professionals to ensure converted data meets established quality and governance standards and is ready for downstream reporting and analysis.