Close

Report Developer

Type: Full-time, permanent

Position: Report Developer

Reports to: Manager of Reporting

We are looking for a skilled individual 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 writing 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;
  • Experience working with BIRT will be considered;
  • 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.

Apply Now – Submit your application below