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.
Requirements
- Experience with MS SQL Server, Power BI or other relational database systems
- Must be advanced in Power BI
- Experience with automated data systems
- 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
Responsibilities
- 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 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
Other
- This position sits in-office Mon-Fri in Hyattsville, MD 8am-5pm eastern.
- MUST Live in the Hyattsville, MD area to be in office Mon-Fri (no relocation provided)
- Ability to effectively interpret and analyze data and present results to stakeholders
- High level of emotional intelligence
- Excellent interpersonal skills
