IT Application Development - Journey

Duty: Application development for custom IT business applications. Develops maintains troubleshoots enhances and monitors all aspects of the application source code databases and websites for IT business systems for the Commerce projects.

This position develops new custom business applications or modernizes existing business applications primarily for the Housing and Community Services Divisions or other divisions as assigned.

Tasks:
Writes Angular C# Structured Query Language (SQL) (stored procedures views functions and table
definitions) JavaScript SSRS Reports VBScript ASP Python. PowerShell and other language(s)
programming code.
Uses Visual Studio to develop unit and regression testing components to run against the code base for business requirements validation and error identification.
Performs analysis planning and application design work and determines and documents the most cost effective and timely approach to resolving IT Business system problems.
Ensures IT Business Applications meets or exceeds the WaTech technology policies federal requirements and agency standards.
Implements encryption methods tools and key management for all category 3 database systems that follow Commerces security standards.
Develops problem statements creates change and report specification documents system state change documents and other technical documents.
Determines best approach for developing new IT systems by diagraming creating logic flows and then
prototyping solutions.
Works closely with the agency Business Analysts and other program staff to ensure that proposed solutions meet business requirements before proceeding to development.
Develops applications using Power Platform Power Automate within the M365 and Commerce Cloud.

Software/Application Design
Tasks include:
Design small to enterprise NTier agency and business unit web applications and systems that may interact with multiple data source types web services or data warehouses from software requirements specifications and other related business analysis artifacts using NET Framework (C# VB VB Script) JavaScript (JQuery Ajax) HTML CSS XML PowerShell MSOffice and MS SQL Server.
Participate in small to enterprise level development projects for Commerce supported applications and systems by developing application design documentation in accordance with standards and practices completing assigned development tasks contributing to monthly project status reports and attending regularly scheduled project team meetings.
Analyze and define data for use by applications
Analyze and assess industry direction and new capabilities to determine if they are applicable to the to the information systems supported.
Conduct research to identify solutions for development challenges and to enhance coding skills.

IT Business Application maintenance and support. Programs tests and deploys IT Business application changes enhancements and other system revisions.

This position primarily supports IT business applications as the primary or secondary application developer including but not limited to the Low Income Heating Assistance Program (LIHEAP) Office of Crime Victims Advocacy Data System (OCVA) PlanView Bond Users Clearinghouse (BUC) Fuel Mix Disclosure (FMD) Manufactured and Mobile Home Relocation Assistance Program (MMRAP) LeadBased Paint and Renovation (LBP) Individual Trust Accounts Reporting System (ITARS) and many others. These systems are used by other state agencies nonprofits local governments and a large number of external user groups. Many are closely integrated with other IT business applications maintained by external organizations.

Tasks:
Determines best approach to making changes to the system by diagraming creating logic flows and then prototyping solutions.
Develops and implements change and enhancement requests.
Improves overall system architecture and corrects performance issues.
Monitors performance database and other environment logs for any system issues or security threats.
Analyses impacts of changes to existing data structures program logic and design patterns.
Develops test scripts for system and integration testing to ensure full system operation as originally intended.
Defines and documents technical requirements for the network administrator in order to configure the
development quality assurance and production environments.
Develops and documents Release (deployment) Plans to move changes into the production environment.
In accordance with the Release Plan uses Visual Studio to move the release package to the production
environment.
Runs previously developed SQL scripts to update database change requirements to match the application changes.
Develops and supports data dashboards and data visualizations on platforms such as Tableau Power BI and Esri ArcGIS Online.
Develops and integrates datasets and reports from other IT business systems for data dashboards and
visualizations for platforms such as Tableau PowerBI and Esri ArcGIS Online.

Data Management
Tasks include:
Utilize DBMS software (SQL Server MS Access) to develop & maintain relational databases & applications using simple to challenging TransactSQL queries and statements.
Compile simple to medium stored procedures user defined functions and queries using TSQL syntax that are wellstructured and reusable.
Use TSQL skills to efficiently and accurately analyze data models and complete simple to challenging adhoc data requests under time constraints.
Extract transform and load data from external sources and partners to Commerce supported applications.
Utilize reporting software (SQL Reporting Services PowerBI or Tableau) to develop & maintain simple to
medium complexity reports.
Utilize standard methods and quality assurance processes to verify data accuracy and completeness ensuring data quality meets specified business requirements before loading into Commerce supported systems and applications.
Development and support of simple to highly complex automated processes to replace manual data extract transformation import and export processes for Commerce supported systems and applications.
Conversion of simple to highly complex Microsoft Access based relational databases and their respective data interfaces to Microsoft SQL Server or Power Platform.
Develop and optimize data products using cuttingedge cloudbased platforms like Databricks Dataverse and Azure Synapse MS Fabric while designing and implementing efficient data pipelines.

Testing & Quality Assurance
Tasks include:
Conduct system and Unit Testing for all products and systems supported by this position and as directed by management.
Appropriately use commercial testing tools such as Microsoft Visual Studio Unit Testing to ensure code
developed meets coding security and functional testing requirements.
Plan and develop test plans cases and scenarios for all products developed or supported by this position or as directed by management.
Conduct research to identify solutions for resolution of testing failures work with lead developer and business owner to repair and retest.

Research Analysis & Problem Resolution
Tasks include:
Solve simple to highly complex IT problems including defining & analyzing the problem identifying & testing solutions choosing & implementing the best solution documenting the changes in the agency configuration management tracking system and evaluating the outcome.
Escalate problems or issues to the next higher level when available resources have been expended or a decision outside this positions level of authority is required.
Participate in comprehensive research and analysis by querying knowledge bases and other resources to resolve application development database or component issues for all supported applications or as directed by management. Make recommendations to the Supervisor or manager when the identified solution requires a decision above this positions level of authority.
Analyze and assess industry direction and new capabilities to determine if they are applicable to any supported information system.
Analyze and determine impacts of requested modifications to IT applications and systems supported by this position or the section.
Review and approve products developed by junior or peer positions.

Required Qualifications:
Eight 8 years (fulltime equivalent) of professional experience in one or more of the following IT disciplines: consulting analyzing designing programming installing and/or maintaining computer software applications.
OR
An associates degree or higher in Information Technology program or a closely related field; and six 6 years (fulltime equivalent) of professional experience in one or more of the following IT disciplines: consulting analyzing designing programming installing and/or maintaining computer software applications. Additional years of experience can substitute for education on a one for one basis.
OR
A bachelors degree or higher in Information Technology program or a closely related field; and four 4 years (fulltime equivalent) of professional experience in one or more of the following IT disciplines: consulting analyzing designing programming installing and/or maintaining computer software applications. Additional years of experience can substitute for education on a one for one basis.
Advanced education may substitute year for year for experience.

Recent Experience must include:
Using Microsoft Visual Studio and other Software Development tools to develop and maintain division or agency level systems.
Evaluating requirements estimating development times designing developing testing implementing and maintaining .NET applications and web services WCF C# .NET Framework ASP MVC Web Forms JavaScript JQuery AngularJS TSQL using Software Management tools such as Team Foundation Server (TFS) or similar development tools.
Working with and maintaining architecting and data modeling relational databases in support of enterprise level applications using Microsoft SQL Server development and database SQL Server development and database administration experience including Structured Query Language (SQL) (stored procedures views functions and table definitions) reporting and ETL (Extract Transform Load) using SSMS SSRS SSIS and Transact SQL tools.
Interpreting user requirements and software design documentation to be used for software and database development.

Preferred Qualifications:
Prior experience implementing large scale database application systems that cross organizational and agency boundaries.
Experience with Bootstrap JavaScript or JQuery
Experience working with external stakeholders connecting to data systems through Secure Access Washington security gateway.
Experience with Unit and Regression Testing.
Professional experience developing Microsoft application security authentication auditing and exception handling protocols using the Microsoft Enterprise Libraries.
Professional experience in the software development field using the following tools platforms and methods. Experience must include:

• A complete and detailed online application.
• A cover letter (enter online).
• At least threeprofessional references(enter online).

Work from Anywhere in Washington State
This position may be located anywhere within Washington State though occasional travel to a Commerce office building or instate travel to attend events or meetings may be required. If selected you will need to travel to pick up equipment and receive instruction. Many Commerce employees work remotely or have a hybrid schedule.

This recruitment may be used to fill future vacancies over the next 60 days.

This position is covered by a collective bargaining agreement.

Technical support is provided by NEOGOV(cant log in password or email issues error messages). DES job seeker support may answer general questions regarding the recruiting system at .

Our Commitment to Equal Opportunity
The Washington State Department of Commerce is an equal opportunity employer. We strive to create a working environment that includes and respects cultural racial ethnic sexual orientation and gender identity diversity. Women racial and ethnic minorities persons of disability persons over 40 years of age veterans or people with military status and people of all sexual orientations and gender identities are encouraged to apply. Persons needing accommodation in the application testing or interview process or this job announcement in an alternative format may email Human Resources at Applicants who are deaf or hard of hearing may call through the Washington Relay Service by dialing 711 or.

Department of Commerce also offers a competitive benefits package including: medical and dental insurance benefits retirement and deferred compensation plans 11 paid holidays each year 1425 vacation days per year (depending on length of employment) 8 hours of sick leave per month (if full time employed) bereavement leave an employee assistance program as well as other benefits. Please see the Benefits Tab for more details.