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 the Washington 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 promote Diversity, 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 as, Rainbow Alliance and Inclusion Network; Veteran Employee Resource Group; Latino Leadership Network, Blacks 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; and Interagency Committee of State Employed Women. 

The Washington State Liquor and Cannabis Board's (WSLCB) Information Technology Services Department (ITSD) is announcing an exciting opportunity for a Salesforce (IT Application Development - Journey) position in Olympia, WA. This position is located within the Salesforce Team which 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 WSLCB’s 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 employee’s 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:

• Bachelor’s 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 agency’s 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.