http://weyer.jobs/16204
Location options: Seattle, WA; one of our major Timberlands offices, including Hot Springs, AR; Columbia Falls, MT; Springfield, OR; or fully remote for the right candidate
About Weyerhaeuser
We sustainably manage forests and manufacture products that make the world a better place. We’re serious about safety, driven to achieve excellence, and proud of what we do. With multiple business lines in locations across North America, we offer a range of exciting career opportunities for smart, talented people who are passionate about making a difference. We know you have a choice in your career. We want you to choose us.
Responsibilities
- Develop, maintain and enhance a spatial data warehouse that is sourced from several disparate business systems
- Assist with database architecture and design of Esri enterprise geodatabases
- Create and maintain SQL Server components for extract-transform-load (ETL) processes: SSIS packages, database schema (including native Geometry spatial data types), stored procedures and functions
- Apply understanding of business needs and thorough understanding of business data to produce data products for enterprise use
- Create and maintain CI/CD pipelines to support unit testing and deployment through integration with source control system
- Create and manage schema documentation and other technical artifacts relating to development
- Partner with our DBAs to define and implement database security consistent with enterprise standards, perform database server upgrades, and assist with disaster recovery processes while adhering to documented IT Controls
- Monitor and manage spatial data indexes, database performance, and tuning
- Partner with vendors and peers in IT to advance the GIS team roadmap
