Application Developer

Franklin County Auditor's Office; Columbus (OH); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Healthcare

Public Loan Forgiveness

Education reimbursement

Free parking & COTA pass

Wellness incentives

Time off

Hybrid work schedule

Diversity & inclusivity

Job summary

The Franklin County Auditor’s Office is seeking an Application Developer to join its IT team in Columbus, OH. You will develop web applications, gather requirements, write server- and client-side code in .NET and React, and build data transformation and ETL workflows to support county services.

You will generate reports against SQL Server databases, collaborate across teams on projects, maintain code and deploy fixes, and provide application support.

Qualifications

• Bachelor's degree in computer science, information management systems, or related discipline.
• Three (3) or more years of application development related experience and/or training.
• Experience with SQL Server administration, SSIS, SQL, T-SQL, ETL, XML and IIS administration.
• Experience with modern client-side web technologies (HTML5, CSS3); .NET and JavaScript; Entity Framework, React, GraphQL, APIs, and Python is a plus.
• Experience with version control (GitHub, Microsoft TFS, etc.).

Responsibilities

• Develops web applications for internal and external use in .NET and React. Gathers requirements, writes server- and client-side code, and builds ETL procedures.
• Generates reports against SQL Server databases and collaborates with coworkers to ensure data accuracy for business analysis.
• Maintains existing source code and deploys incremental improvements and bug fixes.
• Leads application support and troubleshooting as required.
• Analyzes data to assist business units in troubleshooting data issues.

Skills

SQL

JavaScript

React

.NET

Python

ETL

Version control

Education

Bachelor’s degree in computer science or related field

Tools

SQL Server

SSIS

IIS

GitHub

Microsoft TFS

GraphQL

HTML5/CSS3

REST APIs

Job description

The Franklin County Auditor’s Office is seeking an Application Developer to join the IT team.

Who are we?

The Franklin County Auditor’s Office is dedicated to serving the community by ensuring fairness and accuracy in weight and measures across the county. Our mission is to protect and empower consumers, making sure they receive what they rightfully pay for at gas pumps and retail store scanners. As a trusted steward of county finances, we strive to promote fiscal responsibility and innovative initiatives that benefit all residents of Franklin County.

In addition to these important responsibilities, we assess property values to determine fair property taxes, while also working to provide tax relief for senior and citizens who are disabled. We understand the importance of supporting vulnerable populations and strive to make the process as accessible and accommodating as possible.

We are committed to upholding state regulations by ensuring that our furry friends are licensed. As required by state law, we proudly license dogs, recognizing the significance of responsible pet ownership within our community.

At the Franklin County Auditor’s Office, we value the diversity of our residents and businesses and strive to create an environment of fairness, inclusivity, and equity in all our endeavors.

What will you do?

Develops web applications for internal and external use (e.g., gathers and analyzes application requirements from coworkers; writes and tests server-side code; writes and tests client-side code, etc.); develops software for data transformation and integration purposes; creates and maintains automated ETL procedures; creates and maintains web applications, primarily in .NET and React.

Generates reports against databases including gathering report requirements from requesters and coworkers, writing SQL code for Microsoft SQL Server and balancing reports against other data sources to ensure accuracy; compiles and prepares reports for business analysis purposes; analyzes requirements from coworkers for reports and software development; works with team members on various projects to reach the goals of the IT department.

Maintains existing source codes and deploys incremental improvements and bug fixes.

Leads application support and troubleshooting as required.

Analyzes data in order to assist business units in troubleshooting inconsistent data.

Who should apply?

We encourage individuals with working experience with SQL Server administration, SSIS, SQL, T‑SQL, ETL, XML and IIS administration; experience with modern client‑side web application technologies, including HTML5, CSS3; working experience with .NET and Java script; Entity Framework, React, GraphQL, APIs, and Python experience is a plus; experience with version control (E.g.: GitHub, Microsoft TFS, etc.); demonstrated skill and understanding of Microsoft SQL Server including writing SQL queries, creating views and stored procedures, and integrating those databases into web based applications; possession of a Bachelor’s degree from an accredited college or university in computer science, information management systems, or related discipline; three (3) or more years of application development related experience and/or training; or any combination of training, education, or experience which provides the desired knowledge, skills, and abilities to perform the essential functions of this position.

Why should you work here?

We believe in providing an exceptional benefits package that recognizes the value of our employees. Some of our benefits include:

• Healthcare: We offer a competitive medical, dental, and vision plan with low-cost deductibles.
• Public Loan Forgiveness: As a public employee, your student loans can be forgiven after making the required monthly qualifying payments.
• 3. Education Reimbursement & Training: We invest in your growth and development by allowing you to expand your skills.
• 4. Free-Parking Program/COTA Buss Pass: Take advantage of the free parking program available through a lottery process annually; employees of the County get free weekday access to the Central Ohio Transit Authority (COTA) system.
• 5. Wellness Incentive Program: Our wellness incentive program rewards you with monetary incentives for engaging in healthy activities and maintaining a balanced lifestyle.
• 6. Generous Time Off: You deserve time for yourself and your loved ones. Enjoy 32 hours of personal leave per calendar year, 2 floating holidays, and 12 paid holidays annually. Additionally, accumulate sick and vacation leave for well-deserved breaks.
• 7. Hybrid Work Schedule: We understand the importance of work‑life harmony. For most positions, we offer a hybrid work schedule that allows flexibility in where you work, promoting a healthy integration of personal and professional life.
• 8. Emphasis on Diversity and Inclusivity: We celebrate and embrace diversity in all its forms. Our office is committed to creating an inclusive and equitable environment where everyone feels valued and empowered.