Primary responsibilities associated with this position include:
- Researching, developing and implementing new or improved technology solutions to meet business objectives, considering the impact and implications on other systems
- Developing and maintaining complex SQL queries, stored procedures, views and functions
- Performing SQL Servers administration and user-accounts maintenance
- Working collaboratively with the IT security team, ensuring that all production servers are regularly updated and in compliance with the Firm’s security protocols
- Providing technical support to the end-user community
- Performing routine database maintenance tasks and optimization checks
- Assisting with the implementation and testing of system upgrades and software patches from vendors
- Diagnosing, troubleshooting and resolving technical issues that arise to ensure appropriate solutions are actioned in a timely manner, including engagement of various IT teams and external vendors when needed
- Assisting with regular systems audits, user-access reviews and data cleanups
- Bachelor’s degree in computer science or related field
- Minimum of three years of experience working with financial/accounting/information systems, designing technical solutions and providing overall technical support, with proven experience in web applications development
- Work experience in a professional services environment is an asset
- Experience in working with Aderant or Elite accounting software would be an asset
- Familiarity with Microsoft Azure Data Services and data integration would be an asset
- Strong verbal and written communication skills
- Excellent report development and deployment skills on the SSRS platform
- Excellent problem-solving, analytical and critical thinking skills
- Advanced knowledge of SSIS, data mining and data warehousing methodologies
- Solid understanding of the concepts of relational database structure and design, and development life cycle
- Working knowledge in Python, VB
- Working knowledge of Citrix and VMware virtual environments
- Strong understanding of system disaster recovery concepts
- Proficiency in SharePoint, IIS, SQL Profiler, Excel, PowerPoint and Word
- Ability to conceptualize solutions to more complex issues while exploring all possible implications and outcomes
- Ability to work collaboratively within the Finance, Technology and with other departments throughout the Firm
- Detail-oriented and ability to complete work under pressure and with minimal supervision
- Familiarity with data consolidation and integration technology and strategies is an asset
How to Apply?
To apply for this position, please submit your application along with a cover letter and résumé directly to our application portal.
Blakes wishes to thank all applicants for their interest. However, only those candidates selected for an interview will be contacted.