Senior Data and Reporting Analyst

NW Natural

Portland (OR)

Hybrid

USD 110,000 - 157,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health insurance
Vacation days
Sick time
Holidays
Parental leave
Diversity council
Exercise facility
401K match
Tuition reimbursement
Stock discount

Job summary

NW Natural is seeking a Senior Data and Reporting Analyst in Portland, OR. This non-union, full-time role offers a hybrid schedule with onsite Tuesdays–Thursdays and remote flexibility on Mondays and Fridays for residents of Oregon and Washington.

The position focuses on gathering requirements, modeling processes, and delivering functional design specs for the DRA/EDP program. You will translate business needs into use case requirements, document processes, lead redesign sessions, perform data

Qualifications

  • Bachelor's degree in information technology, computer science, or a business-related field.
  • Proficiency in data analysis and SQL.
  • Experience with dashboarding tools, such as Power BI.
  • 8-10 years of related analysis projects, including business process documentation.
  • 5+ years on projects and teams.
  • Experience with asynchronous agile teams across time zones.
  • Strong verbal communication, negotiation, and facilitation skills.
  • Ability to document requirements and lead stakeholder discussions.

Responsibilities

  • Develops use case requirements via interviews, workshops, and analyses.
  • Performs gap analysis and data analysis to gather report requirements.
  • Translates data requirements into functional design specifications (FDS).
  • Tracks and reports status of multiple initiatives.
  • Writes clear requirements specifications.
  • Leads UAT coordination and defect resolution.
  • Prepares reports and supports QA and system testing.
  • Collaborates with stakeholders across organization and time zones.

Skills

SQL
Data analysis
Power BI
Team leadership

Education

Bachelor's degree

Tools

Word
Visio
Excel
Power BI

Job description

Senior Data and Reporting Analyst

Non-Union Position Operations Business Analysis; Portland,Oregon (US-OR)

Hybrid schedule available for Oregon & Washington residents. Regular FT, Exempt. Posting # 5764

About Us:

At NW Natural, we offer more than rewarding career opportunities and a vibrant, inclusive work culture. We invite you to join us in providing safe and reliable utility services and renewable energy to better the lives of the communities we serve. Our vision is to be the leader in service excellence, innovation and environmental stewardship for our customers, while building on our strengths as a trusted energy provider and environmental leader for our industry.

In addition to environmental stewardship, we're also deeply committed to Diversity, Equity and Inclusion at NW Natural. Our DEI Council started 21 years ago, and today we continue to foster a culture where all employees can experience a sense of belonging, shared purpose and possibility.

NOTE:

This hybrid position is based at our headquarters in downtown Portland, Oregon. Candidates must reside within commuting distance of the office or be willing to relocate to the Portland metropolitan area. Employees are required to work onsite Tuesdays through Thursdays each week, with remote work flexibility on Mondays and Fridays, subject to business needs. This schedule supports collaboration, connection, and team engagement while providing flexibility for focused remote work.

Position Summary

The Senior Data and Reporting Analyst is responsible for gathering requirements, modeling business processes, and developing functional design specification documents for the Data Reporting Analytics / Enterprise Data Platform (DRA/EDP) program. The senior analyst works closely with DRA/EDP leadership and the program team to translate business needs into use case requirements. Responsibilities include documenting business processes, leading business process redesign sessions as needed, conducting data research, documenting functional design specifications, preparing reports, participating in design activities, testing deliverables and conducting user acceptance tests.

