Sign upLog in

Business Intelligence (BI) Administrator & Report Developer

George Mason University

Fairfax, Virginia

Apply
JOB DETAILS
SKILLS
Administrative Management, Administrative Skills, Authentication, Background Investigation, Best Practices, Business Intelligence, Business Intelligence Software, Business Services, Business Support, Configuration Management, Consulting, Customer Support/Service, Data Analysis, Data Mart, Data Sets, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Distributed Computing, Enterprise Applications, Help Desk, Identify Issues, Information Technology & Information Systems, Intelligence Agencies, Metadata, MicroStrategy, Performance Analysis, Problem Solving Skills, Prototyping, Relational Databases (RDBMS), Reporting Dashboards, Reporting Skills, Requirements Management, Requirements Validation/Verification, Scripting (Scripting Languages), Software Patches, Software Upgrades, Standards Development, Star Schema, Systems Administration/Management, Systems Analysis, Technical Training, Test Data, Training/Teaching, Unit Test
LOCATION
Fairfax, Virginia
POSTED
30+ days ago
Department: Information Technology

Classification: Info Technology Spec 2

Job Category: Classified Staff

Job Type: Full-Time

Work Schedule: Full-time (1.0 FTE, 40 hrs/wk)

Location: Fairfax, VA

Workplace Type: On Site Required

Sponsorship Eligibility: Not eligible for visa sponsorship

Pay Band: 05

Salary: Salary commensurate with education and experience

Criminal Background Check: Yes

About the Department:

The mission of the Enterprise Applications (EA) department is to plan, implement, and maintain integrated central and distributed information systems and associated databases that support the business needs of the University.

The Business Intelligence Services (BIS) team configures, maintains, and monitors the enterprise Business Intelligence tool. The BIS team creates and maintains the semantic layer within the tool, which enable access to University data sources, including the enterprise data warehouse. In addition, the BIS team creates standard datasets, reports, and dashboards, and supports users of these resources.

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.

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, cub

About the Company

G

George Mason University