Do you have a passion for data and want to use your skills to make a real difference? Join the Health Information Management (HIM) Business Solutions’ team who develops and supports a wide variety of innovative Data Management and Business Analytics Solutions to support the need of all HIM portfolios (Transcription and Health Information Exchange Services, Records Management, Patient Registration, and Clinical Coding and Informatics Services) across all Health Organizations in the Lower Mainland (VCH, PHC, PHSA, FHA). We have an exciting temporary fulltime position that has just recently opened up at Howe Street. If you have your Bachelor’s Degree in Computer Science or related field plus a minimum of five (5) years of recent, related experience with data modeling, ETL, Microsoft BI tools (SSAS, SSRS, and SSIS), Power BI, advanced T-SQL (Microsoft Transact SQL) and analyzing business requirements or an equivalent combination of education, training and experience. Significant recent experience with coordinating and documenting the change management process for complex information systems. Experience as a business analyst and project management required. Strong relationship management and interpersonal and communication skills , we want to hear from you! SharePoint experience is an asset.
SummaryReporting to the Manager, HIM Business Solutions, the ETL (Extract, Transfer, Load) Developer/Business Intelligence (BI) Analyst acts as a key interface between HIM Senior Leaders and Operational Managers to determine HIM business solution requirements. The ETL Developer-BI Analyst is responsible for creating reporting and analytical application solutions to support effective use of business intelligence data by HIM business professionals and other key stakeholders. This role supports the HIM Data Management Program: the process involved in creating, extracting, cleansing, transforming, sharing, protecting, documenting and preserving data. He/she also acts as a liaison to and develops strong, working relationships with the Information Management, Information Technology (IM/IT) departments at all the Organizations and works in conjunction with them, to resolve systems issues and coordinate activities. The position requires extensive liaison with the HIM Senior Leaders and other levels of management as well as access to detailed and confidential information of all types (clinical, financial, payroll, etc.).
Bachelor’s Degree in Computer Science or related field plus a minimum of five (5) years of recent, related experience with data modeling, ETL, Microsoft BI tools (SSAS, SSRS, and SSIS), advanced T-SQL (Microsoft Transact SQL) and analyzing business requirements or an equivalent combination of education, training and experience. Significant recent experience with coordinating and documenting the change management process for complex information systems. Experience as a business analyst and project management required. Strong relationship management and intrapersonal communication skills. SharePoint experience is an asset.
Skills And Abilities:
Significant recent experience and Advanced Knowledge of Microsoft Business Intelligence Stack, SSIS, SSAS, SSRS.
Experience upgrading/migrating to SQL Server Platforms - SQL Server 2016 and Power BI
3+ years writing T-SQL.
3+ years programming experience (C#, VB.net, Java, etc.)
Effectively work in an ETL framework driven environment
Strong understanding of HIM business processes and transactional systems within the HIM business domain.
Ability to understand and prioritize user and business requirements, and to conceptualize information processing solutions in response to them, including analyze, scope and define work effort required to correct program deficiencies and problems.
Strong background in data architecture, data quality, data mapping, and data structures.
Demonstrated knowledge of OLAP technologies and dimensional modeling.
Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables.
Strong understanding of database and business intelligence concepts.
Proven ability to prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules.
Excellent interpersonal, oral and written communication skills
Strong quantitative, analytical, problem solving, organizational and interpersonal skills.
Demonstrated attention to detail and maintaining high quality standards.
Demonstrated Project Management experience.
Proven ability to plan and execute complex projects.
Ability to work to independently, meeting deadlines under pressure, with minimal supervision and frequent interruptions.
Ability to effectively communicate complex ideas/processes in simple terminology to internal and external stakeholders, including all levels of management.
Strong team player with a client/user orientation.
Ability to teach, coach and mentor others.
Physical ability to perform the duties of the position.
Employees of Providence Health Care receive an excellent and comprehensive health benefit package, as per their collective agreement or terms and conditions of employment.
*Other benefit packages may apply if this is an affiliate posting.
We have an exciting casual Medical Registration Switchboard clerk position that has recently opened up at Sechelt Hospital. If you have knowledge of medical terminology, strong client experience and excellent administrative skills we want to hear from you!…
Featured Job Categories
- Foundry - BC Integrated Youth Services Initiative (BC-IYSI)
- Biomedical Engineering
- Cardiac Sonographer
- Clinical and Systems Transformations (CST)
- Critical Care Nurse
- Emergency Nurse
- Geriatric Nurse
- Health Care Analyst
- Health Information Management
- Heart Centre
- Leaders and Corporate Services
- Maternity/NICU Nurse
- Mental Health
- Operating Room Nurse
- PHC Redevelopment
- Registered Nurse
- Rehabilitation Professionals
- Renal Nurse
PHC Medical Care Team Member