Data Architect
We are working with a global media brand looking to add a Data Architect to their team. This position will be responsible for developing, optimising, and overseeing our client's conceptual and logical data systems. They have a myriad of legacy and siloed data systems that need to be migrated into their new centralised structure. Working with the Global Data Engineering team, Analysts, and Business Systems team, this role will deliver technical recommendations and solutions which enable the business to continue the enrichment and accessibility of data assets.
The role:
- Design and implement effective database solutions and end-to-end models for data consumption and analysis
- Examine and identify database structural needs by evaluating operational processes, applications and programming
- Assess database implementation procedures to ensure compliance with internal and external (legal) regulations
- Prepare accurate database design and architecture reports (effectiveness and accuracy) for management and executive teams.
- Oversee the migration of data from legacy systems to new solutions
- Monitor system performance by performing regular tests, troubleshooting, and integrating new features
- Create and maintain database documentation, including data standards, procedures, and definitions for the data dictionary (metadata)
- Ensure that storage and archiving procedures are functioning correctly
- Develop, manage, and test backup and recovery plans
- Develop and maintain security and disaster recovery of the database and create standards to ensure that the system is safe
- Research and discover new methods to acquire data
Requirements:
- AWS: S3 + Glue + Athena
- SQL Server, RDBMS such as PostgreSQL
- Spark SQL, Python, and Python libraries such as Pandas
- Proven experience of ETL design and delivery (SISS or similar tools)
- Experience in designing, building, managing, and maintaining data warehouse, data mart, customer data platform (CDP), and/or data lake architecture
- Proven experience of data migration
- Experience with BI and data visualisation tools, particularly Looker and Tableau
- Experience in working across end-to-end software development, technology, or consulting projects (strategy, discovery, design, development, and deployment)
If your skill set matches the requirements, please email your CV to Chris Bouroutzis on chris.bouroutzis@handle.co.uk.
Handle actively welcomes applicants from under-represented backgrounds
PLEASE NOTE: Due to the high volume of applications we receive we are unable to respond to everyone. If you have not heard from us within 5 working days of sending your CV then unfortunately you have not been shortlisted for the position you have applied for.
