Business Intelligence Manager

Washington D.C
Mar 27, 2023
Apr 01, 2023
Analyst, Management
Full Time
Business Intelligence Manager Marketing Statement:

Metro seeks a Business Intelligence Manager to manage funds, maintain sufficient control, and optimize the use of over $3 billion dollars in multiple Federal, state, and local sources that fund Metro's annual capital program and provide financial assistance for the operating budget. Metro mainly aims to ensure adequate processes are in place to identify, mitigate, and measure risk while ensuring corresponding controls are effective yet flexible.

The position is on the Management and Budget team, which is part of the Finance organization. This portion of the Finance supports Metro's prioritized capital program, ensuring it wisely advances agency priorities and invests in federal, jurisdictional, and dedicated funding. It is the lead organization responsible for capital budgeting and funds and grants management for both the capital and operating budgets , and capital reporting.

The incumbent will work in conjunction with the Director and Senior Manager to manage all aspects of the maintenance of Metro's funding system via Oracle's PeopleSoft Financials to manage over $3 billion effectively made up of multiple funding sources each of which has unique "color of money" and "time of money" and specific billing rule requirements. Additionally, the position will support the Director in data management and business intelligence by reporting/mining data and presenting that data in various levels of detail for Metro's internal and external customers and reviewers. This includes using data tools such as Microsoft's Power Query and Power BI and Oracle's Oracle Business Intelligence Enterprise Edition (OBIEE) and Discoverer tools. The incumbent is expected to be a leader and the main point of contact for auditors, reviewers, and significant contributors from within Metro, external to Metro, and the US Government who affect and influence Metro's funding program.

Minimum Qualifications

  • Bachelor's Degree in degree in City/Regional Planning, Civil/Transportation/Software Engineering, Information Technology, Computer Science, or a related field

  • A minimum of seven (7) years of progressively responsible experience in data systems development, management, and analysis of public transportation systems, transportation operations, or related fields, to include a minimum of two (2) years in a supervisory capacity and/or management of projects, project teams, and consultants

  • N/A

  • N/A

Medical Group

Satisfactorily complete the medical examination for this position, if required. The incumbent must be able to perform the essential functions of this position either with or without reasonable accommodations.

Job Summary

The Business Intelligence Manager leads strategic planning and business intelligence activities in the Office of Planning, delivering data pipelines and quantitative analysis to gain insights into the organization, while supporting strategic decision making. The incumbent manages and supports a team, responsible for gathering, organizing, and analyzing data from a variety of operational and planning data systems, designing business solutions aimed at optimizing performance throughout the authority. The incumbent leads and serves as an integral member of a team required to identify and cultivate data sources, develop data flow and data transformation algorithms, generate tools and data sets. The results provide critical information to support WMATA offices' offering data supported, action-driven recommendations and insights to executive leaders and managers. The incumbent also participates in strategic and tactical planning discussions to identify key questions and areas to be analyzed.

  • Leads and supports the implementation of data sets, algorithms, and/or tools in support of the Business and Strategic Plans across the Authority. Enables data-driven decision-making throughout the authority. Uses technical knowledge and business acumen to identify opportunities for and strategies to capture, transform, aggregate, summarize, and publish data from a variety of internal and external sources.
  • Identifies opportunities to use data to improve decision making processes, addressing the planning, operations, capital, and transit performance measurement challenges of internal client groups.
  • Identifies datasets from a variety of operational and planning systems to be cultivated to support data-driven decision making for internal clients. Identifies opportunities for improved data storage and aggregation formats. Conducts interviews with data owners; documents data flows; develops requirements for data transformation tasks.
  • Develops, extracts, transforms, and loads scripts to migrate raw data into large, structured datasets. Makes data sets more accessible to other analysts and subsequent steps in the data flow process.
  • Creates database objects to store structured and aggregated data and facilitate data extraction. Creates new data storage for full data sets in a location accessible to existing data systems and tools.
  • Authors, optimizes, and runs user- and business-focused data transformation algorithms. Converts "big" data into aggregated and summarized formats more easily used by analysts. Develops and runs Oracle SQL or other scripts to transform data from bulky raw full data sets into aggregated "data marts".
  • Develops dashboards and data tools to support PLAN's technical analyses and customer-focused, data-driven decision making within other WMATA offices. Enables data-driven decision making for non-technical users by creation of user-friendly, web-based dashboards to answer complex business questions and provide data downloads. Authors Tableau dashboards, hosts dashboards on internal or external Tableau server instances.
  • Leads analysis of ridership, fare system, vehicle location, and other WMATA data to identify actionable insights for stakeholders across WMATA. Enables data-driven decision-making and uses data to inform policy. Analyzes, aggregates, and integrates multiple sources of data, creates data visualizations, creates graphics and writes reports and presentations to communicate conclusions to stakeholders.
  • Serves as a project manager, managing teams consisting of contractors and colleagues from partner departments to develop planning, capital, and systems intelligence solutions, to achieve the Authority's mission and resolve the region's mobility challenges. Coordinates and guides project teams in the steps of data transformation and dashboard/tool creation.
  • Facilitates the procurement of consultant services, third-party data and tools and new industry insights into the future of regional travel demand. Brings on-board new analytical skills and datasets to provide insights into the future of regional travel demand.
  • Maintains effective working relationships with individuals and organizations.
  • Supervises subordinate staff to include interviewing, hiring, training, and coaching employees; planning, assigning, and directing work; establishing work plans and programs; leveraging team and individual strengths; managing performance; rewarding and disciplining employees. Other supervisorial duties as needed.


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, disability, 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.

Similar jobs