DataJobs.io
← Back to all jobs

Job Description

The State of Utah is seeking a Data Engineer / Microsoft SQL Database Administrator to help design, maintain, and continuously improve data systems and cloud data infrastructure. This hybrid role in Salt Lake City combines SQL Server database administration with ETL and cloud platform work across Azure and Microsoft Fabric.

You will administer SQL Server databases across development, testing, and production environments, while also building and supporting data pipelines and lakehouse-style analytics capabilities. The position includes responsibilities spanning performance tuning, reliability planning, data integration, and governance practices.

What you will do

  • Administer, monitor, secure, and maintain Microsoft SQL Server databases across development, testing, and production.
  • Monitor database performance, identify bottlenecks, and implement SQL Server tuning strategies for workload efficiency.
  • Manage backups and restores, disaster recovery procedures, maintenance plans, and high-availability solutions.
  • Build, maintain, and troubleshoot ETL processes integrating data from multiple systems.
  • Design and support data pipelines using SQL Server Integration Services, Azure Data Factory, Microsoft Fabric pipelines, notebooks, or similar technologies.
  • Support Azure Cosmos DB including NoSQL storage concepts such as partitioning, indexing, querying, performance monitoring, and downstream integration.
  • Support the Microsoft Fabric OneLake environment, including lakehouses, warehouses, pipelines, notebooks, semantic models, and integration with Power BI.
  • Ensure data integrity, quality, privacy, security, and compliance with organizational policies and applicable regulations.
  • Collaborate with technical and non-technical stakeholders to understand data needs and deliver effective solutions.
  • Assist with database migrations, upgrades, automation, modernization, and cloud data platform initiatives.
  • Promote data governance best practices, including data access, metadata management, and secure data sharing.

Required qualifications

  • Associate degree or higher in Computer Science, Information Systems, Data Engineering, Data Analytics, or a related field (preferred); equivalent professional experience may be considered.
  • Professional experience in database administration, data engineering, database development, or a related technical role.
  • Strong experience with Microsoft SQL Server database administration.
  • Strong proficiency in T-SQL, including complex queries, stored procedures, functions, views, indexing, and query optimization.
  • Experience designing, maintaining, and troubleshooting relational database structures.
  • Experience with backup and recovery, performance tuning, monitoring, indexing, security, and access management.
  • Experience developing and supporting ETL/ELT processes and data pipelines; SSIS and Azure Data Factory experience is required.
  • Experience with Azure Cosmos DB, including NoSQL data models, partitioning, indexing, querying, and integration with other data systems.
  • Experience with Azure Data Lake Storage, including storage organization, security, file formats, and data lifecycle management.
  • Understanding of modern cloud data architecture patterns such as delta lakes, lakehouses, warehouses, and medallion-style data organization.
  • Familiarity with data quality, data governance, data privacy, and secure data access practices (Informatica experience is a plus).
  • Ability to troubleshoot complex database design, data integration, and cloud data platform issues.
  • Strong analytical, problem-solving, documentation, and communication skills.
  • Ability to work independently and collaboratively with technical and non-technical teams.

Technologies

  • Microsoft SQL Server, T-SQL, SQL Server Integration Services
  • Azure Data Factory, Microsoft Fabric, Microsoft Fabric OneLake
  • Azure Cosmos DB, Azure Data Lake Storage
  • Power BI, ETL, ELT, Informatica
  • Notebooks, Semantic models

Role details

  • Location: Salt Lake City, UT (hybrid)
  • Schedule: Full-Time
  • Salary: $40.00 - $50.00 per hour
  • FT / PT STATUS: Full-Time
  • Address: 250 East 500 South, Salt Lake City, UT 84111, United States
  • Background check required: Yes
  • Drug test required: No
  • Schedule code: AE - Employees of the State Board of Edu. This is a career service exempt at will position.

Benefits and application

  • Benefits: Eligible for a full benefits package.
  • Application deadline: 11/27/2026*
  • Posting note: This job posting may close at any time after the minimum advertising period of three (3) business days has passed, should a sufficient applicant pool be received. Applicants are encouraged to apply as early as possible.
  • Application requirement: Applicants must complete a work analysis to be considered for the role.

Similar Jobs