Data Engineer – ELT/ETL Data Modeling (Onsite – Salt Lake City, UT | Local Candidates Only)

WesTech Engineering • South Salt Lake, UT

13h • Onsite

About The Position

As a Data Engineer with WesTech, you will design, develop, and optimize scalable data solutions that support enterprise reporting, analytics, and operational decision-making. This role builds reliable data pipelines, implements dimensional data models, and partners with business stakeholders to deliver trusted datasets and analytics capabilities. The ideal candidate brings hands-on experience with modern data engineering tools and practices, including dbt, Microsoft Fabric, and Kimball dimensional modeling methodologies. Candidates for this position may be required to pass pre-employment and periodic screenings, including background checks, drug and alcohol tests, or other necessary assessments.

Requirements

• Bachelor’s degree in a related field, equivalent practical experience, and/or relevant technical certifications.
• 2–3 years of experience in data engineering, analytics engineering, software development, business intelligence, or a related technical role.
• Hands-on experience building ETL/ELT pipelines, enterprise data models, and enterprise reporting or analytics solutions.
• Strong SQL development and query optimization skills, with experience analyzing complex data issues and implementing scalable solutions.
• Experience using dbt in a production environment and working with data warehousing, ELT architecture, and data pipeline orchestration.
• Experience with Microsoft Fabric or related Microsoft data technologies, as well as cloud-based analytics platforms.
• Strong understanding of Kimball dimensional modeling principles.
• Experience with Git, source control, and development lifecycle practices.
• Strong communication and stakeholder collaboration skills.

Nice To Haves

• Experience with Python for automation, data processing, or analytics.
• Exposure to data science, forecasting, or machine learning workflows.
• Experience with Power BI or enterprise BI platforms.
• Familiarity with ERP systems such as Business Central, SAP, Oracle, or similar enterprise systems.
• Experience working in manufacturing, engineering, supply chain, construction, or project-based industries.

Responsibilities

• Design, develop, and maintain scalable data transformation pipelines using dbt.
• Build and optimize data solutions within Microsoft Fabric.
• Develop dimensional models and enterprise data marts using Kimball methodology.
• Collaborate with analysts, business stakeholders, and technical teams to gather requirements and deliver data solutions.
• Implement data quality checks, testing, and monitoring processes.
• Troubleshoot and resolve data pipeline performance and reliability issues.
• Support CI/CD, deployment, and source control processes for analytics engineering workflows.
• Improve documentation standards for data lineage, business rules, and technical architecture.
• Contribute to data governance and master data management initiatives.

Benefits

• Competitive salary and performance-based annual bonuses.
• Dollar for dollar 401K match of 6%.
• Flexible work hours.
• Comprehensive health and wellness benefits package with an onsite and virtual medical facility
• Company HSA contribution, Paid Parental Leave, Employee Assistance Program
• Company-paid Life Insurance, Accidental Death and Dismemberment, and Long-term Disability.
• PTO plan and Paid Holidays.
• Tuition Reimbursement.
• Company celebrations, summer parties, volunteer opportunities, games, prize drawings, and more!

What This Job Offers

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