DirectJobHub
Jobs · Engineering · Utah

Analytics Data Engineer (BI/Fabric)

LifeWave Corporate · Draper, UT · 4 days ago
On-siteEngineeringFull-time

POSITION SUMMARY

The Analytics Data Engineer (BI/Fabric) will own the technical evolution of our global analytics environment. Reporting to the Global 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

  • Essential Duties and 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.
    • Aid in production and maintenance of a flexible library of Semantic Models ready for visualization and analysis.
    • Aid 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.

  • Qualifications and Experience:

    • 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.

Similar jobs