Description
You are energized by solving problems using location-based data. You take pride in enabling critical business processes through timely, accurate, and innovative geospatial services and solutions. You are passionate about sustainable natural resource management. You are a team player but can excel working independently as well. You are approachable, speak both “GIS” and “IT”, and are looking for a company you can grow in.
We are a fast-moving team that manages the enterprise-level GIS platform, applications, data, and services for Weyerhaeuser. GIS is critical to daily operations on Weyerhaeuser’s 11+ million acres of US timberlands. We’re not just in the cloud, we’re implementing technology that will keep us at the forefront of innovation in the forest products and land management industries. This includes transforming access to the company’s GIS assets using web and mobile solutions. If you want to be part of a world-class technology team changing the world we live in – come grow with us!
In this role, you will develop, deploy and administer enterprise SQL databases that are spatially enabled using ESRI’s ArcGIS Server and native spatial data types. One of your primary responsibilities will be the development and maintenance of our spatial data warehouses that serve a critical role to the organization. Collaborating on the design of the next generation of one of those data warehouses will be a top priority on your roadmap. In this wide-ranging role, you will also help to administer our GIS infrastructure in the cloud. A desire to learn new skills in all areas of responsibility will be critical to your success.
Primary Responsibilities

Designs, builds, maintains, and supports GIS solutions and the underlying infrastructure:

• Works with Product Managers, GIS Dev/Analysts and/or Data Scientists to design and implement GIS solutions, including data pipeline solutions
• Applies knowledge of, and skills in, enterprise geodatabases and data warehousing tools to provision, integrate, monitor, and optimize data stores
• Through curiosity and investigation, develops deep understanding of Weyerhaeuser business and how it is represented in GIS data Develops and maintains automated deployment processes that meet strict IT controls
• Diagnoses, troubleshoots, and resolves production data pipeline issues and reverse-engineers existing codebase and database design when necessary to resolve ongoing issues and seek improvements
• Collaborates with other IT engineers and IT architects to ensure that the GIS solutions efficiently and effectively integrate with the broader IT infrastructure
• Partners with vendors and peers in IT to advance the GIS team roadmap
• Work with broader GIS team to develop tools to automate and enhance new and existing processes.

Qualifications

• Bachelor’s degree in Computer Science, Geography, Information Technology or related field, or equivalent experience is required
• Minimum of four (4) to six (6) years of progressive, relevant GIS/IT experience
• Able to apply business knowledge to develop and deliver innovative, value-added improvements
• Excellent oral and written communication skills, skilled in communicating technical topics to non-technical audiences
• Excellent collaboration skills in working together with others across all IT segments
• Proven ability to operate and effectively communicate while under pressure; as well as the ability to manage a diverse workload and work under time constraints with minimal supervision
• Actively working to learn new skills in order to stay current with changing technologies and industry trends, shares knowledge proactively with others

TECHNICAL QUALIFICATIONS

Proficient knowledge of SQL coding and best practices, including:
-
- coding and optimizing programmable objects like stored procedures and functions
- designing, implementing, and materializing views
- writing automation packages for ETL/ELT processes, e.g. SSIS or Azure Data Factory
- performance evaluation with tools like Activity Monitor and SQL Profiler
- performance optimization of database operations
- Proficient knowledge of geospatial data (including vector and raster), RDBMS systems, and enterprise geodatabases
- Functional understanding of geodatabase design and spatial relationships
- General familiarity with python scripting and automation of GIS tasks, preferably with arcpy or the ArcGIS API for Python

Please refer the Job description for details