At MTM Transit, it is never just a ride, it's personal. We understand that our passengers deserve personalized attention and exceptional care and to us, every trip is important. We have exciting opportunities to join our growing team where your work has a direct impact on the communities we serve. Our company culture is one of innovation, collaboration, and growth. If you are passionate, driven, and ready to join a team where your work will directly transform and shape our industry, then we want to talk to you!
What Will Your Job Look Like?
The Data Analyst II is responsible for ensuring the Data Analyst Team provides WMATA (Washington Metropolitan Area Transit Authority) stakeholders with actionable analysis on data collection and assessment of MetroAccess Service Delivery practices. The Data Analyst II also performs audits that ensure compliance with WMATA protocols. This position sits in office Mon-Fri.
Location: 4100 Garden City Dr Hyattsville, MD 20785
What you’ll do:
Identify problematic areas within the data provided, and conduct research to determine the best course of action to correct the data
Analyze and problem solve issues with current and planned systems as they relate to the integration and management of data
Analyze reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports
Monitor for timely and accurate completion of select data elements
Monitor reporting systems for issues with data and report executions
Identify, analyze and interpret trends or patterns in complex data sets
In collaboration with others, develop and maintain databases and data systems necessary for projects and department functions
Acquire and extract primary or secondary data from existing internal or external data sources
Perform data entry, either manually or using scanning technology, when needed or required
In collaboration with others, interpret data and develop recommendations based on findings
Develop graphs, reports, and presentations of project results
Perform basic statistical analyses for projects and reports
Create and present quality dashboards in Power BI
Generate routine and ad hoc reports
Ensure data integrity
Work with WMATA to maintain Client allocated equipment and systems used for the necessary QA functions
Maintain MTM systems and databases we use to track data, run reports, etc.
Other duties as assigned
What you’ll need:
Experience, Education & Certifications:
Bachelor’s degree with an emphasis on quantitative analytics or experience in a related field
Minimum of two (2) years’ experience in quantitative analytics such as: performance measurement, user segmentation, test design, modeling and web analytics
Experience with MS SQL Server, Power BI or other relational database systems
Experience with automated data systems
Skills:
Ability to develop and execute relational database queries and stored procedures
Technical expertise regarding data models and database design development.
Understanding of SQL, PowerBI, and Tableau
Ability to write basic SQL queries to extract data from Oracle databases
Ability to build dashboards
Proficient in MS Word, Excel, and PowerPoint
Knowledge of statistics, at least to the degree necessary in order to communicate easily with Statisticians
Ability to effectively interpret and analyze data
Must possess the ability to assess potential problems and make sound judgments around issues that may have an adverse effect on the business
Ability to effectively interpret and analyze data and present results to stakeholders
High level of emotional intelligence
Excellent interpersonal skills
Ability to work well under pressure
Ability to work independently and also collaboratively with others to achieve defined goals
Excellent communication skills
Outstanding analytical and organizational skills; attention to detail
Ability to maintain high level of confidentiality
Regular attendance is required
Even better if you have...
Programming skills preferred
Master’s degree preferred
What’s in it for you:
Health and Life Insurance Plans
Dental and Vision Plans
401(k) with a company match
Paid Time Off and Holiday Pay
Maternity/Paternity Leave
Casual Dress Environment
Tuition Reimbursement
MTM Perks Discount Program
Leadership Mentoring Opportunities
Minimum Salary: $61,250
Maximum Salary: $65,000
This information reflects the base salary pay range for this job based on current national market data. Ranges may vary based on the job's location. We offer competitive pay that varies based on individual skills, experience, and other relevant factors. We encourage you to apply to positions that you are interested in and for which you believe you are qualified. To learn more, you are welcome to discuss this with us as you move through the selection process.
Equal Opportunity Employer: MTM is an equal opportunity employer. MTM considers qualified candidates with a criminal history in a manner consistent with the requirements of applicable local, State, and Federal law. If you are in need of accommodations, please contact MTM’s People & Culture.