Salary : $91,442.00 - $158,065.00 Annually
Location : Kennewick, WA
Job Type: Full Time, Regular, Exempt
Job Number:
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
• Lead the creation of 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.
• Lead design solutions by utilizing data tools for data profiling and data mining.
• Guide and mentor 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.
Minimum Qualifications, Experience and Certifications
Required:
Data Engineer II
• BA/BS in Computer Science or related area
• Three (3) to four (4) years' experience with a working knowledge of databases (preferred SQL Server)
• Three (3) to four (4) years programming experience with related technology such as ETL development, Object-oriented programming language, web services development and SQL skills. Data Engineer III
• BA/BS in Computer Science or related area
• Five (5) to seven (7) years' experience with a working knowledge of databases (preferred SQL Server)
• Five (5) to seven (7) years programming experience with related technology such as ETL development, Object-oriented programming language, web services development and SQL skills. 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:
• Advanced skills in two or more of the following: Python, SQL, object-oriented programming languages, or data engineering using Python-supported libraries
• Understanding and experience with SQL Server
• Basic database administration duties and ability to provide support coverage
• Working knowledge of Data Marts and Data Warehouse technologies and concepts
• Working knowledge of Windows and Linux server environments
• Advanced skills in using web services and APIs to retrieve and integrate data, with in-depth knowledge of JSON, XML, REST, and/or SOAP
• Experience building data workflows using orchestration tools such as Apache Airflow
• Advanced skills and experience with writing complex SQL for data analytics
• Advanced skills in database functions or procedures and scripting languages
• Perform data documentation
• Ability to collaboratively debug and trace program execution
• Ability to stay informed on new technologies and to apply training and experience to solve business problems
• Proficiency in system analysis, programming, and iterative application design
• Experience in creating and executing test plans in a continuous integration environment
• Experience with code version control in a collaborative Agile environment
• Troubleshooting skills including using multiple resources to search for problem resolution
• Ability to manage multiple priorities ADA Requirement
• Attendance: Consistent need to attend work at the job site or work location. Frequent or constant need for punctuality.
• Physical Effort: Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
• Environment: Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
• Hazards: Most of the time is spent in general office or equivalent conditions.
• . click apply for full job details
Date Posted: 21 January 2025
Apply for this Job