Salesforce (IT Application Development Journey)

WSLCB Vision
Safe communities for Washington State.

Mission
Promote public safety public health and trust through fair administration education and enforcement of liquor tobacco cannabis and vapor laws.

This position is currently eligible to telework.This position is expected to work in the office up to 2 days a week there is some flexibility with this requirement.

Who we are

The mission of theWashington State Liquor and Cannabis Board(WSLCB) is to promote public safety public health and trust through fair administration education and enforcement of liquor cannabis tobacco and vapor laws. We search for people who demonstrate a strong work ethic excellence in customer service partnering and teamwork and quality performance.

We want to create a culture that fosters excellence in customer service open and honest communication transparency and accountability data-driven decisions and business-initiated process improvement.

Our commitment to DEIB

The WSLCB strives to promoteDiversity Equity Inclusion and Belonging (DEIB)in all aspects of our work. This includes a commitment to our workforce and external stakeholders. It is our mission to build educate and inspire an inclusive environment that recognizes respects and celebrates diversity in the workplace and in the community we serve. We are committed to maintaining a thriving culture where employees and those we serve feel safe and accepted regardless of education background or beliefs. As a WSLCB team member you will have opportunity to join statewide business resource groups (BRGs) such asRainbow Alliance and Inclusion Network;Veteran Employee Resource Group;Latino Leadership NetworkBlacks United in Leadership and Diversity;Disability Inclusion Network;Washington Immigrant Network;Hawaiians Asians and Pacific Islanders Promoting an Empowerment Network;Supporting our Voices Empowering Rights and Engaging Indigenous Governance;andInteragency Committee of State Employed Women.

The Washington State Liquor and Cannabis Boards (WSLCB) Information Technology Services Department (ITSD) is announcing an exciting opportunity for a Salesforce (IT Application Development - Journey)position inOlympia WA.This position is located within the Salesforce Teamwhich serves to define business technical needs design develop and maintain software solutions for WSLCB that are innovative secure and meet IT industry standards. The Salesforce team consists of the WSLCBs salesforce developers system administrators and business analysts. This journey application/Salesforce developer reports to salesforce team supervisor and under general direction.

This is journey-level technical application integration and data development position that is responsible for design development enhancement and maintenance of multiple enterprise applications including all inter-system and inter-agency interactions. The position is responsible with creating and ensuring the requirements and documentation standards within the WSLCB are adhered to. This position provides expert level technical services by designing testing implementing and maintaining multi- dimensional information systems used to issue licenses to produce distribute and sell beer wine spirits vapor products cannabis and tobacco in the State of Washington; and tools to support the compliance services including education audits investigations and public records. These systems provide manage monitor and assess data required to make informed decisions at enterprise division and business unit level for large and highly complex development efforts consisting of multiple applications consisting of various coding languages and integrations. This position works with highly visible systems that have agency-wide (all divisions) statewide and multi-agency impact; providing integration of WSCLB custom Software-as-a-Service (SaaS) and WSLCB Commercial Off the Shelf (COTS) solutions and custom configured and coded solutions on Platform-as-a-Service (PaaS) for internal and cross-enterprise systems.

WSLCB provides a modern work environment and excellent benefits including:

• A comprehensivebenefits package(including but not limited to Medical/Dental/Vision Long Term Disability Life Insurance etc.)
• PaidVacation Leave and Holidays
• Tuition Waiver(enrollment in courses at state universities/colleges on a space availability basis - all or a portion of the tuition/fees may be waived for state employees)
• Tuition reimbursement (courses taken with prior approval in order to further employees career development with the WSLCB)
• Training and career development programs (including online courses and LinkedIn Learning)
• A healthy work/life balance (this may include flexible/alternative work schedules and telework/remote work opportunities when possible)
• Employee Assistance Program- a confidential program created to promote the health safety and well-being of public service employees
• Generous wellness program (we offer reimbursements for certain fitness related activities)
• Onsite exercise facility (for employees working at WSLCB Headquarters Building in Olympia)
• Infants at Work Program to promote parent and infant bonding parental well-being and healthy infant development. Depending on your job duties work location and supervisor approval eligible employees who are new mothers fathers or legal guardians can bring their infant (six weeks to six months) when they return to work.
• Free parking

Some of the duties you will perform are:

