IT Application Development Journey
State of Washington
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Washington State Department of Corrections seeks a Report Writer to design, develop, test, and maintain reports and dashboards using Microsoft SQL Server technologies. You will translate business requirements with analysts and IT teams to deliver timely, reliable data access across the agency.
You will validate data quality, deploy reporting solutions, and optimize performance while supporting budgets and programs.
Qualifications
- High school diploma or equivalent required.
- Bachelor's degree in computer science or related field also acceptable.
- Minimum of six years in Software Development with experience in SQL Server & SSRS.
- Experience analyzing, designing, coding and implementing applications using SQL Server & SSRS.
- Good understanding of ASP.NET, SQL Server and design/architectural patterns.
- Experience in data modeling and enterprise architecture patterns.
- Experience in lifecycle management of modern application development.
- Excellent communication and attention to detail.
Responsibilities
- Design, develop, test, and maintain BI data infrastructure to support business needs.
- Collaborate with Business Analysts to translate reporting needs into technical specs.
- Create/maintain SSRS reports and data sources.
- Implement data models, processing, storage and access for reports.
- Document processes to enable maintenance and future enhancements.
- Perform data quality validation and support data-driven decisions.
- Use Azure DevOps for deployment and security management.
Skills
Education
Tools
Job description
Full Time | Permanent
Salary Range: $85,800 - $115,416 Annually
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. Travel may be required. Are you passionate about transforming complex data into meaningful insights? Join our team as a
Description
IT Application Development Journey
Full Time | Permanent
Salary Range: $85,800 - $115,416 Annually
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. Travel may be required. Are you passionate about transforming complex data into meaningful insights? Join our team as a Report Writer (Application Development Journey) and play a vital role in supporting the Washington State Department of Corrections’ mission to improve public safety. The goal of this position is to develop innovative reports and dashboards that provide critical information to leaders and staff across the agency, helping drive informed decisions that support efficient operations and positive outcomes.
As a Report Writer, you will design, develop, test, and maintain data reports and dashboards using Microsoft SQL Server technologies. Working closely with Business Analysts, subject matter experts, and IT teams, you’ll translate business requirements into accurate, user-friendly reporting solutions that provide timely and reliable access to data across the Department. You’ll develop and populate data structures, validate and deploy reporting solutions, and ensure reports perform efficiently while meeting business needs.
This role also involves analyzing and validating data to ensure its quality and integrity, supporting responses to internal and external requests related to Department populations, programs, services, and budgets, and maintaining reporting solutions that enable effective decision-making. Your work will directly contribute to improving operations and advancing the Department’s mission of enhancing public safety throughout Washington State.
We are looking for teammates who share our vision of public service, committed to an equitable and inclusive culture that fosters and inspires excellence, while promoting innovation, engagement, and safety, leading to better outcomes for our incarcerated population, our agency, and our community.
- 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
- 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
In addition to the above knowledge and experience, the below KSA”s are also required:
- 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 DeveOop, Agile, Scrum, Iterative, or Waterfall development/project methodologies
- American Disabilities Act (ADA) compliance experience
Vision: Working together for safer communities.
Mission: Improving public safety by positively changing lives.
Our Commitment: To operate a safe and humane corrections system and partner with others to transform lives for a better Washington.
- Cultivate an environment of integrity and trust: Corrections values partnership and trust. We foster openness and support courageous conversations. We are committed to doing what we say we are going to do by being accountable and taking personal ownership in our actions.
- Respectful and inclusive interactions: Corrections appreciates and values individuals by promoting an inclusive and diverse environment, which encourages safety. We respect, value, and listen to the thoughts, feelings, and perspectives of our stakeholders and consider the impact on those we serve as well as each other.
- People's safety: Corrections believes in creating an environment that values physical, mental, and emotional security and well-being. We honor those who advance safety for all.
- Positivity in words and actions: At Corrections, we assume positive intentions and believe there is a shared desire for the best outcome. We consistently demonstrate positive behavior and always put forth our best effort.
- Supporting people's success: Corrections is committed to our community – understanding individuals, instilling hope, embracing change, and providing opportunities.
DOC is an equal opportunity employer and does not discriminate on the basis of race, creed, color, national origin, sex, marital status, sexual orientation, gender identity, gender expression, age, honorably discharged veteran, veteran status, genetic information, or the presence of any sensory, mental or physical disability or the use of a trained guide dog or service animal by a person with a disability.
- DOC complies with the employment eligibility verification requirements for the federal employment eligibility verification form I-9. The selected candidate must be able to provide proof of identity and eligibility to work in the United States consistent with the requirements of that form. https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents
- DOC does not use E-Verify; therefore, we are not eligible to extend STEM-Optional Practice Training (OPT). For information, please visit www.uscis.gov.
- This recruitment may be utilized to fill more than one position.
- Please include a minimum of three (3) professional references with your application. A professional reference is defined as an individual who has been paid to supervise your work and can attest to your work performance, technical skills, and job competencies. If you do not have any or sufficient professional references, please include non-related professionals, such as educators or other professional associates.
- Please note: Phone number AND email address are required for all professional references.
- A background check including criminal record history will be conducted prior to a new hire. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant’s suitability and competence to perform in the position.
- Employees may work directly with or near incarcerated individuals in a potentially hazardous setting. Please consider this when deciding whether to apply.
- We are committed to maintaining a drug and alcohol-free work environment, and our employees are expected to comply with all state and federal laws. A pre-employment drug test may be administered as part of the selection process, and applicants who test positive for any controlled substances, will be disqualified from consideration.
- Oleoresin Capsicum (OC) is an aerosol pepper spray made available as a means of self-defense and/or de-escalation. Applicants with sensitivities or allergies are encouraged to ask about the level of exposure they could expect in this position.
- Animal care projects are a common component of most Washington State prisons, including dog and cat programs. Applicants with animal sensitivities or allergies are encouraged to ask about the level of exposure they could expect in this position.
- Tuberculosis (TB) is a priority health issue for DOC employees. The successful candidate may be required to provide valid proof of a baseline TB skin test within 60 days from the date of hire. When positive tests result, further information, testing and treatment will also be required. Employment is not contingent upon test results.
- Foreign equivalent degrees awarded outside the United States must have a credential evaluation report attached to your application. You may request the required evaluation/documentation from www.wes.org and www.aice-eval.org. Until this documentation is provided, you will not be selected to move forward in the hiring process.
This position may be allocated for telework. If authorized for the role, work may be performed from your home or another offsite location within the state of Washington using a reliable internet or cellular hotspot service at that time. Employees are expected to perform assigned duties in a safe manner, to take proper care all state-issued equipment, and maintain confidentiality of all information in possession while working offsite. Employees will be required to commute to a Department of Corrections facility or field office as business requires, to potentially include components of the onboarding process. Some offices will have a “drop in” area available, however, a dedicated workspace within a DOC facility will not be provided.
As an employee of the Department of Corrections, your work-life integration is a priority. Washington State employees are offered one of the most inclusive and competitive benefits packages in the nation. Besides comprehensive family insurance for medical, dental, and vision, these perks also may include:
- 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 and so much more!
- Teamsters 117 represented positions receive 3 days of bereavement leave.
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.
For questions about this recruitment, or to request reasonable accommodation in the application process, please email mackenzie.conley@doc1.wa.gov or call us at 509-630-9160. For TTY service, please call the Washington Relay Service at 7-1-1 or 1-800-833-6388.
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.
We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.
Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.
Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.
To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.
Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.
Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.
The Washington State Employee Assistance Program promotes the health and well-being of employees.
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.
Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.
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.
Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.
Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.
Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours.
Pay status includes hours worked and time on paid leave.
Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.
Sick leave accruals for part-time employees will be proportionate to the number of hours in pay status, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.
Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.
Part-time employees accrue vacation leave hours in accordance with WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full-time employment.
Pay status includes hours worked, time on paid leave, and paid holiday.
As provided in WAC 357-58-175, an employer may authorize a lump-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.
Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.
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. In addition, the employer may approve other available leave types for the purpose of bereavement leave.
Leave Sharing
Parental Leave
Family and Medical Leave Act (FMLA)
Leave Without Pay
Please visit the State HR Website for more detailed information regarding benefits.
Updated 01-07-2026
01
Are you a current DOC employee?
- Yes
- No
02
Please Indicate Your Highest Level Of Education
- High school diploma or equivalent
- Associates degree
- Bachelor’s degree in computer science or a related field
- Masters degree or higher
03
If you have a degree obtained outside of the United States
- Yes
- No
- NA
04
How many years of Software Development experience do you possess?
- I have one year or less of this experience
- I have two to three years of this experience
- I have four to five years of this experience
- I have six or more of this experience
- I have eight or more years of this experience
05
How many 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 do you possess?
- I do not have this experience
- I have one year of this experience
- I have two years of this experience
- I have three years of this experience
- I have four or more years of this experience
06
If you indicated having 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, please describe this experience in detail. If you do not have this experience, please put NA. See resume will be considered an incomplete answer.
07
Please indicate all knowledge, skills and/or abilities in which you possess:
- 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
- I do not have any of the above knowledge, skills and/or abilities
08
Please indicate all knowledge, skills and/or abilities in which you possess:
- Experience with Azure DeveOop, Agile, Scrum, Iterative, or Waterfall development/project methodologies
- American Disabilities Act (ADA) compliance experience
- Experience with, Agile, Scrum, Iterative, or Waterfall development/project methodologies
- I do not have any of the above knowledge, skills and/or abilities
09
How did you hear about this opportunity?
- Careers.wa.gov; jobs.doc.wa.gov; or governmentjobs.com
- Indeed
- DOC social media (Facebook, LinkedIn, Twitter)
- Job/career fair
- Job boards (Monster. ZipRecruiter, GlassDoor, CareerBuilder)
- WorkSource
- Veteran outreach
- Referral from current DOC employee
- Other
10
If hired for this position, do you currently possess required documents to allow you to legally work within the United States? (The below link lists acceptable documents: https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents)
- Yes
- No
11
If hired for this position, will you require employer sponsorship, either now or in the future?
- Yes
- No
- Required Question
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
