Business Intelligence Analyst II (Onsite)

Department/Unit:

AMHS - IT Analytics

Work Shift:

Day (United States of America)

Salary Range:

$71,612.39 - $110,999.20

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.

This position is in person

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.

Typical responsibilities include:

Maintenance

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

Recovery

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

Security and Protection

• Implement and maintain reporting and visualization application security

Support

• 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

Development

• 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 QlikView

Supervision

• This position does not have any supervisory responsibilities

Contact with others

• 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

Other

• 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 standards
• Fulfill department requirements in terms of providing work coverage and administration notification during periods of absence (personnel illness, vacation, education, etc.)

Complete other duties or assignments as designated by management

Thank you for your interest in Albany Medical Center!

Albany Medical is an equal opportunity employer.

This role may require access to information considered sensitive to Albany Medical Center, its patients, affiliates, and partners, including but not limited to HIPAA Protected Health Information and other information regulated by Federal and New York State statutes. Workforce members are expected to ensure that:

Access to information is based on a "need to know" and is the minimum necessary to properly perform assigned duties. Use or disclosure shall not exceed the minimum amount of information needed to accomplish an intended purpose. Reasonable efforts, consistent with Albany Med Center policies and standards, shall be made to ensure that information is adequately protected from unauthorized access and modification.