Database Developer

IT - Application & Software Development
Toronto, ON
Permanent
Apr 13, 2021

Our client is one of the largest private brokerages in Canada.  This position is a member of the Data Services team.  You will be responsible for development of reporting, ad-hoc querying, database design and development and data warehouse and analytics solutions for the enterprise. This position requires OLTP/OLAP architecture and database developer skills with proven experience in complex database, data warehouse and data integration development with technical acumen, passion for innovation and a team player.

The person will have responsibility for development and maintenance of a corporate data warehouse, enterprise databases and reporting solutions, working with other team members in optimizing system performance and for addressing operational issues to meet established Service Level Agreements for product delivery and support. 

Responsibilities: 

  • Design data model, database objects (e.g. tables, stored procedures, functions and views) for application development.
  • Develop and deploy reporting as required by project and business stakeholders.
  • Review functional requirements to give development estimates and product development.
  • Analyze target production systems for performance, capacity planning and storage and make recommendations to department leads.
  • Design, develop and maintain ETL processes with the help of team members.
  • Interpret functional Business Intelligence requirements and translate them into an effective logical and physical data model.
  • Conduct code reviews, by and for peers.
  • Manage & deploy code using industry standard code control techniques.

Qualifications: 

  • 5+ years’ experience in T-SQL skills.
  • Expert level knowledge of SQL Server SSRS (2008, 2012, 2016)
  • Expert level knowledge of SQL Server SSIS (2008, 2012, 2016)
  • Expert level knowledge of SQL for the purposes of developing complex and efficient data queries.
  • Experienced in analyzing and resolving problems and optimize performance of complex data warehouse systems.
  • Must be a strong team member and can work independently or as part of a team.
  • Experienced in identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex, multi-application environments.
  • Experienced in creating, reviewing and presenting Source Systems Analysis and Source-To-Target mapping across Staging, Integration and Presentation layers.
  • Experienced in identifying and documenting data integration issues, challenges such as duplicate data, non-conformed data, and unclean data.
  • Practical knowledge of modern RDBMS and OLAP.
  • Excellent organizational, communication, and interpersonal skills.
  • Ability to take ownership and juggle multiple projects and tasks.
  • Ability to work against tight deadlines in a fast-paced environment.

Nice to have: 

  • Expert level knowledge of SQL Server SSAS
  • Solid experience on Power BI
  • Knowledgeable in designing and implementing data warehouses, including star schema, dimensions and fact tables.
  • Research alternatives and provide recommendations for the data warehouse design that are based on the best practices of leading OLAP solutions.
  • Knowledgeable in Data Mining.
  • Experienced in incrementally building Staging, Operation Data Stores and Dimensional data marts.
  • 5+ years in financial and investment banking, preferably interacting with Dataphile or ISM back-office applications as well as trading platforms like Fidessa. 
  • A Canadian Securities Course is a definite advantage.

Send to Friend

Send to Friend