Data Management (IT Data Management - Senior/Specialist)

Full Job Description

WSLCB Vision
Safe communities for Washington State

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

This recruitment is open until filled. First review of applications will be February 25th, please submit an application on or before February 24th.

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 will be required to work in the office at least 1 day per week. This may change based on business needs.

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 and 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 WSLCB Information Technology Services Division is announcing an exciting opportunity for Data Management Specialist (IT Data Management –Senior/Specialist) in Olympia, WA.

This position reports to the LEEADS and Data Analytics Services Manager in the WSLCB's Information Technology Services Division (ITSD).

In this role, you will work collaboratively with cross-functional teams to support the governance framework necessary for creating, testing, and maintaining complex database systems for the agency including reviewing other technical team member designs for compliance and efficiency.

You will develop data solutions that meet access, security, and quality controls required to ensure the highest level of data accuracy, integrity, and fidelity.

You will also build and maintain reports through custom and BI solutions.

In addition, this position includes the responsibilities of a database developer by taking business requirements to analyze and design, develop, test, normalize, install, and implement agency databases and data interfaces, including writing scripts for automated backups, replication and ETL processes.

If you have an interest in providing technical leadership and strategic direction for the technologies, standards, processes, and architectures for the Agency enterprise data analytics hub, we encourage you to apply to be a part of the WLSCB 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 - 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 Headquarter 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

Requirements

Some of the duties you will perform are:

Lead definition and monitoring of key data to agreed standards and quality (business and regulatory needs).Schedule, convene, and lead joint Data Management working group and report to Council.Develop and maintain Data Management policies and strategy.Establish clear and agreed quality metrics and measurement processes.Define profiling, cleansing, and standardization processes.Create and maintain current and future state data architectures.Define and manage standards, guidelines, and processes to ensure data quality.Oversee end-to-end data life cycle management activities.Work with IT teams, business analysis and data analysis teams to understand data consumption needs and develop solutions.Effectively mentor, train, coach, counsel, and motivate junior developers, system administrators and other technical staff to achieve consistently high performance.

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.Deploy code in accordance with WSLCB deployment release strategy.Ensure that all data objects required by the database(s) are accurately defined and represented at the level warranted based on data model type.Define entities, their attributes, and their relationships for all conceptual data models.Define exact datatypes, lengths assigned and default values for all logical data models.Normalize the data to the third normal form (3NF) for all logical data models.

Define the relational tables, primary and foreign keys, and stored procedures for all physical data models.Address cardinality and nullability of relationships between tables for all physical data models.Define views, indexes, access profiles, and authorizations for all physical data models.Identify missing and redundant data and leverage data modeling best practices to resolve and/or remediate.Develop a database modeling schema (DBMS) including the location, data storage and technology to be used for all projects/efforts.Collect descriptive statistics like minimum, maximum, count and sum.Collect data types, lengths, and recurring patterns.Tag data with keywords, descriptions, and categories.Perform data quality assessments to expose potential risks of performing joins on the data.Discover metadata and assess its accuracy.Work collaboratively with data owners to understand legacy system data design, data structures (i.e., format, location, sensitivity, etc.) and business requirements (e.g., records retention, data security, data privacy, etc.).Work collaboratively with functional team members (e.g., System Architect, System Engineer, etc.) to understand the target system data design and any new business requirements (e.g., data archiving, disaster recovery, data masking, etc.).Develop the data conversion and/or migration plan to include scope, resources and timeline for data conversion and migration activities.Ensure functional life cycle management standards are designed, documented, communicated, and updated on a regular basis.

Develop and implement request handling and escalation policies and procedures.

The expected outcome aligns escalation policies and procedures with expectations of the business owners, stakeholders, division, and agency.Ensure test plans and test cases to validate software is secure and meets state, agency, and NIST guidelines.

Qualifications Required Qualifications:Six (6) years of professional experience in enterprise data governance and principles of data management and the data life cycle.ORA Bachelor’s degree from an accredited college or university with major coursework in Data Science, Information Management, or related field.

ANDFour (4) years of experience in the following:Standard Software Development Life Cycle while implementing enterprise principles, concepts, practices, and current industry standards as they relate to application development.

Data management, data integration/backup, database development and data performance optimization.

Working in a Microsoft-based environment.

AND

Three (3) years of experience in applications development, including experience in designing, developing, and maintaining applications using industry standard tools and development languages. Required languages at a minimum include Python, SQL, C#, JSON, and PowerShell.

AND

Two (2) years of experience in leading a team on medium to large scale development efforts.

Preferred/Desired Qualifications:

• Experience in Microsoft Azure adoption, governance, and administration.
• Experience in collecting and evaluating information for impact analysis and documenting functional and non-functional requirements for RFIs, RFPs, solution design, and maintenance.

If you are excited about this role but not sure if your experience aligns perfectly with every qualification in the job description, we encourage you to apply. At the Washington State Liquor and Cannabis Board, we are dedicated to building a diverse and authentic workplace centered in belonging. You may just be the needed candidate for this or other roles.

Additional Information

IMPORTANT: To be considered for this position, you MUST include the following, failure to do so will result in your application being disqualified:

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.

The Washington State Liquor and Cannabis Board is an equal opportunity employer and encourages applications from job seekers with diverse backgrounds. Honoring diversity, equity and inclusion means that as an agency, and as individuals, we are committed to ensuring that all employees enjoy a respectful, safe, and supportive working environment.

All qualified applicants will receive consideration for employment without discrimination based on sex, race, creed, religion, color, national origin, age, honorably discharged veteran or military status, sexual orientation including gender expression or identity, the presence of any sensory, mental, or physical disability, or the use of a trained dog guide or service animal by a person with a disability. You are welcome to include your name and gender pronouns in your application, to ensure we address you appropriately throughout the application process.

For questions about this recruitment, or to request reasonable accommodation in the application process, please email hrjobs@lcb.wa.gov or call (360) 664.1720. For TTY service, please call the Washington Relay Service at 7-1-1 or 1-800-833-6384.