BI/Data Warehousing Analyst II

Encompass Health - Birmingham, AL

Full-time - Mid Level

Onsite - Birmingham, AL

Hospitals

About the position

The BI/Data Warehousing Analyst II plays a crucial role in the design, development, and maintenance of enterprise data warehouse applications at Encompass Health. This position focuses on data architecture, metadata creation, and troubleshooting existing applications, ensuring that business intelligence applications align with current architecture standards. The analyst will also engage in system deployment, user training, and documentation, contributing to the overall efficiency and effectiveness of data management within the organization.

Responsibilities

• Designs, builds, configures and tests software systems and solutions.
• Designs documentation.
• Develops applications.
• Performs preliminary testing.
• Participates in testing process.
• Supports system deployment.
• Creates technical documentation.
• Executes end-user training and documentation.
• Develops appropriate program and systems documentation.
• Prepares and implements data verification and testing methods for the data warehouse.
• Creates index and view scripts.
• Keeps updated through industry-related materials, periodicals, associations and the internet.
• Understands and utilizes the company resource structure.
• Codes and documents scripts and stored procedures.
• Designs and implements data strategy methods.
• Develops strategies and aligns work to achieve goals.
• Completes special projects and other duties as requested to support needs of organization.
• Networks with co-workers to share best practices.

Requirements

• Valid state driver's license.
• Associates Degree or Undergraduate degree preferred.
• Minimum 3 years of experience.
• Familiar with systems development life cycle for packaged applications.
• Business requirements definition and documentation.
• System design and software development.
• Common system and user acceptance testing procedures.
• System deployment and technical documentation.
• End user training execution and documentation.
• Familiar with regulatory compliance including HIPAA, Medicare, CMS, Sarbanes-Oxley, Privacy and Security.
• Technical knowledge in Oracle Database Platform, MS SQL Server Database Platform, SQL / PL/SQL / Transact-SQL, Light Unix Shell Scripting, Light MS Batch Scripting, Performance tuning, Query optimization, Database modeling and design, Data validation.

Nice-to-haves

• Familiarity with Hyperion Reports and Hyperion Essbase.
• Knowledge of other BI technologies.
• Experience in User Interface design, OLAP design, Cube design, Process re-engineering, ETL.

Benefits

• Affordable medical, dental and vision plans for full-time and part-time employees and their families.
• Generous paid time off that accrues over time.
• Tuition reimbursement and continuing education opportunities.
• Company-matching 401(k) and employee stock purchase plans.
• Flexible spending and health savings accounts.