• Develop detailed comprehensive and well-structured application architected designs to assure quality efficient and secure complex software systems and databases for staff other agencies and the public to consume daily weekly monthly and yearly work.
• Develop complex user intuitive ADA compliance and secure web user-interfaces which includes secure architecture design coding unit tests function tests system tests and implementation.
• Write code to enhance improve logging reporting and security of COTS PaaS and SaaS solutions.
• Use industry best practices to optimize custom and COTS/SaaS solutions and report data query performance
• Optimize data models for PowerBI and write custom ETL solutions to extract transform data and load into WSLCB Salesforce system and various interfaces for internal and external agency use.
• Verify and validate successful code migration and implementation including code review of Commercial off the Shelf (COTS) systems.
• Coordinate with COTS PaaS and SaaS vendors application administrators and technical staff on defining technical integration logging reporting and security requirements implementing upgrades enhancements and security patches.
• Provide system analysis consult and support system failures of small to complex information systems independently.
• Architect application components APIs and web services for re-usable code
• Develop review and approve code modification of fellow developers before migration into user acceptance testing and into production.
• Plan design document review and write code to create enhance or fix application components.
• Using Cloud ETL services to build integration with Custom-Off the Shelf (COTS) Software-as-a-Service (SaaS) software and Platform-as-a-Service(PaaS) services
• Maintain System documentation and Security & Coding Standards:
  • Write and update technical specifications
  • Write and update release notes and support plans.
  • Update and develop project plans.
  • Develop implementation plans.
  • Develop system diagrams.
  • Review logs for production problems/incident tracking.
  • Develop job documentation.
  • Create batch schedules.
  • Develop contingency plans risk/assessment.
  • Create issue papers.
  • Create quality assurance reports and findings.
• Stay current with new/emerging technologies and/or systems.
• Stay current with professional certifications as required by position.
• Participate in required and other job-related training.
• Remain current with RCW WAC changes and new laws policies etc. that are applicable to job duties.
• Provide cross-training to fellow team members.

Required Qualifications:

Experience for required qualifications can be gained through various combinations of formal professional employment and educational experience. See below for how you may qualify.

You need at least 3 or more years of working level knowledge and experience in the following:

