Please login/register to apply for this job.
18 Jan 2023

Full-Time Senior Data Developer (IT App Developer – Senior/Specialist)

Washington State Liquor and Cannabis Board ( – Posted by wslcbjobs@lcb.wa.gov Olympia, Washington, United States

Job Description

An image without description

WSLCB Vision
Safe communities for Washington State.

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

This recruitment is open until filled. 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. 

Who we are

 

The mission of the Washington State Liquor and Cannabis Board (WSLCB) is to promote public safety 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 Liquor and Cannabis Board (LCB) strives to promote Diversity, Equity, Inclusion, and Belonging (DEIB) in all aspects of our workforce.

It is our mission to build, educate, and inspire an inclusive workforce that recognizes, respects, and celebrates diversity in the workplace. We are committed to maintaining a thriving culture where employees feel safe and accepted regardless of education, background or belief. As a WSLCB team member, you will have opportunity to join statewide business resource groups (BRGs) such as, Rainbow Alliance and Inclusion NetworkVeteran Employee Resource GroupLatino Leadership NetworkBlacks United in Leadership and DiversityDisability Inclusion NetworkWashington Immigrant Network and Hawaiians, Asians, and Pacific Islanders Promoting an Empowerment Network.

Your opportunity at a glance

The WSLCB Information Technology Services Division is announcing an exciting opportunity for an Senior Data Developer (IT App Developer – Senior/Specialist) position in Olympia, WA. This position reports to the Application Manager in the WSLCB’s Information Technology Services Division. The position serves and complements the WSLCB’s mission and goals by provides technical leadership and strategic direction for the technologies, standards, processes and architectures for data across the enterprise. You will leverage and apply advanced knowledge in data architecture, data development, and data management to develop the enterprise data strategy which comprises all significant data-related policies and principles. In this position, you will also establish the end-to-end vision for translating logical designs into one or more physical databases and how data will flow through the successive stages involved. You will develop data solutions that meet access, security, and quality controls required to ensure the highest level of data accuracy, integrity and fidelity.

If you have an interest in working collaboratively with cross-functional teams to define 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, 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 – 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

 

 

Duties

Some of the duties you will perform are:

  • Create and maintain current and future state data architectures. Define and manage standards, guidelines and processes to ensure data quality. Ensure technology solutions are in alignment with data architecture principles and future state. Oversee end-to-end data life cycle management activities.
  • 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. Identify distributions, key candidates, foreign-key candidates, functional dependencies, embedded value dependencies, and perform inter-table analysis.
  • 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.).

 

 

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.

Three (3) years of demonstrable progressive experience or advanced-level knowledge in:

  • Extract, Transform and Load (ETL) methodologies and techniques to include data replication, data masking, data encryption and data testing.
  • .NET Framework, MVC, C#.
  • Data warehousing, data modeling, and data analysis.
  • Data management, data integration/backup, database development and data performance optimization.

AND

Demonstrable progressive experience or advanced-level knowledge in a combination of following:

  • Relational database and business intelligence technologies.
  • Relating architectural decisions and recommendations to business needs.
  • Developing reference architecture, principles and standards.
  • Communicating across all levels of the organization and working with diverse project teams.
  • Data profiling.
  • Technical proficiency in the creation and execution of test automation programs using a variety of scripting languages (such as Transact SQL, VBScript, JavaScript, C#, Python, and PowerShell).

 

Preferred/Desired Qualifications:

  • A Bachelor’s degree or above in Computer Science, Engineering or related field from an accredited college or university; OR 5 years of professional experience in one or more of the following IT disciplines: system architecture, system development, database administration.
  • Certified Data Management Professional (CDMP).
  • Experience working is a local/state/federal government environment where IT security best practices, policies and procedures are required and audited.

 

 

Supplemental Information

 

HOW TO APPLY

PLEASE READ THE FOLLOWING INFORMATION CAREFULLY TO ENSURE YOU HAVE SUBMITTED THE REQUIRED MATERIALS TO BE CONSIDERED.

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.

**A resume will not substitute for completing the “work experience” section of the application.

The information provided in your application and supplemental questionnaire must support your selected answers in the supplemental questions. Responses not supported in your application will disqualify you for consideration of employment from this recruitment.

Prior to a new hire, a background check including criminal record history will be conducted.  Information from the background check will not necessarily preclude employment but will be considered in determining the applicant’s suitability and competence to perform in the position.

COVID-19 VACCINATION
Per Governor Inslee’s Proclamation 21-14 (Download PDF reader), state employees must be fully vaccinated against Covid-19. Special note that any offer of employment is contingent upon you providing verification of your vaccine status. No start date will be approved until you verify your status.

To further ensure public safety and in conjunction with our Governor’s proclamation of stay home, stay healthy and current guidelines related to COVID-19, interviews at this time will be conducted by video or phone conference as part of our recruitment process.

Other
Applicants for employment with the Washington State Liquor and Cannabis Board should also be aware of RCW 66.08.080, which states in part: “No employee of the board shall have any interest, directly or indirectly, in the manufacture of liquor sold under this title, or derive any profit or remuneration from the sale of liquor, other than the salary or wages payable to him in respect of his office or position, and shall receive no gratuity from any person in connection with such business.

RCW 69.50.351, no member of the state liquor and cannabis board and no employee of the state liquor and cannabis board shall have any interest, directly or indirectly, in the producing, processing, or sale of cannabis, useable cannabis, or cannabis-infused products, or derive any profit or remuneration from the sale of cannabis, useable cannabis, or cannabis-infused products other than the salary or wages payable to him or her in respect of his or her office or position, and shall receive no gratuity from any person in connection with the business.

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.1674. For TTY service, please call the Washington Relay Service at 7-1-1 or 1-800-833-6384.

How to Apply

State of Washington Job Opportunities | Work that Matters (governmentjobs.com)

Job Types: Full-Time. Salaries: 100,000 and above.

Job expires in 69 days.

57 total views, 1 today

Apply for this Job