Overview
The Systems Data Analyst will play a crucial role in analyzing existing databases and data structures that underpin key business applications, aiding development teams in data migration and integration into modern cloud-based platforms. This position will focus on a specific legacy application, producing essential documentation and mapping to facilitate the application modernization and data transformation projects. The analyst will work closely with development and migration teams to ensure accurate understanding and planning of database transitions.
Responsibilities
- Analyze existing databases and data structures related to core business applications.
- Produce clear and detailed documentation for development teams on schemas, tables, relationships, and constraints.
- Create source-to-target mapping documentation for data migration initiatives.
- Perform reverse engineering of databases to understand logic used for data provision.
- Support application modernization efforts by providing insights on data transformation and integration.
Requirements
- Proven proficiency in SQL and experience interrogating data from various database platforms.
- Strong understanding of relational database concepts and experience in data modeling and design.
- Demonstrated experience in migrating data from relational databases to NoSQL databases, particularly CosmosDB.
- Familiarity with ETL, ELT, and data transformation methodologies.
- Experience with cloud platforms, especially Microsoft Azure, and modern data services.