7/12/2019 4:45:47 PM
We currently have a Regular Full-Time opportunity for an Full Stack Developer in the Information Services Department at our Bayview Campus.
The Information Management (IM) Program within Sunnybrook Health Sciences Centre is seeking a Regular full-time Full Stack Developer
The IM Program at Sunnybrook is aimed at getting information directly into the hands of key users. The IM strategy is focused on providing tools and technologies that support easy access and exchange of information.
The key objectives of the strategy include the following:
Provide access to strategically relevant, accurate, consistent and timely performance data to inform better decision making and actions
Design and develop innovative solutions, based on the unique information and workflow needs of user
Enhance our information architecture to support industry leading visualization and analytics technologies that enable improved clinical care, as well as efficient and effective research
Summary of Duties
Design, develop and support databases, data marts, data dictionaries and metadata repositories
Develop an in-depth knowledge of Sunnybrook’s IM application portfolio, technical architecture, development tools, and development procedures.
Design, develop and test web based applications that fully implement the specified business requirements and are developed using industry/development best practices.
Produce technical documentation that accurately and thoroughly depicts the software design and code base.
Design and implement technical enhancements to the enterprise data warehouse, including database design, ETL processes, access and security
Lead data preparation activities including exploration, cleansing, validation, integration, transformation, and aggregation of data
- Design and implement technical enhancements to the enterprise data warehouse, including database design, ETL processes, access and security
Conduct proactive database monitoring to identify performance improvement opportunities
Work as part of an application development team; create structured code for integration into larger systems, as well as documentation for ongoing maintenance in production environments
Work closely with Data Architect, Solution Architect, Project Managers, Quality Assurance Analysts and
Business Intelligence Consultants
Conduct research and make recommendations on database products, services, protocols, and standards in
support of procurement and development efforts.
Qualifications & Skills - Required:
Computer Science or Engineering degree with at least 5 years of relevant experience
Understanding of Service Oriented Architecture, .Net and SharePoint
Fluent in SOAP and REST API web service technologies (JSON and XML)
Proficiency with MS SQL Server, SQL Server development, & T-SQL
Experience with MS Visual Studio, VSCode or IntelliJ
ETL expertise using MS SQL Server 2012 SSIS or later
Data warehousing experience, including an understanding of fundamental concepts, schemas, and models
Understanding of major RDBMS; including MS SQL, Oracle, & Access
Knowledge and experience with both Waterfall/SDLC and Agile development methodologies
Past involvement with architectural systems design (client/server, distributed multi-tier)
Qualifications & Skills – Good to Have:
Experience in a healthcare environment
Experience developing and configuring cloud based solutions (with GCP, AWS and/or Azure)
Exposure to formalized data governance, data quality processes and master data management processes
Privacy and security concepts
Experience with server-side scripting languages (e.g. ASP, ColdFusion, PHP, Python, Ruby)
Use of Team Foundation Server and GIT
Exposure to Business Intelligence (BI) tools such as Microsoft Power BI
In addition to the above technical skills, all candidates for the above roles shall possess:
Excellent oral and written communication skills
Analytical abilities and ability to work effectively with technical & business users
Ability to understand business requirements and convert them to functional specifications
Ability to create technical and functional documentation
Ability to work effectively with all levels of management
References should mention expertise, talent, initiative
Qualified candidates are invited to submit their resume and cover letter (in one document) quoting 190642 to:
Sunnybrook Health Sciences Centre
To apply, please click "Apply for Position" at the bottom of this page
Sunnybrook Health Sciences Centre is committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation for disability during any stage of the recruitment process, please indicate this in your cover letter.
Sunnybrook Health Sciences Centre is strongly committed to inclusion and diversity within its community and welcomes all applicants including but not limited to: visible minorities, all religions and ethnicities, persons with disabilities, LGBTQ persons, and all others who may contribute to the further diversification of ideas.