Conduct thorough and efficient SQL optimization to enhance database performance.
Identify and implement improvements in database queries for optimal data retrieval.
Develop processes for loading data from various sources into our data environment.
Ensure data integrity and accuracy during the loading process.
Perform data reconciliation to validate and ensure consistency across different data sets.
Troubleshoot and resolve any discrepancies identified during reconciliation.
Collaborate with business stakeholders to understand data mapping requirements.
Implement data mapping strategies to meet business needs and enhance data usability.
Design and execute ETL processes to facilitate seamless data integration.
Monitor and optimize ETL workflows to ensure efficiency and reliability.
Extract and integrate data from multiple sources to create comprehensive datasets.
Develop and maintain processes for efficient data extraction and consolidation.
Keep track of data migration projects providing regular updates on progress.
Document and report on the number of successful data migrations undertaken.
Demonstrate a high level of proficiency in writing complex SQL queries.
Utilize strong analytical skills to extract actionable insights from large datasets.
Proven experience in SQL optimization ETL processes and data reconciliation.
Strong proficiency in SQL and database management systems.
Familiarity with data mapping techniques based on business requirements.
Experience in pulling and integrating data from 23 diverse sources.
Previous involvement in data migration projects is a plus.
Qualifications:
Bachelors degree in Computer Science Information Technology or a related field.
We are looking for candidates who possess the ability to analyse data to improve quality and the efficiency of data systems.
- Interpret data analyse results using statistical techniques and provide reports & analytics.
- Develop and implement databases data collection systems data analytics and other strategies that optimize statistical efficiency and quality.
- Acquire data from primary or secondary data sources and maintain databases/data systems.
- Collaborate with the teams to provide insights into the usage behaviour and patterns to shape the product and define new process improvement opportunities.
- Work with management to prioritize business and information needs.
data,sql,data mapping,database,etl,etl,analytics,data migration,data reconciliation