Data & GIS Analyst w/ State of Oregon OLCC (pdx)

https://oregon.wd5.myworkdayjobs.com/SOR_External_Career_Site/job/Portland--OLCC/Information-Systems-Specialist-6--Geographical-Information-Systems--GIS--Analyst----Portland_REQ-71673

Job Description:
The Oregon Liquor and Cannabis Commission (OLCC) is hiring for an Information Systems Specialist 6 (Data and Geographic Information Systems (GIS) Analyst) for the Portland/ Milwaukie location. This is an exciting opportunity to be a part of a state agency that is the third largest generator of state revenue. In this role, you will get to expand and strengthen the way OLCC uses data and GIS tools to make decisions and policies related to the regulation of alcohol and cannabis in Oregon.

We are posting this opportunity as an internal and external recruitment opportunity.  Individuals who currently work for the OLCC will be given preference during the application review process.

Who are we?
The OLCC is the agency responsible for regulating the sale and service of alcoholic beverages, the production and sale of recreational marijuana, the tracking of Oregon Health Authority medical marijuana, and the tracking of industrial hemp products sold in OLCC retail stores. The agency is comprised of three major operational programs; the Distilled Spirits Program, the Marijuana Program, and the Public Safety Program.  All three programs are supported by the Administration, Financial Services, and Support Services divisions.  Revenue generated from these programs helps support state and local government programs.

What will you do?
You will act as the primary support resource for OLCC’s Geographic Information System (GIS) as well as a resource for data extraction and analysis from various OLCC systems. This resource will work with various stakeholders both within and outside the agency in supporting staff with location data, development and maintenance of geodatabases, the development of maps, web-based applications, extraction and analysis of data, and other data needs.

Want to know more?  Here are some of the essential duties you will perform:
Construction

• Creating, planning, managing, and administering GIS activities, application design, and geodatabase development
• Analyzing, updating, performing quality control, and developing methods and procedures to ensure existing GIS data and datasets are accurate
• Utilize various ArcGIS extensions and tools to provide necessary analysis as requested
• Creating, planning, and managing datasets for use in Tableau and other systems, including the development of SQL queries and other methods to extract and clean agency datasets

Operations

• Maintain Enterprise GIS Infrastructure
• Process and ensure completion of GIS data change requests
• Work with department staff to ensure GIS and other data needs are met
• Build and maintain trusted relationships with clients and team members
• Analyze problems, evaluate alternatives, and make sound, well-structured recommendations
• Research new GIS, visualization, and analytic technology to improve GIS and data analysis business process
• Review opportunities to improve GIS and data analysis business process

Customer Service

• Provide technical support to staff related to GIS and SQL
• Mine for opportunities to share ideas and solutions with customers and peers
• Explain Data Management, Data Analysis, and GIS-related technical issues and concepts to non-technical staff
• Prepare and present clear and well-organized written and oral reports to internal departments, executive leadership, clients, and other groups as required
• Communicate effectively and timely with customers and peers

Working Conditions:
The person in this position works in a variety of environments including offices and field offices throughout the state. There is occasional overnight travel for development and conferences.

This person interacts with a wide variety of people, and may encounter stressful situations dealing with angry or upset individuals, and is expected to treat users and all staff with dignity and respect.

What do you need to qualify?

• Five (5) years of information systems experience in: ArcGIS, OR;
• An Associate's degree in Computer Science, Information Technology, or related field, OR;
• Completion of a two (2) year accredited vocational training program in information technology or related field; AND Three (3) years of information systems experience in: ArcGIS, OR;
• A Bachelor's degree in Information Technology, Computer Science, or related field AND; One (1) year of information systems experience in: ArcGIS.

The State of Oregon is requiring all executive branch employees to complete their COVID-19 vaccination series by October 18, 2021 or six weeks after FDA approval of the vaccines, whichever is later, unless the employee receives a medical or religious exemption/accommodation. New employees must submit vaccination documentation or be approved for an exemption/accommodation before beginning work. For more information, visit https://www.oregon.gov/gov/Documents/executive_orders/eo_21-29.pdf

Strongly preferred skills we would like for you to have?

• Proficiency in Python and SQL