BI Developer-Analyst

Providence Healthcare • Vancouver, BC

5d • CA$39 - CA$56 • Hybrid

About The Position

PHC's Data Analytics team is now hiring a temporary full-time BI Developer-Analyst to help transform data into practical solutions that support better decision-making across the organization. Reporting to the Senior Data Scientist and working alongside Analysts and technical teams, you’ll contribute to a variety of projects ranging from process automation and application development to business intelligence solutions and data analytics initiatives. This is an opportunity to leverage your expertise in SQL, data visualization, automation, and data analytics to help improve the systems and processes that support healthcare delivery across PHC. This is a primarily remote position, with occasional in-person work required. This posting is scheduled to close at 11:59PM on Friday, July 31st.

Requirements

• Bachelor's Degree in Computer Science, Business Analytics, Statistics, Mathematics, Engineering or related field
• minimum of five (5) years' recent, related experience with data modeling, data visualization and reporting tools (specifically, Tableau, SAP Crystal Reports, SSRS and Power BI), 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 in business analysis and project management
• Significant recent experience in coordinating and documenting the change management process for complex information systems
• Significant recent experience in Upgrading/migrating to SQL Server Platforms - SQL Server 2019
• Significant recent experience in Writing T-SQL
• Significant recent experience in Programming experience in C#, VB.net, Java, etc.
• Advanced knowledge of Microsoft Business Intelligence Stack, SSIS, SSAS, SSRS.
• Expert proficiency in Tableau and other Analytical and Reporting tools.
• Strong analytical/modeling skills with the ability to convert raw data into actionable business insights.
• Demonstrated knowledge of OLAP technologies and dimensional modeling.
• Strong background in data architecture, data quality, data mapping, and data structures.
• Strong understanding of database and business intelligence concepts.
• Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables.
• Work effectively in an ETL framework driven environment with proven ability to prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules.
• Strong understanding of business processes and transactional systems within the business domain.
• Demonstrated 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 interpersonal relationship management skills, a team player with a client/user orientation.
• Excellent oral and written communication skills with demonstrated ability to effectively communicate complex ideas/processes in simple terminology to internal and external stakeholders, including all levels of management.
• Strong quantitative, analytical, and problem solving skills.
• Demonstrated attention to detail and maintaining high quality standards.
• Excellent organizational skills with 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 teach, coach and mentor others.
• Physical ability to perform the duties of the position.

Responsibilities

• Designs, develops and maintains dashboards, databases, ETL, reports and other BI content and analytical solutions as required.
• Works collaboratively with clients and business analysts to gather requirements, create definitions and specifications and translate into data models, ETL packages and reports as appropriate.
• Writes ad-hoc queries and reports to support analysts and leaders in data analysis.
• Participates in the VCH/PHC regional and PHC local Data Warehouse development lifecycle including: planning, development, testing, migration and production support development activities.
• Design, develop and support all extraction and integration processes (ETL).
• Design and build interactive and static data visualizations to provide insights
• Liaise with team members and/or other stakeholders to determine analytical solutions requirements including understanding inefficiencies in existing business applications and future business needs.
• Extract, manipulate and analyze complex information from multiple data sources / systems using a variety of software (e.g., R, SQL, Python)
• Conduct statistical analysis and hypothesis testing to improve forecasting, targeting and performance measurement
• Assist with data-related technical challenges and perform root-cause analysis to answer specific business questions and recommend and implementing ways to improve data reliability, efficiency and quality.
• Maintain a repository of metadata and lineage information about how data flows through its lifecycle.
• Contribute to the development and documentation of data management standards framework.
• In consultation with the Solutions Architect, provides input into the logical design and development of PHC Local Data Warehouse data models to be used for reporting and information delivery.
• Collaborates with Database Administrators, Systems Analysts, and Solutions Architect to identify, analyze and rationalize internal and external data sources and ETL strategies.
• Performs technical analysis and prepares and implements recommended ETL design approach.
• Prepares and validates end-to-end business logic and mappings.
• Develops, tests, documents and implements proposed analytical solutions (e.g., reports and dashboards).
• Responds to ad-hoc, on-demand and scheduled business user information requests as they relate to services and support provided by the business groups.
• Produces and maintains core PHC management reports, departmental dashboards and related management tools.
• Adapts ETL processes as necessary to accommodate changes in source systems and target business user requirements.
• Maintains and administers PHC organizational development key performance indicators data and reports.
• Supports and maintains migration of data to data mart from source systems.
• Develops, maintains and schedules ETL data flows/workflows/jobs, and provides daily support of these processes once implemented.
• Works with business users to validate rules regarding data integrity and data quality as it relates to the impact on business needs.
• Debugs, monitors and troubleshoots business solutions to resolve production issues.
• Liaises with other IT Development and Operations departments to clarify and build applications that meet business unit objectives.
• Administers security settings and access to the data mart and related systems.
• Supports all business users with the use of data mart tools and in deployment activities such as user acceptance testing, user training, product demos and product evaluation.
• Performs other duties as assigned.

Benefits

• Competitive Pay: $76,111 - $109,409 per year, depending on experience
• Growth opportunities: We welcome individuals at all stages of their career, offering opportunities for professional development and growth.
• State-of-the-art facilities: The new St. Paul’s Hospital and health campus will be the most innovative approach to the delivery of integrated care in B.C. and Canada, designed to appropriately address the future health needs of patients, families, and our communities. From hospital care to primary and community health solutions, the new St. Paul’s Hospital and health campus will continue to lead innovations in care, research, and teaching. The new St. Paul’s Hospital is expected to open in 2027.
• Inclusive culture: We respect the diversity, dignity and interdependence of all persons. We value the cultural richness that our diverse workforce brings to the care of our equally diverse population of patients and residents.
• Meaningful impact: You will have the opportunity to work for an organization that is deeply committed to safeguarding of our surrounding environment by contributing to high quality care while promoting sustainable practices in your everyday work.
• A comprehensive health benefits package including dental, vision, and life insurance as well as pension.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level