Data Architect

He Data Architect will be responsible for providing the design, development and delivery of the Company’s data warehouse, models and architecture to optimise data management. They will be responsible for building and maintaining data pipelines from source systems to the data warehouse and data lake, in line with Company standards and regulations
Key stakeholders:
Internal - Gaming and Hospitality segments, Central IT Team;
Business Support Team, Sunbet Team
External - Gaming Boards, Vendors, Testing Labs;
Data Providers
**Responsibilities**:
- Understand organisational Business strategies and data requirements and collaborate with management to determine and create a data management roadmap for design, development and storage of various software packages and databases
- Design data models and database solutions that are aligned to IT and business strategies and information management requirements by designing proposed systems;
defining database physical structures and functional capabilities
- Cate a blueprint framework for designing, testing and maintaining databases.
- Assess external data management opportunities and threats and develop security, back-up, and recovery specifications.
- Project manage and document installations and actions taken around the development and amendment to databases and dashboards
- Manage split testing on various database content categories
- Design and manage a data warehouse to receive, transform, normalise, deliver and integrate cross functional data from business systems to be used by various business stakeholders
- Check the conformance of the delivered data warehouse to standards and architectural decisions and resolve design and architectural conflicts by explaining and justifying design and architectural decisions
- Conduct investigations and analyses into potential technology innovations, and deliver a data architecture to support the future business growth and streamline processes
- Design solutions and update the data warehouse infrastructure to manage data requirements in the organisation, including the daily monitoring and management of the functionality and optimal performance of various databases
- Develop data management reports for various business stakeholders in order for them to complete required analyses and make business decisions
- Develop standards and processes for database management aligned to legislation, gaming regulation requirements and security protocols - ensuring they are updated and communicated
- Implement sufficient control measures (including systems and processes) &
checks to mitigate any risk to the business.
- Ensure own competence to meet changing technology and database architecture requirements remains relevant, and receive necessary training and updates
- Conduct testing and audit compliance of new or enhanced products to ensure requirements of key stakeholders (customers, staff and gambling boards) are met.
- Ensure a complete understanding of information flow and system architecture and how it relates to underlying data structures
- Review the interfaces tracking dashboards and reports in order to resolve any data issues timeously
- Provides database support by coding utilities, responding to user questions, and resolving problems.
- Liaise with Compliance function to discover data regulatory requirements for inclusion when integrating key data policies and standards
- Establish appropriate levels of co-ordination, communication and liaison with internal stakeholders to ensure database changes and functionalities in the warehouse remain up to date and relevant
- Maintain external relationships with industry bodies, vendors and technology analysts to learn and influence future database warehousing standards
Qualifications:
- BSc Degree (in Computer Science, Engineering, Mathematics, Statistics, Information Systems or other technical/quantitative discipline).
- Post graduate degree is an advantage
- Microsoft certified:
Azure Data Engineer/Azure Solutions Architect Associate or equivalent AWS certifications
- Any certification in data modelling, data warehousing, project management will be advantageous
**Experience**:
- Minimum 5 years of building data pipelines including at least 3 years of experience developing both multidimensional and tabular models with large and complex datasets
- Experience with data migration and integration
- Experience building data dictionaries, dimensional data models, architecture diagrams, meta data repositories, data integration processes, ETL processes and data quality
- Experience with developing enterprise data warehouse solutions, data modelling and development
- Must be passionate about data and analytics
Work conditions and special requirements:
- Travel to all units required on a regular basis
- May be required to work outside of normal working hours, in line with operational requirements (including weekends, public holidays)
Core behavioural competencies:
- Analysing
- Creating and