Job Information
Benton PUD Data Engineer II or III - Hybrid in Kennewick, Washington
Position Purpose/Summary
Benton PUD is seeking an experienced, highly analytical and creative applicant with strong data skills that complement their development skills. This position will have the opportunity to design and build data workflows that support the vision of transforming critical information into actionable business insights using Python with data engineering libraries, an orchestration tool like Apache Airflow, database tools, and 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 strong SQL skills complemented with programming and database experience. The candidate should have data project experience and have a passion for working with data. This position is located in Kennewick, WA and the successful candidate will have to be on-site at the Kennewick office.
The successful candidate will be placed appropriate to their education, experience and ability to perform the specific position accountabilities. Please note that Benton PUD does not sponsor H1-B Visas or H1-B Visa Transfers.
Range for Data Engineer II: $91,442 to $130,632 Annually (Hiring Target Range $91,442 to $108,860) Range for Data Engineer III: $110,646 to $158,065 Annually (Hiring Target Range $110,646 to $131,721)
The primary purpose of this position is to create optimized data flows using both current and future data architecture to deliver data solutions and visualizations. The Data Engineer will collaborate with the Manager of Data & Analytics, fellow Data Engineers, BI Analysts, and department data champions to meet data needs and fulfill use case requirements for visualizations. This position is also responsible for designing, building, and maintaining data engineering workflows that efficiently move and transform data into data marts within our Data Warehouse. In addition, the role will contribute to the ongoing development of data architecture and standards, as well as researching and recommending new tools and techniques to continually improve our data processes.
Accountabilities
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.
Create data flows by sourcing data from multiple disparate sources using Python with data engineering libraries, SQL, and APIs. This includes understanding and working with structured and semi-structured data formats such as JSON and XML.
Support design solutions by utilizing data tools for data profiling and data mining.
Support the enterprise data analytics architecture by performing management, administration, upgrades, troubleshooting and resolving issues.
Support the District's database environments by performing all required database administration tasks.
Support the District BI platform by designing, building and deploying Data visualization solutions, managing security, scheduling extracts, subscriptions and alerts as well as performing any other duties required to manage the BI Server application.
Ensure that data engineering workflows are thoroughly tested by implementing reliable error/exception handling and rollback mechanisms. Perform unit testing, system integration testing, and assist with user acceptance testing to ensure data integrity and process reliability.
Maintain data integrity and quality by developing robust data workflows, establishing and enforcing data standards, and creating data dictionaries, diagrams, and entity-relationship models. This includes generating reports, creating schedules, defining work processes, and developing maintenance procedures. Additionally, re
