Analytics Data Engineer (BI/Fabric)

Lifewave Inc•Draper, UT

13h•Onsite

About The Position

The Analytics Data Engineer (BI/Fabric) will own the technical evolution of our global analytics environment. Reporting to the Globa Senior Manager of Business Intelligence, you will aid in the administration of our Microsoft Fabric ecosystem—leveraging ETL functions to produce a high-performance business-ready data framework. Your primary mission is to empower our BI Analysts by building flexible, organized, and efficient data objects within Fabric that follow firm data governance guidelines. Acting as a critical bridge between the core Azure engineering team and multi-functional business stakeholders, you will not only build the data objects that drive company-wide strategy but also define and contribute to the standards for data health and governance within our analytics environment, with special attention to Microsoft Fabric Workspaces.

Requirements

Bachelor’s Degree in related field or equivalent/higher.
2-4 years of experience in data engineering, analytics, or comparable fields.
Mastery of T-SQL for warehouse management and complex data modeling (DDL and DML required, DQL preferred).
Functional knowledge of DAX for Semantic Modeling.
Experience connecting to and extracting data from REST/SOAP APIs via Data Factory objects and/or PySpark.
Functional knowledge of PySpark/Python.
Familiarity with the Fabric Ecosystem, specifically an understanding of Lakehouses, Data Warehouses, and Semantic Models.
General understanding of Star Schema design in support of BI reporting.
Knowledgeable with Power Query / Dataflows / Data Pipelines.
Practiced attention to detail, critical thinking, and problem solving.
Excellent written, verbal, and communication skills and ability to work cross-functionally in a team environment.
Comfort with adapting and adjusting to multiple demands, shifting priorities, ambiguity, and rapid change.

Nice To Haves

Experience in a network marketing organization.
Databricks SQL/Python.
Managing RLS logic tables.
API connectivity handling pagination and OAuth tokens.
Process oriented mindset.
Comfortable with providing organized and efficient project updates.
Proactive mentality with a desire for self-improvement.
Driven by opportunity for innovation and professional independence.

Responsibilities

Manage data warehouses and lakehouses in MS Fabric.
Develop data pipelines using Data Factory objects and PySpark in MS Fabric.
Administrate Fabric workspace access and connections.
Design and implement automated data freshness and monitoring for pipeline failures and data latency.
Write enduring and adjustable SQL while navigating a complex database.
Work with a variety of partners such as Sales, Marketing, Events, Recognition, etc.
Assist in production and maintenance of a flexible library of Semantic Models ready for visualization and analysis.
Assist in defining and enforcing data naming conventions and workspace folder structures to ensure a scalable Global BI self-service environment.
Support defining, documenting, and enforcing a business ready data dictionary.
Prepare the environment for future scaling to support complex transformations and AI readiness.
Managing CI/CD processes in a Fabric environment via GitHub integration.