Sr. Performance Analyst

MARTA (Metropolitan Atlanta Rapid Transit Authority); Atlanta (GA); On-site; USD 85,000 - 110,000; Full time

Job summary

MARTA (Metropolitan Atlanta Rapid Transit Authority) is seeking a results-driven data analytics professional with strong SQL, Python, and R skills to deeply understand transit operations and business needs. The role focuses on gathering requirements, creating mockups, and developing Power BI and other standardized reports, with continuous improvement and audit of those reports.

The ideal candidate will be a strong analytical thinker, capable of learning quickly, taking direction, and working

Qualifications

• Bachelor’s degree required; six years of progressively responsible experience in quantitative analysis, operations, project management, or related fields.
• Experience with data visualization software (Power BI or Tableau) and conducting advanced data analytics (multivariate stats, networks, forecasting, ML).
• Experience with data analysis software (R, Python).
• Experience with GIS software (ArcGIS, AGOL) is a plus.
• Advanced MS Excel knowledge preferred.
• Experience coding and managing databases (SQL, R, Python).
• Experience communicating effectively in writing and presentations to technical and non-technical partners.
• Expertise in creating and optimizing BI datasets and dashboards.
• Master’s/Doctorate preferred; public agency or transit industry experience preferred.

Responsibilities

• Understand client needs and extract data using SQL for analysis.
• Collect and analyze data using SQL, Python, and R; identify trends and insights.
• Create intuitive data visualizations using Power BI, Python, and R.
• Evaluate data quality with SQL and implement data quality processes.
• Map legacy system objects and translate logic for self-service analytics.
• Support strategy implementation with SQL, Power BI, Python, and R.
• Manage all phases of BI: data exploration, automation, analysis, and reporting.
• Coordinate regular and ad hoc production of reports and memos.

Skills

Data analytics

SQL

Python

R

Power BI

Education

Bachelor’s degree in Business Analytics / Data Science / Public Administration / Business Administration / related field

Master’s or Doctorate degree (preferred)

Tools

ArcGIS

AGOL

Job description

MARTA is the 12th largest transit system in North America that provides bus and rail services. We are committed to a culture of continuous improvement and setting a higher standard of service delivery.

The Career Opportunity

This is an exceptional opportunity for a results-driven and self-motivated individual who has a strong data analytics background and will be excited to deeply understand transit operations and business needs. Major responsibilities include business requirement gathering, creating mockups, developing Power BI reports and other standardized reports, continuous improvement and audit of those reports, and analysis of data and business performance to identify challenges and areas for improvement. The individual will become a subject matter expect in one or more departmental areas of MARTA. To succeed, it is important that the individual is a strong analytical and solution-oriented thinker, able to learn quickly, take direction, and work independently as well as part of a team.

How will you impact MARTA

• Understanding Client Needs: Building strong relationships with internal clients to understand their needs and leveraging SQL to extract relevant data for analysis.
• Data Collection and Analysis: Utilizing SQL, Python, and R to collect and analyze data, employing statistical techniques to identify trends and patterns for meaningful insights.
• Data Visualization: Using Power BI, Python, and R to create intuitive and impactful data visualizations that effectively communicate the derived insights.
• Data Quality Assurance: Evaluating data quality using SQL and designing and implementing processes to ensure high-quality data for decision-making.
• Process Optimization: Identifying key functions and logic, mapping objects in legacy systems and then translating their syntax to better Self-Service Analytical tools for the teams.
• Strategy Implementation Support: Assisting in the implementation of strategies by utilizing SQL, Power BI, Python, and R for role and responsibility identification, workflow development, change management support, and feedback collection.Business Analytics Management: Utilizing SQL, Python, and R for all phases of business intelligence cycle, including data exploration, automation, analysis, reporting to internal stakeholders.
• Report Production: Coordinating the regular and ad hoc production of reports, memos, and other communications using SQL, Power BI, Python, and R, as required.

Education/Qualifications

Bachelor’s degree in Business Analytics, Data Science, Public Administration, Business Administration, Industrial/Organizational Management, or related field is required. Six years of progressively responsible experience working in quantitative analysis, operations, project management, or related fields, including using data visualization software (e.g. Power BI or Tableau) and conducting advanced data analytics (e.g. Multivariate statistics, network and cluster analysis, forecasting, machine learning and pattern matching). Experience with data analysis software (e.g. R, Python). Experience with GIS software (ArcGIS, AGOL) is a plus. Advanced MS Excel knowledge is preferred. Experience with coding and database management (e.g. SQL, R, Python). Experience communicating effectively in writing and in presentations to technical and non-technical partners and audiences. Expertise in creating and optimizing business intelligence datasets and dashboards. Master’s or Doctorate degree, or other advanced degree (e.g., Six Sigma) is preferred. Experience in a public agency or public transit industry preferred.

MARTA is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class.