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