Description: |
Data Development - Manage deployment of changes, upgrades and bug fixes to databases, data lake and data warehouse
- Development of new AWS Data Lake
- Migrate customer orchestration solution to AWS Airflow
- Refine and extend system and ETL designs to improve accuracy, timeliness, completeness, and consistency
- Manage integration and maintenance of new data sources. Design, build and maintain data pipelines
- Code management, review and reversion using GitHub
Data Administration - Monitoring, diagnosis and troubleshooting orchestration including SSIS, Airflow, Spark, Scala, Kubernetes, AWS Orchestration, Python and Glue
- Security, key management, DR, performance, and cost monitoring of AWS solution including S3 and Athena
- Disaster Recovery planning, maintenance, and execution
- Design, develop and maintain non-production environments
- Design, develop and adhere to change control processes
- Administration of MSSQL Server RDS environment
- Upgrade of existing MSSQL Server environment including SSIS, SSAS, MDS
- Establish the needs of users, monitor user access and security, control access permissions and privileges
- Ensure that storage and archiving procedures are functioning correctly
- Develop, manage, and test back-up and recovery plans
- Manage the security and disaster recovery aspects of Databases and Data Lake
Data Governance - Align existing and new processes to defined design patterns and coding standards
- Maintain data standards, including adherence to the Data Protection Act
- Investigation, design and implementation of QA processes and reporting
- Protection of Personally Identifiable Information
- Design and develop GDPR processes
- Collation and maintenance of meta data about the Hearst Data Estate.
- Create and maintain documentation, including data standards, procedures, and definitions for the data dictionary (metadata)
- Maximise data value to the business
Application Support - Commission and install new applications and customise existing applications to make them fit for purpose
- SSRS, PowerBI, Tableau and Looker report editing and origination
- Data Warehouse (DW) maintenance and support. SSIS, SSAS, SQL Server for analysis on existing DW
- Design and development of replacement for existing MSSQL Data Warehouse and Cube
- Advice on back-end standards for new and existing applications and ETL
- Creation and maintenance of GDPR Compliant Development and Testing environments
- Design, implementation and monitoring of deployments along with co ordinating code, data and schema reversions when required.
Stakeholder Management - Liaise with developers, application owners and SMEs around DR, Security and Operational Requirements (including ETL timings)
- Liaise with data architect to move data estate to consolidate, simplify and document operational landscape
- Define and enforce standards for data quality
- Define and enforce code standards
- Liaise with 3rd party data suppliers to understand data structures / formats etc.
- Monitor performance and manage parameters to provide fast responses to front-end users
- Manage and respond to alerts and notifications around feeds to our Databases and Data Lake
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security
Team - Positive contributor to the wider Data & Technology team
- Training and mentoring of junior team members
- Provide wider business user support by responding to system issues within agreed SLAs
Leading from the front - To be an ambassador of Hearst and its values.
- You may be required to undertake such further duties as your skills, qualifications and experience allow and/or as may be assigned to you from time to time.
|