Vacancy expired!
- The Data Analysts will need strong skills in PowerBI, Python, SQL, and ArcGIS as we put a strong emphasis on spatial data. We are looking to supplement an existing team with data analysts to help keep the data-based projects on track. We hope that these resources will be able to work in tandem with the existing team to leverage their deep business knowledge and expand our current operations and scope.
- 2 years of experience with Powerbi Report Design
- 3 years of experience with SQL query writing
- 3 years of experience with Python
- 2 years of experience with Spatial Data
- Bachelor's Degree or a Master's degree in computer science from an accredited college or related field.
- Prior education industry/project experience
- Excellent oral and written communication skills; ability to communicate in a credible and confident manner at all levels in the organization including conveying technical issues to a non technical audience.
- Detailed and process oriented.
- Familiarity with DIIT network standards for hardware and network connectivity
- Renewing and updating documentation on our existing PowerBI inventory
- Updating SQL scripts for existing PowerBI reports
- Expanding our current PowerBI report structure to implement PowerBI apps for easy access
- Implementation by department
- Designing and producing new PowerBI reports based on requirements collected from operations departments
- Redesigning spatial data queries
- Redesigning our report change request process
- To support OPT operations, the data & reporting team is responsible for using data and reports to support operations in assessment and implementation of transportation policies and report to external agency offices on students, routes, vehicles, stops, Metrocards and school bus companies.
- The team oversees the data modeling, data tools, data capture, tracking and reporting for services provided to help move children across the city to get them to school whether by yellow bus service or public transportation pass.
- Redesigning, renewing, and updating queries, reports, and documentation to ensure business needs are met.
- Work with existing data analysts to update existing PowerBi reports and Python Scripts and create new reports based on SQL queries provided by analysts with strong business knowledge.