Business Intelligence (BI) Administrator & Report Developer

George Mason University • Fairfax, VA

1d • Onsite

About The Position

The Business Intelligence (BI) Administrator & Report Developer supports and
maintains the enterprise Business Intelligence (BI) environment, which provides
reporting using data from the enterprise data warehouse and other data sources.
The position maintains and monitors the BI platform configuration, including
connections to data sources, definition of user accounts and groups, and
authentication. Performs system administration, including monitoring system
health, analysis of logs, and resolution of issues. The role performs report
development and troubleshooting and collaborates with stakeholders, subject
matter experts, and report users to define reporting requirements and validate
report results. Assists customers in meeting their reporting needs by ensuring
that reports are accurate and perform well. This includes support for new
requests, bug fixes and enhancements, as well as troubleshooting customer
issues. The role disseminates information about the enterprise BI tool to the
end-user community, and trains end-users on the policies and supporting
procedures necessary to use the BI tool. The position collaborates closely with
BI reporting and data mart team members, as well as other stakeholders
throughout the university.

Requirements

• Bachelor’s degree in related field, or equivalent combination of education and experience
• Hands on experience with the administration of an enterprise BI platform
• Knowledge of data warehouse design and star schema methodology
• Skill developing reports and dashboards using a BI tool such as MicroStrategy, Power BI, or Tableau
• Proficiency with SQL queries
• Strong organizational skills, including the ability to manage multiple workstreams simultaneously
• Ability to communicate and work effectively with systems technical staff and business users
• Excellent communication, debugging, monitoring, and troubleshooting skills.

Nice To Haves

• Master’s degree in related field
• MicroStrategy certification
• Experience developing reports using Strategy/MicroStrategy
• Experience transitioning a BI solution from on premise to a cloud environment
• Experience administering a BI tool in a cloud environment
• Experience with Microsoft Active Directory or similar identity providers for BI tool access management
• Experience working in an agile development environment
• Deep understanding of MicroStrategy architecture, security, and administration tools (Developer, Object Manager, Command Manager, Workstation)
• Proficiency in Linux/Unix environments, including shell scripting and Python
• Knowledge of and experience working with higher education data.

Responsibilities

• Develop Complex Reports: Applying knowledge of star schemas and relational databases, develops complex reports for the university's administrative and academic units using enterprise reporting tools such as MicroStrategy/Strategy; Collaborates with users and stakeholders to gather requirements for reports. Develops and maintains requirements and reports documentation; Applies reporting tool features to effectively and efficiently meet the reporting requirements, developing prototypes as needed to demonstrate concepts; Develops and abides by report development standards and best practices; Conducts thorough unit testing on all newly developed and modified reports; Works with ITS staff in enhancing ETL processes to populate the data warehouse, adding data elements as necessary to meet user’s needs; and Keeps abreast of new features in the enterprise BI tool.
• End User Support: Acts as principal liaison with business users in the use of MicroStrategy and the underlying metadata/data marts; Develops training material and conducts training sessions for users of the university data warehouse; Assists the MicroStrategy Administrator in report trouble-shooting and problem resolution; Supports users in the use of MicroStrategy; provides one-on-one consulting/assistance to report developers as needed/requested; and Periodically serves as the primary point of contact for user support and inquiries regarding reports produced by the BIS team.
• Data Mart Team Support: Assists data mart analysts in the testing of data mart tables and views; and Assists with testing MicroStrategy and database upgrades/patches for functionality, performance, and security.
• BI Tool Administration: Supports configuration, management, and administration of MicroStrategy; Supports installation and upgrades of MicroStrategy software; Develops and maintains scripts in support of automated administration tasks; Uses diagnostic tools to monitor MicroStrategy performance and user sessions; Monitors cache management, cube refreshes, subscriptions, schedules, and governing settings for MicroStrategy; and Manages user authentication and maintains user groups and privileges to ensure secure report and data access in MicroStrategy.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees