Senior Database Developer

Boyd Interactive; Toronto; On-site; CAD 70,000 - 75,000; Full time

Benefits offered by this job

Dental care

Disability insurance

Extended health care

Life insurance

On-site gym

On-site parking

Paid time off

Work from home

Job summary

A gaming technology provider in Toronto is seeking a skilled Data Engineer/Reporting Developer. The role involves developing and optimizing SQL scripts, designing ETL processes, and ensuring data integrity. Candidates should have 3-5 years of experience with MySQL and bash scripting, alongside strong analytical skills. This is a full-time, hybrid position offering a variety of benefits.

Qualifications

• 3-5 years experience writing raw SQL queries and stored procedures using MySQL.
• 3-5 years ETL experience using bash scripts in a Unix/Linux environment.
• Experience developing scripts and running cron jobs.

Responsibilities

• Develop and optimize complex SQL scripts to support reporting requests.
• Design and develop ETL processes using bash scripting.
• Investigate data anomalies and develop validation scripts.

Skills

SQL queries

bash scripting

data analysis

data integrity validation

communication skills

Education

Formal Computer Science education

Tools

MySQL

MS Excel

Job description

Boyd Interactive 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.

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.

We are looking for a skilled Data Engineer/Reporting Developer to join our IT team to develop and support reporting solutions using MySQL databases.

Responsibilities:

• Develop and optimize complex SQL scripts and stored functions to support reporting requests from business users;
• Design and develop ETL process using bash scripting in Linux to automate data loads and extracts from transactional database to the reporting database;
• Investigate reporting/sampling of possible data anomalies;
• Design and develop data validation scripts to ensure integrity of the data in the reporting system;
• Monitor and report abnormal data loads, slow queries, and data integrity anomalies.

Requirements:

• 3-5 year(s) experience hands-on writing raw SQL queries and stored procedures using MySQL database;
• 3-5 year(s) ETL experience using bash scripts in a Unix Linux environment;
• Experience with MS Excel - charts, graphs, pivot tables, vlookup and other Excel functions;
• Solid understanding of MySQL explain plans and optimization of slow queries;
• Experience developing scripts using bash and running cron jobs;
• Ability to analyze and organize raw data;
• Ability to combine raw information from different sources;
• Interpret and conduct complex data analysis and report on results;
• Organized, detailed oriented, meticulous and precise when writing scripts;
• Solid analytical and problem solving skills;
• Ability to handle multiple tasks;
• High attention to detail with a structured and methodical way to review scripts and queries;
• Ability to work in a dynamic, fast-paced environment with competing priorities;
• Ability to adapt to new environments, and the ability to identify, propose and implement changes and improvements;
• Strong interpersonal and communication skills, both written and verbal;
• Formal Computer Science education.

Job Types: Full-time, Permanent

• Dental care
• Disability insurance
• Extended health care
• Life insurance
• On-site gym
• On-site parking
• Paid time off
• Work from home

Flexible Language Requirement:

• French not required

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Toronto, ON: reliably commute or plan to relocate before starting work (required)
• 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)?

Work Location: Hybrid remote in Toronto, ON

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Gambling Facilities and Casinos

Referrals increase your chances of interviewing at Boyd Interactive by 2x

Get notified about new Database Developer jobs in North York, Ontario, Canada.

Software Engineer, Backend (All Levels / All Teams)

Software Developer Full Stack (Junior) 9063-1115

Toronto, Ontario, Canada CA$70,000.00-CA$75,000.00 3 weeks ago

Software Engineer, Frontend (Lyft Urban Solutions)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.