The Department of Transportation Planning of the Metropolitan Washington Council of Governments (COG) is seeking a Program Analyst to perform data collection and evaluation activities for the Commuter Connections Transportation Demand Management (TDM) program for the metropolitan Washington, DC region.
SUMMARY
The Department of Transportation Planning of the Metropolitan Washington Council of Governments (COG) is seeking a Program Analyst to perform data collection and evaluation activities for the Commuter Connections Transportation Demand Management (TDM) program for the metropolitan Washington, DC region.
The successful candidate for this position has a strong ability to collect, publish, and analyze data generated by the program to help inform strategic direction. The candidate will be responsible for writing and proofreading various technical reports. Daily work will include team-oriented tasks requiring collaboration among team members and oversight of consultants. Prior TDM experience is preferred but not required.
EXAMPLES OF WORK
Project Lead for the Commuter Connections Regional TDM Evaluation Project. Collect data generated by program participants and report at monthly, quarterly, and annual frequencies to interested stakeholders. Coordinate triennial calendar of surveys that lead to the publication of technical reports.
Oversee contractual work performed by the Regional TDM Evaluation Consultant team. Assist Program Manager in developing and reviewing scopes of work (SOW). Collaborate with COG’s procurement team to issue contracts and/or contract amendments. Monitor work conducted by contractors and provide guidance, as needed.
Serve as staff lead to the Regional TDM Evaluation Workgroup, a group of network members who provide guidance and feedback to the Commuter Connections evaluation effort. This includes presenting work products to the workgroup, facilitating discussion, and collecting/analyzing feedback.
Proofread technical reports authored by the Regional TDM Evaluation consultant. Author reports associated with program monitoring, such as quarterly progress reports for program funders and stakeholders.
Mine database of 20,000 commuter records to generate relevant data for routine reporting. Generate custom reports for network members as requested.
Maintain and enhance visual data dashboards built with Microsoft Power BI on TDM program participation and impacts.
Maintain a Customer Relationship Management (CRM) database with over thirty contributors throughout the region. Enforce high data integrity standards. Assist and train contributors on proper data entry and maintenance. Run routine conformity reports to help evaluate contributors’ successes and growth opportunities.
Report annually to the Federal Transit Administration’s (FTA) National Transit Database (NTD) as part of the Commuter Connections ‘Pool Rewards Vanpool Subsidy program.
Collaborate with a variety of team members, such as the TDM Program Manager, Principal GIS Analyst, Database Administrator, and TDM Marketing Manager to procure necessary data that informs strategic decision making for Commuter Connections’ focus areas and marketing.
Make presentations of significant activities to committee groups as assigned.
SUPERVISORY RESPONSIBILITIES
None.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES
The successful candidate will require strong analytical skills and sound knowledge of principles and practices of program evaluation. This includes establishing and monitoring performance metrics, survey development and analysis, publishing data to an online dashboard, and reports writing (including writing SQL queries to generate reports). Ability to coordinate a project with several stakeholders, including consultants. Ability to express ideas clearly and concisely, both orally and in writing, and to establish and maintain effective working relationships with other employees, officials, and the public while demonstrating good judgment.
EDUCATION AND EXPERIENCE
Three or more years of progressively responsible experience in data analysis and program evaluation. Bachelor’s degree in Data Analytics, Computer Science, Public Policy and Administration, or related field, or any equivalent combination of experience and training which provides required knowledge, skills, and abilities.
COMPUTER KNOWLEDGE AND SKILLS
Strong skills required for Microsoft Office programs (Word, Excel, PowerPoint, Teams, Planner) and Power BI. Familiarity with reports writing in a PostgreSQL database environment. Ability to produce query strings and manage data within a CRM.
Familiarity with ArcGIS preferred, but not required.
COMMUNICATION SKILLS
Ability to read, analyze, and interpret technical evaluation reports. Ability to write reports and articles for publication that conform to prescribed style and format. Ability to interact with program stakeholders and fill support requests for data. Ability to present information effectively to management, committees, public groups, and/or board of directors.
MATHEMATICAL SKILLS
Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute percentages, rates, and ratios and to draw and interpret numeric charts and graphs.
REASONING ABILITY
Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of instructions furnished in written, oral, diagram, or schedule form and deal with a variety of abstract and concrete variables in situations where only limited standardization may exist.
PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to perform the essential functions of this job successfully. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; and talk or hear. The employee frequently is required to walk. The employee is occasionally required to stand and reach with hands and arms. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. This is a fast-paced environment and requires the ability to handle multiple tasks at any given time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.
COG currently operates in a “hybrid” manner, where an employee may be eligible to telework up to two days per week, pending supervisor and Executive Director approval.
Salary Range: $80,000.00 To $95,000.00 Salary Depends on Qualifications
If you would like to apply please click HERE