Website Benton PUD
BENTON COUNTY PUBLIC UTILITY DISTRICT 1
invites applications for the position of:
Business Intelligence Analyst I, II, or III
$2,326.69 – $3,686.73 Biweekly
$60,494.00 – $95,855 Annually
2721 W 10th Avenue, Kennewick
Open Until Filled
Full Time, Regular, Exempt
Benton PUD is seeking a highly analytical and creative applicant with strong business intelligence visualization skills that complement their business and data analysis skills. This position will have the unique opportunity to work with all departments supporting the vision of turning critical data into key decision-making information utilizing business intelligence software. The work is diverse and challenging and the size of the organization allows for innovation and creativity working within a small data team.
The preferred candidate will have experience with Tableau, SQL, data analysis, requirements gathering and data mining. The ideal candidate will have an understanding of electric utility operations and have a passion for storytelling with data.
This position is located in Kennewick, WA, and we offer work/life balance options including alternative and hybrid work schedules.
The successful candidate will be placed appropriate to their education, experience, and ability to perform the specific position accountabilities.
Target range for BI Analyst I: $60,494 to $72,017
Target range for BI Analyst II: $73,198 to $87,141
Target range for BI Analyst III: $80,518 to $95,855
The primary purpose of this position is to turn data into critical information that can be used to make solid business decisions. This position requires a working knowledge of the District’s business processes and the ability to perform in-depth data requirements analysis by working with functional users and subject matter experts. This position will follow a well-defined Business Intelligence methodology to create the required artifacts necessary for dimensional model design and the subsequent handoff to the BI/ETL Developers for creating the ETL packages. The position will ensure all business analytics questions are met by developing or supporting department data citizens in creating and publishing visualizations, dashboards, and data stories using the District’s Business Intelligence toolsets.
Support the District’s mission to serve our customers and foster a positive workplace by personally choosing behavior aligned with our values and ethical code.
Capture business analytics requirements by conducting interviews; capturing business analytics questions; defining key dimensional data and enhancing our data analysis methodologies.
Perform data validation and profiling using appropriate tools to identify, document and understand the data and any quality issues or anomalies.
Perform data mapping for each dimension and fact table and subsequently capture each business attribute definition and business field name for the Business Semantic Layer.
Resolve data quality issues by making recommendations and then working with Data Stewards or BI/ETL developers to implement tracking metrics and solutions.
Manage the lifecycle development of Data Marts by organizing and managing tasks, interviews, and district resources.
Provides direction and participates in the Data Mart testing effort to validate the Data Warehouse data is valid and accurate.
Recommends workflow changes, procedure changes, new policies and data capture options for data needed to fulfill the business analytics questions.
Co-leads training efforts with our business department citizens for creating effective dashboards using our Business Intelligence toolset.
Creates and builds Dashboards, KPI’s or Data Stories using the district’s Business Intelligence toolset that meet the expectations of department heads and executives.
Be the first line of contact for dashboard or daily Data Warehouse production issues by troubleshooting and either resolving or facilitating the resolution with the Data Team.
Maintains the Business Intelligence Server by managing content, security, users, groups, schedules, tasks, and configurations.
Ensure the District meets obligations to protect the privacy of employee and family member health information (known as Protected Health Information or PHI) by complying with the Health Insurance Portability and Accountability Act of 1996 (HIPAA) and adhering to all related District policies and procedures relating to HIPAA Privacy and Security.
Complete special projects and other duties as assigned to meet team, department, and organization goals.
MINIMUM QUALIFICATIONS, EXPERIENCE AND CERTIFICATIONS:
Education required for all levels:
BA/BS in Management Information Systems, Computer Science or field related to functional area
Minimum experience required:
BI Analyst I: Up to two (2) years in a Business Intelligence role
BI Analyst II: Three (3) to five (5) years in a Business Intelligence role
BI Analyst III: Five (5) to seven (7) years in a Business Intelligence role
In lieu of BA/BS, a minimum of an AA/AS is required with 2 additional years of directly related experience and training
Knowledge, Skills and Abilities:
Ability to perform Use Case requirements gathering for data analytics
Ability to solve technical problems
Ability to learn functional business processes of an electric utility.
Ability to develop a working knowledge of District Departments analytical needs
Strong communication, interpersonal, and facilitation skills
Intermediate MS Office skills, including Word, Excel, Access, PowerPoint, Project, and Visio
Intermediate skills using a Business Intelligence tool
Some experience performing data profiling using a software tool
Intermediate SQL skills
Intermediate knowledge of Data Warehousing concepts
Intermediate knowledge of relational database concepts
Excellent data documentation skills
Intermediate analytical and forecasting skills
Ability to create effective dashboards that tell data stories
Attendance: Consistent need to attend work at the job site or work location. Frequent or constant need for punctuality.
Physical Effort: Frequent periods are spent standing or sitting in the same location with some opportunity to move about; occasionally there may be a requirement to stoop or lift light material or equipment (typically less than 8 lbs.).
Environment: Located in a comfortable indoor area, with occasional requirement to visit an external job site. Any unpleasant conditions would be infrequent and not objectionable.
Hazards: There is occasional exposure to hazards or risk of injury that are generally protected against or predictable.
Sensory Attention: Typically requires regular use of one or more senses of medium intensity and long duration. Position requires color vision.
Job Pressure/Deadline Orientation: Must meet reasonable deadlines, quotas or demands for accuracy and/or may be involved in some mildly unpleasant situations.
APPLICATIONS MAY BE FILED ONLINE AT:
2721 W 10th Avenue
Kennewick, WA 99336
BUSINESS INTELLIGENCE ANALYST I, II, OR III
To apply for this job please visit www.bentonpud.org.