SQL Reports Developer (Information Systems Specialist 6)
SQL Reports Developer (Information Systems Specialist 6)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Initial Posting Date:
07/08/2025Application Deadline:
07/31/2025Agency:
Department of Environmental QualitySalary Range:
$6025 - $9108Position Type:
EmployeePosition Title:
SQL Reports Developer (Information Systems Specialist 6)Job Description:
The Oregon Department of Environmental Quality strives to build and sustain an inclusive and equitable environment that embraces and values diversity. Employees at all levels of the agency work together to foster fairness equity inclusion and belonging. We strive to be a workplace where we share our authentic identities while advancing our individual professional goals and while collaborating to protect preserve and enhance the environment for current and future generations. We celebrate and appreciate diversity champion equity and treat each other with respect and dignity. We are an equal opportunity employer and do not discriminate based on race color national origin ethnicity veteran status gender sexual orientation religion age or physical or mental disability.
Are you passionate about preserving enhancing and protecting Oregons environment If so please consider a career with the State of Oregon at the Department of Environmental Quality (DEQ). At DEQ employees have the opportunity to work with a dynamic and supportive team of mission-focused individuals tasked with maintaining restoring and enhancing the quality of Oregons air land and water.
The Oregon Department of Environmental Quality has a full-time opportunity available for a SQL Reports Developer (Information Systems Specialist 6) in Portland Oregon.
Please consider joining an innovative team and work to advance our agencys mission to protect and improve Oregons environmental quality.
About DEQ!
The Oregon Department of Environmental Quality is the primary regulatory agency of the government of the U.S. State of Oregon responsible for protecting and enhancing the states natural resources. Here is a video about DEQ: Central Services Division (CSD) assists the Agency in achieving its mission by providing central management services for the agency in accounting budgeting information systems human resources health and safety training policy and organizational development purchasing and facilities management. The division serves headquarters and 3 regional divisions the Vehicle Inspection Program and the Laboratory and Environmental Assessment Division. Services are provided for over 800 positions various local and regional governments and directly to citizens.
Click here to view a map of all of the DEQ offices.
What you will do!
In this position youll play a key role in developing and maintaining complex SQL Server Reporting Services (SSRS) and Power BI reports that support the Your DEQ Online enterprise system. Approximately 65% of your time will be spent writing and optimizing advanced SQL queries working with relational and JSON-based data and building dynamic reports and dashboards for both internal and external users. Youll also contribute to application and system development (25%) helping integrate reports with existing applications and supporting database-driven features. The remaining 10% of your time will be dedicated to improving reporting processes conducting data validation and collaborating with technical and program staff to meet evolving data and reporting needs.
Whats in it for you!
The opportunity to work in a productive and creative environment where no two days are ever the same!DEQ cares deeply about employee wellness and benefits. We offer a competitive benefits package that offers comprehensive medical dental and vision plans for the employee and their qualified family members as well as paid sick leave vacation leave personal leave and 11 paid holidays per addition we offer membership in the Public Employees Retirement System (PERS) and you have the opportunity to potentially receive loan forgiveness under the Public Service Loan Forgiveness Program (PSLF). If you are passionate about Oregons environment apply today!
This is a full-time AFSCME represented position.
This recruitment may be used to fill future vacancies.
What are we looking for
Minimum Qualifications:
- 5 years of information systems experience OR
- 3 years of information systems experience and an Associates degree in computer science information technology or a related field OR
- 1 year of information systems experience and a Bachelors degree in computer science information technology or a related degree.
Candidates who are most competitive will also reflect the following desired attributes:
- Proven experience developing SQL Server and Visual Studio-based transaction processing systems and distributed applications.
- Strong understanding of relational database theory and practical application in real-world environments.
- Experience designing and supporting database solutions in multi-user multi-site systems.
- Ability to provide technical guidance and support to managers developers and system usersboth internal and external.
- Strong critical thinking and analytical skills with the ability to exercise independent judgment take initiative and contribute effectively both independently and as part of a team.
- Demonstrated understanding of the historical impacts for marginalized and underrepresented communities; ability to take personal responsibility for increasing their knowledge of environmental justice and diversity equity inclusion and belonging.
- Excellent communication and customer service skills including the ability to communicate complex ideas clearly and respectfully with diverse audiences even in high-pressure or compliance-focused scenarios.
- Strong organizational skills and the ability to manage multiple priorities navigate complex assignments and meet tight deadlines.
Working Conditions:
DEQ believes in a diverse and inclusive work environment. All employees are expected to contribute to a work environment that collectively values and benefits from respecting its diversity and promotes a culture of inclusiveness.
This position will be based out of DEQs Headquarters office in Portland however the successful candidate may be eligible for hybrid work. The logistics of hybrid work will need to be worked out with the Hiring Manager prior to your hire and may be changed at any time given specific job duties and business needs. DEQ will provide necessary hardware (laptop monitor keyboard mouse and cell phone) for an employee to successfully work from home. At DEQ sites you will have access to a workspace however it may be shared with other employees.
This position requires occasional travel on official State business for meetings trainings conferences seminars and public hearings some of which may include evening work overnight stays and /or weekend work. You may need to work outside of regular business hours to respond to emergencies as needed.
How to Apply: (complete the application in full)
- External Applicants Click on the Apply button and submit your application. Click this link for the External Candidate job aid and view this video for additional information.
- Internal Applicants (current State of Oregon employees): Apply through your employee Workday account. View this knowledge article for assistance.
Helpful Tips:
- Allow yourself plenty of time to complete and submit the application.
- Workday will timeout after 15 minutes of inactivity.
- This posting closes at 11:59 PM on the close date listed.
- Please save a copy of the job announcement for your reference as it may not be available for you to view after the job posting closes.
- Be sure to check both your email and Workday account for updates regarding this recruitment.
- Workday performs best in Google Chrome.
- Click here for Resources and a Job Support Page.
Help Your Application Rise to the Top!
Your application materials are the perfect opportunity to highlight your interest in the position and showcase your amazing skills and experience. In addition to your related work experience and education DEQ will use the desired attributes and minimum qualifications above under the What are we looking for section to determine whom to interview. Please make sure your attributes and minimum qualifications are clearly demonstrated in your application materials.
Interested in hearing about future opportunities with DEQ Click here to subscribe for our weekly e-mail updates.
Veterans Information:
DEQ provides veterans preference points to all eligible veterans. For more information on veterans preference please visit Veterans Resources or call the Oregon Department of Veterans Affairs at: 1-. For privacy reasons please do not attach veterans preference documents when initially applying. Instead you will be asked to submit those at a later time as part of a future task in Workday.
Equal Pay Analysis:
As an employer the State of Oregon complies with HB 2005 the Pay Equity Bill. We do not discriminate on the basis of protected class in the payment of wages and we do not screen applicants on the basis of their current or past compensation. Please visit for more information. Please note: the salary listed is the non-PERS qualifying salary range. If the successful candidate is PERS qualifying the salary range will reflect an additional 6.95% (6% goes to PERS and .95% covers payroll taxes). Please review the Classification and Compensation page for more details.
Work Authorization:
DEQ does not offer visa sponsorships. On the first day of employment all hires will be required to complete the US Department of Homeland Securitys Form I-9 confirming authorization to work in the United States. In addition hires will have three business days from their first day of employment to present documents that establish employment authorization and identity. DEQ is an E-Verify employer and will use E-Verify to confirm that hires are authorized to work in the United States.
Questions/Need Help
If you have questions about the recruitment or need assistance to participate in the application process please contact DEQs Recruitment Team at or . TTY users: please use the Oregon Telecommunications Relay Service at 1-.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
