Analytics Data Engineer (BI/Fabric) in Draper, Utah at Lifewave Inc

POSITION SUMMARY

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.

SUPERVISORY RESPONSIBILITIES

This position has no supervisory responsibilities for this role.

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

QUALIFICATIONS AND EXPERIENCE

Required:

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

Preferred:

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

Work Environment & Physical Demands

LifeWave will operate as an in-office organization, and all employees are required to work onsite in alignment with corporate policy. While performing the duties of this job, the employee is regularly required to work at a computer workstation and be mobile within the office. Occasional movement of up to 25 pounds may be required.

LifeWave is committed to creating an inclusive workplace that values diversity and promotes equal opportunities for all. We embrace the principles of the Americans with Disabilities Act (ADA) and strive to provide reasonable accommodations to qualified individuals with disabilities.

In our pursuit of building a diverse and talented team, we encourage candidates of all abilities to apply for positions at LifeWave. If you require accommodation during the application or interview process, please inform our HR department, and we will work with you to ensure your needs are met.