The Washington State Department of Ecology is looking to solve the problem of transforming how data is used across the agency by hiring a Data Engineer to identify business requirements, design and implement robust data storage solutions, and develop processing pipelines.
Requirements
- SQL programming, experience with entity relationship modeling and notation, or database report development.
- Experience with data extraction and transformation (e.g. ETL).
- Knowledge of versioning control and automated deployment tools.
- Knowledge of Azure Cloud development.
- Data Engineer Certificate (AWS or Azure).
- Ability to distill end-user requirements into a data management or technology solution which is centered primarily on Microsoft technologies.
- Knowledge of Geographical Information System (GIS).
Responsibilities
- Develop and maintain data pipelines so that data is delivered securely, reliably, and consistently to support analytics, reporting, and decision making.
- Execute ETL/ELT operations to efficiently deliver data to centralized repositories supporting enterprise data accessibility and trust.
- Design, develop, and maintain scalable storage solutions and tools that can be used for data warehousing, analytics, and reporting.
- Integrate data quality and integrity into transformation workflows to enable trusted operational use.
- Provide technical support and consultation on data engineering best practices to agency teams, ensuring that data solutions are robust, scalable, and future-oriented to provide continuity and high value.
- Create and maintain thorough technical documentation and metadata, making data systems well-documented, transferable, and sustainable across changes in technology and personnel.
- Support statewide coordination and data governance efforts to share and collaborate on innovations and align with WaTech and agency standards.
Other
- Must live within a commutable distance from the duty station.
- May telework most of your work time with occasional in-person meetings and activities.
- Must have a college degree involving a major study in computer science, information technology (IT), science, technology, engineering, mathematics (STEM), or closely related field.
- Must have 7 years of experience and/or education as described.
- Must be able to work a flexible schedule.
