Senior Data and Reporting Analyst

NW Natural • Happy Valley, OR

11h • $110,250 - $157,100 • Hybrid

About The Position

The Senior Data and Reporting Analyst gathers requirements, models business processes, and develops functional design specifications for NW Natural’s Data Reporting Analytics / Enterprise Data Platform (DRA/EDP) program. Working with program leadership and team members, the analyst translates business needs into use case requirements, documents business processes, conducts data research, prepares reports, participates in design activities, tests deliverables, and conducts user acceptance testing.

This is a hybrid position based at NW Natural’s downtown Portland, Oregon headquarters. Candidates must live within commuting distance or be willing to relocate to the Portland metropolitan area. Onsite work is required Tuesday through Thursday, with remote work flexibility Monday and Friday, subject to business needs. The role is a regular, full-time, exempt, non-union position.

Requirements

• 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.
• 8–10 years of related experience involving progressively more complex analysis projects, including business process documentation and redesign.
• At least 5 years of experience working on projects and project teams.
• Ability to work effectively in a team environment and lead others in a directed effort to complete projects.
• Experience working with asynchronous agile teams across multiple time zones.
• Strong verbal communication, negotiation, and facilitation skills, with the ability to communicate effectively one-on-one and in groups.
• Skill in assessing stakeholder needs and asking probing questions to identify underlying needs and essential requirements.
• Ability to work with employees and management at all organizational levels and across organizational and geographic boundaries.
• Analytical skills to evaluate information from multiple sources, reconcile conflicts, break high-level information into details, identify underlying needs, and distinguish solution ideas from requirements.
• Ability to work with changing requirements and priorities using internal and external resources.
• Ability to prepare clear, effective reports and documentation for varied audiences.
• Advanced skill with documentation methods and software, including Word, Visio, Excel, and Power BI.
• Ability to learn new systems and applications.
• Ability to work independently and apply problem-solving and decision-making skills.
• Ability to prioritize multiple tasks and projects, meet tight schedules and demanding targets, deliver high-quality work, and reconcile competing priorities and expectations.
• Exceptional organizational skills and ability to follow through on tasks.
• Must reside within commuting distance of the Portland headquarters or be willing to relocate to the Portland metropolitan area.

Nice To Haves

• Experience with and knowledge of dashboarding tools such as Power BI.

Responsibilities

• Develop use case requirements through interviews, document analysis, workshops, storyboards, surveys, process descriptions, scenarios, task and workflow analysis, and management viewpoints.
• Perform gap analysis comparing current data processes with business objectives and conduct data analysis to gather report requirements.
• Translate business and data requirements into comprehensive functional design specification documents for business stakeholders, developers, QA specialists, production support specialists, and product owners.
• Track, prioritize, and report the status of multiple initiatives.
• Write clear, concise, and unambiguous requirements specifications using standard templates.
• Identify and document data requirements, source-to-target data mappings, and associated business rules.
• Manage expectations through direct, routine interaction with business partners.
• Document test scripts and test plans as needed, participate in system testing, and support the quality assurance specialist in developing a thorough QA test plan.
• Work with business stakeholders to conduct user acceptance testing, document and log defects, manage defect resolution, and obtain written UAT approval for production release.
• Perform other duties as assigned to support efficient and effective system operations.
• Support the company’s commitment to safe work practices.

Benefits

• Health insurance benefits with competitive employer contribution.
• Free access to an online wellness resources platform.
• Up to 23 vacation days.
• 80 hours of sick time.
• 10 paid holidays and 3 floating holidays.
• Three weeks of paid parental leave.
• Diversity, Equity & Inclusion Council and Employee Resource Groups.
• Onsite exercise facility and secure bike room.
• Annual incentive bonus opportunity.
• 401(k) company contribution and match.
• 15% discount on NW Natural stock through the Employee Stock Purchase Program.
• Up to $5,250 per year in tuition reimbursement.
• Wellness incentive program.
• 20% discount on natural gas service.
• Up to 30% discount at NW Natural Appliance Center.
• TriMet Pass for headquarters employees.
• Discounts with Verizon and AT&T Wireless.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior