Senior Data and Reporting Analyst

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.

• 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.

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.

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.