Business Intelligence; BI Architect

Department: Information Technology

Classification: Info Technology Spec 3

Job Category: Classified Staff

Job Type: Full-Time

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

Location: Fairfax, VA

Workplace Type: Hybrid Eligible

Sponsorship Eligibility: Not eligible for visa sponsorship

Pay Band: 06

Salary: Salary commensurate with education and experience

Criminal Background Check: Yes

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.

The Business Intelligence (BI) Architect:

• Supports and maintains the Micro Strategy environment, which provides reporting using data from the enterprise data warehouse and other data sources.
• Configures and maintains the semantic layer within the enterprise BI tool, which enables the development of standard datasets and reporting. Ensures the configuration supports and enforces defined security policy.
• Performs report development and troubleshooting. Collaborates with stakeholders, subject matter experts, and report users to define reporting requirements and validate results.
• Assists customers in meeting their reporting needs by ensuring that reports perform well. This includes support for new requests, bug fixes and enhancements as well as troubleshooting customer issues.

Develop Complex Reports

• Using knowledge of star schemas and relational databases, uses reporting tools such as Micro Strategy to develop complex reports for the university’s administrative and academic units;
• Independently collaborates with users in developing requirements for data mart reports, using drill-down and cube technologies as necessary to effectively and efficiently meet the reporting needs;
• Develops prototypes to demonstrate concepts;
• Develops and maintains requirements and report documentation;
• Develops and abides by report development standards and best practices;
• Conducts thorough unit testing on all newly developed and modified reports; and
• Keeps abreast of new features/technology in Micro Strategy.

End User Support

• Acts as principal liaison with business users in the use of Micro Strategy and the underlying metadata/data marts;
• Develops training material and conducts training sessions for users of the various university Data Marts;
• Assists the Micro Strategy Administrator in report trouble-shooting and problem resolution;
• Supports users in the use of the Micro Strategy; provides one-on-one consulting/assistance to report developers as needed/requested; and
• Periodically serves as the primary point of contact with users regarding support and use of reports developed by the Business Intelligence Services team.

Data Mart Team Collaboration

• Assists Data Mart Analysts in the testing of data mart tables and views; and
• Assists with testing Micro Strategy and database upgrades/patches for functionality, performance and security.

BI Architecture

• Defines the semantic layer within the BI tool, enabling access to data sources and generation of datasets to support reporting and analysis;
• Ensures the accuracy of results through unit and regression testing of datasets;
• Implements access controls to align with defined data security policy, enabling data element access as defined by data stewards;
• Manages the migration of objects between the development, UAT and production environments, including definition of procedures and best practices; and
• Supports performance tuning of reporting queries using a variety of techniques, including using VLDB properties and by interacting with DBA’s and database designers.

• Bachelor’s degree in related field or the equivalent combination of education and experience;
• Typically, 5+ years of experience in a BI Developer/Architect role utilizing Micro Strategy;
• Experience in all aspects of software development life cycle for Data Warehouse/BI projects;
• Experience with Oracle or other relational databases;
• Knowledge of Data Warehouse design and star schema methodology;
• Knowledge of SQL queries;
• Excellent communication skills, both verbal and written;
• Strong organizational skills, including the ability to manage multiple work streams simultaneously;
• Skill developing reports, documents, and dossiers/dashboards in Micro Strategy;
• Skill configuring the semantic layer/model in Micro Strategy;
• Skill working with Micro Strategy Architect to build hierarchies, attributes, facts and relationships between various attributes;
• Ability to perform Micro Strategy object migration, user management, and…