About Greencastle Digital
Greencastle Digital is a forward-thinking company in the dynamic betting and gaming industry, with a newly established Development Centre in Belgrade. Our mission is to unite the brightest minds in digital technology, product development, customer experience, and marketing to deliver innovative solutions for clients across Europe.
About the Role
We're looking for an experienced Senior Data Engineer to join our BI Data Engineering team in the sports betting and gaming industry. This role will be responsible for developing the company data warehouse (DWH) and Business Intelligence (BI) assets to meet business requirements. The ideal candidate will have a strong background in data warehouse solution design and implementation, with expertise in Oracle technologies and ETL processes.
This role will support the Extract, Transformation and Load (ETL) layer operating between transactional internal systems, external data sources and the Data Store layer.
Key Responsibilities
Solution Design & Development
- Actively engage with business stakeholders to interpret and understand business requirements for potential Data Warehouse solutions
- Prepare technical specifications in line with business requirements and secure appropriate business support and approvals for proposed solutions
- Design, code and build scripts, stored procedures or ETL objects as required to integrate various data sources within the Oracle data layer
- Develop reporting objects/procedures in the Tableau reporting layer in line with agreed specifications
System Testing & Deployment
- System test all development objects in line with specifications
- Manage deployment releases of BI solutions to production environments
- Maintain technical documents as required post go-live
- Apply agreed development standards and quality levels to all areas of activity
Business Support & Maintenance
- Manage and support ad-hoc data requests from the business
- Provide BAU support and resolve issues raised by users concerning the Data Warehouse
- Liaise with IT on related projects or change items and manage third party reporting software/toolsets where required
- Optimize/streamline integration processes to minimize resource demand, improve performance and reduce associated costs
Project Management & Team Coordination
- Manage your own capacity, and any junior developers that may be assigned to you, to meet agreed deadlines for in-flight change deliverables
- Provide status updates to the line manager and/or the Head of BI Reporting & Analytics as required
- Ensure data governance and data policies are being adhered to when delivering high quality Data Warehouse solutions
Required Qualifications
- University degree in Computer Science or related field (e.g. mathematical science)
- High level of expertise (8+ years) in Oracle database applications including advanced PL/SQL coding, Oracle SQL Developer, TOAD toolset or similar integration layer software
- Highly experienced in data preparation, data gateway and data warehousing projects, including utilization of data integration tools (ODI preferred)
- High level of competency in RDBMS, database design and development of data structure methodologies, including Dimensional modeling in Data Warehouse applications
- Proven experience working with very large datasets (billions of rows) and complex OLTP systems with hundreds of tables
- Experience integrating multiple disparate source systems with varying data quality, completeness, and refresh frequencies
- Experience in implementing large and complex Business Intelligence reporting solutions with a robust route-to-live process
- Experience in identifying performance bottlenecks and providing solutions
- Excellent English communication skills with ability to convey complex technical concepts to international teams
- Ability to train and knowledge-share with BI team members on SQL and data warehouse best practices
Preferred Qualifications
- Specific expertise in Tableau report design, data extract build and data prep
- Experience of using Google Analytics data and delivering integration solutions via APIs or Google Big Query
- Proven experience with AWS
- Proficiency in Python, R or similar
- Knowledge of the sports betting and gaming industry
Key Competencies & Skills
- Strong negotiation skills to guide, influence and persuade others within own remit
- Strong interpersonal skills and ability to collaborate with team members and communicate effectively with senior stakeholders and management
- Self-motivated with clear ability to use own initiative and work to tight deadlines in a pressurized environment
- Ability to prioritize activities and multi-task and motivate team resources to optimize the level and quality of service delivery
- Proven ability at problem solving with an analytical approach, with understanding of key business and financial challenges
- Ability to engage with business stakeholders, understand business requirements, design and implement solutions
