Sql data analyst Jobs in Vancouver, WA

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.00 per 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.

Application Process: To be considered for this position, submit a complete electronic application including cover letter and resume via our website.

https://www.nwnatural.com/about-us/the-company/careers

Deadline: 12/1/26

Disclosure: 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.

E-Verify Information
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.

All applications must be submitted through NW Natural’s Electronic Application System. Resumes submitted via email, fax or mail will not be accepted in lieu of an electronic application.

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.