Job Description

Our client in the healthcare domain is entering a time of great opportunity and we are looking for exceptional individuals to be part of their extraordinary team and future to focus on digital health technologies that scale far beyond the traditional walls of the hospital. With a vision for supporting an efficient patient experience and a consistent approach to clinical best practices, our client is preparing to implement a modern Hospital Information System (HIS) in 2024.
As a valued member of the team, the HIS Data Architect / Data Scientist (Technical) will play a crucial hands-on role in designing and implementing all project data-related needs. We are looking for a strong hands-on candidate who possesses a holistic view of IT in a healthcare setting including experience and strong knowledge of data architecture, data transformation strategies, data warehousing, BI, and analytics.
CORE DUTIES AND RESPONSIBILITIES
\xe2\x80\x93 Modeling/transformation, design and documentation

• Proficiency in developing reports with SQL, SSRS/SSIS/SSAS tools;

\xe2\x80\x93 Data warehouse

• Development and analysis development and maintenance of architectures and data structures to support reports and analyzes which includes among other things the regular updating / updating of the ETL, the design of the data mapping, the integration and aggregation of data from various sources, SQL Server database;

\xe2\x80\x93 Programming and testing

• In close collaboration with the programmer analyst, make sure to have an action plan for programming and automating the reports of the decision support service using programming languages such as SQL, SAS, SSAS, SSRS, SSIS or Business Objects or other reporting tools in the HIS;

RESPONSIBILITIES:

• Responsible for developing and optimizing database models to store and retrieve electronic medical record and administrative data.
• Execute thorough analysis/profile of all system data elements (tables and fields), migrate data, and design data models with strong expertise in SQL, Oracle, Python, R and/or similar data storage software query languages
• Developing database solutions to store and retrieve company information
• Analyzing structural requirements for the new Oracle Health software and may associated
• applications
• Migrating the required data from legacy systems to new Oracle Health solution
• Design conceptual and logical data models and flowcharts
• Improve system performance by conducting tests, troubleshooting and integrating new elements
• Optimize new and current database systems
• Perform tests and evaluations regularly to ensure data security, privacy, and integrity
• Participate in the development of archival and migration strategies of legacy applications data and/or databases
• Assist in the implementation and execution of the data migration and data archival strategies
• Reviewing gaps and proposing a solution for data migration and archival during the solution design phase
• Define, document, communicate, and stabilization of all relevant data integration and transfer processes
• Support the design and help implement visualization and reporting of archived data to satisfy business needs and data retention policies of the organization

QUALIFICATIONS:

• 5+ years of experience with MS BI Stack (SSRS, SSAS, SSIS, SSMS)
• 5+ years of DBA experience
• Demonstrable experience in managing data warehouse and BI domain
• Excellent knowledge of data backup, recovery, security, integrity, and SQL
• Familiarity with database design, documentation, and coding
• Strong understanding of ETL/Data design/Data model/Data consolidation/Data cubes
• Strong understanding of Data Security
• Good functional knowledge and ability to work with both MS SQL, and Oracle and NoSQL database environment
• Strong analytical skills with the ability to translate business needs into technical solutions
• Project management experience would be an asset

EDUCATION & TRAINING:

• Bachelor\'s degree or Community College diploma relating to computer technology
• In-depth understanding of database structure principles
• Experience gathering and analyzing system requirements
• Knowledge of data mining and segmentation techniques
• Expertise in SQL and Oracle
• Experience with producing conceptual and logical architecture diagrams
• Proven analytical skills
• Problem-solving attitude
• Vaccines (COVID-19 and others) are a new hire requirement of the job unless you have an exemption based on medical or on a ground pursuant to the Ontario Human Rights Code

Availability
Anticipated start date is November 20, 2023. Proponents must confirm the start date availability of the candidate submitted for consideration.

SRA Staffing Solutions