State of Washington · 1 day ago
L&I IT Data Warehouse Team Supervisor (IT Data Management Senior/Specialist)
The State of Washington is seeking a Data Warehouse Team Supervisor within their IT Division. The role involves leading a team of database engineers to maintain and optimize the agency’s data warehouse, ensuring security and compliance while collaborating with various technical teams.
AssociationCommunitiesEducationEmploymentEventsGovernmentInformation TechnologyNewsNon Profit
Responsibilities
Supervise and lead the Enterprise Data Warehouse team through changes to complex data management systems and interfaces
Coach, lead, mentor, and provide guidance to the Database team in the execution of solutions
Develop technology roadmaps for highly-complex systems that have significant statewide or multi-agency impact
Lead projects to integrate new and existing technologies
Plan, analyze, and design applications or enhancements for systems that are high risk, high impact and mission critical
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
Stay up to date with emerging technologies and trends in data warehousing, big data, and related methodologies
Qualification
Required
Five (5) years of advanced IT experience as an IT Manager or technical lead including leading IT professionals in implementing business systems, applications, new technology and infrastructure
Ten (10) 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, 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
The ability to take action to learn and grow
The ability to take action to meet the needs of others
Preferred
One (1) year of experience within an agile scrum team
Working knowledge of current technology trends and tools in data extraction and management
Benefits
Flexible custom work schedules
Hybrid and remote work options
Generous retirement package
Medical (including vision), dental and basic life insurance
Medical flexible spending account
Basic life and long-term disability insurance
Dependent care assistance
Auto, boat, home, and renter insurance
Washington State Employee Assistance Program
Washington Public Employees' Retirement System (PERS)
Deferred Compensation Program (DCP)
Public Service Loan Forgiveness
Paid holidays
Sick leave
Vacation leave
Military leave
Bereavement leave
Leave Sharing
Parental Leave
Family and Medical Leave Act (FMLA)
Leave Without Pay