Washington State ESD
L&I Database Team Supervisor (Data Management Senior/Specialist)
Washington State ESD, Seattle, Washington, us, 98127
Overview
Our Mission:
Keep Washington Safe and Working!
Our Values:
Customer Focus, One L&I, Respect, Diversity, Equity and Inclusion, Learning and Growth, Reliability This position has been reopened to expand the candidate pool. Previous applicants do not need to reapply. IT supervisors will receive five percent (5%) supervisory pay differential in addition to their base pay. The Department of Labor & Industries (L&I), an employer of choice, is announcing an exciting opportunity to join our Information Technology (IT) Division as an
Enterprise Database Team Supervisor
(IT Data Management Senior/Specialist). Within the IT Division, the Applications & Data Management (A&DM) program is dedicated to delivering advanced web capabilities and data solutions to citizens and businesses across Washington. The Database team supports hundreds of major database systems for 400+ custom applications and COTS applications. Data in these systems is used for reporting, data analytics, providing claims and employer data to other applications and systems, and supports the agency\u2019s enterprise reporting capabilities. If selected for this role, you will apply your senior level Enterprise Database technical skills and knowledge to lead in data management technologies, standards, best practices, data management lifecycle, and data management technologies. Some of what you’ll do: Supervise and lead the Enterprise Database team through changes to complex data management systems and interfaces. Coach, lead, mentor, and provide guidance to the Database team with an eye towards future responsibilities and goals of individual team members. 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, develop, and implement data solutions using Microsoft technologies, Transact SQL, SQL Server databases, Software as a Service (SaaS), and/or Commercial off the Shelf (COTS) so that systems are compliant with agency and industry standards. 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. And much more! Requirements 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:
Administrating MS SQL Server (creating indexes, DB maintenance, backups/recovery, etc.) Database management systems such as SQL Server, MySQL, MongoDB, etc. Database design, implementation, optimization, and maintenance SQL querying, stored procedures, triggers, and other database scripting languages Performance tuning, capacity planning, and troubleshooting database issues, Performance Tuning, Query Optimization, capacity planning, troubleshooting database issues, monitoring and troubleshooting tools Advanced database security principles and best practices Designing and implementing backup and disaster recovery solutions Strong understanding of data integrity, normalization, and data modeling concepts Documenting database architectures, processes, and procedures comprehensively
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. Desired One (1) year of experience within an agile scrum team. Working knowledge of current technology trends and tools in data extraction and management Things You Need To Know
To help you maintain a proper work-life balance, teleworking is one of the work schedule options for this position. L&I also offers flexible custom work schedules. We offer hybrid and remote work options. Remote work from a state outside of WA requires approval. State employees who meet the qualifications will become eligible for a generous retirement package at the end of the employee\u2019s career. Click on the “Benefits” tab to learn more. At L&I, your voice matters. In addition, L&I is a diverse state agency dedicated to the safety and health and security of Washington\u2019s 3.3 million workers. Take a look at this brief video and learn more about why L&I is an employer of choice. To receive more information on opportunities at L&I sign up for GovDelivery and select L&I job alerts. Application process We will contact the top candidates directly to interview for this position. Because we base the selection on information provided by you, it is in your best interest to identify the knowledge, skills, and abilities that address the required and desirable qualifications described in the announcement. Please include the following documents with your application: A cover letter describing specific qualifications. A resume detailing applicable experience and education. A list of at least three professional references with current telephone numbers. Note: we will never call any reference without your written authorization Please do not attach or place any medical information (vaccination status included) within the application, resume, or cover letter. If you do, we will have to reject your application to safeguard others from receiving your confidential information. You will have to remove the confidential information before you can apply again. To learn more about our hiring process timeline at L&I please visit our L&I recruiting page. If you would like to read our website in a language other than English, scroll up to select your language of choice. Background Check Notice
Prior to a placement in this position, a background check, including criminal history, will be conducted. Information from your background check will not necessarily preclude employment but will be considered in determining your eligibility to perform the requirements of the position. Other information
IT position applicants selected to move forward in this hiring process will receive an email skills assessment invitation within 3 weeks of your application being accepted. The invitation expires 5 days after it is sent. Once you start the assessment, you will be required to complete it. You cannot start the assessment and then come back to it later. Check your email (including spam) for messages from CodeSignal. For positions requiring travel, you must have a valid unrestricted driver\'s license and insurance if driving a privately owned vehicle on state business. This position is represented by the Washington Federation of State Employees (WFSE). Candidates offered a job with L&I must possess work authorization that does not require sponsorship now or in the future. The Department of Labor & Industries complies with I-9 requirements. The selected candidate must provide proof of identity and eligibility to work in the United States on the first day of employment. Please note: L&I may use this announcement to fill multiple permanent and/or non-permanent positions. Did You Know? Washington is America\u2019s Top State to live, play, and work, according to U.S. News (2021). Join the L&I team and enjoy all the Evergreen State has to offer. In addition to offering a positive balance between life and work, L&I provides one of the most competitive benefits packages in the nation. We also believe your voice matters. We value our employees and their work-life balance by encouraging flexible schedules. L&I is a diverse state agency dedicated to the safety and health and security of Washington\u2019s 3 million workers. Veterans Preference Applicants wishing to claim Veterans Preference should attach to their application a copy of their DD-214 (Member 4 copy), NGB 22, or signed verification of service letter from the United States Department of Veterans Affairs. Please blackout any personally identifiable data such as Social Security numbers. For further information, contact L&I\u2019s Jobs@lni.wa.gov. Diversity, Equity, and Inclusion Employer L&I employees come from all walks of life. We strive to hire great people from a wide variety of backgrounds. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We are committed to building a diverse and inclusive workplace for everyone and we strongly mean everyone. The State of Washington is an equal opportunity employer. Persons with a disability who need accommodation in the application process or testing process, or those needing this announcement in an alternative format, may call 360-902-5700. TTY users should first call 711 to access the Washington Relay Service. You are welcome to include the name and pronoun you would like to be referred to in your materials and we will honor this as you interact with our award-winning diverse and inclusive organization. For more Information If you have any questions regarding this job posting, program, or the agency, please contact Jennifer Nuño at nunk235@lni.wa.gov.
#J-18808-Ljbffr
Our Mission:
Keep Washington Safe and Working!
Our Values:
Customer Focus, One L&I, Respect, Diversity, Equity and Inclusion, Learning and Growth, Reliability This position has been reopened to expand the candidate pool. Previous applicants do not need to reapply. IT supervisors will receive five percent (5%) supervisory pay differential in addition to their base pay. The Department of Labor & Industries (L&I), an employer of choice, is announcing an exciting opportunity to join our Information Technology (IT) Division as an
Enterprise Database Team Supervisor
(IT Data Management Senior/Specialist). Within the IT Division, the Applications & Data Management (A&DM) program is dedicated to delivering advanced web capabilities and data solutions to citizens and businesses across Washington. The Database team supports hundreds of major database systems for 400+ custom applications and COTS applications. Data in these systems is used for reporting, data analytics, providing claims and employer data to other applications and systems, and supports the agency\u2019s enterprise reporting capabilities. If selected for this role, you will apply your senior level Enterprise Database technical skills and knowledge to lead in data management technologies, standards, best practices, data management lifecycle, and data management technologies. Some of what you’ll do: Supervise and lead the Enterprise Database team through changes to complex data management systems and interfaces. Coach, lead, mentor, and provide guidance to the Database team with an eye towards future responsibilities and goals of individual team members. 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, develop, and implement data solutions using Microsoft technologies, Transact SQL, SQL Server databases, Software as a Service (SaaS), and/or Commercial off the Shelf (COTS) so that systems are compliant with agency and industry standards. 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. And much more! Requirements 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:
Administrating MS SQL Server (creating indexes, DB maintenance, backups/recovery, etc.) Database management systems such as SQL Server, MySQL, MongoDB, etc. Database design, implementation, optimization, and maintenance SQL querying, stored procedures, triggers, and other database scripting languages Performance tuning, capacity planning, and troubleshooting database issues, Performance Tuning, Query Optimization, capacity planning, troubleshooting database issues, monitoring and troubleshooting tools Advanced database security principles and best practices Designing and implementing backup and disaster recovery solutions Strong understanding of data integrity, normalization, and data modeling concepts Documenting database architectures, processes, and procedures comprehensively
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. Desired One (1) year of experience within an agile scrum team. Working knowledge of current technology trends and tools in data extraction and management Things You Need To Know
To help you maintain a proper work-life balance, teleworking is one of the work schedule options for this position. L&I also offers flexible custom work schedules. We offer hybrid and remote work options. Remote work from a state outside of WA requires approval. State employees who meet the qualifications will become eligible for a generous retirement package at the end of the employee\u2019s career. Click on the “Benefits” tab to learn more. At L&I, your voice matters. In addition, L&I is a diverse state agency dedicated to the safety and health and security of Washington\u2019s 3.3 million workers. Take a look at this brief video and learn more about why L&I is an employer of choice. To receive more information on opportunities at L&I sign up for GovDelivery and select L&I job alerts. Application process We will contact the top candidates directly to interview for this position. Because we base the selection on information provided by you, it is in your best interest to identify the knowledge, skills, and abilities that address the required and desirable qualifications described in the announcement. Please include the following documents with your application: A cover letter describing specific qualifications. A resume detailing applicable experience and education. A list of at least three professional references with current telephone numbers. Note: we will never call any reference without your written authorization Please do not attach or place any medical information (vaccination status included) within the application, resume, or cover letter. If you do, we will have to reject your application to safeguard others from receiving your confidential information. You will have to remove the confidential information before you can apply again. To learn more about our hiring process timeline at L&I please visit our L&I recruiting page. If you would like to read our website in a language other than English, scroll up to select your language of choice. Background Check Notice
Prior to a placement in this position, a background check, including criminal history, will be conducted. Information from your background check will not necessarily preclude employment but will be considered in determining your eligibility to perform the requirements of the position. Other information
IT position applicants selected to move forward in this hiring process will receive an email skills assessment invitation within 3 weeks of your application being accepted. The invitation expires 5 days after it is sent. Once you start the assessment, you will be required to complete it. You cannot start the assessment and then come back to it later. Check your email (including spam) for messages from CodeSignal. For positions requiring travel, you must have a valid unrestricted driver\'s license and insurance if driving a privately owned vehicle on state business. This position is represented by the Washington Federation of State Employees (WFSE). Candidates offered a job with L&I must possess work authorization that does not require sponsorship now or in the future. The Department of Labor & Industries complies with I-9 requirements. The selected candidate must provide proof of identity and eligibility to work in the United States on the first day of employment. Please note: L&I may use this announcement to fill multiple permanent and/or non-permanent positions. Did You Know? Washington is America\u2019s Top State to live, play, and work, according to U.S. News (2021). Join the L&I team and enjoy all the Evergreen State has to offer. In addition to offering a positive balance between life and work, L&I provides one of the most competitive benefits packages in the nation. We also believe your voice matters. We value our employees and their work-life balance by encouraging flexible schedules. L&I is a diverse state agency dedicated to the safety and health and security of Washington\u2019s 3 million workers. Veterans Preference Applicants wishing to claim Veterans Preference should attach to their application a copy of their DD-214 (Member 4 copy), NGB 22, or signed verification of service letter from the United States Department of Veterans Affairs. Please blackout any personally identifiable data such as Social Security numbers. For further information, contact L&I\u2019s Jobs@lni.wa.gov. Diversity, Equity, and Inclusion Employer L&I employees come from all walks of life. We strive to hire great people from a wide variety of backgrounds. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We are committed to building a diverse and inclusive workplace for everyone and we strongly mean everyone. The State of Washington is an equal opportunity employer. Persons with a disability who need accommodation in the application process or testing process, or those needing this announcement in an alternative format, may call 360-902-5700. TTY users should first call 711 to access the Washington Relay Service. You are welcome to include the name and pronoun you would like to be referred to in your materials and we will honor this as you interact with our award-winning diverse and inclusive organization. For more Information If you have any questions regarding this job posting, program, or the agency, please contact Jennifer Nuño at nunk235@lni.wa.gov.
#J-18808-Ljbffr