Information Technology Specialist
- Full Time
The mission of the Architect of the Capitol (AOC) is to serve Congress and the Supreme Court, preserve America's Capitol and inspire memorable experiences. Under the leadership of Stephen T. Ayers, FAIA, LEED AP, the roles and responsibilities of the Architect of the Capitol cover an expansive and diverse portfolio. The AOC is responsible for the maintenance, operation, development and preservation of 17.4 million square feet of buildings and more than 553 acres of land throughout Capitol Hill. The AOC provides a welcoming and educational environment for millions of visitors through the U.S. Capitol Visitor Center and the US Botanic Garden. The AOC also provides professional expertise on the preservation of architectural and artistic elements entrusted to its care. Learn more at www.aoc.gov.
The AOC prides itself on our Core Values of Teamwork, Integrity, Pride and Professionalism.
The PROFESSIONALISM and INTEGRITY of each AOC employee demonstrates our dedication to providing quality services and our commitments to holding ourselves to the highest standards.
We recognize that we do our best work through TEAMWORK, each of us lending our individual strengths and talents to the greater goal of the entire team. We respect each other and rely on each other in our efforts to make the AOC a center of excellence.
We take PRIDE in what we do and in the honor of serving Congress, the Supreme Court, and the American people each and every day.
- Not Required
You must meet the United States Office of Personnel Management's (OPM) qualification requirements (including specialized experience and/or educational requirements) for the advertised position. You must meet all eligibility and qualifications requirements by the closing date of the job announcement. Additional information on the qualification requirements is outlined in the OPM Qualifications Standards Handbook of General Schedule Positions. It is available for your review on the OPM web site at http://www.opm.gov/qualifications.
Specialized experience is experience that has equipped you with the particular knowledge, skills and abilities to perform successfully the duties of the position, and that is typically in or related to the position to be filled. To be creditable, specialized experience must have been equivalent to at least the next lower grade level.
Candidates for the GS-14 grade level must have at least 52 weeks of specialized experience equivalent to the GS-13 grade level in the Federal service.
Specialized experience is defined as (1) experience designing, developing, testing, deploying and maintaining dashboards with drill down and drill through capabilities to monitor, support and expand financial and performance reporting in coordination with end users; (2) experience identifying, evaluating and recommending emerging data management technologies for improved efficiency and effectiveness; (3) experience designing, building and populating data models used by reporting tools. Includes, but not limited to: relational databases (such as Oracle and SQL Server), in memory models (such as Microsoft SQL Server Analysis Services (SSAS) tabular models) and others; (4) experience interfacing with existing Commercial Off-the-Shelf (COTS) vendors and outside vendor groups, consultants and contractors to maintain, update and improve data management for an organization. Note- COTS applications may include, but are not limited to: Tableau, QlikView, Crystal Reports, SAP Business Objects (BO), Excel Services, Google Analytics; and (5) experience communicating complex technical requirements and alternatives to non-technical personnel, including end users and senior management.
***Applicants for positions at grades GS-14 and above in the Architect of the Capitol must possess a Bachelor’s Degree or higher from an accredited college or university.***
Q - Nonsensitive
This position is in the Architect of the Capitol (AOC), Office of the Chief Operating Officer, Office of the Chief Financial Officer, Accounting and Finance Division, Financial Systems and Reporting Branch (FSR). The incumbent is responsible for providing technical advice, guidance and recommendations to management and other technical specialists on critical information technology (IT) issues related to data warehouses, data storage, data mining and reporting for the AOC. Reports covered include financial reports, performance reports and other cross-functional reporting requirements.
Data Management (40%)
Provides expert technical advice, guidance and recommendations to management and other technical specialists on critical IT issues for data warehouse, data storage, data mining and reporting for AOC financial, performance and other cross-functional reporting requirements.
Researches trends, patterns and emerging policies, guidelines and regulations in rapidly changing technology environment.
Designs, develops, tests, deploys and maintain dashboards with drill down and drill through capabilities to monitor, support and expand financial and performance reporting in coordination with end users.
Communicates complex technical requirements and alternatives to non-technical personnel, including end users and senior management.
Standardizes data and data definitions and ensures their consistent re-use throughout reporting infrastructure in support of an overall data governance program.
Applications Software (30%)
Designs and builds data structures used by reporting tools. Includes, but not limited to: relational databases (such as Oracle and SQL Server), in memory models (such as Microsoft SQL Server Analysis Services (SSAS) tabular models) and others.
Works within the AOC, across departments, with AOC employees and contractors of all skill levels. Significant interface with existing Commercial Off-the-Shelf (COTS) vendors and outside vendor groups, consultants and contractors to maintain existing, update and improve data management for agency. COTS applications may include, but are not limited to: Tableau, QlikView, Crystal Reports, SAP Business Objects (BO), Excel Services, Google Analytics. Computer languages include, but are not limited to: SQL, database functions, stored procedures, etc., Microsoft SQL Server Integration Services (SSIS) modules.
Identifies and addresses changing report requirements, information security and interfaces with enterprise-wide and shared services’ systems, such as Legislative Branch Financial Management System (LBFMS) CGI Momentum, AOC/US Capitol Police (USCP) Maximo Inventory Control System, AOC in-house reports warehouse and other IT programs.
Improves efficiencies and effectiveness of existing interfaces between multiple systems. Optimizes system and data models as needed to reduce run time and improve reporting of existing in-house and emerging technology.
Systems Analysis (10%)
Serves as technical authority for data management, data warehouse, data mart and reporting programs for the AOC. Works independently and with stakeholders to plan, design and carry out projects, including changing requirements, policies and regulations.
Designs, develops, documents, tests, integrates, deploys and maintains various reporting tools for agency and shared-services’ needs. Works within cloud, shared-services structure and traditional in-house network with multiple stakeholders.
Diagnoses and resolves application, system, database, interface and other errors, failures and inefficiencies to optimize performance of existing data warehouse and data mart structures.
Customer Support (10%)
Works with Information Technology Department (ITD), Financial Systems and Reporting (FSR), end users, contractors from existing COTS vendors and outside vendor groups, consultants and contractors to recognize needs and recommend solutions. Focus is on continuous improvement of products to facilitate customer needs.
Represents AOC in meetings and works with reporting tool vendors, such as Tableau, QlikView, Oracle, Microsoft, or SAP. Maintains keen awareness of customer needs and ensures they are addressed in workgroups and meetings.
Enterprise Architecture (5%)
Stays abreast of emerging technologies and their potential application to AOC business processes and enterprise architecture.
Designs, develops and manages systems that meet current and future business requirements and apply and extend, enhance or optimize the existing AOC system architecture.
Maintains an up-to-date understanding of National Institute of Standards and Technology, and AOC Security Directives to ensure system compliance with all security requirements.
Ensures that application security issues and concerns are thoroughly tested, documented and addressed prior to deployment of upgrades and/or new system applications. Works closely with other specialists to ensure security, privacy and interoperability of applications.