Software and Data Developer (Information Systems Specialist 7) page is loaded
Initial Posting Date:
12/27/2023Application Deadline:
01/08/2024Agency:
Oregon Liquor & Cannabis CommissionSalary Range:
$6,261 - $9,460Position Type:
EmployeePosition Title:
Software and Data Developer (Information Systems Specialist 7)Job Description:
The Oregon Liquor and Cannabis Commission (OLCC) is recruiting for multiple permanent, full-time Software and Data Developer (Information Systems Specialist 7) positions within our Information Services Division.
This position is responsible for designing, developing, and maintaining software applications while actively engaging in data-related tasks, including data analysis, integration, and database management. This position also ensures all legacy application updates are documented and traceable, including interfaces. Develops database administration standards and processes, including change control, to inform Agency's SDLC process. Participates in division strategic planning and prioritization based on analysis and research performed with business subject matter experts.
While this recruitment is an internal and external opportunity, internal OLCC applicants 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 in Oregon by administering the state's Liquor Control Act and regulating the production, processing, and sale of recreational marijuana in Oregon through the Control, Regulation and Taxation of Marijuana and Industrial Hemp Act.
The agency is comprised of three major operational programs; the Distilled Spirits Program, the Recreational 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. The OLCC distributed more than $600.4 million in the last two years to Oregon’s General Fund, Cities, Counties, and Drug/Alcohol Abuse Programs. This money helps fund essential services such as schools, police, and healthcare for Oregonians.
The Distilled Spirits Program oversees the distribution and sale of distilled spirits in the state. The Distilled Spirits division centrally purchases, warehouses, and distributes distilled spirits to Oregon’s independently operated liquor stores. OLCC’s Public Safety Program licenses and regulates businesses in the alcohol industry such as manufacturers, wholesalers, bars, restaurants, grocery, and convenience stores.
The Recreational Marijuana Program is exclusively authorized to make recreational marijuana available to consumers and licensed businesses through retail marijuana stores. The program also tracks the growing, transporting, processing, and selling of recreational marijuana products. The Public Safety Program is responsible for licensing and regulating the operation of the recreational marijuana industry in Oregon .
The following list represents the general responsibilities of the Software and Data Developer.
Provides expert-level guidance into decision making for change requests to the agency’s change control board and technical problem escalation for business continuity issues affecting mission critical operations or interfaces with state or national business partners.
Provides mentoring, advice, and guidance on tasks to peer system support staff as needed on projects for which this position is the lead. Provides instructions for development staff to program or implement the design of the data system components (database tables, database views, screens, application program interfaces [APIs], batch programs, reports, other output).
Completes overall system upgrades and codes extensions to software. Performs system testing/validation on change requests or updates (new and modified code) prior to deployment, unit testing to ensure requirements are met and changed code works as specified, and logical and physical data modeling and designs relational databases.
Implement logging mechanisms to capture and store relevant application data for debugging and analysis and security measures to protect sensitive data within the application. Ensure compliance with data protection regulations and industry standards. Implement features for generating reports and analytics within the application. Integrate with external analytics tools or develop in-house reporting solutions.
Problem solving for projects that involve a high level of coordination where there may be conflicting code and/or data sets or a variety of customers including other state agencies or external partners.
Diagnoses user problems on an ongoing basis, prioritizing systems that are the most complex and critical to the state (such as finance, distribution center, licensing and compliance). Problem solving requires a high level of coordination with other IT staff and sometimes vendors.
Reviews and evaluates programming assignments to provide accurate estimates of effort and to determine realistic timeframes for assignment completion that will be included in a work breakdown structure for project planning.
Analyzes reports and feedback from build and quality control systems to reduce build errors and software defects. Provides expert-level input and recommendations to IT prioritization meetings for strategic planning of IT projects, change requests, and continuous maturity initiatives.
Analyzes, designs, and develops enhancements or corrections to existing agency application software. Analyzes and designs data system components (database tables, database views, screens, application program interfaces [APIs], batch programs, reports, other output) and how they will interface with each other.
Researches, designs, develops, and documents software build systems, version control systems, as well as manual and automated quality control systems for software. Manage data versioning and implement data migration strategies. Update code change analysis documentation. Including updated application code including modifications per the accepted technical and design documents, updated applications from merged code sets and Technical Specifications documentation for internal development applications.
Creates application software designs and models (e.g. UML, ERD) according to agency business requirements, specifications, and standards. Create data models that represent the structure and relationships within the application's data. Creates and maintains comprehensive documentation which includes code repository, release notes, dependencies, design documentation, database schemas, data flows, and integration points and test plans/scripts.
Creates source code tests at various levels and using appropriate concepts and technologies as required on per-application basis, including - but not limited to - unit, integration and performance tests using testing libraries, automated test runners and test/mock objects.
Develops division standards and procedures. Routinely checks version, build and quality control systems to ensure adherence. Develops and designs data conversion strategies. Defines and develops qualitative testing standards for application software designs and code to decrease instances of error and functional gaps.
Establishes controls and creates security measures for newly implemented applications. Establishes monitoring systems to track application performance and user behavior.
Designs logic for, writes, and tests computer program code to construct data system components that perform efficiently and produce desired results for various sized data systems. Designs, develops, and tests database architecture and objects associated with application development and maintenance.
Facilitate with the business liaison and other IT leaders as appropriate to set and manage requirements and compliance needs across the application lifecycle; and establish processes, procedures, and methodologies to manage and control development, testing, and maintenance activities as it pertains to assigned business area applications.
Participates in vendor selection/assessment through the Request for Proposal (RFP), Request for Quote (RFQ) evaluations and preparation of materials.
What do you need to qualify? Minimum Qualifications:
Six (6) years of information systems experience in software and data development;
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
four (4) years of information systems experience in software and data development;
OR
A Bachelor's degree in Information Technology, Computer Science, or related field
AND
two (2) years of information systems experience in software and data development;
OR
Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.
What we are looking for: Your application should clearly demonstrate these preferred skills and desired attributes.
Preferred skills:
Knowledge of data visualization tools such as Tableau or PowerBI
Experience in software programming, .Net/Blazor stack development, Python/Java development, Data analytics/ Data science.
Desired attributes:
Highly motivated, self-learner, and technically inquisitive
Demonstrated experience with large-scale complex technical architectures that include interfaces with other large-scale systems.
Demonstrated knowledge with logging of communication between large-scale systems.
Demonstrated knowledge in data migration, interfacing systems, and synchronization of records; this should specifically include experience developing and testing web services across multiple platforms.
Demonstrated experience working independently with minimal supervision and direction.
Demonstrated experience developing analysis and design documentation necessary for the construction, testing and implementation of identified tasks to be completed.
Note: You must clearly describe your experience in each area listed. Failure to provide this information may result in eliminating your application from further consideration.
How are candidates selected?
The selection process consists of a review of your application and an evaluation of your education, experience, training, and overall professionalism of your application materials. Candidates that follow the application directions, submit what is required and provide us with credentials that showcase their skills and how they meet the minimum qualifications and desired attributes will be invited to an interview. Resumes will not replace the completed job history experience in Workday. We will only review documents that are requested. Because details are really important to us, your application materials will be evaluated for grammar, spelling and punctuation.
What's in it for you?
Medical, vision, and dental insurance.
11 paid holidays per year.
8 hours of vacation leave earned per month, eligible to be used after 6 months of service.
8 hours of sick leave earned per month, eligible to be used as accrued.
24 hours of personal business leave per fiscal year, eligible to be used after 6 months of service.
Pension and retirement programs.
Click here to learn more about State of Oregon benefits.
A workplace that fosters fairness, equity, and inclusion to maintain a workplace environment where everyone is treated with respect and dignity.
A healthy work/life balance, with opportunities for hybrid remote work.
How to Apply:
Internal Applicants (Current State of Oregon Employee) – MUST apply through your employee Workday account. Please update your profile with current job history and education. In Workday, click on the Career application link, View Internal-Find Jobs, Find the position and select Apply.
External Applicants – Please visit the State of Oregon job opportunities webpage to submit your application for the position.
Workday does not pull your work history from your profile; you MUST list your current work experience on your application for it to be considered. A resume will not substitute for completing the work experience section of your application.
The work history and/or education section of your application must clearly demonstrate how you meet all the minimum qualifications and desired attributes listed above .
Upload and attach your resume in addition to completing your job history and education details in Workday.
Want to Know More? Here’s some additional information:
Remote work: This position is eligible for a flexible remote work schedule, and you will be required to come into the office as needed. Remote work is evaluated periodically to ensure business needs are being met and can be adjusted at any time. Please visit the state’s Work Reimagined website for more information.
The salary listed is the non-Public Employee Retirement Systems (PERS) qualifying salary. If the successful candidate is PERS qualifying, the salary will reflect the 6.95% increase .
This position requires a background and security check with fingerprinting to work in areas that handle confidential documents. An adverse background and failed security clearance will result in disqualification.
This position will be represented by the American Federation of State, County & Municipal Employees Union, Local 2505.
This position serves a six-month trial service period.
Applicants must be authorized to work in the United States. Applicants who require VISA sponsorship will not be considered at this time.
Within three days of hire, all applicants will be required to complete the US Department of Justice Form I-9, confirming authorization to work in the United States. OLCC uses E-Verify to confirm that applicants are authorized to work in the United States.
Please save a copy of this job announcement for your reference, as it may not be available for you to view after the job closes.
Helpful Tips:
Be sure to attach a resume . Note: Applicants who don’t attach the required documents or fail to complete the “Work History” section of the application may be automatically disqualified from further consideration . If you are concerned that the requested documents weren’t attached to your application, please email a copy to corie.shelley@oregon.gov . Material will be associated on your behalf if received before the posting deadline.
Allow yourself plenty of time to complete and submit the application process.
Workday will timeout after 20 minutes of inactivity.
This posting closes at 11:59 PM on the close date listed.
Be sure to check both your email and Workday account for updates regarding this recruitment.
Workday performs best in Google Chrome.
Click here for Resources and a Job Support Page .
Veteran's Preference:
The OLCC provides veterans’ preference points to all eligible veterans. For privacy reasons, please do not attach veterans’ preference documents when initially applying. You will be sent a Workday “Task” to complete once you have submitted your application. The “Task” will prompt you to provide the appropriate documentation for your Veterans’ Preference point selection. For more information, please go here: .
After you apply:
Log in to your Workday account before the job announcement closes to see if you have any pending tasks or actions, and make sure to complete these tasks or actions before the job announcement closes. These can be found under the “My Applications” section.
Questions/Need Help?
If you have questions about the recruitment or need assistance, please contact OLCC HR Recruiter, Corie Shelley by email at Corie.Shelley@oregon.gov.
THE OREGON LIQUOR & CANNABIS COMMISSION IS AN EQUAL OPPORTUNITY, AFFIRMATIVE ACTION EMPLOYER COMMITTED TO WORK FORCE DIVERSITY
...contract close-outOverall responsibility for project execution, ensuring that the project is delivered within contract requirements and Tesla standards of quality and safetySupports selection of partners and suppliersPromote a safe and quality driven culture, both project...
...professionalism, quick turnaround time, and constant communication with our customers. We are in need of an experienced, licensed auto appraiser in the Albany, NY area. This is a hybrid / remote position. Earning Potential : $60,000 - $100,000 per year Requirements:...
...Delivery Driver Job Description - Appliance & Furniture RentAll Part-Time As a Delivery Associate at Appliance & Furniture RentAll, you will be an essential part of our team, ensuring the smooth and timely delivery of appliances and furniture to our valued customers...
...Telecommuting Options: Onsite Work Location: USA MD Annapolis Junction Additional Work Locations: Total Rewards at GDIT: Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts,...
...guidelines. KEY SKILLS/RESPONSIBILITIES Guest Service & Hospitality: Provide a warm, friendly, and professional dining experience... ...a thing or two about hosting spectacular meetings and events. Application deadline for Colorado positions: Aimbridge Hospitality