Data & Applications Engineer (Internal Candidates Only)

Washington Education Association • Auburn, WA

12h • $150,179 - $206,210

About The Position

The Data & Applications Engineer serves as the Washington Education Association’s technical lead for databases, data integration, and business application platforms. The position is responsible for WEA’s SQL environment and data sources, as well as the data and integration layer supporting business applications such as Tableau, Appian, and Laserfiche.

Reporting to the IT Manager, the engineer collaborates with IT leadership on data and application platform strategy, planning, and design. The role partners with staff across WEA who build, maintain, and use applications and reports, and serves as a Tier 2/3 escalation resource for support requests involving databases, integrations, and business applications. The work supports WEA’s goal of helping members strengthen public schools in Washington State.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
• Five or more years of demonstrated experience working with Microsoft SQL Server in a production environment, including administration, performance tuning, backup and recovery, and security.
• Advanced T-SQL skills, including the ability to read, debug, and rewrite existing queries, stored procedures, and ETL logic.
• Experience designing data models, building integrations using APIs and web services, and building ETL processes.
• Hands-on experience with SQL Server in Microsoft Azure (Azure VMs, Azure SQL Managed Instance, or Azure SQL Database), including at least one migration of SQL workloads to Azure.
• Experience developing on or supporting low-code or business application platforms such as Appian, Laserfiche, or Microsoft Power Platform.
• Experience with version control and structured release management practices, such as Git and separate development, test, and production environments.
• Working knowledge of industry trends, standards, and best practices, with the ability to stay current with evolving technologies.
• Strong written communication and technical documentation skills, including the ability to explain technical concepts and recommendations to non-technical stakeholders.
• Provide proof of full COVID-19 vaccination status upon hire; exceptions may be made for medical or religious reasons in accordance with applicable laws.

Nice To Haves

• Experience supporting analytics and reporting platforms such as Tableau or Power BI, including connecting and managing data sources.
• Scripting experience using PowerShell, Python, or a similar language.
• Experience with SSIS, Azure Data Factory, or other ETL and integration tools.
• Experience configuring application authentication and single sign-on with Microsoft Entra ID using SAML, OAuth, or OpenID Connect.
• Experience working in a labor, nonprofit, or public-sector organization.

Responsibilities

• Administer WEA’s SQL environment, including instance configuration, access and security, patching, backup and recovery, and performance tuning.
• Plan and execute database migrations, upgrades, and consolidations.
• Write, troubleshoot, and optimize T-SQL queries, views, and stored procedures.
• Oversee the design, monitoring, and error handling of data pipelines and ETL processes, and lead ongoing modernization efforts.
• Guide WEA’s data architecture strategy in Microsoft Azure with IT leadership, including evaluating hosting options, capacity requirements, and costs.
• Maintain an inventory of data sources and establish standards for data storage, sourcing, and documentation.
• Design, build, and maintain integrations between WEA systems and third-party platforms.
• Administer business application platforms, including configuration, upgrades, licensing, vendor relationships, and user access, emphasizing least privilege and role-based access control.
• Support the design and development of member-facing applications and services, emphasizing security, privacy, and performance.
• Build, support, and maintain workflows, forms, and reports across WEA’s business application platforms.
• Develop scripts or automations to improve operational efficiency across data and application systems.
• Serve as a Tier 2/3 support escalation point for databases, integrations, and business applications.
• Serve as a subject matter expert on databases, integrations, and assigned business applications across the organization.
• Maintain current documentation, including runbooks, architecture designs, and data source inventories.
• Contribute to continuous improvement through knowledge sharing, documentation, and collaboration with IT staff and colleagues across the organization.
• Complete other duties as assigned.

Benefits

• Employer-paid medical, dental, vision, and life insurance with full family coverage.
• Generous sick leave and paid time off (PTO).
• Long-term disability plan.
• Defined Contribution plan - 401(k) with employer contribution.
• Defined Benefit plan.
• Relocation assistance.
• Position covered by the WEA/WEASO Collective Bargaining Agreement.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level