IT Application Development Journey

Summary

The Washington State Department of Corrections works to improve public safety by positively changing lives and operating a safe and humane corrections system. The Report Writer (Application Development Journey) develops, tests, maintains, and deploys SQL Server-based reports, dashboards, data structures, and integration processes. The role also validates data quality, resolves reporting and performance issues, and supports data-driven decision-making across the Department.

Responsibilities

• Designing, developing, and maintaining the BI data infrastructure to consistently and reliably support business needs to include:
• Collaborating with Business Analysts to understand reporting needs and translate them into technical specifications
• Translating business requirements into a data model
• Designing how data will be processed, stored, and accessed through the SSRS reports
• Creating/maintaining the SSRS reports and all the processes and data from multiple data sources
• Clearly documenting processes to ensure effective and consistent maintenance
• Maintaining SSRS reports and resolving data quality issues which could look like:
• Maintaining communication with stakeholders and troubleshooting and updating existing reports to ensure performance and accuracy
• Consulting with and makes recommendations to the supervisor on continuous improvements to data processes, including data mining, efficient report production, data integrity, and innovative ways to support the Department in making data-driven decisions
• Modifying the data integration processes to include the requested changes
• Identifying root causes behind data inconsistencies and data issues, and determines whether it is a local data integration issue or an application issue
• Recommending, designing and deploying continuous improvements to enhance the performance and quality of SSRS reports
• Performing database administration, uses Azure DevOps (ADO) and manages Active Directory security groups administration on the BI group managed data, processes and reporting access

Skills

• High school diploma or equivalent
• Minimum of six (6) Years of Software Development experience. This experience must include: At least two (2) years of progressively responsible, professional work experience within the Information Technology field including experience in analyzing, designing, coding, and implementing applications using SQL Server, and SQL Server Reporting Services
• A bachelor's degree in computer science or a related field
• At least two (2) years of progressively responsible, professional work experience within the Information Technology field including experience in analyzing, designing, coding, and implementing applications using SQL Server, and SQL Server Reporting Services
• A good understanding of the ASP.NET framework, SQL Server, and design/architectural patterns
• Demonstrated experience in logical data modeling, relational data architecture
• Experience in resolving application defects and performance issues in connection with changing business requirements
• Experience in writing and/or modifying existing programs, documenting solution programs for application systems
• In-depth knowledge of design patterns, enterprise integration patterns, and patterns for modern enterprise architecture
• Experience in life-cycle management of modern application development
• Excellent communication skills and attention to detail
• Experience with, Agile, Scrum, Iterative, or Waterfall development/project methodologies
• Experience with Azure DevOps, Agile, Scrum, Iterative, or Waterfall development/project methodologies
• American Disabilities Act (ADA) compliance experience

Qualifications

Must Haves

• High school diploma or equivalent
• Minimum of six (6) Years of Software Development experience. This experience must include: At least two (2) years of progressively responsible, professional work experience within the Information Technology field including experience in analyzing, designing, coding, and implementing applications using SQL Server, and SQL Server Reporting Services
• A bachelor's degree in computer science or a related field
• At least two (2) years of progressively responsible, professional work experience within the Information Technology field including experience in analyzing, designing, coding, and implementing applications using SQL Server, and SQL Server Reporting Services
• A good understanding of the ASP.NET framework, SQL Server, and design/architectural patterns
• Demonstrated experience in logical data modeling, relational data architecture
• Experience in resolving application defects and performance issues in connection with changing business requirements
• Experience in writing and/or modifying existing programs, documenting solution programs for application systems
• In-depth knowledge of design patterns, enterprise integration patterns, and patterns for modern enterprise architecture
• Experience in life-cycle management of modern application development
• Excellent communication skills and attention to detail

Nice to Haves

• Experience with, Agile, Scrum, Iterative, or Waterfall development/project methodologies
• Experience with Azure DevOps, Agile, Scrum, Iterative, or Waterfall development/project methodologies
• American Disabilities Act (ADA) compliance experience

Benefits

• This is a telework eligible position, with a 5/8’s schedule. The candidate of choice may work from anywhere within the state of Washington with a reliable internet connection.
• Comprehensive family insurance for medical, dental, and vision
• Remote/telework/flexible schedules (depending on position)
• Up to 25 paid vacation days a year
• 8 hours of paid sick leave per month
• 12 paid holidays a year
• Generous retirement plan
• Flex Spending Accounts
• Dependent Care Assistance
• Deferred Compensation
• Employees and their families are covered by medical (including vision), dental and basic life insurance.
• Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.
• The Washington Wellness program supports workplace wellness programs.
• The Washington State Employee Assistance Program promotes the health and well-being of employees.
• New employees have the option of two employer contributed retirement programs.
• Employees also have the ability to participate in the Deferred Compensation Program.
• All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.
• If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.
• Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.
• Full-time employees earn eight hours of sick leave per month.
• Washington State supports members of the armed forces with 21 days paid military leave per year.
• Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave.
• Leave Sharing
• Parental Leave
• Family and Medical Leave Act (FMLA)