RESPONSIBILITIES
·Writing code, performing standard analysis and geo-analysis that will combine and transform datasets to meet a specific business need.
·Applying quality controls to output data for accuracy and usability by the desired audience.
·Developing reports in a variety of formats (Power BI, GIS Maps, Dashboards, automated emails, etc.) to share finished insights.
·Breaking down large requests/ problems from senior managers into discrete and solvable tasks.
·Documenting work in a thorough manner consistent with team standards so that it can be easily understood by teammates.
·Creating documents explaining the work done – both the outputs/ insights and the programs used – for technical and non-technical audiences.
·Performing statistical and geospatial analyses on a wide range of datasets.
·Keeping skill current by learning new algorithms, programming languages and GIS techniques.
QualificationsEXPERIENCE & eDUCATION
·Minimum 5 years hands-on experience of experience in supporting ESRI GIS software, Portal of ArcGIS, ArcGIS Server, ArcGIS Desktop, HeXagon, Microsoft products, Microsoft Dynamics, Coding Languages such as: SQL & Python
·Strong skills in programming for data analytics, most preferably in Python or SQL,
but other languages such as R and Java are valuable.
· Strong skills in database designs and management
· Strong skills in GIS Software Applications, preferably ArcPro and Enterprise, as
well as Experience Builder and Survey123 Connect.
· Understanding of analytical methods (e.g., probability and statistics, algorithm
design).
· Familiarity with transit/ transportation systems, particularly the MTA subway, bus
and railroad networks.
· Exceptional ability to read code and interpret data.
· Familiarity with data processing and management support tools, including MS Office,advanced Excel analysis, and business intelligence tools (e.g., Power BI, Tableau).
· Familiarity with transportation planning theory and practice, especially in large-scale transitsystems.
· Ability to collaborate and provide support to all levels of MTA, both technical and nontechnical.
· Ability to manage projects and help lead team-based projects.
· Proficiency in data management.
· Experience in documenting processes, as well as performing quality checks.
· Ability to keep up with technical innovation and trends in data science.
· Familiarity with KPI metrics and ability to create algorithms to calculate them.
· Ability to deconstruct difficult problems into smaller and simpler pieces.
· Ability to think at a policy and strategic level
· Strong written communication skills.
·Excellent oral, written and presentation communication skill in relating technical information to non-technical personnel
·Strong analytical and problem-solving skills
·Ability to effectively prioritize and execute in a high-pressure environment
·Ability to independently set priorities and meet deadlines in a fast-paced environment; a self-starter
·Excellent inter-personal skills including the ability to work with individuals at all levels of the organization
· Bachelor's degree in Engineering, Information Management, Statistics, Mathematics or Transportation Planning/ Civil Engineering.
· Ability to write, edit, and understand Python code, SQL or R Programming as well as useGIS Applications
· Familiarity with data exploration/data visualization tools like Tableau, Power BI,
Web Focus, etc.