What are the responsibilities and job description for the Data Anlayst position at Surge IT?
Summary
The Data Analyst will support a large-scale modernization effort to migrate legacy Sybase databases to Amazon RDS for PostgreSQL. This role focuses on understanding existing legacy data structures, profiling and validating data migrations, and ensuring that downstream applications and analytics pipelines continue functioning without disruption. The analyst will work closely with engineering and modernization teams to analyze legacy schemas, validate migrated data, and support AI-assisted code and schema conversion using tools such as Amazon Bedrock and Claude.
Required Skills
The Data Analyst will support a large-scale modernization effort to migrate legacy Sybase databases to Amazon RDS for PostgreSQL. This role focuses on understanding existing legacy data structures, profiling and validating data migrations, and ensuring that downstream applications and analytics pipelines continue functioning without disruption. The analyst will work closely with engineering and modernization teams to analyze legacy schemas, validate migrated data, and support AI-assisted code and schema conversion using tools such as Amazon Bedrock and Claude.
Required Skills
- Strong experience with relational databases, including data modeling, profiling, schema analysis, and complex SQL queries.
- Handson experience working with legacy systems such as Sybase ASE and modern relational systems such as PostgreSQL.
- Ability to analyze existing stored procedures, triggers, and SQL logic to understand data flows and downstream dependencies.
- Experience validating data migrations including row counts, referential integrity, constraints, and transformation logic.
- Experience with AIassisted code analysis or migration tools, such as Amazon Bedrock and Claude.
- Ability to support stakeholder meetings and coordinate with data stewards to ensure all data migration activities are completed as expected and that no downstream dependencies are impacted.
- Support stakeholder meetings and coordinate with data stewards to validate and ensure the accuracy of all data migration activities to keep migration on track.
- Experience documenting data dictionaries, lineage, and data dependency mappings.
- Strong communication, analytical thinking, and problem‑solving skills.
- Ability to collaborate with backend engineers, cloud architects, and analytics teams in an Agile environment.
- Experience with AWS services such as RDS, DMS, and data pipeline tools.
- Exposure to domaindriven design concepts and microservicesoriented data architectures.
- Familiarity with SybasetoPostgreSQL migration tooling such as AWS SCT.
- Understanding of downstream analytics ecosystems and how schema changes impact reporting.
- Experience supporting or collaborating with Java/Spring development teams.
- Experience with Gitbased version control systems such as GitHub or Bitbucket.
- Basic understanding of CI/CD and DevOps workflows.