Data Analyst
Core
Investigating existing data structures, analyzing business logic in queries/reports, mapping source data to target systems, and collaborating with stakeholders for a large-scale data migration.
Role type
Data Analyst (Data Migration & Integration)
Builds
Data migration and integration initiatives
Domain
Financial services / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis | research | client delivery | infrastructure | physical/clinical work
Required skills
SQL, data profiling, data mapping, data reconciliation, data dictionary creation, gap analysis, reverse engineering business logic, stakeholder communication
Preferred skills
Snowflake, ETL/ELT processes, dashboard tools (Sigma), code repository systems (Bitbucket/Git)
Technologies
SQL, Snowflake, Sigma, Bitbucket, Git
Responsibilities
Investigate source systems and databases to understand data structures and logic; Analyze existing SQL queries and stored procedures to reverse engineer business rules; Map source fields to target model requirements; Identify gaps, data quality issues, and transformation needs; Partner with business SMEs to clarify definitions and requirements; Produce detailed data dictionaries, mapping documents, and gap analysis reports; Support data validation and reconciliation efforts during development and UAT.
Seniority
Mid-level, hands-on IC
