Sr. Data Engineer

About KēSTA I.T.

Our name says it all; KēSTA I.T. (Keys-to-I.T.) AND our people are our keys to our success!

KēSTA I.T. is a premier Utah-based technical staffing and consulting services firm. We specialize in temporary and permanent placement of Software, Hardware, Network, Cloud, CRM/ERP, Data, End-User support, Web and Executive / leadership-based positions on a full time and consulting basis. If you're interested in a role where top performance is rewarded, personal time is valued, and excellence is demanded at every level we want to talk to you today!

Where do you want to go? We've got the keys! ~ KēSTA I.T.

WWW.KeSTAIT.COM

Responsibilities

• Design, build, and maintain secure, scalable, and compliant data pipelines, including tables, views, stored procedures, and datasets
• Continuously optimize and monitor data pipelines to ensure long-term performance, reliability, and efficiency
• Partner with data analysts and data scientists to enable insights, and develop production-grade infrastructure to operationalize those insights at scale
• Ingest, integrate, transform, and consolidate data from a variety of structured and unstructured sources into models that support analytics, reporting, and machine learning use cases
• Identify and evaluate external data sources (second- and third-party) that can enhance business outcomes; define strategies to acquire, standardize, and integrate this data effectively
• Monitor production data environments, proactively troubleshoot issues, and implement timely resolutions
• Review and improve ETL/ELT processes, tooling, and code quality to strengthen data validation, maintainability, and overall engineering efficiency

Requirements

• 6+ years of relevant experience with a Bachelor’s degree, or 4+ years with a Master’s degree
• Bachelor’s degree in Computer Science, Software Engineering, or a related technical field (Master’s degree preferred)
• 3+ years of experience working with large-scale datasets
• At least 1+ year of experience working in cloud-based data environments
• Strong understanding of software design and engineering principles

Technical Expertise:

• Relational databases and data warehousing platforms (e.g., Snowflake, SQL Server or similar)
• ETL/ELT frameworks and tools (e.g., Azure Data Factory, Synapse Analytics, dbt, Databricks or equivalents)
• Cloud monitoring and orchestration tools (e.g., Azure Monitor, Logic Apps or similar)
• Data storage solutions (e.g., Data Lakes, Delta Lake architectures)
• Data modeling methodologies (e.g., Kimball, Star Schema, Snowflake Schema)
• Cloud development experience (preferably within a major cloud provider ecosystem)
• Programming languages such as Python, Scala, Java, or similar
• CI/CD pipelines and DevOps practices (e.g., Azure DevOps or equivalent)
• Experience working in Agile environments
• Familiarity with system and software architecture concepts