IT - Systems Integration
Dec 09, 2021
.. a rapidly growing fintech company based out of downtown Toronto, is looking for someone to assist in their continued , large scale business and technology transformation initiatives.
What’s in it for you?
Join a team in expansion mode with an award winning platform in an industry sector that is experiencing rapid change. Features include a dynamic team and working environment that provides ongoing support with frequent company wide social events and a fully stocked kitchen
- Leads or contributes to data architecture road maps that integrate solutions across various platforms and build for big data and next generation data solutions
Researches, designs, evaluates, tests, and recommends tools, technologies, processes and implements database systems in the cloud and on-premises environments; Review and recommend emerging database and web technologies.
Work with the architecture and engineering teams to oversee the design of critical areas of the application data model throughout the entire SDLC and document accordingly
Collaborates with various stakeholders during various phases of the projects to produce cutting-edge data solutions.
Maintains documentation on current architecture (logical and physical) for all data environments (development, test and production)
Develops, documents and maintains standards and policies for user authentication, database security, database naming conventions, etc.
Review and approve database designs presented by the development teams for implementation.
Provide support and mentoring to other engineers in all aspects of logical database design,
creating and tuning queries, and other related activities.
Advises on database performance problems and other database-related issues lifecycle
Implements data quality standards, data protection standards and adoption requirements across the enterprise
Skills & Qualifications
- Minimum 7 years database architecture, systems development, database engineering and administration experience, with at least 2 years designing modern data platforms and large databases.
Understanding of relational and dimensional data modeling for OLAP and OLTP with Hands on experience using Erwin, Visio or similar tools
Experience testing and evaluating data technologies and systems.
Extensive experience with database technologies, for both structured and unstructured data (MySQL, MS SQL, PostgreSQL, MongoDB)
Strong knowledge of SSAS, SSIS, SSRS as well as Spark, R and python experience
Demonstrated skills in collaboration, teamwork, and problem-solving to achieve goals
Excellent verbal and non-verbal communication skills and ability to professionally interact with variety of stakeholders.