Applications Programmer

We are looking for a Applications Programmer! Reach out if you are interested and feel free to refer friends/colleagues!

Type of Employment: Contract
Title: Applications Programmer
Term: Contract – 12 months with extension
Location: Toronto – Hybrid 2 days a week
Industry: Banking
Job ID number: 238

Ideal candidate background:

• 7-10 years’ experience in ETL development, data analysis/ reporting and working with large volumes of data, ideally within financial services.
• Well organized, high attention to detail, results oriented.

Accountabilities and responsibilities:

• Craft complex and comprehensive BI reporting packages by understanding data structure on Azure platform, constrains, existing reports in SSIS, Access, Tableau and ensure reengineered processes meet the business needs and currently technology architecture.
• Validate the quality and integrity of the data included in reporting
• Create and maintain detailed documentation on all projects/requests.
• Validate the quality and integrity of the data included in the Reporting Packages and Dashboards
• Adopt, implement, and effectively evolve report automation standards
• Design/develop dashboards and scorecards to support business needs; ensure alignment of metrics across the organization

Must have: 

• 7-10 years’ experience in ETL development, data analysis/ reporting and working with large volumes of data, ideally within financial services.
• 5+ years’ Experience in SQL writing complex queries and minimum two years in advanced PySpark / Python preferably in Azure environment
• Extensive knowledge of data engineering practices and developing scalable data pipelines
• Excellent troubleshooting skills with ability to interpret data and do trend analysis to identify anomalies and ability to understand and Tableau
• Project and time management skills and work independently to delivery on the tasks.
• Experience using visualization tools and ability to develop basic to intermediate complex Tableau Dashboards.