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.
ESSENTIAL FUNCTIONS
- 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.
Minimum Qualifications
Education
Bachelor’s Degree in degree in City/Regional Planning, Civil/Transportation/Software Engineering, Information Technology, Computer Science, or a related field
Experience
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.
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.
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:
- Personal Interview
- Skills Assessments
- Verification of education and experience
- Criminal Background Check
- Credit history report for positions with fiduciary responsibilities
- Successful completion of a medical examination including a drug and alcohol screening
- Review of a current Motor Vehicle Report
Please apply before 8/11/2022
To apply for this position, visit WMATA's Career Center