Whatsapp
Posted : Tuesday, October 03, 2023 12:42 AM
Definition & Duties
Under direction, provides technical leadership on software application integrations, value-added customizations, implementations and support.
Diagnoses and resolves complex problems and/or escalates as needed to meet expected levels of service.
Caters to user experience and functionality through collaboration with users, stakeholders, vendors and other technical staff.
Contributes to a cross-functional team that responds to business software needs by creating custom applications, reports and interfaces and implements and supports third-party software applications.
Knowledge of & Ability to SQL Server database (considerable) Design T-SQL query language Stored procedures SQL Agent jobs Security SQL Server Integration Services SQL Server Reporting Services SQL Server Analysis Services (plus) Git version control (or similar) Microsoft Visual Studio Microsoft Office Software application configuration, custom report creation, back-end interfaces and security Web services/APIs English language to include grammar, spelling, sentence structure, and vocabulary and proofreading skills Ability to: Learn County operational processes needed to be considered expert of related applications Provide technical aspects and leadership for large software implementation/upgrade projects Gather/analyze requirements, design, create, test, implement and document application enhancements, custom reports, back-end interfaces and business processes Work closely with stakeholders to devise meaningful, reliable and timely solutions Identify prerequisites and secure resources needed to complete projects Serve as application administrator role as assigned: manage security, configuration, upgrades, performance, data structures and interfaces Consult with software vendors to resolve issues, perform upgrades and keep abreast of changes Evaluate moderate to complex business processes for improvement and while diagnosing and resolving issues Generate creative solutions Present technical information, explain concepts and advise others clearly, logically, in oral, written and graphical form, and in a manner understood by technicians, other County personnel, and the general public Adapt to changing technologies and advocate for acceptance to improve business processes Build consensus and coordinate projects around new ideas promoting operational excellence throughout the County Learn and apply new programming techniques and tools Train IT and user department staff Interact effectively with persons from widely divergent backgrounds, interests, and points of view Learn, apply, and articulate departmental policies and procedures Represent Johnson County and perform duties in a professional, responsible and trustworthy manner Work independently and in teams Be detailed oriented and accurate while performing duties Follow complex oral and written instructions Multi-task, prioritize, and manage time efficiently Maintain confidentiality of protected information as appropriate Provide customer service that is courteous and responsive Establish and maintain effective working relationships with elected officials, department heads, co-workers, vendors, and members of the public Handle moderate levels of stress, meet deadlines and solve problems appropriate to the position Use a computer for word processing, spreadsheets, databases, presentations, email, Internet and programming Operate common office equipment such as calculator, fax machine, photocopier, multi-line telephone, scanner, computer projector and printer Have clarity of speech, hearing, and writing which permits effective communication Have sufficient vision which permits moderate to heavy production and review of a wide variety of materials in both electronic and hardcopy forms Have sufficient manual dexterity to make handwritten notations and which permits moderate to heavy use of a keyboard and mouse Stand, sit, walk, climb, balance, stoop, kneel, crouch, crawl, squat, bend, twist, reach and use a step stool or ladder as needed Lift, push, pull, and/or carry up to 25 pounds Have sufficient personal mobility to complete field work at various county facilities and other locations Occasionally work evenings and weekends Minimum Education, Training & Experience & Special Requirements Bachelor’s degree with major course work in computer/technology-related field AND five (5) years professional experience in systems implementation, analysis, programming or related including three (3) years of SQL Server and two (2) years of project management OR Associate degree in computer/technology-related field AND seven (7) years professional experience in systems implementation, programming or related including three (3) years of SQL Server and two (2) years of project management OR any equivalent combination of education and experience which provides the required knowledge, skills, and abilities.
Special requirements: Valid driver’s license and insurable under County liability coverage.
May also require use of personal vehicle or equivalent transportation for official business.
Must pass background check.
Specific Duties To be performed satisfactorily with or without reasonable accommodation.
The following duties are normal for this position.
These are not to be construed as exclusive or all inclusive.
Other duties may be required and assigned.
Develops significant product expertise of third party software systems as assigned; provides subject matter, first-line support to users and other technical staff; escalates issues to vendor; acts as vendor point of contact and keeps abreast of changes; leads implementations, conversions, upgrades and testing; promotes new features or untapped functionality to users; maintains security rights and configuration; creates and maintains custom reports and back-end interfaces with other applications Provides technical leadership on complex projects; formulates and defines system scope and objectives; establishes time estimates for completion of projects; and develops and implements solutions to problems.
Interacts with users to analyze and evaluate requests for services; identifies user requirements and objectives; defines problems and develops solutions; determines program intent, data input/output requirements, and inclusion of internal checks and controls; creates detailed requirements documentation.
Gathers and documents requirements for enhancements and issue resolution; devises and modifies methods to solve complex problems considering human resources, time, capabilities/limitations of assets, risk and benefit to the County; serves as a subject-matter expert to software development staff.
Develops and maintains interfaces between software systems using SQL Server Integration Services, web services/APIs and other available methods.
Analyzes data using ad-hoc T-SQL database queries and Excel spreadsheets.
Develops and maintains simple to complex reports using SQL Server Reporting Services with underlying SQL Server stored procedures.
Develops and maintains SQL Server databases, tables, views, stored procedures, user-defined functions, Integration Services catalogs, SQL Agent jobs.
Analyzes business processes to formulate programming specifications for modification or enhancement based on interaction with and needs for end users.
Participates in research and analysis in support of users and IT peers needing to solve technical issues.
Contributes to design and development of innovative strategies to improve system performance and business processes.
Thoroughly tests system modifications /enhancements to ensure accuracy, consistency, completeness and stability.
Provides timely communication about issues /impending changes to supervisor, peers and users to promote a coordinated effort.
Creates and maintains SQL Agent jobs to perform routine functions.
Commits source code to version control repository.
Identifies, researches, learns and applies additional tools, programming languages and frameworks to assist in performing assigned tasks.
Participates in committees; attends work-related meetings, conferences and seminars as requested.
Answers and refers telephone calls and responds to users.
Provides back-up for team members.
Performs all work duties and activities in accordance with Departmental and County policies, procedures, and safety practices.
Attends work regularly.
Resume and cover letter must be attached to online application.
Diagnoses and resolves complex problems and/or escalates as needed to meet expected levels of service.
Caters to user experience and functionality through collaboration with users, stakeholders, vendors and other technical staff.
Contributes to a cross-functional team that responds to business software needs by creating custom applications, reports and interfaces and implements and supports third-party software applications.
Knowledge of & Ability to SQL Server database (considerable) Design T-SQL query language Stored procedures SQL Agent jobs Security SQL Server Integration Services SQL Server Reporting Services SQL Server Analysis Services (plus) Git version control (or similar) Microsoft Visual Studio Microsoft Office Software application configuration, custom report creation, back-end interfaces and security Web services/APIs English language to include grammar, spelling, sentence structure, and vocabulary and proofreading skills Ability to: Learn County operational processes needed to be considered expert of related applications Provide technical aspects and leadership for large software implementation/upgrade projects Gather/analyze requirements, design, create, test, implement and document application enhancements, custom reports, back-end interfaces and business processes Work closely with stakeholders to devise meaningful, reliable and timely solutions Identify prerequisites and secure resources needed to complete projects Serve as application administrator role as assigned: manage security, configuration, upgrades, performance, data structures and interfaces Consult with software vendors to resolve issues, perform upgrades and keep abreast of changes Evaluate moderate to complex business processes for improvement and while diagnosing and resolving issues Generate creative solutions Present technical information, explain concepts and advise others clearly, logically, in oral, written and graphical form, and in a manner understood by technicians, other County personnel, and the general public Adapt to changing technologies and advocate for acceptance to improve business processes Build consensus and coordinate projects around new ideas promoting operational excellence throughout the County Learn and apply new programming techniques and tools Train IT and user department staff Interact effectively with persons from widely divergent backgrounds, interests, and points of view Learn, apply, and articulate departmental policies and procedures Represent Johnson County and perform duties in a professional, responsible and trustworthy manner Work independently and in teams Be detailed oriented and accurate while performing duties Follow complex oral and written instructions Multi-task, prioritize, and manage time efficiently Maintain confidentiality of protected information as appropriate Provide customer service that is courteous and responsive Establish and maintain effective working relationships with elected officials, department heads, co-workers, vendors, and members of the public Handle moderate levels of stress, meet deadlines and solve problems appropriate to the position Use a computer for word processing, spreadsheets, databases, presentations, email, Internet and programming Operate common office equipment such as calculator, fax machine, photocopier, multi-line telephone, scanner, computer projector and printer Have clarity of speech, hearing, and writing which permits effective communication Have sufficient vision which permits moderate to heavy production and review of a wide variety of materials in both electronic and hardcopy forms Have sufficient manual dexterity to make handwritten notations and which permits moderate to heavy use of a keyboard and mouse Stand, sit, walk, climb, balance, stoop, kneel, crouch, crawl, squat, bend, twist, reach and use a step stool or ladder as needed Lift, push, pull, and/or carry up to 25 pounds Have sufficient personal mobility to complete field work at various county facilities and other locations Occasionally work evenings and weekends Minimum Education, Training & Experience & Special Requirements Bachelor’s degree with major course work in computer/technology-related field AND five (5) years professional experience in systems implementation, analysis, programming or related including three (3) years of SQL Server and two (2) years of project management OR Associate degree in computer/technology-related field AND seven (7) years professional experience in systems implementation, programming or related including three (3) years of SQL Server and two (2) years of project management OR any equivalent combination of education and experience which provides the required knowledge, skills, and abilities.
Special requirements: Valid driver’s license and insurable under County liability coverage.
May also require use of personal vehicle or equivalent transportation for official business.
Must pass background check.
Specific Duties To be performed satisfactorily with or without reasonable accommodation.
The following duties are normal for this position.
These are not to be construed as exclusive or all inclusive.
Other duties may be required and assigned.
Develops significant product expertise of third party software systems as assigned; provides subject matter, first-line support to users and other technical staff; escalates issues to vendor; acts as vendor point of contact and keeps abreast of changes; leads implementations, conversions, upgrades and testing; promotes new features or untapped functionality to users; maintains security rights and configuration; creates and maintains custom reports and back-end interfaces with other applications Provides technical leadership on complex projects; formulates and defines system scope and objectives; establishes time estimates for completion of projects; and develops and implements solutions to problems.
Interacts with users to analyze and evaluate requests for services; identifies user requirements and objectives; defines problems and develops solutions; determines program intent, data input/output requirements, and inclusion of internal checks and controls; creates detailed requirements documentation.
Gathers and documents requirements for enhancements and issue resolution; devises and modifies methods to solve complex problems considering human resources, time, capabilities/limitations of assets, risk and benefit to the County; serves as a subject-matter expert to software development staff.
Develops and maintains interfaces between software systems using SQL Server Integration Services, web services/APIs and other available methods.
Analyzes data using ad-hoc T-SQL database queries and Excel spreadsheets.
Develops and maintains simple to complex reports using SQL Server Reporting Services with underlying SQL Server stored procedures.
Develops and maintains SQL Server databases, tables, views, stored procedures, user-defined functions, Integration Services catalogs, SQL Agent jobs.
Analyzes business processes to formulate programming specifications for modification or enhancement based on interaction with and needs for end users.
Participates in research and analysis in support of users and IT peers needing to solve technical issues.
Contributes to design and development of innovative strategies to improve system performance and business processes.
Thoroughly tests system modifications /enhancements to ensure accuracy, consistency, completeness and stability.
Provides timely communication about issues /impending changes to supervisor, peers and users to promote a coordinated effort.
Creates and maintains SQL Agent jobs to perform routine functions.
Commits source code to version control repository.
Identifies, researches, learns and applies additional tools, programming languages and frameworks to assist in performing assigned tasks.
Participates in committees; attends work-related meetings, conferences and seminars as requested.
Answers and refers telephone calls and responds to users.
Provides back-up for team members.
Performs all work duties and activities in accordance with Departmental and County policies, procedures, and safety practices.
Attends work regularly.
Resume and cover letter must be attached to online application.
• Phone : NA
• Location : Johnson County, IA
• Post ID: 9142887293