Essential Duties & Responsibilities
  • Develops use case requirements through interviews, document analysis, requirements workshops, storyboards, surveys, business process descriptions, scenarios, task and workflow analysis, and management viewpoints.
  • Performs gap analysis to compare current data processes with business objectives. Performs data analysis to gather report requirements.
  • Translates business and data requirements into comprehensive functional design specification (FDS) documents for review and use by business stakeholders, developers, QA specialists, production support specialists, and product owners.
  • Tracks, prioritizes, and reports on the status of multiple initiatives.
  • Writes requirements specifications using standard templates and clear, concise, and unambiguous language.
  • Identifies and documents data requirements, source-to-target data mappings, and associated business rules.
  • Manages expectations through direct and routine interaction with business partners.
  • May perform additional duties, including documenting test scripts and test plans and participating in system testing. Provides support to the quality assurance specialist to develop a thorough and complete QA test plan.
  • Works with business stakeholders to complete user acceptance testing (UAT), document and log defects, manage defect resolution, and obtain written UAT approval for production release.
  • Performs other duties as assigned to support efficient and effective system operations.
  • Supports the company's commitment to a culture of safe work practices.
Qualifications
  • Bachelor's degree in information technology, computer science, or a business-related field, or an equivalent combination of education and experience.
  • Proficiency in data analysis and SQL.
  • Experience with and knowledge of dashboarding tools, such as Power BI, are highly desirable.
  • 8-10 years of related experience involving progressively more complex analysis projects, including business process documentation and redesign.
  • 5 or more years of experience working on projects and project teams.
  • Demonstrated ability to work effectively in a team environment and to lead others in a directed effort to complete projects. Experienced working with asynchronous agile teams across multiple time zones.
  • Superb verbal communication, negotiation, and facilitation skills, with a proven ability to communicate effectively in one-on-one and group settings.
  • Skilled at assessing stakeholder needs and asking probing questions to understand underlying needs and surface essential requirements information.
  • Demonstrated ability to work with employees and management at all levels of the organization including skill in working across organizational and geographical boundaries.
  • Proven analytical skills to critically evaluate the information gathered from multiple sources, reconcile conflicts, deconstruct high-level information into details, discern underlying true needs from presented user requests, and distinguish solution ideas from requirements.
  • Proven ability to work with changing requirements/priorities using internal and external resources.
  • Demonstrated ability to prepare clear, effective reports and documentation for a variety of audiences.
  • Advanced skill in documentation methods and software including but not limited to Word, Visio, Excel, and Power BI.
  • Proven ability to learn new systems and applications.
  • Demonstrated ability to work independently and apply problem-solving and decision-making skills.
  • Proven ability to prioritize multiple tasks and projects, meet tight schedules and demanding targets, and deliver high-quality products while managing competing priorities and reconciling divergent expectations.
  • Exceptional organizational skills, with the ability to follow through on tasks.
What we offer:
Health & Wellness
  • Rich health insurance benefits with competitive employer contribution
  • Free access to an online wellness resources platform
Work Life Balance
  • Up to 23 Vacation Days
  • 80 Hours of Sick Time
  • 10 paid holidays and 3 floating holidays
  • 3 weeks paid parental leave
  • Be part of a workplace where your voice matters. Engage with our Diversity, Equity & Inclusion Council, and a variety of Employee Resource Groups that support community and growth.
  • 1500 sq foot exercise facility and secure bike room
Financial
  • Meaningful annual incentive bonus opportunity in addition to base salary
  • Competitive 401K company contribution and match
  • 15% discount on NW Natural stock through Employee Stock Purchase Program
  • Up to $5250 a year in tuition reimbursement
  • Wellness incentive program
Discounts
  • 20% off natural gas service
  • Up to 30% discount at NW Natural Appliance Center
  • TriMet Pass for all HQ employees
  • Generous discounts with Verizon & AT&T Wireless

Base salary range: $110,250.00-$157,100.00per year, depending on qualifications

Annual Target Incentive: Level 3, 12.0% target Targets are calculated using eligible earnings during plan year participation. Payout, if earned, is based on company and individual performance for each plan year and may range from 0% - 200% of target. Targets are subject to change in subsequent plan years. Must be employed by September 30 in order to receive any prorated payout.

Deadline: 12/1/26

