Senior Database Developer

Job Description

<p>Job description</p><p>Boyd Interactive<br>is a full-service, real-money and social gaming technology provider and operator which caters to both B2B and B2C markets. Pala offers a full spectrum of games across all distribution channels (web, download, tablet & smartphone). In Canada, they offer sports betting and casino games. In the US, they offer casino, bingo, and poker games.</p><p>Pala's strength is its relentless focus on high quality, high functioning, immersive software platforms, and with recent developments in legislation, the online gaming industry is poised for rapid growth.</p><p>We are looking for a skilled<br>Data Engineer/Reporting Developer<br>to join our IT team to develop and support reporting solutions using MySQL databases.</p><p>Responsibilities:</p><ul><li>Develop and optimize complex SQL scripts and stored functions to support reporting requests from business users;</li><li>Design and develop ETL process using bash scripting in Linux to automate data loads and extracts from transactional database to the reporting database;</li><li>Investigate reporting/sampling of possible data anomalies;</li><li>Design and develop data validation scripts to ensure integrity of the data in the reporting system;</li><li>Monitor and report abnormal data loads, slow queries, and data integrity anomalies.</li></ul><p>Requirements:</p><ul><li>3-5 year(s) experience hands-on writing raw SQL queries and stored procedures using MySQL database;</li><li>3-5 year(s) ETL experience using bash scripts in a Unix Linux environment;</li><li>Experience with MS Excel - charts, graphs, pivot tables, vlookup and other Excel functions;</li><li>Solid understanding of MySQL explain plans and optimization of slow queries;</li><li>Experience developing scripts using bash and running cron jobs;</li><li>Ability to analyze and organize raw data;</li><li>Ability to combine raw information from different sources;</li><li>Interpret and conduct complex data analysis and report on results;</li><li>Organized, detailed oriented, meticulous and precise when writing scripts;</li><li>Solid analytical and problem solving skills;</li><li>Ability to handle multiple tasks;</li><li>High attention to detail with a structured and methodical way to review scripts and queries;</li><li>Ability to work in a dynamic, fast-paced environment with competing priorities;</li><li>Ability to adapt to new environments, and the ability to identify, propose and implement changes and improvements;</li><li>Strong interpersonal and communication skills, both written and verbal;</li><li>Formal Computer Science education.</li></ul><p>Job Types<br>: Full-time, Permanent</p><p>Benefits<br>:</p><ul><li>Casual dress</li><li>Commuter benefits</li><li>Dental care</li><li>Disability insurance</li><li>Extended health care</li><li>Flexible schedule</li><li>Life insurance</li><li>On-site gym</li><li>On-site parking</li><li>Paid time off</li><li>Vision care</li><li>Work from home</li></ul><p>Flexible Language Requirement<br>:</p><ul><li>French not required</li></ul><p>Schedule<br>:</p><ul><li>Monday to Friday</li></ul><p>Ability to commute/relocate<br>:</p><ul><li>Toronto, ON: reliably commute or plan to relocate before starting work (required)</li></ul><p>Application question(s)<br>:</p><ul><li>This is not a remote position. Are you willing about able to work on-site at the office on a hybrid basis (50% of the time)?</li></ul><p>Work Location<br>: Hybrid remote in Toronto, ON</p>