Applications Systems Analyst II – EHRA

DIT EBS; United States; Hybrid; USD 82,000 - 122,000; Full time

Job summary

The North Carolina Department of Transportation seeks an Applications Systems Analyst II (NS) to join the Transportation Engineering Applications Development Unit. You will develop and maintain application code using C# and SQL, and support data requests and reporting.

Responsibilities include designing SQL Anywhere database schemas, managing Mobilink synchronization for offline field apps, writing complex queries, and providing user support for the bridge inspection software.

Qualifications

• Bachelor's degree in computer science or IT field with 2+ years in development or consulting.
• Associate degree in computer science or IT field with 3+ years in development or consulting.
• High School/GED with 6+ years in business application development/consulting.

Responsibilities

• Develop and maintain complex source code in C# and SQL.
• Maintain SQL Anywhere 17 database schemas and publications for data distribution.
• Manage Mobilink synchronization scripts for offline field apps.
• Write, optimize, and analyze complex SQL queries for data sync and reporting.
• Analyze SQL query performance and suggest optimizations.
• Provide technical support for bridge inspection software users.

Education

Bachelor's degree in computer science or IT related field

Associate degree in computer science or IT related field

High School diploma or GED with six years of experience in related field

Tools

SQL Anywhere

Microsoft SQL Server

C#

Job description

Applications Systems Analyst II (NS)

Position Number: 60026049, Grade: DT09

Salary Range: $81,504- $122,256

The position is designated Statutory Exempt (EHRA) and is exempt from the State Human Resources Act. This position may be eligible for hybrid remote work in accordance with state policy and the agency’s remote work program but does require weekly onsite work. Any telework will be under the conditions of the state Teleworking Program Policy and the employer may end any teleworking arrangement at any time in the employer's sole discretion.

The Applications Systems Analyst II position in the NCDIT-Transportation Engineering Applications Development Unit provides a challenging and exciting opportunity to be a member of the Application Development Team responsible for maintaining custom software used by the North Carolina Department of Transportation for bridge inspections. In this role, responsibilities range from writing code for bridge inspection tools to assisting business units with data requests, reporting, and operational support.

Responsibilities

• Develop and maintain highly complex program source code for applications in high level languages such as C# and Structured Query Language (SQL)
• Develop and maintain SQL Anywhere 17 database schemas, publications, and subscriptions for data distribution to remote inspection teams
• Manage Mobilink synchronization scripts to support offline-capable field applications
• Write, optimize, and analyze complex SQL queries for data synchronization, reporting, and data analysis
• Analyze SQL query performance and recommend optimizations
• Provide technical support and problem resolution for business units and end users of the bridge inspection software

Management Preferences

• Experience with Microsoft SQL Server and/or SAP SQL Anywhere
• Experience with writing, optimizing, and maintaining complex SQL queries
• Experience with Microsoft C# or similar object-oriented programming language

Minimum Education and Experience

• Bachelor's degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and two years of experience in business application consulting or development OR Associate degree in computer science or an IT related field from an appropriately accredited institution and three years of experience in application consulting or development OR High School or General Educational Development (GED) diploma and six years of experience in business application consulting or development; or an equivalent combination of education and experience.

EEO Statement

The State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.

All job postings close at 11:59pm the night before the End Date on the posting.