Power Bi Architect

Job Title: Power Bi Architect

Experience: 5+

Job location: DLF Cyber Hub Gurugram

Work Mode: 5 Days (WFO)

Job Type: Full time

Interview Rounds: 4

Notice Period: Max 30 days

• Bachelors degree in computer engineering, Computer Science, Data Analytics, or related field.
• 7+ years of experience in BI engineering or data analytics, and in advance SQL Programming.
• 2+ Years of proven experience in BI governance including BI administration, metadata management, and data quality frameworks.
• Strong hands-on experience with Microsoft Power BI (including Power Query, DAX, dataflows, etc.).

In-depth knowledge of relational database design, data warehousing and dimensional data modeling concepts. Also, self-starter and motivated with ability to work in a fast-paced development environment. 

Strong hands-on experience with Python/Spark scripting and shell (Unix/Linux) scripting. 

Familiarity with data warehousing concepts and cloud data platforms (Azure, Snowflake, etc.) and their services like Azure Synapse Analytics, Azure Analysis Services, Azure Databricks, Azure SQL DW/Synapse. 

Excellent communication and stakeholder management skills with Strong analytical abilities. 

Proficiency across the environments, including DevOps, database server, GIT, Continuous Integration, unit testing tool, and defect management tools.

Responsibilities - 

• Design and architect scalable and high-performance BI solutions to support reporting, analytics, and report integration needs.
• Define and implement BI architecture standards, best practices, and governance principles. 
• Evaluate, select, and integrate BI tools and technologies (e.g., Power BI, Tableau, Looker, Qlik, etc.).
• Set up and manage Power BI workspace permissions, usage monitoring, and security roles (Row Level Security, etc.) with RBAC and managing licensing costs by ensuring governance compliance. 
• Ensure report quality, consistency, and security across BI platforms and provide mentorship to analysts.
• Lead the design and development of data models (star/snowflake schemas) and data warehouse structures for the reporting purposes. 
• Having great hold on the report definitions, lineage, and documentation across the BI landscape. 
• Collaborate with business stakeholders and other technical team members, also monitor and enforce reporting quality standards across BI functions. 
• Write custom scripts to extract data from structured/semi-structured sources from data warehouse or BI Cubes or from Snowflake. Skilled in deployment, report consolidation, and enhancing report usability.
• Provide clear documentation for delivered solutions and processes, integrating documentation with the appropriate corporate stakeholders.
• Optimize DAX queries and Power BI performance for scalability and responsiveness.

Preferred Skills - 

• Microsoft Certified: Data Analyst Associate or equivalent Power BI certification. 
• Experience with tools like Microsoft Purview, Alation, Collibra, or similar governance platforms.
• Hands-on experience with Microsoft Power BI (including Power Query, DAX, dataflows, etc.). 
• Knowledge of data governance, data security, and compliance standards. 
• Working Knowledge of Dev-Ops processes (CI/CD), Azure DevOps, Git/Jenkins version control tool, Power BI Administration, Data Quality tools, regulatory data compliance standards (e.g., GDPR, HIPAA). 
• Hands-on experience in extracting data from databases like (Azure SQL DB, MySQL/, Cosmos DB etc.), Python/Unix shell Scripting. 

• Experience with agile methodologies and project management tools (e.g., Jira, Confluence). 

 Technologies we use: Power BI, Databricks, Python, PySpark, Scripting (Power shell, Bash), Azure SQL DW/Synapse, Azure Tabular/Cubes, Azure DevOps, Git, Terraform, Snowflake