Position OverviewThe Data Engineering & Power BI Architect is a strategic technical leader responsible for architecting scalable data platforms, ELT pipelines, semantic models, and enterprise-grade analytics solutions.This role focuses on data warehouse design, backend modeling, and DAX optimization to enable high performance, governance, and self-service BI across the organization.The Architect will serve as a technical advisor to Data Engineering and BI teams, ensuring solutions align with architectural standards, DevOps practices, and business strategy.Key Responsibilities1. 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.QualificationsEducation- 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).
Job Title
Data Architect