Data Engineer

JourneyTeam•Draper, UT

About The Position

The Data Engineer delivers technical excellence and business value for clients by understanding business requirements and working with client teams to build and implement modern data engineering solutions in the Microsoft ecosystem, with a focus on Microsoft Fabric. The role contributes to solution design and development alongside senior team members while meeting client expectations and project scope. The position focuses on engineering the data that powers reporting, collaborating with Power BI developers and other cross-functional partners. Solutions may include analytics, migrations, and data integrations, primarily in Microsoft Fabric, with additional work in Azure Databricks and other Azure data services.

Requirements

At least 3 years of hands-on data engineering experience, preferably within the Microsoft ecosystem.
Hands-on experience with Microsoft Fabric, including Lakehouse, Warehouse, Data Pipelines, and Notebooks, and Azure technologies such as Data Factory, ADLS, Azure SQL Database, and Synapse Analytics.
Strong SQL skills and a clear understanding of relational databases, transformation logic, and dimensional modeling techniques.
Ability to write and optimize complex SQL.
Working knowledge of Spark, including PySpark and/or Spark SQL in notebooks.
Experience building data orchestration and pipelines.
Experience connecting to and ingesting data from API sources, including using OAuth 2.
Experience flattening and/or normalizing JSON into a SQL structure.
Solid understanding of modern data lakehouse concepts, such as medallion architecture and combining data lakes with data warehouses.
Demonstrated commitment to JourneyTeam’s values and client priorities.
Ability to take ownership of assigned work and issues and see them through to resolution.
Strong problem-solving and collaboration skills.
Ability to build rapport with client teams and communicate technical concepts clearly.
Strong communication, organization, and time management skills.

Nice To Haves

Exposure to metadata-driven techniques.
Bachelor’s or master’s degree in computer science, informatics, data science, or a related technical discipline.
Exposure to real-time or near-real-time data, such as Fabric Real-Time Intelligence or Eventstreams.
Experience with Git, CI/CD, and Azure DevOps or GitHub for data solutions.
Relevant industry certifications, especially Microsoft certifications such as DP-700 Fabric Data Engineer Associate.

Responsibilities

Build and implement data solutions aligned with client objectives, including analytics, migrations, and data integrations, primarily using Microsoft Fabric and also Azure Databricks and other Azure data services.
Collaborate with Power BI developers, Azure cloud administrators, business analysts, and other cross-functional team members to deliver comprehensive data solutions.
Develop data engineering solutions that provide data quality, reliability, automation, notification, scalability, modularity, and security.
Design, develop, and optimize dimensional models, including star schemas, to support Power BI reporting.
Participate in design sessions with client teams and contribute to workshops and internal knowledge sharing.
Apply JourneyTeam and Microsoft best practices and contribute ideas to improve data engineering patterns.
Understand client problems and respond using appropriate methods based on best practices and repeatable patterns.
Create and maintain clear diagrams and documentation.
Take ownership of assigned work and issues through resolution.