• In software development languages and MVC frameworks.
• In HTML5 CSS JavaScript.
• Demonstrable knowledge of platform authentication patterns (SAML SSO OAuth).
• Demonstrable extensive knowledge of platform security capabilities (eg. TLS SSL).
• In scripting languages and data management. (eg. SOQL SOSL T-SQL Azure cloud services data management database architecture ETLs data profiling data modeling and data conversions especially in conversion to the Salesforce platform.)
• In data reporting tools At least 1 year using Microsoft or Salesforce reporting tools.
• Knowledge of data integration tools and experience integrating solutions with different business systems.
• In building and maintaining multiple application complex web based application techniques including version control automated testing and continuous integration.
• In comparing benefits and limitations of open source software vendor developed software.
• Maintaining RESTful web services (eg. Apex SQL SOQL and Python or other Azure compatible language to build WebAPI).
• In taking business requirements to analyze and design develop test normalize install and implement agency datasets. (eg. writing T-SQL for create schemas stored procedures views Azure Synapse and/or Data Factory driven ETLs (extract data from one source (database API File etc.) transform the data per business rules and load into a different source (database API File).
• In developing and implementing data mining and use of data definition language.
• In evaluating software quality and applicability in testing software capabilities.
• In using evaluation software for validating software APIs performance and ADA compatibility.
• Demonstrable knowledge of developing system estimates for new software solutions full or partial software solution replacements and upgrading software solutions.
• Demonstrable knowledge of COTS/SaaS/PaaS software and ability to provide integration and security requirements for RFIs and RFPs.
• In working in an environment where IT security best practices policies and procedures are required and audited with having responsibility for enforcing and administering the policies and procedures.
• Demonstrable knowledge of SDLC (Software Development Life Cycle) and Agile development methodology.
• Demonstrable knowledge of skills in unit testing requirements testing user testing load testing functional performance/load testing and regression testing.
• Demonstrable knowledge of workload management skills -plan and organize assignments to create timely accurate work products. Work efficiently remain focused and handle interruptions effectively.
• Demonstrating working-level customer service skills - build and maintain customer relations and satisfaction.
• Knowledge of business and management principles involved in planning resource allocation leadership techniques production methods and coordination of people and resources.
• In research skills and problem solving collect synthesize and evaluate information.
• Experience with systems security skill - knowledge of systems security issues.
• Experience with application systems operation infrastructure and performance skill.
• Experience with systems integration skill in application development.
• Experience with technical consulting skills provide long term strategic and change management consultation.

Preferred/Desired Qualifications:

• Bachelors degree from an accredited college or university with major coursework in data science information technology web development computer science or related field.

• 3 or more years experience in and demonstrable knowledge of directly working with the Salesforce product suite including Sales Service and Experience Clouds as a Salesforce developer and administrator.

• 3 or more years experience in and demonstrable knowledge and experience in all current Salesforce development languages including Apex VisualForce Lightning SOQL/SOSL and Omniscript.

• Knowledge of Cloud Architecture and recent experience developing using PaaS SaaS IaaS with focus on scalability security and integration challenges.

• Current Salesforce Developer Certification.

• Recent experience in building Salesforce Lightning applications.

• Experience with VSCode Git and Salesforce (SFDX) deployment life cycle.

Required Equity Competencies:

The ability to take action to learn and grow

This equity competency identifies people who are curious about themselves and others who take responsibility for knowing their own strengths and weaknesses and who use their learning to make government programs and processes more efficient and effective to serve all in Washington.

The ability to take action to meet the needs of others

This equity competency identifies people who are flexible adaptable customer-service focused and willing and able to empathetically respond to the unique needs of the people they work with and serve.

Competencies:

Accountability: Accept personal responsibility for the quality and timeliness necessary to achieve excellent results. With little oversight; develop innovative solutions to a variety of issues. Make timely decisions although faced with limited data or resources. Accept own role when expectations are not met and respond quickly to resolve issues with others.

Build and Maintain Relationships: Earn the trust respect and confidence of coworkers and customers through consistent honesty and professionalism in all interactions. Build and maintain working relationships characterized by mutual acceptance and cooperation. Contribute to an environment that honors diversity and uses diverse perspectives to meet the agencys mission and goals.

Effective Communications General: Convey clear timely persuasive messages that positively influence the thoughts and actions of others. Effectively express ideas and information through the written and spoken word using language that is appropriate to both the complexity of the topic and the knowledge and understanding of the reader or audience (plain talk). Keeps supervisor and co-workers informed while sharing complete and accurate information with others to include staff and people outside the organization. Practices active listening by concentrating on person or caller; listens without interrupting; and asks questions to clarify and verify information.

Effective Communications Writing Skills: Composes clear straightforward and technically correct documents. Proofreads and edits information to improve clarity organization content and correcting errors in grammar punctuation and spelling. Independently compose written responses to emails and letters from customers answering questions providing information and/or explaining decisions made regarding eligibility for services or compliance with rules. Extract and compile data to prepare narrative statistical or other reports for review analysis documentation etc (e.g. financial payroll labor distribution purchasing inventory registration patient or student information)

LEAN: Actively pursue opportunities for problem solving and continuous process improvement participate in team huddles and promote program priorities and results.

Serving Customers: Build and maintain internal and external customer satisfaction with the products and services offered by the Liquor Control Board develop innovative ideas that provide solutions to our customers challenges.

Safety: Understand and follow agency safety policies and other standards established to maintain a safe work environment. Carefully organize your personal workspace to minimize the likelihood of accidents. Report all injuries accidents or hazards to your supervisor immediately.

Adaptability: Demonstrates flexibility in the face of change. Projects a positive demeanor regardless of changes in working conditions. Shows the ability to manage multiple conflicting priorities without loss of composure.

Analysis: Use data and information in a clear and rational thought process to assess and understand issues evaluate options form accurate conclusions and make decisions.

Judgment:Exhibits sound judgment and the ability to make reasonable decisions in the absence of direction. Swiftly refers problems/issues to the appropriate person(s) when necessary. Works effectively without constant and direct supervision or guidance.

Consulting: Employ expertise credibility and effective partnering to help clients identify evaluate and resolve complex or sensitive issues problems and service needs.

Administration and Management: Knowledge of business and management principles involved in strategic planning resource allocation human resources modeling leadership technique production methods and coordination of people and resources.

Computers and Electronics: Knowledge of electronic equipment computer hardware and software including applications programming and databases. Demonstrates advanced proficiency by quickly adapting to new technology and easily acquiring new technical skills.

Software Development: Knowledge of WebAPI REST C# .NET MVC Entity Framework HTML5 AngularJS JavaScript and T-SQL TFS Git SSIS and ability to grow skillset to match industry standards.

Program Management: Effectively direct and integrate all aspects of a project or program ensuring that work progresses toward achieving goals and objectives.

Research Skills: gather information: Can create data gathering processes; can propose/formulate new processes; able to design new organizational systems; can validate appropriateness of data/information; can logically defend outcomes/results; can analyze and evaluate the accuracy of data; can integrate multiple items of data; contrasts conflicting data; can identify and organize documents and information in ways that make it useful for subsequent applications.

Stress Tolerance: Effectively handle highly stressful or adverse situations making good decisions working calmly and accurately and helping to calm others.

Tact & Diplomacy: Respond to difficult stressful or sensitive interpersonal situations in ways that reduce or minimize potential conflict and maintains good working relationships among internal and external customers.

Workload Management: Effectively organize multiple assignments sometimes of a complex nature or involving competing priorities to produce work products that are accurate thorough and on time.

Personnel Management: Assesses current and future staffing needs based on organizational goals and budget realities. Using merit principles ensures staff are appropriately selected developed utilized appraised and rewarded; takes corrective/disciplinary action when necessary.

Administration and Management: Knowledge of business and management principles involved in strategic planning resource allocation human resources modeling leadership technique production methods and coordination of people and resources.

1. Completed online application.
2. Current Resume.
3. Letter of Interest describing how you meet the specific qualifications for the position.
4. Three professional references to include a current or recent supervisor with email addresses and phone numbers.