Business Intelligence and Data Manager

Marketing Statement:

WMATA’s Funds and Grants Management Office is seeking a Business Intelligence and Data Manager. This team leads Metro's efforts to transform data into actionable insights that strengthen financial management, grants and funding management, organizational performance, and strategic decision-making. In addition to the requirements below this position oversees business intelligence, analytics, reporting, and data governance initiatives, develops dashboards and performance metrics, and partners with stakeholders across the organization to support data-driven decisions that improve efficiency, accountability, tractability and service delivery. Through innovative use of data and technology, this role helps advance Metro's strategic priorities and operational excellence.

Job Description:

The Business Intelligence and Data Manager will support the Finance Department's Management and Budget (M&B) Office which is responsible for the management of the operating and capital budgets development, execution, and reporting. This position will support M&B, specifically the Funds and Grants Management office. The Business Intelligence and Data Manager is responsible for all aspects of incoming funding and outgoing project expenses associated with WMATA's multiple federal and non-federal funding sources. The incumbent supports the M&B office and is key to administering the rules-based funds control system, to include all interfaces to other ledger and non-ledger sources. The incumbent will also be a key participant in the development and implementation of the future finance/budgeting/funding systems. Additionally, the incumbent will support all aspects of required reporting for the federal and non-federal sources. The incumbent is expected to be a key point of contact to other system administrators and users in ensuring seamless integration of all information systems such as inventory, payroll, timekeeping, and receivable/payment systems. The position will be part of a close-knit collaborative team environment that encourages discussion, discovery, and innovative problem-solving.

Principal Job Duties

• Conducts data analyses and provides recommendations by aggregating and integrating information from areas such as the existing financial management system.
• Interprets data analyses to foster managerial decision making in the areas of operating and capital project funding, forecasting, and production of jurisdictional and federal reporting requirements.
• Aggregates and integrates data from various sources to inform key recommendations, which will influence agency investments decisions in areas such as federal and local funding utilization and debt financing needs.
• Develops and employ business intelligence tools to inform decisions on the current, upcoming budget, and future 6-year capital funding plan for the Authority.
• Supports all aspects of Metro's project, funding, and budget enterprise resource planning (ERP) programs. Performs, maintains and optimizes projects' data, billing, and funding rules, entry and administration in the ERP programs.
• Assists in identifying and fulfilling all funding and grant reporting requirements. This may include identification and extraction of data from disparate systems and fusion of the data.
• Develops innovative metrics to measure effectiveness and efficacy of programs, funding, and administrative resources.

Other Duties

• Maintains and promotes awareness and accountability with safety policies and procedures while performing job functions. Promotes a positive safety culture and encourages reporting of safety concerns consistent with our Agency Safety Plan, other regulatory requirements within the Safety Management System and just culture principles.

The functions listed are not intended to limit specific duties and responsibilities of any particular position. Nor is it intended to limit in any way the right of managers and supervisors to assign, direct and control the work of employees under their supervision.

Knowledge

• Knowledge of financial management systems and projects, or with Federal and other fund sources.
• Knowledge of Federal financial management practices and other grant and contract management policies and procedures.
• Knowledge of Federal, State, and Local government proposal solicitation requirements and processes, and contract compliance.
• Knowledge of modern accounting systems including the use and integration of sub-ledgers.
• Knowledge of modern database and business intelligence systems and tools.

Skills

• Excellent interpersonal and communication skills
• Skilled with interaction of various internal technical audiences to ensure requirements are addressed from an information technology perspective

Abilities

• Ability to collect, organize, and edit technical concepts into easy-to-understand grant and contract proposals.
• Ability to personally engage effectively with all staff at all levels.
• Ability to explain FGM processes and challenges to various non-technical and technical audiences.
• Demonstrated ability to write effectively with compelling language and appropriate grammar.
• Ability to communicate complex operational and policy matters in written communications with various audiences.
• Ability to think innovatively and creatively about their work.

Machine, Tools, Equipment, Software, Hardware Required

• Microsoft Office Suite to include Word, PowerPoint, Excel
• Laptop computer
• Printer
• Copier
• Adobe Creative Suite, Acrobat

Supervisory Responsibility

Not responsible for supervising others.

Minimum Education

• Bachelor's degree in Information Systems, Computer Science, Finance, Public Administration, Business Administration, or other related fields.

Minimum Experience

• A minimum of six (6) years of work experience in program or project management, budgeting, public administration, information systems and/or data management related role. Advanced education may be substituted for experience.

Minimum Certification/Licensure

• N/A

Preferred Qualifications

• N/A