Senior Database Developer

2 weeks ago

Vaughan, Ontario, Canada Boyd Interactive Full time $80,000 - $120,000 per year

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

Benefits
:

  • Casual dress
  • Commuter benefits
  • Dental care
  • Disability insurance
  • Extended health care
  • Flexible schedule
  • Life insurance
  • On-site gym
  • On-site parking
  • Paid time off
  • Vision care
  • 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)

Application question(s)
:

  • 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

  • Senior Web Developer

    2 weeks ago

    Vaughan, Ontario, Canada Boyd Interactive Full time $120,000 - $180,000 per year

    THE COMPANYPala Interactive Canada Inc., operating as Boyd Interactive, is a full service real-money and social gaming technology provider and operator which caters to both B2C and B2B markets in Canada and the United States. Boyd Interactive offers a full spectrum of games, including casino, bingo, and poker, across all distribution channels (web, download,...

  • Senior Full Stack Developer

    4 days ago

    Vaughan, Ontario, Canada RentZoro Full time US$600,000 - US$1,200,000 per year

    Job Summary:We are looking for aFull-Stack Developerwithover3 years of experience in and backend testing. The base salary is$50,000 + up to $100,000 in performance/equity compensationin a pre-growth startup,depending on performance. The team is small and looking to take on someone who will grow their career and product with the team. You will have the...

  • Senior Labour Relations Manager

    1 week ago

    Vaughan, Ontario, Canada Verve Senior Living Full time $80,000 - $120,000 per year

    Come join us and help make a difference in the lives of older adults As employees at a Verve Senior Living Retirement Residence, our primary goal is to help each person, have a great day, every day Our employees thrive on collaboration and have a passion for excellence, achieving multiple awards including the Order of Excellence in Quality, from Excellence...

  • Senior Labour Relations Manager

    1 week ago

    Vaughan, Ontario, Canada Verve Senior Living Full time $80,000 - $120,000 per year

    Come join us and help make a difference in the lives of older adults As employees at a Verve Senior Living Retirement Residence, our primary goal is to help each person, have a great day, every day Our employees thrive on collaboration and have a passion for excellence, achieving multiple awards including the Order of Excellence in Quality, from Excellence...

  • Full Stack Developer

    1 week ago

    Vaughan, Ontario, Canada Hyrr Full time $80,000 - $120,000 per year

    Job DescriptionAre you a passionate and versatile Full Stack Developer eager to make a significant impact in a fast-paced startup environment? We are seeking a talented mid-level developer to join our dynamic team and contribute to building innovative web applications from concept to deployment. This is an exciting opportunity to leverage your expertise...

  • C++ / Java Developer (Senior)

    1 day ago

    Vaughan, Ontario, Canada Source Code Full time $120,000 - $180,000 per year

    Senior C++/ Java Developer to provide technical and architectural leadership to a cross-functional Agile team that supports the world's largest online poker platform, built with Java, C++, SQL and AWS. Permanent, full timeToronto, Ontario (remote until further notice, hybrid thereafter) Key responabilties:Review business requirements and implementation...

  • Senior Leasing Manager

    1 week ago

    Vaughan, Ontario, Canada SmartCentres Full time $80,000 - $120,000 per year

    Job Title: Senior Leasing ManagerReports To: VP, LeasingDepartment: LeasingPosition SummaryAccountable for leasing commercial retail and some office projects, as well as, portions thereof, towards the attainment of corporate objectivesResponsibilities:LeasingPrepare, negotiate and consummate, as the case may be, Lease Proposals, Offers to Lease and Leases in...

  • Senior Leasing Manager

    1 week ago

    Vaughan, Ontario, Canada SmartCentres REIT Full time $80,000 - $120,000 per year

    Job Title: SeniorLeasing ManagerReports To:VP, LeasingDepartment:LeasingPosition SummaryAccountable for leasing commercial retail and some office projects, as well as, portions thereof, towards the attainment of corporate objectivesResponsibilitiesLeasingPrepare, negotiate and consummate, as the case may be, Lease Proposals, Offers to Lease and Leases in...

  • Java Developer

    7 days ago

    Vaughan, Ontario, Canada Executive Scouts Full time $80,000 - $120,000 per year

    Job BriefOur client is seeking a talented Java Developer with expertise in AWS and Spring Boot to contribute to the development and maintenance of their environmental services platform. You will collaborate with cross-functional teams to design, implement, and deploy scalable solutions that address complex environmental issues.ResponsibilitiesDesign,...

  • Senior Data Analyst

    2 days ago

    Vaughan, Ontario, Canada 407 ETR Full time $80,000 - $120,000 per year

    Position SummaryThis role centers on analyzing financial data, developing and maintaining ECL models, and providing valuable insights to drive informed business decisions. This position requires the development of SQL queries to extract large data, preparation of complex financial models and automation of operational reports and processes. This position will...