Business Intelligence Analyst 3 - BI/BA * Days - 40 hrs/wk

Requisition #: req6166

Shift: Days

FTE status: 1

On-call: Yes

Weekends: No

General Summary:

Reporting to the Director Business Intelligence/Analytics, builds and supports business intelligence and analytics initiatives to enhance departmental and organizational effectiveness, efficiency and safety. Works closely with other Information Technology staff to plan and implement strategies. Designs database structures that support the business needs of end users. Defines and designs database structures. Evaluates hardware and software platforms and ensures system integration. Develops system configurations and defines technical and functional specifications for data warehouse projects. Writes code to extract data from original data sources. Creates test scripts to identify and address data inconsistencies. Performs quality audits of processes in order to verify data integrity. Provides end user support for data reporting tools.

Requirements:

• A bachelor’s degree in computer science or related field.
• 5 or more years of experience in one or more of the roles listed below, or ten years of commensurate experience.
• This position requires experience with an in depth knowledge of Crystal Report Development, SQL script development, SSIS package development, SSAS development, and an operational understanding of the components of the technologies that support a hospital system.
• In addition, skills in Epic Clarity report development preferred.
• Intermediate to advanced skills are required in the functional areas above.

Essential Functions and Responsibilities:

1. Conducts analysis of departmental, organizational, and individual information needs relative to specific assignments.
2. Analyzes system performance, data integrity and security requirements in development and resolution work.
3. Participates in the analysis of system backup, restoration and disaster recovery planning and strategic direction.
4. Participates in the development of system architecture and design.
5. Coordinates closely with Project Managers and other Information Technology staff in project management and resource coordination.
6. Collaborates with user department staff, vendors, Information Technology staff and others as appropriate to facilitate effective system, organizational and departmental operations.
7. Installs or participates in the installation of system and application installations, upgrades.
8. Documents all phases of project and product life cycles.
9. Cross trains team and department members in the support of tools developed.
10. Provides technical assistance in resolving developed tools issues
11. Remains abreast of healthcare industry trends advancement and climate.
12. Remains technically current in areas specifically assigned.
13. Establishes and continues development toward personal career goals.
14. Investigates new uses of current or future system development and support tools to facilitate accomplishment of corporate strategic goals.
15. Develops or participates in development of reports, interfaces, queries, forms, workflows, scripts, databases, browser-based and/or client server applications, and system testing strategies.
16. Supports and educates others in support of applications and tools developed, as well as third party applications assigned.
17. SQL and other report development.
18. SSIS package development and deployment.
19. SSAS Cube development and implementation.
20. Workflow analysis, development and workflow forms design.
21. Participates in support of applications that require scripting methodologies.
22. Assists in any other activity as assigned