Database Developer

IT - Application & Software Development
Toronto, ON
Permanent
Dec 05, 2019

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: 

  • 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 design using dimensional modeling techniques.
  • Research alternatives and provide recommendations for the data warehouse design that are based on the best practices of leading OLAP solutions.
  • Conduct code reviews, by and for peers.
  • Create thorough and demonstrable unit testing specifications.
  • Implement code upgrades, backups and version control.

QualificationS: 

  • 5+ years’ experience in T-SQL skills.
  • Expert level knowledge of SQL Server SSRS ( 2005, 2008, 2012)
  • Expert level knowledge of SQL Server SSIS ( 2005, 2008)
  • Expert level knowledge of SQL Server SSAS ( 2005, 2008)
  • 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 have the ability to 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.
  • Knowledgeable in designing and implementing data warehouses, including star schema, dimensions and fact tables.
  • Knowledgeable in BI and Data Mining.
  • Experienced in incrementally building Staging, Operation Data Stores and Dimensional data marts.
  • 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.
  • 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