Job Information
Washington Department of Fish and Wildlife Scientific Data Program Engineer - IT Data Management Journey - Permanent - *00067-25 in Olympia, Washington
*Title- *Scientific Data Program Engineer
Classification- *IT Data Management -- Journey *
Job Status- *Full-Time - Permanent *
WDFW Program- *Information Technology Services *Program
Duty Station- Olympia, Washington -- Thurston County
Learn more about being a member of Team WDFW{target="_blank" rel="noopener noreferrer"}!
This position offers the opportunity to design, deploy, and maintain IT data infrastructure, enhancing the agency's scientific capabilities through efficient and effective data solutions.
Key responsibilities include designing and supporting cloud-based data management systems, configuring and maintaining cloud storage and reporting functions, and providing ongoing support for data management activities.
* *
What to Expect-
Among the varied range of responsibilities held within this role, the Scientific Data Program Engineer will,
*Scientific Data Management Architecture and Design: *
- Coordinate with multiple internal and external stakeholders and user groups to define data requirements, design, normalize, and implement data storage, transformation, analysis, and reporting solutions.
- Design and implement automated data pipelines through scripting, replication, or other means and spanning a variety of environments.
- Design data pipelines for data to move between environments - some environments are within the agency (State Data Center and Cloud Service Provider environments such as AWS and MS Azure), while others are managed by third parties (SaaS/PaaS).
- Design and implement Extract-Transform-Load (ETL) patterns and scripts to migrate data across systems.
- Develop and maintain appropriate database entity relationship (ER) diagrams and metadata. Write documentation to communicate capabilities to less technical user groups.
- Write and maintain documentation related to cloud storage, compute, and CSP services to ensure continuity of operations.
Cloud Storage Administration:
- Design and implement Cloud storage solutions to support Scientific Data Management.
- Deploy and maintain Cloud Storage Infrastructure across multiple Cloud Service Provider (CSP) storage environments (AWS S3 and Azure blob).
- Deploy and manage data cataloging solutions to identify and manage different data sets across CSP environments.
- Collaborate with other IT teams to plan and execute solution deployments and upgrades in the cloud.
- Manage Role Based Access Control (RBAC) provisioning across storage areas.
- Implement and enforce cloud policies and procedures to ensure compliance with industry regulations and company standards (WA State policy, CJIS, PII).
Manage Cloud Services for Data Management:
Design and implement CSP data service solutions to support Scientific Data Management (AWS Athena, Redshift, Sagemaker, Glue).
Create and maintain scripts for the automation and management of service integration across data pipelines.
Design, write, and document extract, transform, and load (ETL) programs and procedures.
Design, deploy, and manage a data management cataloguing solution.
Ensure data validation procedures are complete when data is imported or exported.
Support virtual infrastructure both on prem (State Data Center) as well as CSP provided virtual infrastructure as related to data management pipelines (PostgreSQL and SQL service)