Analytics Data Engineer (BI/Fabric)
Role details
Job location
Tech stack
Job description
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., * 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.
Requirements
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.