Transit Data Analyst

We have been in business for more than 110 years and we are known for our quality work and quality employees. This is your chance to join our team - help us to design the buildings and infrastructure that improve the world! 

We are seeking a Transit Data Analyst to work full time in our client’s (MTA) Office of Performance Management and report to the Manager of Data Analytics & Performance Programs. The MTA’s Office of Performance Management oversees end-to-end management of data and metrics related to all aspects of MTA’s performance. This includes transit operations, planning, and administrative support functions. The Transit Data Analyst will coordinate with internal stakeholders on various databases, write queries, create of data visualization tools in Power BI, and provide ongoing support for OPM’s ETL (extraction, transformation, loading) processes. The Office of Performance Management is housed within MTA’s Office of Customer Experience. This position may require on-site time at various MTA operations facilities throughout the Baltimore region.

Responsibilities:

• Conduct meetings with data owners, database administrators and subject matter experts.
• Support OPM’s Power BI 2initiatives and inquiries.
• Develop SQL queries and data pipeline engineering processes (automated ETL)
• Develop Key Performance Indicator calculation methodologies.
• Create data visualization tools.

Requirements:

• Master’s degree in a quantitative field such as computer science, engineering, mathematics, economics, statistics, etc.
• A minimum of 4 years of relevant experience required.
• Excellent organizational and interpersonal skills.
• Understanding of relational database architecture and management.
• Proficiency in SQL.
• Proficiency in scripting languages such as R or Python.
• Proficiency in Power BI, Tableau or other data visualization software a plus.

Benefits:

WRA recognizes that employees play an important role in its success. Our commitment to full-time employees is reflected in the comprehensive benefits package we offer:

• Flexible work schedule options
• Competitive salary
• Leave accrual and paid holidays
• Healthcare benefits
• Group Life Insurance, as well as additional optional life Insurance, short and long term disability insurance
• Flexible spending accounts for medical and dependent care reimbursement
• 401(k) Retirement Plan
• Tuition Reimbursement
• Employee Assistance Program
• Parental and maternity leave benefits
•  

WRA is an equal opportunity/affirmative action employer and complies with all applicable anti-discrimination laws.

The expected annual compensation range for this position is $83,000.00 - $108,000.00.  This range represents a good faith estimate for this position. The specific compensation offered to a candidate may vary based on factors including, but not limited to, the candidate’s relevant knowledge, training, skills, work location, and/or experience. 

Applicants must be currently authorized to work in the United States on a full-time basis without the need for employment-based visa sponsorship now or in the future. WRA will not sponsor applicants for U.S. work visa status for this opportunity. (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa)

Position # 2563

#LI- Mid Level #LI - Onsite