L&I SQL Architect (IT Architecture Senior/Specialist)

Full Job Description

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 for an IT SQL Architect!

About the Division and Unit

The Information Technology (IT) Division is responsible for providing quality products, services, and solutions in service of Washington State Department of Labor and Industries (L&I) business priorities enabling the organization’s customers to keep Washington safe and working.

Within the IT Division’s Maintenance and Operations (M&O) program, the Application & Data Management (A&DM) program is comprised of six development teams organized into multiple Agile teams that deliver advanced web capabilities to citizens businesses within Washington State.

About the Role

As the A&DM SQL IT Senior Data Architect, this position is responsible for designing strategies for enterprise databases, data warehouse systems, data reporting, data archival and data storage.

If chosen for this role you will set standards for database operations, programming, query processes, and security.

You will use your specialist knowledge to create and optimize data models for warehouse infrastructure and workflow as well as integrate new systems and refine system performance and functionality.

Requirements

Some of what you’ll do:

Develop, design, and maintain new architecture for systems and ensure that compliance of existing architecture and documentation are in alignment with IT standards.

This includes:Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.

Plan and develop policy for overall solution-integrity of applications maintained by the agency.

Develop agency-wide standards and practices, design decisions, and deliver architected standards by incorporating feedback from interacting and consultation with a wide range of people, from highly technical software developers to Senior Executive stakeholders.

Develop and maintain implementation plans for key aspects of enterprise architecture based on business requirements and IT strategies.

Lead work with project teams across the organization to develop and apply standards and ensure compliance during project development and implementation phases are sustained.

Provide exceptional customer service, including:

• Consult and advise with several program managers, IT Managers, Agency Directors, and other leadership roles.
• Provide facilitation, clarification, and instigate cooperation amongst peer groups.
• Provide appropriate, clear, and concise reporting.

Operational Architect, including:

• Consult with the Application and Data Management (A&DM) supervisors/technical leads in developing and complying with architectural policies, standards, and procedures outlined by the supporting IT groups.

Business and Systems Analysis, including:

• Interpret business requirements as defined by the end user to intelligible requirements that meet system architecture and design.
• Consult and advise the supervisors/technical leads of the system in question by the development of documented system designs and an outlay of technical solutions.

Data Management Compliance for systems, including:

• Provide data architecture, services, data modeling, and data administration support to ensure the following is compliant with overall architecture requirements.

Qualifications

Required:

Ten (10) years* of progressive professional experience in qualifying professional IT experience.

Qualifying professional IT experience for this position is defined as experience in the following:Developing and enhancing applications using languages and tools such as Visual Studio, C#, VB.Net, ASP.Net, HTML, CSS, JavaScript XML, JQuery, MWM or MVC, WPF, ADO, WCF, JSON

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, and Entity Framework

Performing unit testing

Applying development and architecture 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.

Desired:

• Working knowledge of current technology trends such as:
  • DevOps methodologies
  • Service orientation
  • Cloud computing
  • loT
  • Security

Additional Information

Things You Need To Know

To help you maintain a proper work-life balance, L&I offers flexible custom work schedules as well as hybrid and remote work options. Teleworking is one of the work schedule options for this position. 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’s 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's 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.

You must include the following documents with your application:

1. A cover letter describing specific qualifications.
2. A current resume detailing applicable experience and education.
3. 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.

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 driver's license and have insurance if driving a privately owned vehicle on state business.

This position is represented by the Washington 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, I-9.

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 non-permanent positions.

• Sign up for L&I Job Alerts to receive information about our newest openings: GovDelivery

To learn more about our hiring process timeline at L&I please visit our L&I recruiting page at Hiring 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.

Did You Know?

Washington is America's 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's 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’s 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 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 agency’s 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 service.

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.