You will play a critical role in understanding the data required for migration, cleansing, viewing and ultimately reporting. You will work closely with transactional systems business analysts to build logical/physical data models for the department’s business processes and manage common data model that satisfies requirements.
Key Responsibilities
Support, maintain and operate a Microsoft Azure-based ETL framework
Support multiple business data migration go-lives and post go-live data reconciliation activities
Undertake data mapping against an ICT solution and identify the delivery of data sets to support Product delivery.
Participate in data extract, transformation and migration activities
Work with development teams and other skilled analysts to validate functionality against the data requirements
Provide timely, strategic and expert advice regarding data requirements, information requirements, business impacts, scope management, and project risks
Manage the delivery of work to a schedule and assist in the setting and managing of expectations
Apply standardised templates, methodologies and processes for data analysis activities and related project documentation
Contribute to business integration, change management, and testing
Essential requirements
Data and ETL experience especially with Microsoft Azure Cloud Data Platform (Azure Data Factory, Azure Synapse, Azure Dataverse)
Demonstrated ability to write complex SQL scripts, queries, and stored procedures to extract and mine data.
Demonstrated experience in data ingestion, cleansing, manipulation and modelling
Experience in eliciting, analysing, specifying, documenting and validating the business data needs of stakeholders.
Data/reports development skills and experience relevant to the position
Understanding and experience working with applications that utilise complex relational architecture
Experience working within a large, complex multi-disciplinary organisation
Proven ability to manage a large workload whilst maintaining high levels of accuracy