Business Intelligence and Data Manager

Washington Metropolitan Area Transit Authority (WMATA); Washington (District of Columbia); On-site; USD 110,000 - 150,000; Full time

Job summary

Washington Metropolitan Area Transit Authority (WMATA) is seeking a Business Intelligence and Data Manager to support the Finance Department's Management and Budget Office. The role will manage BI, analytics, reporting, and data governance across WMATA’s funding sources, ensuring data-driven decisions that improve efficiency and accountability.

You will develop dashboards, performance metrics, and interfaces across systems, collaborating with stakeholders to advance WMATA’s strategic priorities

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Finance, Public Administration, Business Administration, or other related fields.
• Six (6) years of work experience in program or project management, budgeting, public administration, information systems and/or data management related role.

Responsibilities

• Contributes to data analyses from the financial management system to support decisions.
• Interprets data analyses for operating and capital project funding, forecasting, and reporting requirements.
• Aggregates data from multiple sources to inform funding and debt financing decisions.
• Develops and uses business intelligence tools to inform budget and six-year capital plans.
• Supports ERP programs for projects, funding, and budgeting; maintains data and funding rules.
• Identifies funding and grant reporting requirements and pulls data from disparate systems.
• Develops metrics to measure program and funding effectiveness and efficiency.

Skills

Interpersonal communication

Stakeholder engagement

Technical explanation

Education

Bachelor's degree in Information Systems

Tools

Microsoft Office Suite

Adobe Creative Suite

Acrobat

Job description

JOB DESCRIPTION

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.

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.

Responsibilities

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.

Qualifications

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

About Us

The Washington Metropolitan Area Transit Authority (WMATA), known as Metro, is the region’s leading public transportation provider. Serving a 2,054-square-mile jurisdiction, Metro operates six rail lines, 98 stations, 126 bus routes, and Metro Access, a shared-ride paratransit service. As one of the nation’s busiest transit systems, Metro connects communities, supports economic growth, and provides safe, reliable transportation.

Evaluation Criteria

Consideration will be given to applicants whose resumes demonstrate the required education and experience. Applicants should include all relevant education and work experience.

Evaluation criteria may include one or more of the following:

• Skills and/or behavioral assessment
• Personal interview
• Verification of education and experience (including certifications and licenses)
• Criminal Background Check (a criminal conviction is not an automatic bar to employment)
• Medical examination including a drug and alcohol screening (for safety sensitive positions)
• Review of a current motor vehicle report

Closing

WMATA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, status as a protected veteran, or any other status protected by applicable federal law.

This posting is an announcement of a vacant position under recruitment. It is not intended to replace the official job description. Job descriptions are available upon confirmation of an interview.