Business Intelligence Developer
Business Intelligence Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Union: NonUnion
# of Vacancies: 1
Position: Business Intelligence Developer
Department: Altum Health
Reports to: Reporting and Analytics Manager
Location: Toronto (Krembil Discovery Tower)
Hours: 37.5 hours per week
Status: Permanent Fulltime
Job Summary:
The Business Intelligence (BI) Developer reports to the Reporting and Analytics Manager at Altum Health UHN and collaborates closely with Business Intelligence Analyst and clinical/business analysts. This role is responsible for creating data extract and analysis content based on enduser specifications. The ideal candidate will have expertise in SQL SSIS Epic Clarity and Caboodle database along with excellent communication and interpersonal skills. A solid background in data management analytics and business intelligence is essential for success on this role.
Duties:
- Work closely with stakeholders subject matter experts and endusers to understand the requirements and analyze the needs of data consumers.
- Identify and develop the appropriate technological solutions for various data needs.
- Designs and maintains databases tables views stored procedures jobs schedules alerts within a Microsoft SQL Server environment and works to maintain database system integrity and daily processing.
- Write SQL queries and configure report settings for custom SQL metrics; build extract (in SQL) using Epics Reporting databases (Clarity and Caboodle).
- Develops data models and maintains database schemas. Automates regularly scheduled database tasks.
- Leads the development maintenance and reporting from various internal databases (utilizing database application design security query forms reports macros VBA skills).
- Implements data quality checks and develops analytical reports to address data quality issues for related departments.
- Responds to data quality issues identified by audits and provides solutions/explanations to fix issues.
- Provides technical support for user testing; serves as a support resource to resolve issues related to system problems.
- Review upgrade documentation related to application features and determine how to implement the changes;
- Coordinates with the appropriate parties to resolve issues with the SQL Server.
- Automates and develop key performance metrics (KPIs) and scorecards to support performance measurement and hospital accountability.
- Contributes to the development of BI solution and delivery requirements for data integration projects.
Qualifications :
- Undergraduate Degree in Computer Science Information system Health Informatics Business Analytics or equivalent.
- A minimum 35 years of experience in Business Intelligence data Analytics and reporting tool development.
- Microsoft Certified Solutions Associate (MCSA) SQL Server or Microsoft SQL Server Certificate preferred.
- Epic Cogito Data Model Certification (Epic Cogito Fundamentals Clarity Data Model Caboodle Data Model Clinical and/or revenue/access Data Model) preferred.
Skills & Experience
- Expertise in relational & dimensional database and data modeling.
- Proficiency in MS SQL Server Management Studio and MS Visual Studio.
- Handson experience with analytics and Business Intelligence tools.
- Familiarity with Epic application and database structure.
- Strong databases design development and maintenance skills.
- Excellent problem solving skills and communication skills.
- Ability to gain an indepth understanding of data models and data structures.
- Ability to effectively work both independently and in a teamoriented environment.
- Experience with clinical and business workflows and data in a Canadian healthcare setting preferred.
- Familiarity with UHNs system build end user workflows and data usage patterns preferred.
Additional Information :
Why join UHN
In addition to working alongside some of the most talented and inspiring healthcare professionals in the world UHN offers a wide range of benefits programs and perks. It is the comprehensiveness of these offerings that makes it a differentiating factor allowing you to find value where it matters most to you now and throughout your career at UHN.
- Competitive offer packages
- Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https://hoopp/
- Close access to Transit and UHN shuttle service
- A flexible work environment
- Opportunities for development and promotions within a large organization
- Additional perks (multiple corporate discounts including: travel restaurants parking phone plans auto insurance discounts onsite gyms etc.
Current UHN employees must have successfully completed their probationary period have a good employee record along with satisfactory attendance in accordance with UHNs attendance management program to be eligible for consideration.
Vaccines are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code.
UHN is a respectful caring and inclusive workplace. We are committed to championing accessibility diversity and equal opportunity. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known in advance. Any information received related to an accommodation will be addressed confidentially.
University Health Network thanks all applicants however only those selected for an interview will be contacted.
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
