Job Description

The Business Intelligence and Reporting Team, part of the Analytics Department under the Digital Solutions Portfolio, is seeking a Senior Programmer Analyst. This team supports the organization’s mission of achieving excellence in patient care, research, and innovation by delivering high-quality data, self-service tools, and reporting solutions.

In this role, you will design, configure, and manage security provisioning for Cogito/reporting users within the Atlas Alliance. Additionally, you will create and support reporting and data visualization solutions using Epic reporting tools such as Reporting Workbench, SlicerDicer, and RW/Cogito SQL.

Key Responsibilities:

• Configure and maintain security for Epic reporting users, including subtemplates, linkable templates, security classes, security points, and menus.
• Troubleshoot user and tool access issues.
• Collaborate with Epic security leads to coordinate and communicate reporting security changes for Data Access and Security projects.
• Design, build, test, and implement reporting solutions related to the Cadence application and Access data model.

Mandatory Requirements:

• A university degree or college diploma in a relevant discipline.
• A minimum of 5 years of experience in a programming environment, demonstrating strong analytical and programming skills across various languages and platforms.
• Proficiency in Epic security configuration and user provisioning, including templates, linkable templates, security classes, and menus.
• Expertise with Epic reporting tools such as Reporting Workbench, SlicerDicer, Metrics, and RW SQL.
• Advanced proficiency in SQL and relational databases (e.g., SQL Server, Azure SQL, MySQL).
• Hands-on experience programming transact-SQL queries and stored procedures.
• Strong knowledge of Data Warehousing and ETL tools, preferably SSIS.
• Experience in Business Intelligence development, with a preference for Power BI.
• Proven ability to analyze and document business requirements and recommend solutions.
• Experience troubleshooting and debugging applications.
• Excellent communication skills, both oral and written.
• Strong client service skills, including patience and diplomacy.
• Certifications in Epic Cogito, Caboodle, Access, and/or Clinical Data models are required.