Data Architect

Position Overview

Data Engineering & Power BI Architect

data warehouse design, backend modeling, and DAX optimization

technical advisor

Key Responsibilities

1. Data Architecture & Engineering

• Design and optimize enterprise-grade

  data warehouse

  and

  ELT/ETL frameworks

  to ensure scalability and performance.
• Collaborate with analytics and business teams to enhance data models and promote data-driven decision-making.
• Define and enforce data modeling, lineage, and governance frameworks.
• Evaluate and implement open-source and vendor tools for data integration and observability.
• Develop

  CI/CD pipelines

  and testing automation for data and semantic deployments.
• Establish and communicate

  coding standards

  , reusability patterns, and best practices across teams.

2. Semantic Modeling & BI Architecture

• Design

  Power BI Tabular Models

  using Import, DirectQuery, and Hybrid storage modes.
• Implement

  composite models, aggregation tables, and calculation groups

  within Microsoft Fabric or similar architectures.
• Leverage

  Tabular Editor, ALM Toolkit, and Best Practice Analyzer

  to ensure model consistency and maintainability.
• Manage data refresh strategies, relationships, and partition design for optimal performance.

3. DAX Optimization & Security

• Author complex and reusable

  DAX measures

  for business domains.
• Optimize model performance using

  DAX Studio, VertiPaq Analyzer, and Performance Analyzer

  .
• Implement

  row-level and object-level security

  to protect sensitive data and meet compliance requirements.

4. Collaboration, Governance & Technical Leadership

• Provide

  architectural oversight

  and code reviews for Data Engineers and BI Developers.
• Document and maintain modeling conventions, reusable templates, and SOPs.
• Ensure alignment with enterprise data governance, metadata management, and Fabric service integration.
• Mentor teams on performance tuning, semantic modeling, and DevOps readiness.

5. Platform Integration & DevOps

• Operate within

  Azure DevOps / Git-based pipelines

  for automated build, test, and deploy.
• Ensure semantic models and ELT jobs are

  CI/CD-ready

  , version-controlled, and auditable.
• Collaborate with platform and infrastructure teams for

  access control, refresh orchestration

  , and

  automated monitoring

  .
• Integrate with

  Fabric, Lakehouse, and Delta Lake

  components to unify analytics layers.

Qualifications

Education

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field.
• Master’s degree preferred.

Experience

• 7+ years

  designing and architecting data engineering and analytic systems.

• Deep experience

  with SQL, dimensional modeling, and cloud data warehouses (e.g., Snowflake, Azure Synapse).
• Hands-on expertise in

  Power BI, Tabular Models, and DAX optimization

  .
• Proficient with

  Tabular Editor, ALM Toolkit, and model performance tools

  .
• Strong experience with

  ETL/ELT frameworks

  ,

  Airflow

  , and

  Python

  scripting.
• Skilled in

  DevOps

  tools such as

  Git, Jenkins, Terraform, and Ansible

  .
• Proven ability to design

  data lake and data warehouse

  architectures on

  AWS or Azure

  .
• Familiarity with

  Fabric services

  such as Lakehouse, Delta Lake, and Semantic Link Labs.
• Experience building code-driven, automated infrastructure with observability and audit logging.

Skills & Competencies

• Expert in

  data modeling

  ,

  DAX

  , and

  semantic architecture

  .
• Strong grasp of

  database optimization, ELT orchestration, and data governance

  .
• Advanced

  DevOps

  and

  CI/CD pipeline design

  capabilities.
• Excellent communication and mentoring skills for technical and non-technical stakeholders.
• Product-oriented mindset with the ability to translate business needs into scalable architectures.
• Independent, detail-oriented, and comfortable leading backend solution design.

Certifications

• Microsoft Fabric Certified

  (preferred).

• Azure Data Engineer / Architect

  certifications (a plus).