Data Engineer

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.