Senior Systems Analyst - Business Intelligence Developers (NGEMR)

Business intelligence developers (BIDs) create analytics content based on specifications created by Cogito business analysts. BIDs design and write reports based on an in-depth knowledge of operational system usage. This level of knowledge requires a deep understanding of system build, end user workflows, and patterns ofuse. The BIDs shall have both the technical skills required to design and write reports and the operational knowledge to help them understand what report consumers need to see.Roles and ResponsibilitiesMeeting with Cogito Process Analysts (PA) and report requesters (SMEs) to understand their data needs.Identifying and reviewing the appropriate technological solutions for various reporting needs.Creating Reports/Dashboards to present data from relational database Clarity to users.Writing SQL for custom SQL metrics.Modifying existing reports, as necessary.Reviewing peer reports for validity.Testing report build in a specified testing environment and volume testing in live environments.Reviewing upgrade documentation related to Clarity features, and determining how to implement the changes.BIDs might also be responsible for building:Universes and cubesExtractsSlicerDicerThird-party tools (WebI/QlikView/Tableau)Provide Go-live and Command Centre support to other integration systemsRequirementsA degree in engineering, physics, computer sciences, math, information systems, or statisticsAt least 2 - 5 years’ experience in developing, implementing and maintaining IT systemsStrong communication skillsCritical thinking and an analytical mindTechnically proficient in analytical database platformsPossess relevant working knowledge of the database operating systemsProficiency with SQL, relational database concepts and report writing toolsFamiliarity with Epic applications and database structure, through training that occurs early in the implementationAbility to gain an in-depth understanding of the data model through data model classes geared toward content areasCertification in Clarity Admin, or Cogito or other Epic modules will be advantageous