We are seeking a Data Engineer with strong expertise in Microsoft Fabric, Power BI, Semantic Modeling, SQL, dimensional data modeling, and cloud data platforms.

The role will focus on designing, building, and governing an enterprise semantic layer using Microsoft Fabric to support trusted, self-service reporting and analytics. The ideal candidate will have hands-on experience assessing data quality, table readiness, data grain, keys, relationships, and source-system structures for semantic modeling.

The candidate will work closely with data domain teams and provide recommendations for modeling data from platforms such as Snowflake and Databricks. The role also involves developing and optimizing data pipelines, performing data exploration, and mentoring team members on semantic modeling and data engineering best practices.

Primary Skills: Microsoft Fabric, Power BI, Semantic Modeling, SQL, Dimensional Modeling, Snowflake, Databricks, Data Pipelines

Key Responsibilities

Microsoft Fabric & Semantic Modeling

• Design, build, and maintain semantic models using Microsoft Fabric and Power BI.
• Work with OneLake and Power BI datasets to support enterprise reporting and self-service analytics.
• Develop scalable and trusted enterprise semantic layers.
• Define and implement semantic models, relationships, measures, and business logic.
• Optimize semantic models for performance, usability, scalability, and business adoption.
• Ensure semantic models are supported by reliable, high-quality underlying data.

Data Readiness & Data Modeling

• Partner with data domain teams to evaluate table readiness for semantic modeling.
• Assess data quality, data grain, primary/foreign keys, relationships, and data structures.
• Identify data gaps and communicate recommendations to source/data teams.
• Apply star schema, dimensional modeling, snowflake schema, and data vault concepts.
• Define conformed dimensions and reusable data structures for enterprise analytics.
• Translate business and technical requirements into effective data and semantic models.

Data Engineering & Pipelines

• Develop and optimize data pipelines and transformations supporting the semantic layer.
• Work with data from Snowflake and Databricks.
• Perform data ingestion, transformation, integration, and preparation for downstream analytics.
• Develop complex data engineering solutions using SQL, Python, DAX, Java, Scala, and/or Go.
• Troubleshoot data pipeline and transformation issues.
• Optimize data processing for performance, scalability, and reliability.

Data Exploration & Analytics

• Perform data wrangling, exploration, profiling, and discovery across heterogeneous data sources.
• Analyze data structures to identify quality, relationship, and modeling issues.
• Translate data findings into actionable semantic modeling recommendations.
• Support business teams with trusted and easily consumable analytical data.

Cloud & Data Platforms

• Work with cloud data platforms including Azure, AWS, or Google Cloud.
• Integrate and optimize data across Microsoft Fabric, Snowflake, and Databricks.
• Apply cloud data engineering and architecture best practices.
• Support scalable enterprise data and analytics environments.

Data Governance & Observability

• Apply data governance, cataloging, lineage, and data quality practices.
• Support data discovery and traceability across enterprise data environments.
• Work with data monitoring and observability tools such as Prometh

Mentoring & Technical Leadership

• Mentor team members on semantic modeling and data engineering best practices.
• Conduct knowledge sharing and technical guidance.
• Support the development of team capabilities in Microsoft Fabric, Power BI, data modeling, and data engineering.
• Collaborate with architects, engineers, data domain teams, and business stakeholders.

Project Planning & Delivery

• Assist management with project definition, estimation, planning, and scope development.
• Contribute to semantic layer initiatives from prototype through production.
• Help identify technical dependencies, risks, and implementation requirements.
• Own solutions and deliverables through the complete development lifecycle.

Education Requirements

• Bachelor's Degree in Computer Engineering, Computer Science, or a related field plus 5 years of related experience; OR
• Advanced Degree with 3 years of related experience.
• Equivalent education and experience may be considered where applicable.

ABOUT BRICKRED SYSTEMS

BrickRed Systems is a global leader in next-generation technology consulting and workforce solutions, specializing in delivering high-quality talent across digital, engineering, marketing, analytics, finance, operations, and business transformation domains.

With a strong emphasis on innovation, scalability, and client success, BrickRed Systems helps organizations solve complex business challenges by providing skilled professionals across strategy, technology, creative, and operational functions.

BrickRed fosters a culture of continuous learning, collaboration, and excellence, enabling professionals to contribute to high-impact global initiatives while advancing their careers.