Salesforce (IT Application Development - Journey)

id="details-info" class="tab-pane active fr-view" style="margin:2px"> Description 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 recruitment is open until filled.

First review of applications will be August 17 th, please submit an application on or before August 16th . The hiring authority reserves the right and may exercise the option to make a hiring decision at any time. We encourage all to apply as early as possible.

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 .

Your opportunity at a glance 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.

If you have an interest in working independently in a position where you balance multiple testing activities as well as collaborate with cross-agency, cross-divisional, and cross-disciplinary teams involved in the application development process to ensure that systems meet business requirements and technical design specifications with a focus on process improvement, we encourage you to apply to be a part of the WSLCB team!

WSLCB provides a modern work environment and excellent benefits including: A comprehensive benefits package (including but not limited to Medical/Dental/Vision, Long Term Disability, Life Insurance etc.) Paid Vacation, 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 Duties 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.

Qualifications 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. OR At least 1 year as an entry-level Salesforce developer or equivalent.

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. Independe