Sql Careers in portland ∙ Page 1
72 Remote & work from home jobs online
Hybrid Sr. Software Development Engineer
Capsa Healthcare · Portland, United States Of America · Hybrid
Hybrid Business Analyst I (User Configuration Specialist)
CorVel · Portland, United States Of America · Hybrid
City Nature Analyst II - CPPW
City of Portland, OR · Portland, United States Of America · Hybrid
- Professional
- Office in Portland
About the Department
Job Appointment: Regular, Full-time
Work Schedule: Monday – Friday 8:30 AM – 5:00 PM
Work Location: The current schedule for this position is hybrid. Employees are expected to work on-site 50% of the time. The City is reevaluating its return-to-office (RTO) policy, which may result in changes to in-person requirements with advance notice. The hiring manager for this position will have more up-to-date information at the time of all verbal/contingent offers. In-person work will be conducted at Carnegie Annex, 2909 SW 2nd Ave, Portland, Oregon 97201. Remote work must be performed within Oregon or Washington.
Benefits: Please check our benefits tab for an overview of benefits for this position.
Language Pay Premium Eligible: This position is or may be eligible for Language Pay Differential for qualifying employees.
Union Representation: This classification was recently recognized as represented by a new labor union, City of Portland Professional Workers (CPPW). To view current labor agreements, please visit here.
Application Material: Please click APPLY to submit your application via the City of Portland’s online portal. You will need to respond to the supplemental questions and attach a resume. Candidates meeting the minimum qualifications will be invited to demonstrate a sample of their work. An eligible list will be established upon review of the candidate’s qualifying work samples.
Position Summary
The City Nature Analyst supports a coordinated and strategic approach to performance tracking, budget monitoring, and resource analysis across Portland Parks & Recreation’s Land Stewardship division. This role develops and tracks performance metrics, evaluates equity in resource allocation, and supports informed decision-making that aligns with service goals. The Analyst also works closely with the fund center manager to prepare and monitor budgets, provide real-time financial analysis, and ensure consistent practices across the division.
The Land Stewardship division manages Portland’s parks, trails, natural areas, and community gardens, which are essential spaces that support healthy, connected communities. The team provides maintenance, environmental stewardship, and programming that promote physical, mental, and social well-being across the city.
City Nature is a work group within PP&R's Land Stewardship division. In the City Nature work group, we strive to support ecologically healthy natural areas, gardens, trails, and nature patches, as well as provide sustainable access to nature for our community.
As a City Nature Analyst, you will work on:
Data Management:
- Create and manage data tracking systems to support City Nature work, such as documenting compliance with state and local environmental regulations and progress on key performance indicators
- Support integration of data management systems into new Bureau and City initiatives, such as the CMMS work order system
- Track and document impacts of climate change on City Nature operations, support integration with performance metrics in regionally significant plans such as Portland’s Climate Emergency Work Plan and Multnomah County Community Wildfire Protection Plan
- Collaborate with City Nature staff to review, monitor, and assess gardens, natural areas, parks, nature patches, assets, and operational programs
- Manage complex data systems for analysis, reporting, and decision-making, utilizing tools such as advanced Excel, Power BI, SQL, and/or budgetary software
- Collaborate with City Nature, Planning, and GIS staff to review, optimize, and standardize use of geospatial tracking tools such as Field Maps and SprayMapper; integrate with other City or Bureau initiatives
Financial Management and Analysis
- Support development of work group budgets, develop strategies and spending plans to meet work group goals, identify emerging challenges and potential solutions
- Identify and establish systems to ensure resource allocation is led by equity
- Develop recommendations on resource allocation based on analyses; make recommendations to improve efficacy and efficiency
- Provide procurement support for establishing contracts, tracking, and invoicing
- Track and document the impacts of process and budget changes on City Nature operations
- Administer and track grant funds and performance metrics for project work; negotiate and draft proposed contracts, grants, and interagency agreements
Strategic Planning and Documentation
- Coordinate and contribute to strategic planning efforts, including sequencing, program planning, document control, gathering and analysis of technical feedback, and the creation of operational guidance materials
- Provide training, problem-solving, and technical support for City Nature work; coordinate and serve on committees and work groups
- Design and execute data gathering efforts to inform strategic planning, which may include trends, needs, use patterns, gaps in equitable access, community input, etc.
Project, Policy, and Grant Oversight
- Collaborate with Managers and Supervisors to set project goals, identify measurable outcomes, and demonstrate progress towards performance metrics
- Support research, data collection, analysis, and recommendations for special project work
- Alignment with Bureau and City priorities, such as the Climate Emergency Action Plan
- Oversee the planning, implementation, and reporting of policies, special projects, and grant-funded initiatives; ensure compliance with funding requirements, timelines, and performance metrics.
- Design, document, and update operational best management practices in collaboration with subject matter experts; ensure efficiency, safety, and quality standards across operations
- Track legislative impacts on City Nature work
- Support the research and development of relevant grant applications to secure funding for City Nature work (trails systems/equitable access improvements, wildfire/climate resilience, regenerative agriculture, environmental education, etc.)
- Support work to address encroachments and navigate easement complexities of land in our care
Communications and Reporting
- Prepare and deliver clear, timely, visually dynamic, and accurate reports, articles, and data summaries for internal and external audiences
- Provide support in drafting City Council ordinances and associated communications
About the Bureau:
Portland Parks & Recreation (PP&R) is committed to the overall Citywide vision that race will have no detrimental effect on people of color, refugee and immigrant communities in accessing our parks and natural areas, or from the benefit of our services. We recognize, understand, and encourage celebration of the differences that surround us. Diversity and equity are vital to PP&R’s ideals and values. The City of Portland, Oregon is a growing and diverse city of 650,000 residents, nearly 20% of whom speak languages other than English at home. PP&R values a diverse workforce and seeks ways to promote equity and inclusion within the organization and with the public. PP&R encourages applications from candidates with knowledge, ability and experience working with a broad range of individuals and communities with diverse racial, ethnic, and socio-economic backgrounds. Although not required, PP&R encourages candidates who can fluently speak another language to include that information in their application materials. Multilingual candidates are encouraged to apply.
Virtual Zoom Meet & Greet Opportunity
Come meet the hiring manager and the senior recruiter! We'll be talking about the position duties and responsibilities, day to day life in the role, review the announcement, discuss how to apply, and answer questions you may have about the position.
Topic: Meet & Greet: City Nature Analyst II - CPPW
Time: Sep 3, 2025 11:30 AM Pacific Time (US and Canada)
Invite Link: Link will be available by Tuesday at 10 am
*Please note: AI Notetaking apps will not be allowed into virtual sessions hosted by the Bureau of Human Resources Recruitment Team. If you need accommodations as defined by the American Disabilities Act, then please contact the Recruiter for assistance.
Questions?
Amanda Hillebrecht, Senior Recruiter
Bureau of Human Resources
Position Duties
The following minimum qualifications are required for this position:
- Experience in public administration and program evaluation in field(s) related to organic gardening, natural resource management, environmental education, integrated pest management, or environmental science.
- Ability to research, analyze, interpret, explain, and apply relevant laws and regulations; develop policies and procedures; and apply equitable program practices to complex operations.
- Experience in public sector budgeting and financial management, including forecasting revenue, tracking expenditures across multiple funding streams, analyzing trends, ensuring compliance with grant or program requirements, and recommending fiscal adjustments.
- Knowledge of the impacts of systemic oppression on marginalized communities and experience applying diversity, equity, and inclusion principles in program development and resource allocation.
- Experience translating complex technical data and performance metrics into clear, actionable insights tailored to a range of audiences.
- Experience leveraging complex data systems (e.g., Excel with advanced formulas, VBA automation, Power BI, Tableau, SQL) to evaluate program performance, support decision-making, and develop evidence-based recommendations
Applicants must also possess:
A valid driver's license and acceptable driving record at the time of hire.
Although not required, you may have:
- Bachelor’s degree from an accredited college or university with major course work in statistics, data management, GIS, natural resources, environmental science, public administration, environmental education, or a related field.
- Knowledge of principles and practices of natural resource management, land stewardship, and Indigenous Traditional Ecological and Cultural Knowledge.
- Experience advancing racial equity within a government agency or large institution.
- Experience developing and managing budgets and applying principles of racial equity in resource allocation.
- Strong communication skills, knowledge of trauma-informed care practices, cultural humility, and the ability to apply these skills effectively with diverse groups.
Minimum Qualifications
STEP 1: Apply online between September 1st to September 8th, 2025
Required Application Materials:
- Resume
- Answer to the Supplemental Questions (click on the Questions tab to preview the questions)
Optional Application Materials:
- Veteran documents to request Veteran Preference (ex, DD214-Member 4, VA Benefit Letter, etc.)
Application Tips:
- The City of Portland has How to Apply Videos and offers How to Apply Classes once per month. If you have questions after watching the videos, you are invited to contact the recruiter listed on the announcement.
- Your responses to the supplemental questions should include details describing your education, training, and/or experience, and where obtained, which clearly reflect your qualifications for each of the numbered items in the "To Qualify" section of this announcement.
- Your resume should support the details described in your responses to the supplemental questions.
- How We Determine Pay: The City of Portland is covered by the Oregon Equal Pay Act. Your salary is determined based on the experience listed in your resume that is directly related and equivalent to the position for which you are applying. It is strongly encouraged to include any transferable experience (paid or unpaid, regardless of how recent) to ensure your offer is reflective of all your relevant experience.
- Do not attach materials not requested.
- All completed applications for this position must be submitted no later than the closing date and time of this recruitment.
- All applications must be submitted via the City's online application process. E-mailed and/or faxed applications will not be accepted.
- You can use AI tools to assist with your job application, but please make sure to personalize your responses to supplemental questions. Avoid copying and pasting; instead, use AI to generate ideas and then tailor them to reflect your own experiences and skills.
Step 2: Minimum Qualification Evaluation: Week of September 8, 2025
- An evaluation of each applicant's training and paid and unpaid experience, as demonstrated in their resume and supplemental questions, is weighted 100%.
- Your resume and responses to the supplemental questions will be the basis for our evaluation of your qualifications for this position. Incomplete or inappropriate information may result in disqualification.
- You have 14 days from the notice of the minimum qualification evaluation results to let us know if you would like to review and discuss your evaluation results. Please read the City of Portland Administrative Rule 3.01 for complete information.
- Additional evaluation may be required before the establishment of the eligible list and/or final selection.
Those who meet the minimum qualifications will receive an email with instructions to provide a work sample. Applicants will submit the work sample and attach it to their application by the deadline. Alternatively, an in-person or virtual work sample demonstration may be utilized.
*Please note that your completed work sample exercise may be included in the interview process.
Step 4: Establishment of Eligible List: Week of September 22, 2025
- Candidates who meet the minimum qualifications and have an acceptable work sample will be placed on the equally ranked eligible list.
Step 5: Selection (Interview): October 2025
- The hiring bureau will review and select candidates to interview.
Step 6: Offer of Employment: November 2025
Step 7: Start Date: November 2025
- A start date will be determined after all conditions of employment have been met.
*Timeline is approximate and subject to change*
Other Qualifications
Click here for additional information regarding the following:
- Veteran Preference
- ADA, Pregnancy, and Religious Accommodations
- Work Status
- Equal Employment Opportunity
