LI IT Data Management Journey Level Database Administrator
LI IT Data Management Journey Level Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Description
Our Mission:Keep Washington Safe and Working!
Our Values: Customer Focus One L&I Respect Diversity Equity and Inclusion Learning and Growth ReliabilityThe Department of Labor & Industries (L&I) an employer of choice is announcing an exciting opportunity to join our Information Technology (IT) Divisions 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 1400 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 youll 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 TSQL 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 Bachelors degree and up to two 2 years for an associates 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
- Eight 8 years of professional experience* in all of the following:
Supplemental Information
Things You Need To Know
To help you maintain a proper worklife 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 employees 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 Washingtons 3.3 million workers. Take a look at thisbrief video and learn more about why L&I is an employer of choice.
To receive more information on opportunities at L&I sign up forGovDeliveryand 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:
- Acover letterdescribing specific qualifications.
- A currentresumedetailing applicable experience and education.
- A list of at least three professional references with current telephone numbers. *Please 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 atHiring Process at L&I.If you would like to read our website in a language other than English scroll up to the top of the page to select your language of choice from the banner.
Background Check Notice
Prior to a placement in this position a background check including criminal history record 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. An applicant may complete the assessment when ready but the invitation to complete the assessment will expire 5 days after the invitation was sent. Once you start the assessment you will be required to complete it. You cannot start your assessment and then come back to it later. Please look in your email inbox or spam as these invitations are sent by CodeSignal.
- For positions requiring travel you must have a valid unrestricted drivers license and have insurance if driving a privately owned vehicle on state business.
- This position is represented bytheWashington Federation of State Employees (WFSE).
- Candidates who are offered a job with L&I must possess work authorization that does not require sponsorship by the employer for a visa now or in the future.
- The Department of Labor & Industries complies with the employment eligibility verification requirements of the federal employment eligibility verification form I9. The selected candidate must be able to provide proof of identity and eligibility to work in the United States consistent with the requirements of that form on the first day of employment.
- Please note: L&I may use this announcement to fill multiple permanent and/or nonpermanent positions.
- Sign up for L&I Job Alerts to receive information about our newest openings: GovDelivery
Did You Know
In addition to offering a positive balance between life and work L&I provides one of the most competitive benefits packages in the also believe your voice matters. We value our employees and their worklife balance by encouraging flexible schedules.L&I is a diverse state agency dedicated to the safety and health and security of Washingtons 3 million workers.
Veterans Preference
Applicants wishing to claim Veterans Preference should attach to their application a copy of their DD214 (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&Is.
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 believe in the importance of recognizing the value each of us contribute to the success of the agency mission. Having a diverse workforce is this agencys greatest resource of strength and knowledge. It is through the combination of talents and abilities that we can pursue finding effective measures to provide the best customer 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. 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 awardwinning diverse and inclusive organization.
For more Information
If you have any questions regarding this job posting program or the agency please contact Jennifer Nuo at.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
