Business Intelligence Analyst Lead - Hybrid

Purpose Of The Job

Develops reports using data-warehouse and data-access tools; provides user support and training for data structure and use of Data Warehouse; creates mapping specifications from source systems to new and expanded business-intelligence systems, and designs, tests and implements new business intelligence systems.

Required Work Experience

• 1 year of experience in computer technology and/or information systems (Level
  1)
• 2 years of experience in computer technology and/or information systems (Levels 2 –
  4)
• 2 years of experience in data management and report analysis, design or development (Levels 2 –
  4)

Required Education

• High-School Diploma or GED in general field of study (All Levels)

Required Licenses

• N/A

Required Certifications

• N/A

Preferred Work Experience

• 2 years of experience in computer technology and/or information systems (Level
  1)
• 3 - 5 years of experience in computer technology and/or information systems (Level
  2)
• 5 years of experience in data management and report analysis, design or development (Levels 3
  - 4)
• 2 years of experience working in healthcare-related systems as a business analyst or programmer (Levels 3
  - 4)

Preferred Education

• Bachelor's Degree in Computer Science, Information Systems, Business, or related field (All Levels)

Preferred Licenses

• N/A

Preferred Certifications

• N/A

Level 1 - Performs job functions under close supervision or peer review

Analysis

• Track and resolve processing problems, coordinating with all areas
• Track and resolve programming problems
• Develop and document business objectives, processing requirements, and specifications
• Develop and document system and data diagrams, program flows
• Develop test plans, scripts and test bases
• Analyze files and map data from one system to another
• Draft or modify internal procedures; implement new procedures including workflows, manuals and training
• Utilize corporate data tools to ensure quality and documentation standards are achieved.
• Provide backup support to SME's in two or more of areas as assigned:
• BI Project Management
• BI Production Reporting
• Application Architecture
• Application Architecture and Support
• Training
• Provide backup support to SME's in one or more datamarts

Technical/Programming

• Learn process and data flow; and how it affects surrounding systems and operational areas.
• Map logical data models to physical data models.
• Maintain existing programs/routine changes and major enhancements.
• Document programs, systems, manuals, etc.
• Review code for proper design, standards, content and functionality.
• Design and code complex programs.
• Responsible for production cycles, solving abends and notification of problems.
• Responsible for production support documentation in accordance with department standards and industry best practices.
• Review code for proper design, standards, content and functionality.
• Program in multiple programming languages (SQL, , 3GL/4GL).
• Translate business needs into technical solutions with knowledge of Bl Tools (SQL, ETL, and OLAP).
• Implement and maintain operational and disaster-recovery procedures.
• Manage Metadata
• Conduct capacity planning
• Write or modify procedures for internal use, user operational areas, and computer operations, as applicable.
• Utilize ODBC and OLE DB methodology.

Business Intelligence / Database

• Educate users on data warehouse capabilities; gain consensus among users on common data definitions
• Understand business opportunities for information usage
• Schedule data updates and report generation
• Develop business intelligence and EIS applications
• Convert existing reporting applications to use the data warehouse and datamarts
• Develop periodic reporting systems
• Develop monitoring systems to ensure data has been updated as expected
• Monitor data quality
• Implement data access tools
• Develop metadata management processes and/or systems

Project Management

• Develop programs, time estimates and project schedules based on prioritization and business requirements.
• Use sound project management methodology and demonstrate solid time management skills.
• Creates and delivers presentations.
• Monitor and create priority list(s) that are agreed to by user management

User Support

• Assist users with…