IT Applications Developer Senior

State of Nebraska•Lincoln, NE

6d•Onsite

About The Position

The Nebraska Department of Labor has a great opportunity to join our Information Technology (IT) team as an IT Applications Developer Sr. This position will work extensively with all aspects of our evolving Data Warehouse. As your experience, skills and familiarity with the business grow, you will touch all steps of the life cycle process to incorporate new data sources and provide beneficial data/statistics to our stakeholders to help improve business efficiencies and help eliminate suspected fraud. This is an on-site position in Lincoln, Nebraska. All interviews will be conducted in-person. Please include a personalized cover letter with your application. The Department of Labor does not sponsor work visas or OPT visas for this position. If the candidate selected doesn’t qualify for the IT Applications Developer Sr level, the position may be filled as an IT Applications Developer at a lower standard rate until qualifications are met for the senior level. Hire rate for the IT Application Developer Sr is $35.267. Hire rate for the IT Application Developer is $29.348

Requirements

A bachelor’s degree or equivalent in computer science, information systems, mathematics, engineering or other related field and two years of experience, education, or training in coding computer applications; programming experience can be substituted for education on a year for year basis.
Experience, education, or training in coding computer applications.

Nice To Haves

SQL Query Language
data visualization
critical thinking
problem solving
data cleansing
statistics
communication
attention to detail and ability to explain complex data in a simple, clear manner for non-technical stakeholders.
Experience with Data Warehouse software and tools.
Experience with SFTP data transfers and scripting functionality to schedule associated tasks.
Solid SQL skills to quickly retrieve and provide requested information in a timely manner.
More than 2 years directly responsible for data elements, data systems, and/or databases in a work environment.
A working knowledge of State of Nebraska or other public service database systems and the ability to use multiple types of database reporting tools.

Responsibilities

Assists and mentors peers and subordinates
Consult with clients on application issues
Uses application development tools and utilities as appropriate
Prepares the business problem definition
Performs the information analysis and organization
Accomplishes the information collection
Prepares the economic evaluation
Prepares the solution development and evaluation
Development of the functional design
Development of the technical design
Preparation of the system specifications
Development of the implementation plan
Preparation of the support material
Providing on-going support
Gathers requirements to build logical model for design analysis.
Creates logical views of business function.
Supports data management by creating and managing test data.
Supports data structure by creating and managing test data
Gathers requirements for data definition
Creates physical model as part of the physical design.
Create data access methods.
Creates sub-system facilities.
Creates IMS databases
Creates relational databases.
Program code, assemble/compile code, and debug code
Perform alpha/unit testing and participate in system program testing
Prepare program documentation
Use software and tools to troubleshoot database issues.
Assist users with desktop applications to view and edit data or reports in the data warehouse.
Coordinate with the State OCIO to test new platforms for data server upgrades.
Using software tools, test migrations of data to ensure data integrity and availability.
Evaluate new software to upgrade or lifecycle current platform.
Effectively use query language SQL Plus and SQL Developer to access and query data and objects.
Define data repository requirements, data dictionaries, and warehousing requirements.
Develop plans for database implementation, data source integration, data archiving and recovery.
Work closely with State OCIO data managers to ensure data availability on the network
Maintain a current understanding of the business environment supported to provide expert guidance for technical, business, and operational impacts associated with a project or production problem
Ensure agency data is organized and maintained in acceptable formats to ensure availability, speed, and integrity.
Establishes and maintains relationships between data elements to ensure accessibility and optimization.
Ensure proper configurations are set on databases to protect sensitive agency data containing Personally Identifiable Information (PII), Federal Tax Information ((FTI), Social Security Information (SSA), National Directory of New Hires (NDNH) and bank account information.
Writes SQL queries to produce reports, validate data, or integrate with applications.
Works with other IT teams to ensure databases are available and optimized to work for all applications and reports.
Establish and check principle of least privilege (PoLP) to ensure users and systems have access the minimum amount of data and resources needed to perform their tasks.
Evaluate, design, review and implement databases to serve the agency business need.

Benefits

13 paid holidays
Vacation and sick leave that begin accruing immediately
Military leave
156% state-matched retirement
Tuition reimbursement
Employee assistance program
79% employer paid health insurance plans
Dental and vision insurance plans
Employer-paid $20,000 life insurance policy
Public Service Loan Forgiveness Program (PSLF) through the Federal government
Wide variety and availability of career advancement as the largest and most diverse employer in the State
Opportunity to be part of meaningful work and make a difference through public service
Training and Development based on your career aspirations