Power BI / Azure Data Engineer

Job description

Position: Power BI / Azure Data Engineer Job Description: Power BI / Azure Data Engineer – Job Description Position : Power BI and Azure Data Engineer Job Summary We are looking for a skilled and detail-oriented Power BI / Data Analytics Engineer with 4–6 years of experience in business intelligence, data engineering, and cloud analytics platforms. The candidate will be responsible for designing, developing, and maintaining scalable BI solutions, automated data pipelines, and interactive dashboards to support business decision-making. The ideal candidate should have strong expertise in Power BI, Advanced SQL, and Python, along with experience in modern cloud data platforms, ETL/ELT tools, and data transformation frameworks. The role requires close collaboration with business stakeholders, data engineers, architects, and analytics teams in a fast-paced environment. Key Responsibilities Design, develop, and maintain interactive dashboards, reports, and semantic models using Power BI. Create optimized data models, DAX calculations, KPIs, measures, Power Query transformations, and enterprise reporting solutions. Develop and maintain complex SQL queries, stored procedures, and database objects for analytics and reporting. Build and maintain scalable ETL/ELT pipelines using Azure Data Factory, Databricks (PySpark/SQL), and modern data integration frameworks. Develop Python scripts for automation, data processing, validation, and workflow optimization. Integrate data from multiple enterprise systems including SQL Server, Oracle, SAP, ERP, APIs, Azure platforms, and cloud data warehouses. Work with modern cloud platforms including Microsoft Azure, Databricks, Snowflake, Microsoft Fabric, Synapse Analytics, and SQL Server. Design dimensional data models (Star Schema/Snowflake Schema) and publish curated datasets for enterprise analytics. Optimize Power BI reports through DAX optimization, query tuning, incremental refresh, aggregation, and performance best practices. Implement Row-Level Security (RLS), workspace governance, deployment pipelines, and Power BI Service administration. Collaborate with Data Engineering teams to design scalable Medallion Architecture (Bronze–Silver–Gold) and Lakehouse solutions. Support deployment, release management, CI/CD implementation, and migration across Development, UAT, and Production environments. Maintain technical documentation for dashboards, datasets, pipelines, and operational runbooks. Troubleshoot reporting, performance, data quality, and production issues while ensuring high availability of analytics solutions. Work closely with business stakeholders to gather reporting requirements and translate them into scalable technical solutions. Primary Skills (Must Have) Power BI & Analytics Strong hands-on experience developing enterprise Power BI reports, dashboards, and semantic models. Expertise in DAX, Power Query (M), calculated measures, calculated columns, relationships, and data modeling. Experience publishing and managing datasets using Power BI Service. Knowledge of Row-Level Security (RLS), Incremental Refresh, Gateways, Deployment Pipelines, Workspace Management, and report performance optimization. Experience building executive dashboards, KPI scorecards, and self-service BI solutions. Programming Languages Advanced SQL (essential) for query optimization, stored procedures, and analytics. Strong Python programming for automation, data processing, scripting, and ETL development. Data Engineering & ETL Hands-on experience building ETL/ELT pipelines using Azure Data Factory and Databricks (PySpark/SQL). Strong understanding of Medallion Architecture (Bronze, Silver, Gold). Working knowledge of Delta Lake, schema evolution, MERGE/Upsert, and ACID transactions. Experience with orchestration, monitoring, and pipeline optimization. Data Warehousing & Cloud Platforms Experience with Microsoft Azure, Microsoft Fabric, Databricks, Snowflake, Azure Synapse Analytics, SQL Server, or equivalent cloud platforms. Strong understanding of cloud data warehousing, Lakehouse architecture, and dimensional modeling. Data Modeling & Database Strong understanding of Star Schema, Snowflake Schema, and dimensional modeling. Experience working with SQL Server, Oracle, MySQL, or cloud databases. Knowledge of semantic modeling and enterprise reporting architecture. Engineering Best Practices Experience using Git/version control. Experience implementing CI/CD pipelines using Azure DevOps or GitHub. Familiarity with Agile/Scrum methodologies. Strong documentation, troubleshooting, and code review practices. Data Governance & Security Experience implementing metadata management, lineage, and governance using Microsoft Purview or Microsoft Fabric governance capabilities. Knowledge of RBAC, workspace security, data privacy, PII handling, and encryption best practices. Secondary Skills (Good to Have) Exposure work with Microsoft Fabric (Lakehouse, Warehouse, Data Factory, OneLake, Real-Time Analytics). Exposure to other cloud analytics platforms such as AWS, Snowflake Qualification Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. 5–8 years of experience in Power BI, Data Analytics, and Data Engineering. Strong analytical, troubleshooting, communication, and stakeholder management skills. Ability to work effectively with cross-functional business and technical team. Preferred Certifications Microsoft Power BI Data Analyst Associate Azure Data Engineer Associate Databricks Fundamentals or Associate Certification Tools & Technologies Power BI Desktop & Power BI Service Azure Data Factory (ADF) Azure Databricks (PySpark & Spark SQL) SQL Server / Azure SQL / Oracle / MySQL Python Advanced SQL DAX & Power Query Azure Data Lake Storage (ADLS Gen2) Location: IN-GJ-Ahmedabad, India-Ognaj (eInfochips) Time Type: Full time Job Category: Engineering Services