Senior Business Intelligence Developer

Business Intelligence Developer/ Advisor (Healthcare)Reporting to Manager of Business Intelligence and Data Governance, the Business IntelligenceDeveloper/ Advisor is responsible for supporting Business Intelligence solutions. In addition, the BIAdvisor will also be responsible for deployment, development and troubleshooting data as well astechnical issues. A self-motivated individual with exceptional technical, communication and analytical skills with a demonstrated commitment to customer service will excel in this position. There will be a specific focus on building reporting solutions for data quality reports for Med2020 and CIHI reporting.The Business Intelligence Advisor is responsible for providing the following:Job Responsibilities:- Maintain and support existing BI Solution in SSRS, Power BI, EPIC, Data warehousing, BIdeveloped data applications- Define and document business rules for BI solutions, including data warehouse, reports,dashboard, scorecards and web applications.- Identify and review the appropriate technological solutions for various BI data, analyses,reporting, and visualization needs.- Maintain Data governance reports, data sets, and other BI solutions.- Design and develop dashboards and scorecards and reports using a third-party report writingtool such as SSRS, Power BI, or Tableau, to display data from a reporting server- Build extracts using SQL, enterprise (EPIC,MS )reporting tools against enterprise systems (Clarity,Caboodle, Data warehouse)- Document reporting and other BI Data Sets- Act as a primary support contact for SSRS administration, security and upgrades- Troubleshoot problems, questions, and review peer reports for validity;- Identifying advanced analytics opportunities in interactions with clients- Test, debug and deployment of all BI solutions and web applications following industry standardSDLC – Software Development Life Cycle procedures.- Attend weekly meetings with team members to discuss the status of deliverables, shared issues,end user concerns, and upcoming milestones;- Identify issues that arise in the application area as well as issues that impact other applicationteams and work to resolve them;- Provide professional internal and client-facing documentation (SRS - System RequirementSpecifications, BRD - Business Requirements Documentation etc.) through a combination ofwireframes, workflow diagrams and written documentation;- Achieve certification in vendor’s application as requiredKnowledge and Experience Required- University Degree in Computer Science or Community College Diploma (3-year program)- Knowledge of Med2020, CIHI databases (DAD, NACRS, NRS, CCRS)- Microsoft BI certification is considered an asset

Qualifications:• Bachelor’s degree in a clinical discipline/health informatics/information systems/business/computer science/engineering or other related filed or equivalent work experience• 6 plus years’ experience in SQL Server 2016/2019/2022- Ability to lead and/or participate in requirement gathering sessions, document userrequirements and translate them into useful solutions;- Experience developing indicators and associated documentation;- Experience in maintaining proper data governance best practices- Applicable knowledge in SQL programming and stored procedures- Experience with Visual studio 2016+ and TFS (Team Foundation Server)- Applicable knowledge to design and development in Microsoft BI Stack (SSRS, SSIS, SSAS, .Net,SharePoint) and EPIC reporting software- Experience troubleshooting and performance tuning SQL scripts, stored procedures and SSRSreports- Knowledge of SQL Server security and administration- Experience using, developing Data Marts and Models- Ability to lead and/or participate in requirement gathering sessions, document userrequirements and translate them into useful solutions- Knowledge of mobile application design is considered an asset

Eligible to work in Canada, No Visa SponsorshipContract 6 Months to start remote role

Key Skills

• SQL