*Our Mission: *Keep Washington Safe and Working! * Our Values: *Customer Focus, One L&I, Respect, Diversity, Equity and Inclusion, Learning and Growth, Reliability

The Department of Labor & Industries (L&I), an employer of choice, is announcing an exciting opportunity to join our Information Technology (IT) Division's Enterprise Data Warehouse Team as a Database Administrator (IT Data Management, Journey Level).

The Applications & Data Management (A&DM) program is comprised of six development teams organized into multiple Agile teams that deliver advanced web capabilities to citizens and businesses within Washington State. If you are selected for this role, you will play a key part in maintaining and optimizing a data warehouse that serves over 1,400 users and supports enterprise reporting, analytics, and claims data distribution. You will apply your advanced technical expertise to ensure the successful design, development, and maintenance of our data systems.

Duties

Some of what you'll do:

• Design and structure databases to efficiently store, retrieve, and manage data, including creating schemas, tables, indexes, and other objects.
• Ensure security of the data warehouse and compliance with data governance standards.
• Collaborate with business analysts, data scientists, and product teams to create appropriate data structures that support analytical needs.
• Work with developers and data analysts to design databases that meet application and reporting requirements.
• Create data models that represent business processes and support analytics in collaboration with IT and business stakeholders.
• Establish and enforce data warehouse standards and best practices for consistency and reliability.
• Develop Dimensional Models to integrate data from multiple sources into a centralized repository.
• Manage Extract/Transfer/Load (ETL) systems for data extraction, cleaning, transformation, and presentation.
• Write complex SQL queries for data manipulation and retrieval.
• Stay up to date with emerging technologies and trends in data warehousing, big data, and related methodologies.

• And much more!

   

Qualifications

Required:

• Eight (8) years of professional experience* in all of the following:
  • Developing and enhancing Microsoft applications using languages and tools.
  • Developing and enhancing data loads and data transformations applications using programming languages and tools.
  • Developing and enhancing data warehouses, data marts, data lakes, and database designs.
  • Applying and developing coding and testing standards, application architecture and architectural patterns, security protocols and frameworks, application source control and agency policies required to develop and maintain applications.
  • Writing and accessing database code using T-SQL, stored procedures, SSMS, and SSIS.
  • Performing unit testing.
  • Applying development standards in a managed environment.

*NOTE: Education may substitute year for year for experience up to four (4) years for a Bachelor's degree and up to two (2) years for an associate's degree in Information Technology, Computer Science, Computer Programming, or a closely aligned field.