Business Intelligence Analyst II

Department/Unit: AMHS - IT Analytics

Work Shift:

Day (United States of America)

Salary Range: $71,612.39 - $

The Business Intelligence Analyst will implement solutions that support and drive qualitative and quantitative based decisions, facilitate business process and performance improvement, and support strategy development. They will evaluate process design, systems, workflow, system and process architecture, quality metrics, outcomes, and other environmental factors in order to adjust and optimize analytics and provide decision makers with actionable insights. The Business Intelligence Analyst will deliver reports and analytic applications that present high level performance indicators and allows for flexible exploration and drill down capabilities such that the root conditions driving the applicable performance indicator can be uncovered.

The delivered reports and analytics will highlight and forecast costs, risks, and opportunities associated with new and changing business conditions. They will also respond to ad-hoc report requests across multiple business areas and will participate in the development of the Business Intelligence reporting tools.

In this role, the Business Intelligence Analyst is responsible for collaborating with business and information services counterparts to derive, present, and communicate findings in a manner that facilitates business performance improvement, strategy development, and the elevation of business intelligence and data competencies throughout the organization.

The Business Intelligence Analyst – Level II will have little to moderate business or business intelligence experience with the desire to further develop proficiency and pursue a career as an analyst. The individual will conduct tasks and assignments as directed and will contribute to team objectives and outcomes. The complexity of tasks and assignments will be determined by management and will be proportional to the experience, knowledge, skills and abilities of the individual.

The individual in this role will receive close to moderate supervision, will be responsible for tasks and assignments of increasing complexity, will have basic to moderate skill sets, and will consult with senior peers and management on assigned tasks and projects.

• Evaluate, install, configure, use, and upgrade reporting and visualization tools (Qlik View, SSRS, etc.)
• Patch management and version control
• Perform maintenance tasks ensuring data is properly formatted, stored, cleansed, and secured

• Assist in the scheduling and maintenance of regular backup and recovery procedures
• Maintain documentation and standards

• Implement and maintain reporting and visualization application security

• Monitor application related jobs and data replication activities
• Perform model tuning and performance analysis/monitoring
• Perform technical troubleshooting and consult with development teams on performance issues
• Alert appropriate senior team leads when monitoring systems identify potential issues

• Conceptual or business model design and implementation
• Create database objects (tables, indexes, etc.)
• Write database stored procedures, functions and triggers
• Assist developers with database activities
• Write reports, develop dashboards
• Document system interdependencies from a business model perspective
• Use tools such as SSAS and Qlik View

• This position does not have any supervisory responsibilities

• Primary contacts will be internal to Information Technology
• Contact with other Albany Med departments will be limited and in support of job specific activities/on project teams
• Contact with vendors will be limited to support calls as needed
• Contact with others outside of Albany Med will be limited to job specific forums/organizations for technical collaboration

• Provide on-call, extended weekday and weekend support for on-site and off-site locations, as warranted by critical business requirements
• Maintain confidentiality by using and communicating information only as needed to perform one’s duties
• Perform at or above the Information Technology performance…