MicroStrategy Business Intelligence (BI) Administrator

Job Description:

SUMMARY:
The Business Intelligence (BI) Administrator is responsible for enterprise-wide administration, report design and support of third party Business Intelligence software including, but not limited to: MicroStrategy, SAS, Hyperion, Unica and or Cognos. The primary focus is utilizing advanced functions within BI tool suites to gain optimum efficiency and accuracy.


JOB RESPONSIBILITIES:
MANAGING EMPLOYEES:
• Coaches less experienced teammates
• Creates documentation to aid in others' learning
• If applicable, provides supervision and ensures quality and timeliness of others' deliverables

MANAGING WORK:
• Understands scope, priority and timelines for assigned work
• Manages workload to deliver quality deliverables that meet requirement
• Communicates status of assignments to supervisor
• Notifies supervisor of issues that impact productivity or ability to meet expectations
• Adheres to CSF processes in completing assignments
• Follows standards/uses standard toolsets
• Assists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members
• Resolves issues or escalates to Manager, if necessary
• Identifies opportunities to improve existing conditions and processes & implements solutions
• Creative in problem solving
• Does not miss important items
• Does not need to be told the same thing multiple times
• Checks work in to central repositories


ADDITIONAL RESPONSIBILITIES:
• Provide Administration of Business Intelligence software under the domain of Database Architecture to support enterprise-wide initiatives.
• Provide report development for one of the following: MicroStrategy, SAS, Hyperion or Cognos.
• Design recommendations to accommodate business requirements, application development needs, and database modifications required to implement BI solutions.
• Provide leadership for other BI team members and act as liaison between BI Administrators, Developers, Database Administrators, System Administrators, and business users
• Determine the appropriate BI tool for the task
• Perform BI Administration tasks including:
- Perform BI software installation and configuration
- Perform BI software backup and recovery
- Apply BI software patches and upgrades
- Perform BI performance tuning
- Validate BI source connectivity
- Perform BI scheduling tasks
- Provide BI documentation
- Provide on-call support


QUALIFICATIONS:
EDUCATION:
Bachelors’ degree or equivalent experience

EXPERIENCE:
• 5+ years experience in hardware and software management
• Experience administering Business Intelligence software (minimum 3 years)
• Database background required
• Data modeling background required (minimum 3 years)
• Data warehouse familiarity (minimum 3 years)


SPECIAL SKILLS:
• Solid understanding of Business Intelligence software: MicroStrategy Desktop, MicroStrategy Web, MicroStrategy NarrowCast, Hyperion Performance Suite, and/or SAS Enterprise Guide.
• Strong written and verbal communication skills
• Strong technical skills
• Strong analytical and problem solving skills
• Strong interpersonal skills
• Strong understanding of the software development lifecycle including: requirements gathering, design, coding, testing and production support.
• Strong understanding of Relational OLAP database models used in Decision Support Systems
• Good understanding of SQL in accessing and manipulating data in Very Large Databases.
• General understanding of system architecture.
• Understanding of Unix, DOS and Windows operating systems
• Understanding of general programming concepts


CORE COMPETENCIES:
CUSTOMER FOCUS:
• Establishes strong relationships with customers
• Understands and strives to meet customer needs

TEAM ORIENTATION:
• Works well with others
• Assists less experienced team members

LEADERSHIP:
• Sets a good example for less experienced team members
• Provides direction
• Proposes and implements change
• Is held accountable for all actions/work
• Displays initiative
• Demonstrates persistence until goals are met
• Applies problem solving skills to overcome obstacles
• Attempts to solve problems, yet asks for help before productivity is impacted
• Adapts to given situations
• Understands and works effectively with ambiguity

COMMUNICATION SKILLS:
• Excellent verbal and written communication skills
• Strong listening skills
• Translates technical details into descriptions the customer can understand
• Illustrates concepts clearly
• Adjusts content of written/verbal communication to the audience
• Written communications are succinct, clear and complete

PERSONAL QUALITIES:
• Displays professionalism, honesty, integrity, self confidence, maturity, respect and conviction
• Maintains a positive attitude