Business Intelligence Architect

Description

• The Business Intelligence Architect is responsible for providing technical direction and expertise for IT Business Intelligence projects. The Business Intelligence Architect will use project management methodologies and System Life Cycle disciplines to ensure successful implementation of projects in support of corporate initiatives. The Business Intelligence Architect participates on development efforts by performing detailed analysis, developing detailed designs, programming, and testing applications. The ability to effectively communicate with all levels of the organization, including senior management, is essential.
  
  • Bachelor’s degree in Information Technology or equivalent in experience and education.
  • Minimum of 5 to 7 years experience designing and developing business intelligence applications or demonstrated equivalent knowledge.
  • Experience with methodology based development.
  • Understanding of application design principles and application architecture.
  • Ability to navigate and work on multiple operating systems such as OS/400, AIX, or Windows.
  • Extensive knowledge of SQL, including cursors, stored procedures, and indexes. Proficient with relational databases such as Oracle, MS SQL Server, and DB2.
  • Experience with various business intelligence tools such as Cognos, Crystal Reports, or Informatica is preferred.
  • Ability to work as part of a team or to be self-directed as required.
  • Good organizational and project management skills including demonstrated success in leading small to medium sized project teams.
  • Good oral and written communication skills.
  • Knowledge of health care business is preferred.

Requirements I. Specific Duties
• Leadership
o Promote Core Values in all activities.
o Coach, mentor and delegate to Business Intelligence Specialists and Senior Business Intelligence Specialists to facilitate their development.
o Provide day-to-day technical support to Business Intelligence Specialists, Senior Business Intelligence Specialists, and other IT resources to solve problems, provide guidance and direction and develop new skills in others.
o Facilitate a collaborative approach to problem solving and make well-reasoned decisions.
• Engineering
o Follows the IT systems development lifecycle in order to achieve project objectives within budget and timeframe requirements.
o Manages small to medium sized projects.
o Follow established quality standards, checkpoints, and communications processes to ensure project quality.
• System and Software Development
o Demonstrates good analytical abilities and technical skills.
o Prepares detailed system and program specifications.
o Manages testing of all system functions.
o Prepares and provides user training and system documentation.
o Automate data access processes and solve reporting and analysis problems for business units and external stakeholders.
o Design, blueprint, code and provide development support as necessary for BI systems, applications and programs.
o Assist in the design of database models and data warehouses to ensure interoperability with BI solutions.
o Develop and implement strategies for meeting analytic needs that are not addressed by current data warehouse capabilities.
o Create and follow standards and maintain processes to balance consistency with flexibility to support the business needs.
o Lead data validation effort by planning, designing and deploying effective test regimens. Apply proven analytical and problem-solving skills to help validate, verify, communicate and resolve issues through careful testing.
o Develop written specifications and documentation to support BI processes.
o Apply proven communication, analytical and problem-solving skills to identify, communicate and resolve problems.
o Ensure stability, integrity, availability, productivity and efficient operation of BI systems.
• End User Support
o Translates customer needs into requirements.
o Manages changes to requirements.
o Ensures customer requests for information are addressed and follow up occurs.
o Gains customer satisfaction.
o Understands business objectives of departments.
o Evaluates and recommends application systems that can improve department’s environment.