Analytics Developer

Title

Analytics Developer

NJTPA

Director, Information Technology

Staff

The Analytics Developer is responsible for designing, developing and maintaining data solutions that support the agency’s transportation planning and programming analytics. This includes grant management, financial reporting, and project tracking. This role requires expertise in database, dashboard and report development, data integration from diverse sources – including internal systems, ERP platforms, and spatial datasets – and programming to deliver actionable insights and automate key processes that support organizational goals.

The developer will work closely with end‑users to gather requirements, document technical specifications, and translate complex concepts into clear, understandable language for non‑technical audiences. Strong experience with geographic information system (GIS) platforms is highly preferred, as the position often involves collaborating across teams to support and enhance GIS initiatives. Key responsibilities include preparing and integrating geospatial datasets, performing geoprocessing tasks, and presenting results through reports, dashboards, and interactive webmaps.

The ideal candidate is detail‑oriented, proficient in data visualization, and committed to promoting data‑driven decision‑making within a federally funded transportation planning environment.

• Report Development:
  Design and develop reports and dashboards with data visualization tools (e.g., Power BI, Power BI Report Builder/SSRS). Use languages such as SQL, DAX, and Python to query data sources and process data for reporting and decision‑making.
• Data Integration:
  Develop application and data integration solutions between disparate sources. Integration of client web portals and in‑house front‑end applications with server‑side programming by leveraging RESTful API services using open source and vendor‑specific frameworks.
• Data Processing:
  Interface with our core enterprise systems, including SQL Server, SAP HANA, Esri ArcGIS, and Office 365 (SharePoint, Power BI, Project Online) to acquire and transform data such that it can be used to produce insights relevant to the agency’s core planning and programming initiatives and federal reporting requirements.
• Data Services:
  Design and develop automated workflows for our core enterprise systems to streamline data interaction and data processing tasks. Design automated integration and ETL tasks through CI/CD pipelines.
• GIS Support:
  Support staff in the preparation of GIS data visualizations and maintenance of enterprise geodatabases, GIS automation scripts, and web mapping and spatial analytics applications, adhering to NJTPA Enterprise GIS standards.

• Support staff development needs agency‑wide and manage consultant resources as needed.
• Perform other related duties as assigned.

• Graduation from an accredited college with a bachelor’s degree in computer science, Geographic Information Science, Information Systems, or a related field.
• Coursework in GIS is a plus.
• Minimum of three years of relevant experience, with at least one programming language such as Python, JavaScript or C#.
• Experience with dashboard and reporting tools such as Power BI and Tableau.
• Proficiency in SQL.
• Experience with DBMS technology, such as SQL Server and Access.
• Understanding of relational database concepts.
• Understanding of ETL tools such as SSIS and Azure Data Factory, and experience in ETL development.
• Solid understanding of HTTP.
• Experience developing with cloud and open APIs.
• Experience with Esri ArcGIS or other geospatial platform, and geospatial APIs.
• At the university's discretion, the education and experience prerequisites may be exempted where the candidate can demonstrate to the satisfaction of the university, an equivalent combination of education and experience specifically preparing the candidate for success in the position.

• Master’s degree in computer science, GIS, Information Systems, or related field.
• Experience with version control such as Git.
• Experience with cloud platforms such as…