This job has closed.

NEOGOV · 2 months ago

Data Management (IT Data Management - Senior/Specialist)

Thurston County – Olympia, WA

Full-time

Hybrid

Senior Level

$93K/yr - $125K/yr

6+ years exp

NEOGOV is seeking a Data Management Specialist (IT Data Management – Senior/Specialist) to join the Washington State Liquor and Cannabis Board in Olympia, WA. This role involves collaborating with cross-functional teams to maintain complex database systems, ensuring data accuracy, integrity, and quality controls, while also leading data management policies and strategies.

GovTechHuman ResourcesInformation TechnologySoftware

No H1B

Responsibilities

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

Qualification

Data governanceDatabase developmentData integrationData performance optimizationMicrosoft AzurePythonSQLC#PowerShellTeam leadershipSoft skills

Required

Six (6) years of professional experience in enterprise data governance and principles of data management and the data life cycle

A Bachelor's degree or above in Data Science, Information Management, Computer Science, or other closely related field will substitute for 2 years of experience mentioned above

Four (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

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

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

Preferred

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

Benefits

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

Insurance Benefits: Employees and their families are covered by medical (including vision), dental and basic life insurance.

Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.

Retirement and Deferred Compensation: State Employees are members of the Washington Public Employees' Retirement System (PERS).

Public Service Loan Forgiveness: If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

Holidays: Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.

Sick Leave: Full-time employees earn eight hours of sick leave per month.

Vacation (Annual Leave): Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165.

Military Leave: Washington State supports members of the armed forces with 21 days paid military leave per year.

Bereavement Leave: Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave.

Additional Leave: Leave Sharing, Parental Leave, Family and Medical Leave Act (FMLA), Leave Without Pay.