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.
-
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.
We are an IT Consulting Company specializing in transformative solutions. We provide comprehensive services including Enterprise Architecture, Application Modernization, and Talent Management. With a focus on innovation and efficiency, we empower businesses to navigate the complexities of the digital landscape. Our dedicated team of experts collaborates closely with clients to optimize their IT infrastructure, streamline applications, and cultivate a high-performing workforce. Through cutting-edge technologies and strategic insights, we drive sustainable growth and enhance operational excellence for organizations of all sizes.
