Performance Insights Specialist

What Will Your Job Look Like?

The In Office 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 In Office Data Analyst II also performs audits that ensure compliance with WMATA protocols.

This position sits in-office Mon-Fri in Hyattsville, MD 8am-5pm eastern.

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


* Must be advanced in Power BI


* Experience with automated data systems


* MUST Live in the Hyattsville, MD area to be in office Mon-Fri (no relocation provided)

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 d...