We are a drug free workplace and we comply with Federal Drug Free Workplace Act and Department of Transportation regulations. NW Natural participates in E-Verify. Individuals hired will have their Form I-9 information submitted to E-Verify. E-Verify is an Internet-based system that compares information from an employee's Form I-9, Employment Eligibility Verification, to data from U.S. Department of Homeland Security and Social Security Administration records to confirm employment eligibility.

NW Natural participates in E-Verify. Individuals hired will have their Form I-9 information submitted to E-Verify. E-Verify is an Internet-based system that compares information from an employee's Form I-9, Employment Eligibility Verification, to data from U.S. Department of Homeland Security and Social Security Administration records to confirm employment eligibility.

NW Natural is proud to be an equal opportunity employer. We welcome and embrace our candidates' diversity and take affirmative action to employ and advance individuals without discrimination on the basis of race, color, sex, gender identity or expression, sexual orientation, religion, age, physical or mental disability, veteran status, pregnancy (including childbirth or related medical conditions), national origin, marital status, genetic information, and all other legally protected characteristics. We forbid discrimination and harassment in the workplace based on any protected status or characteristic. A criminal history is not an automatic bar to employment with NW Natural. Instead, we make individualized assessments regarding qualifications and backgrounds. NW Natural is also committed to providing reasonable accommodations for individuals with disabilities, individuals with sincerely held religious beliefs, and disabled veterans in our job application procedures. If you need assistance or an accommodation as part of the application process, please contact us at employment@nwnatural.com or (971) 979-6341.

NW Natural does not accept unsolicited submissions or assistance from search firms for posted positions. Resumes submitted by search firms working under a valid and current written contract with NW Natural valid written Statement of Work in place for this position from NW Natural HR/Employment will be deemed the sole property of NW Natural. No fee will be paid in the event the candidate is hired by NW Natural as a result of the referral or through other means.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Full Stack Web Developer
Full Stack Web Developer

NW Natural • Happy Valley (OR)

Hybrid
USD 89,000 - 140,000
Health insurance
401K company contribution
Tuition reimbursement
+3
Full Stack Web Developer
Full Stack Web Developer

NW Natural • Portland (OR)

Hybrid
USD 89,000 - 140,000
Health & Wellness benefits
Vacation & holidays
Tuition reimbursement
Enterprise Architecture Business Analyst
Enterprise Architecture Business Analyst

NW Natural • Portland (OR)

Hybrid
USD 110,000 - 157,000
Health insurance
401(k) with company match
Tuition reimbursement
+1
IT Project Manager
IT Project Manager

NW Natural • Portland (OR)

Hybrid
USD 98,000 - 157,000
Health insurance
401(k) matching
Tuition reimbursement
+1
General Accounting Manager
General Accounting Manager

NW Natural • Oregon (IL)

Hybrid
USD 120,450 - 171,650
Health insurance benefits
401K company contribution
Tuition reimbursement
HRIS & SuccessFactors Administrator
HRIS & SuccessFactors Administrator

NW Natural • Portland (OR)

Hybrid
USD 89,000 - 140,000
Health insurance
Wellness platform
Vacation days
+5
IT Project Manager (SAP)
IT Project Manager (SAP)

NW Natural • Portland (OR)

Hybrid
USD 98,000 - 157,000
Procurement Manager, IT & Cybersecurity
Procurement Manager, IT & Cybersecurity

NW Natural • Portland (OR)

Hybrid
USD 110,000 - 157,000
Health insurance
Wellness resources platform
Vacation days
+10
Gas & Regulatory Accounting Mgr
Gas & Regulatory Accounting Mgr

NW Natural • Oregon (IL)

On-site
USD 120,450 - 171,650
Health insurance benefits
Up to 23 vacation days
Tuition reimbursement
Auto Body Repair Tech
Auto Body Repair Tech

NW Natural • Sherwood (OR)

On-site
USD 65,000 - 70,000
11 paid holidays
3 weeks paid parental leave
401K company match
+1