PM, GIS, Analyst, Application Dev and Spt Professionals for LA, CA EntityThe entity maintains vital data repositories for modeling planning analyses and projections, and for Geographic Information Systems (GIS) that support a continuous, comprehensive, and coordinated planning process in areas such as regional transportation, demographic projections, tracking of integrated land use, housing, employment, transportation programs, performance measures, and air quality planning and management.
Job Responsibilities and Experience RequirementsProfessionals must be capable of providing high quality systems design and development, maintenance and support services; project management; business/system analyses; IT quality assurance (QA); and IT maintenance and integration of key systems, including enterprise resource planning (ERP); customer relationship management (CRM); enterprise content management (ECM); enterprise geographic information system (EGIS); and Internet and Intranet development and content management system (CMS). Projects will be associated with the following systems and environment:
- Federal Transportation Improvement Program (FTIP) Enhancement, Maintenance, and Support
- Enterprise Geographic Information System Development
- Inter-Governmental Review (IGR) - GIS program that provides the geographic locations of Projects.
- Transportation Improvement Program (TIP) - GIS program that supports the geographic locations of the Projects.
- SCAG Atlas - GIS application that provides an interactive user interface to allow city members to view their regions and submit land use input to entity.
- Goods Movement - GIS viewer that allows entity planners to view GIS maps related to goods movement data.
- Regional Active Transportation Database (RATD) - Interactive GIS application that provides Active Transportation planners with region-wide bicycle usage counts and routes. Includes mass data input capability; display of multiple layers of maps; and printing of analysis reports through the application.
- Regional Population Growth Projection (RPGP) - Interactive GIS application that allows the GIS analysts to demonstrate regional population growth with multiple layers.
- Sustainability Map - Interactive map component of regional sustainability factors framed in SCAG's Sustainability microsite.
- GIS Data Library - Interactive GIS application that allows GIS analysts and planners to view, analyze, print, and download GIS data from entity's geodatabase.
- Local Population Projection - GIS application that allows GIS analyst local planners to view and analyze their local population and household projections.
- California Assembly Bill 2 (AB2) - GIS application that allows GIS analyst to develop, maintain, and enhance data and information to support California Assembly Bill 2 (AB2) CRIA-related planning and decision making process.
- Enterprise Geographic Information System Implementation
- Planning System Development
- Local Profiles (LP) - web based application that allows entity planners to prepare and distribute Microsoft word based profiles for all 191 cities and 6 counties every other year.
- Compass Blue Print (CBP) - web application that allows entity planners to manage and track all Compass Blue Print projects.
- Regional Affairs Officer (RAO) - web application that allows entity regional affairs staff to manage and track all outside meetings and agenda materials.
- Inter-Governmental Review (IGR) - web application that allows the IGR Team to review and analyze environment impact review (EIR) documents submitted by local jurisdictions and provide geographical editing capability to display polygon or spots of the projects.
- Financial Management Information System (FMIS)
- Consolidated Budget Development System (CBDS) - project/task based budget development system designed and developed in-house for the Budget and Grants Department to allow project managers prepare for their annual budgets. It facilitates the Budgets and Grants Department to manage and analyze entity's budgets to request approval from Caltrans.
- OWP Management System (OMS) - subsystem of CBDS for Project Managers to submit current year's progress report to Caltrans, entity's funding administrator.
- Financial Database System (FDS) - contract-oriented system that collects all consultant contracts information in a database for the Finance Division to manage, share, and analyze. It also retrieves project task information and invoice transactions from other systems to provide a global view to the Finance staff as well as entity Project Managers.
- Commercial Off-The-Shelf (COTS) Application Maintenance and Support
- Microsoft Dynamics GP (ERP)
- Microsoft Dynamics CRM
- Hyland OnBase Document Management System (ECM)
- Drupal or other CMS (TBD) for SCAG main website
- Others, as required
- New Applications
- Agenda Management System
- Internal Support Tracking & Inventory System
- New GIS applications
- Microsoft SharePoint based internal team sites, workflows and Intranet
Possible Positions AvailableSENIOR PROGRAMMER ANALYST, 3 Positions (OR EQUIVALENT)A senior programmer is responsible for leading and/or working on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software. This classification may also plan, install, configure, test, implement and manage a systems environment in support of an organization's IT architecture and business needs. Common organizational or functional industry position titles for programmers include, but are not limited to, programmer analyst, applications developer, software engineer, software developer, software quality assurance specialist, systems programmer, systems software programmer, database administrators, computer systems analysts, systems engineer, systems software engineer.
a. Duties/Tasks (Applications Software)- Analyzing and refining business systems requirements;
- Collaborating with IT staff and other consultants regarding potential solutions, leveraging existing systems and code libraries whenever possible;
- Translating business and systems requirements into written specifications, business rules and applications prototypes;
- Coordinating with ADT, other IT teams and staff to adhere to all SCAG Systems Development Life Cycle (SDLC) and Change Control Board (CCB) processes and guidelines;
- Planning and designing systems architecture;
- Writing, debugging and maintaining code using agile methodologies;
- Determining and designing applications architecture;
- Determining output media/formats;
- Designing user interfaces and working with customers to design and test applications in an iterative manner;
- Assuring software and systems quality and functionality;
- Integrating hardware and software components;
- Writing and maintaining program documentation;
- Evaluating new applications software technologies; and/or
- Ensuring the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services.
b. Duties/Tasks (Operating Systems)- Analyzing systems requirements in response to business requirements, risks and costs;
- Evaluating, selecting, verifying and validating the systems software environment;
- Evaluating, selecting and installing compilers, assemblers and utilities;
- Coordinating with SCAG IT teams and consultants to integrate hardware
and software components within the systems environment;
- Monitoring and fine-tuning performance of the systems environment;
- Evaluating new systems engineering technologies and their effect on the operating environment; and/or
- Ensuring that information security/information assurance policies, principles and practices are an integral element of the operating environment.
c. General Knowledge Skills and Abilities (KSA)/Competencies- Applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software;
- Development and production software installation and configuration procedures;
- Organization' s operational environment;
- Software design principles, methods and approaches
- Principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components;
- Pertinent government regulations;
- General infrastructure requirements
- Database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing;
- Functionality and operability of the current operating environment;
- Systems engineering concepts and factors such as structured design,
supportability, survivability, reliability, scalability and maintainability;
- Optimization concepts and methods;
- Establish and maintain cooperative working relationships with those contacted in the course of the work; and
- Speak and write effectively and prepare effective analyses and reports.
d. Experience.NET DeveloperRequired Qualification- A minimum of seven (7) years of web application development experience in C# or VB.NET using MVC on Microsoft SQL Server.
- At least two (2) years of reporting tools experience in either SAP Crystal Report or Microsoft SQL Server Reporting Services (SSRS).
- Good knowledge on HTML5, JQuery, Java Scripts, and CSS files.
- Good knowledge on responsive design for web applications, native and hybrid mobile application design and development.
Desired Qualification- Experience with Telerik DevCraft development tools.
- Experience with Microsoft Team Foundation Server (TFS).
- Experience with Ironspeed development platform.
- Good knowledge on Microsoft SharePoint platform.
- Good knowledge on native or hybrid mobile application development (HMAD) using Angular UI or Telerik AppBuilder.
- Certified in MCSD, MCPD or equivalent certification.
- Experience with Nintex or related workflow products.
GIS DeveloperRequired Qualification- A minimum of seven (7) years of GIS application development experience in ArcGIS Server using .NET, Java Scripts, or Geocortex Essentials.
- Experience with ArcGIS Online application development using Web AppBuilder or Open Data.
- Good knowledge or experience on Python programming language.
- Excellent knowledge on Geographic Information Systems.
Desired Qualification- Experience with Team Foundation Server (TFS).
- Good knowledge on native or hybrid mobile application development (HMAD) using Angular UI or Telerik AppBuilder.
- Certified in MCSD, MCPD or equivalent certification.
- Good knowledge on SharePoint platform.
SharePoint DeveloperRequired Qualification- A minimum of seven (7) years of web application and webpart development experience in C# or VB.NET application development on SharePoint environment using Microsoft SQL Server.
- At least two (2) years of reporting tools experience in either SAP Crystal Report or Microsoft SQL Server Reporting Services (SSRS) on SharePoint platform.
- Good knowledge on HTML5, JQuery, Java Scripts, and CSS files on SharePoint platform.
- Good knowledge on the SharePoint farm administration.
- Good knowledge on responsive design for web applications, native and
hybrid mobile application design and development.
Desired Qualification- Experience with Telerik DevCraft development tools.
- Experience with Team Foundation Server (TFS).
- Good knowledge on native or hybrid mobile application development (HMAD) using Angular UI or Telerik AppBuilder.
- Certified in MCSD, MCPD or equivalent certification.
- Experience with Nintex or related workflow products.
e. EducationThis classification requires the possession of a Bachelor's Degree in an IT related or Engineering field from an accredited college or university or equivalent certifications and/or training.
PROGRAMMER ANALYST (OR EQUIVALENT)The description is the same as with the Senior Programmer, except this classification functions under general guidance.
a. Duties/TasksSee duties and tasks listed for the Senior Programmer above.
b. General Knowledge Skills and Abilities/CompetenciesSee KSAs/Competencies listed for the Senior Programmer above.
c. ExperienceSee Experience listed for the senior programmer above. The year experience on the development will be five (5) years for Programmer Analyst.
e. EducationThis classification requires the possession of a Bachelor's Degree in an IT related or Engineering field from an accredited college or university or equivalent certifications and/or training.
SENIOR ENTERPRISE GIS CONSULTANT (OR EQUIVALENT) a. Duties/T asks- Maintain, support, and administrate ESRI ArcGIS Server, ArcGIS SDE, and ArcGIS Online.
- Perform system upgrade to all ESRI related products.
- Support the GIS group to perform data cleanup and restructure for all GIS
related Data.
- Perform data transfer between the geodatabase in Microsoft SQL Server and other resources in different file format.
