What are the responsibilities and job description for the Data Engineer II or III position at Benton PUD?
Salary : $91,442.00 - $158,065.00 Annually
Location : Kennewick, WA
Job Type : Full Time, Regular, Exempt
Job Number : 202400019
Department : Information Technology
Opening Date : 10 / 15 / 2024
FLSA : Exempt
Bargaining Unit : N / A
Equal Opportunity Employer / Veterans / Disabled
As of January 1, 2023, Benton PUD will be including a full wage scale or salary range for positions under the salary section shown per the Engrossed Substitute Senate Bill 5761 that amends portions of the Equal Pay and Opportunity Act. Please see the target hiring range for this position under the Position Purpose / Summary section.
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 : This position is only available to candidates who are legally authorized to work in the United States without the need for current or future visa sponsorship. Benton PUD does not sponsor employment visas or employment visa transfers (e.g. H 1B, O-1, TN, etc.).
Ran g e for Data Engineer II :
91,442 to $130,632 Annually (Hiring Target Range $91,442 to $108,860)
Ran g e 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, review SQL explain plans and write database functions as needed to ensure optimal performance and data consistency.
- Recommend Data Architecture and Data standards enhancements and changes by researching technically assigned tasks.
- Ensure the reliability of applications by deploying system changes to production in alignment with the District's approved Configuration Change Management process and department source control procedures. This includes monitoring application performance and availability, as well as troubleshooting and optimizing programs for improved efficiency.
- Collaborate with BI Analysts, Data Engineers, Data Champions, Application Analysts, Specialists, and subject matter experts by leading or supporting the definition and execution of cross-functional data movement processes across all areas of District business.
- Complete special projects and other duties as assigned to meet team, department, and organization goals.
Level III Additional Accountabilities
Minimum Qualifications, Experience and Certifications
Required : Data Engineer II
Data Engineer III
Education Substitutions :
A BA / BS is preferred; however, substitution is allowed for those with an approved job-related certification and at least an AA degree, with two (2) additional years of directly related experience
Preferred :
Prefer recognized certificates in programming languages indicated
Knowledge, Skills and Abilities :
ADA Requirement
Applications may be filed online at : www.bentonpud.org
Questions?
Contact Amber Melling via phone at (509) 585-2291 or email at careers@bentonpud.org
Benton PUD's Total Pay Approach provides a comprehensive package that includes compensation, benefits, retirement plans, and employee development. We have a variety of programs and options to fit your needs, including :
Health and Life Benefits :
Retirement Benefits :
Saving / Spending Accounts :
Health Care Spending Account
Paid Time Off
New Years Day
Other benefits include :
Will you now or in the future require sponsorship for employment visa status (e.g. H-1B visa status)?
What is your highest level of education?
Do you have an AA degree or higher level degree in Computer Science, or a closely related degree program?
How many years of experience do you have working with databases, such as SQL Server or PostgreSQL?
How many years experience do you have working with an Object-oriented programming language?
Describe your skill level in with SQL :
Do you have experience writing Python code for Data Engineering workflows?
Do you have experience working with Data Marts and Data Warehouse technologies and concepts?
Required Question
Salary : $91,442 - $158,065