Power BI & Microsoft Fabric Consultant - Contract Position at Ampera Technologies · Bengaluru (Bangalore), Delhi, Gurugram, Noida, Ghaziabad, Faridabad, Chennai · 5 - 10 years · Profitable · Posted 5 May 2026

Power BI & Microsoft Fabric Consultant - Contract Position
Role Overview
We are seeking an experienced Power BI & Microsoft Fabric Consultant to partner with our BI team for a short-term engagement focused on capability building, governance setup, and platform enablement.
The primary objective of this role is to upskill the team and establish a robust, scalable foundation for Power BI and Microsoft Fabric—covering security, governance, administration, and best practices—so that the team can independently manage and scale the platform post-engagement.
This is a hands-on + coaching role, not just advisory.
Key Responsibilities
1. Power BI & Fabric Enablement
- Conduct structured training sessions and workshops on:
- Power BI (Pro + Fabric-integrated experiences)
- Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2, Pipelines, etc.)
- Build foundational understanding of:
- End-to-end analytics workflows in Fabric
- Integration between Power BI and Fabric workloads
- Data Lake will be Snowflake
2. Governance & Security Framework
- Design and implement Power BI & Fabric governance model, including:
- Workspace strategy (Dev/Test/Prod separation)
- Naming conventions and standards
- Content lifecycle management
- Establish security architecture:
- Role-based access control (RBAC)
- Row-Level Security (RLS) / Object-Level Security (OLS)
- Data access patterns across Fabric and Power BI
- Define data sharing and access control processes
3. Administration & Platform Setup
- Configure and optimize:
- Power BI tenant settings
- Fabric capacity (capacity planning, workload management)
- Monitoring and usage metrics
- Set up:
- Deployment pipelines
- CI/CD best practices (where applicable)
- Audit logs and governance controls
4. Best Practices & Standards
- Define and document:
- Development standards (data modeling, DAX, report design)
- Performance optimization guidelines
- Dataset/reusable semantic model strategy
- Establish certification and promotion workflows for datasets and reports
5. Hands-On Implementation
- Work alongside the team to:
- Build or refactor key dashboards/reports using best practices
- Set up Fabric artifacts (Lakehouse/Warehouse/Pipelines)
- Ensure real use cases are implemented, not just theoretical training
6. Knowledge Transfer & Self-Sufficiency
- Provide:
- Playbooks, SOPs, and governance documentation
- Recorded sessions and training materials
- Mentor team members through:
- Office hours / Q&A sessions
- Code and architecture reviews
- Ensure the team can independently:
- Manage Fabric capacity
- Govern Power BI environment
- Implement secure and scalable solutions
Expected Outcomes (End of Engagement)
- Fully defined and implemented Power BI & Fabric governance framework
- Configured and optimized Fabric capacity + Power BI tenant
- Established security and access control processes
- Documented standards, playbooks, and operating model
- BI team capable of independent development, administration, and governance
Required Skills & Experience
Must-Have
- 5+ years of experience in Power BI development and administration
- Hands-on experience with Microsoft Fabric (end-to-end)
- Strong expertise in:
- Power BI governance and tenant administration
- Fabric capacity management
- Security models (RLS, RBAC, data access controls)
- Experience setting up enterprise BI governance frameworks
- Proven track record of training and mentoring teams
Good-to-Have
- Experience with data platforms (Snowflake, Azure, etc.)
- Knowledge of CI/CD for Power BI (DevOps integration)
- Familiarity with data catalog and lineage tools (e.g., Atlan, Alation)
- Understanding of modern data architecture patterns

About Ampera Technologies
About
At Ampera Technologies, we empower businesses with cutting-edge data analytics, quality assurance, and data engineering solutions
Company social profiles
Similar jobs (10)
About the Role
We are looking for an experienced Power BI Architect to lead enterprise-wide BI initiatives. This role will be responsible for designing, implementing, and governing scalable Power BI solutions across the organization. The ideal candidate will play a key role in establishing best practices, driving adoption, and owning the overall BI architecture within the Center of Excellence (CoE).
Key Responsibilities
- Lead end-to-end implementation of Power BI solutions across the enterprise
- Design scalable, secure, and high-performance BI architecture
- Act as the Power BI Architect, providing technical leadership and direction
- Own and drive BI governance, standards, and best practices within the CoE
- Collaborate with business and technology teams to translate requirements into robust BI solutions
- Define data modeling strategies, reporting frameworks, and dashboard standards
- Ensure data accuracy, consistency, and performance optimization across reports
- Support and guide development teams in Power BI implementation
- Enable enterprise-wide adoption of Power BI through training, documentation, and mentorship
- Work closely with IT/technology teams to integrate Power BI with data platforms and enterprise systems
Required Skills & Qualifications
- 10+ years of experience in BI/Data Analytics, with strong focus on Power BI
- Proven experience in enterprise-wide Power BI implementation
- Strong expertise in:
- Power BI (Desktop, Service, Gateway, Dataflows)
- Data Modeling (Star Schema, Snowflake Schema)
- DAX, Power Query (M language)
- Experience in designing and implementing BI architecture at scale
- Strong understanding of data warehousing concepts and ETL processes
- Experience working within a Center of Excellence (CoE) model
- Excellent stakeholder management and communication skills
Preferred Skills
- Experience with Azure (Azure Synapse, Data Factory, Data Lake)
- Knowledge of DevOps practices for Power BI (CI/CD pipelines)
- Exposure to governance tools and security frameworks
- Certification in Power BI / Microsoft Data Platform
Job Description:
Experience: 10+ Years
Job Summary
We are looking for an experienced Azure Fabric Data Architect to lead the design and implementation of an enterprise data platform on Microsoft Fabric. The role involves architecting scalable data solutions, defining data governance, and enabling AI-driven analytics for a global financial services client.
Key Responsibilities
- Design end-to-end data architecture using Microsoft Fabric.
- Build enterprise Lakehouse, Data Warehouse, and OneLake solutions.
- Define data ingestion, ETL/ELT, governance, security, and performance strategies.
- Lead architecture for AI-powered analytics, AI Agents, and enterprise chatbots using Azure AI services.
- Work with business stakeholders to translate requirements into technical solutions.
- Mentor engineering teams and provide technical leadership.
Required Skills
- Microsoft Fabric (Data Factory, Lakehouse, Data Warehouse, OneLake)
- Azure Data Engineering
- Power BI
- Azure AI Services / Azure OpenAI
- Data Architecture & Data Modeling
- SQL, Python
- Azure DevOps, CI/CD
- Strong stakeholder management and solution design experience
Preferred: Experience in Capital Markets or Financial Services and Microsoft Azure/Fabric certifications.
NOTE: One technical round is mandatory to be taken F2F from office.
Job Summary
We are seeking a skilled and detail-oriented Power BI Developer to design, develop, and maintain enterprise-level BI solutions. The ideal candidate should have strong expertise in Power BI, DAX, SQL, Data Modeling, and performance optimization tools such as DAX Studio, Tabular Editor, and ALM Toolkit. The candidate will collaborate with business stakeholders to transform data into actionable insights and deliver high-quality dashboards and reports.
Key Responsibilities
- Design, develop, and maintain interactive Power BI dashboards and reports.
- Create complex DAX measures, calculated columns, and calculated tables to meet business requirements.
- Develop and optimize SQL queries, stored procedures, views, and ETL processes.
- Design and implement scalable Star Schema and Snowflake Data Models.
- Perform report and model performance tuning using DAX Studio.
- Utilize Tabular Editor for model management, calculation groups, best practice analysis, and metadata enhancements.
- Manage model deployment, comparison, and version control using ALM Toolkit.
- Configure and manage Power BI Workspaces, Apps, Gateways, and Security (RLS/OLS).
- Work extensively with Power BI Service/Web Experience, including dataset refresh schedules, deployment pipelines, subscriptions, and workspace administration.
- Collaborate with business users to gather and analyze reporting requirements.
- Ensure data accuracy, governance, security, and report performance.
- Troubleshoot data-related issues and implement effective solutions.
- Create technical documentation and provide knowledge transfer to support teams.
Required Skills
Technical Skills
- Strong experience in Microsoft Power BI Development.
- Expertise in DAX (Data Analysis Expressions).
- Advanced knowledge of SQL Server/T-SQL and query optimization.
- Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables).
- Hands-on experience with Tabular Editor.
- Experience using DAX Studio for model and query performance tuning.
- Experience with ALM Toolkit for model comparison and deployment.
- Strong understanding of Power BI Service/Web Experience.
- Knowledge of Power Query (M Language).
- Experience with Row-Level Security (RLS) and data governance.
- Understanding of data warehousing and ETL concepts.
Business Intelligence Analyst - 2
Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.
Job Summary:
The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.
This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.
Key Responsibilities:
· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.
· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.
· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.
· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.
· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.
· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.
· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.
· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.
· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.
· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.
· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.
· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.
Required Skills & Qualifications:
· 5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.
· Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.
· Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.
· Strong experience with SSRS and enterprise reporting.
· Experience with SSAS Tabular and/or Multidimensional models.
· Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.
· Experience working with OData and enterprise data integration.
· Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.
· Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.
· Strong analytical, troubleshooting, and root-cause analysis skills.
· Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.
· Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.
- Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.
Location: Wakad, Pune
No of position: 1
Shift- 2PM to 11PM; (post 6pm can work from home when visiting office)
Mode of work: Hybrid (3 days from office)
Job Summary
We are looking for a skilled Power BI Developer with 3–5 years of experience in developing interactive dashboards, reports, and business intelligence solutions. The candidate should have strong expertise in Power BI, DAX, Power Query, data modeling, and SQL, with the ability to translate business requirements into actionable insights.
Key Responsibilities
- Design, develop, and maintain interactive dashboards and reports using Microsoft Power BI.
- Develop complex DAX measures, calculated columns, and KPIs to meet business reporting requirements.
- Perform data extraction, transformation, and loading using Power Query (M language).
- Design and optimize data models, including star and snowflake schemas and relationships.
- Write and optimize SQL queries to retrieve and validate data from relational databases.
- Configure Power BI Service workspaces, scheduled refreshes, gateways, and report access.
- Implement Row-Level Security (RLS) and appropriate data access controls.
- Optimize report performance, DAX calculations, and data models.
- Collaborate with business stakeholders, business analysts, and data engineering teams to understand reporting requirements.
- Perform data validation, troubleshoot reporting issues, and ensure data accuracy.
- Support report deployments, enhancements, and production issues.
- Maintain technical documentation and follow BI development best practices.
Required Technical Skills
- 3–5 years of hands-on experience in Power BI development.
- Strong proficiency in Power BI Desktop and Power BI Service.
- Good experience with DAX, including measures, filter context, and time intelligence.
- Strong knowledge of Power Query and M language.
- Experience in data modeling, relationships, calculated tables, and star schema design.
- Proficiency in SQL, including joins, subqueries, aggregations, and query optimization.
- Experience with report publishing, scheduled refreshes, gateways, and workspace management.
- Knowledge of Row-Level Security (RLS) and report performance optimization.
- Experience integrating data from SQL databases, Excel, and other business data sources.
Good to Have
- Exposure to Microsoft Fabric, Azure Data Services, or Azure SQL.
- Knowledge of ETL/ELT concepts and data warehouse fundamentals.
- Experience with Power BI deployment pipelines and version control.
- Familiarity with incremental refresh and large dataset optimization.
- Experience working in Agile/Scrum environments.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
- Strong analytical, problem-solving, and communication skills.
- Ability to work independently and collaborate effectively with cross-functional teams.
Selection Criteria
Candidates should demonstrate practical experience in building Power BI reports, writing DAX measures, transforming data using Power Query, designing data models, and troubleshooting report performance issues.
NOTE: Technical rounds are mandatory to be taken F2F from Pune office on the same day.
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
About the Role
We are seeking an experienced Power BI Developer to design, develop, and maintain interactive dashboards and reports that drive data-informed decision-making across the business. The ideal candidate will have deep expertise in DAX, Power Query, data modeling, and enterprise data integration, along with strong communication skills to coordinate directly with clients, and the ability to mentor junior team members.
Key Responsibilities
- Design, develop, and maintain interactive Power BI dashboards and reports
- Develop complex DAX measures, calculated columns, and KPIs
- Build and optimize data models using star and snowflake schema design
- Perform data transformation and cleansing using Power Query (M Language)
- Connect Power BI with enterprise data sources including SQL Server, Oracle, PostgreSQL, APIs, Excel, and SharePoint
- Optimize report performance and troubleshoot data/report issues
- Implement Row-Level Security (RLS) and manage Power BI Service workspaces
- Partner with business stakeholders and clients to gather and translate reporting requirements
- Mentor junior developers and contribute to overall BI solution architecture
Required Skills & Experience
- 3-4 years of hands-on Power BI development experience
- Strong proficiency in Power BI Desktop, Power BI Service, DAX, Power Query, SQL, and data modeling
- Experience with relational databases such as SQL Server, Oracle, or PostgreSQL
- Solid understanding of ETL processes and performance tuning
- Excellent analytical, communication, and problem-solving skills, with the ability to coordinate directly with clients and stakeholders
- Basic understanding of Object-Level Security (OLS) in Power BI (not mandatory, but working knowledge is a plus)
- Experience with Incremental Refresh (Incremental Load) and DAX optimization for large datasets
- Hands-on experience handling large datasets (4GB+) in Power BI/Power Query, along with performance and query optimization techniques
- Exposure to big data platforms such as Databricks
- Strong working knowledge of DAX queries and functions
- Familiarity with Power BI MCP Server and AI-driven features (e.g., Copilot in Power BI, natural language querying via MCP)
Preferred / Nice-to-Have Skills
- Experience with Microsoft Fabric
- Knowledge of Azure Data Factory, Azure Synapse, or Azure SQL
- Microsoft Power BI Certification
Eligibility Criteria
- Immediate joiners only — maximum notice period of 15 days
- Must be available to work the 4:00 PM – 11:40 PM IST shift
- Comfortable working in a 100% remote setup
- Excellent communication skills, as the role requires regular coordination with clients
Solution Architect – AZURE Data Engineering
Job Overview
We are looking for an experienced Solution Architect – Data Engineering with strong expertise in designing data solutions and hands-on experience with Azure, Synapse, PySpark, Data Warehousing, and Data Lakes. The ideal candidate should have strong architectural and data engineering knowledge.
Key Responsibilities
- Design and implement scalable data architecture and solutions.
- Develop and manage Data Warehouse and Data Lake architectures.
- Design data platforms using Medallion Architecture.
- Lead Data Engineering and ETL activities.
- Work with Azure Synapse Analytics for data processing and analytics.
- Develop data solutions using PySpark / Apache Spark.
- Define and implement data validation and data quality processes.
- Collaborate with business, data, and technology teams to deliver effective data solutions.
Required Skills
- Strong experience in Solution Architecture / Data Architecture.
- Strong knowledge of Data Warehouse and Data Lake architecture.
- Good understanding of Medallion Architecture.
- Strong experience in Data Engineering and ETL.
- Hands-on experience with Microsoft Azure and Azure Synapse Analytics.
- Strong knowledge of PySpark / Apache Spark.
- Experience with Data Validation and Data Quality.
- Good communication and stakeholder management skills.
Experience
8+ Years
Technical Lead
Job Description
Role Overview
We are seeking a highly skilled Data Engineering Lead with minimum of 5 years of hands-on experience in Azure data engineering, data warehousing, and automation-driven integration. The ideal candidate should be a proven technical lead, capable of driving end-to-end
project delivery and working closely with customer teams. This is a Work from Office / Customer Site role.
Roles and Responsibilities
• Lead the design, development, and delivery of data engineering and automation projects.
• Architect and implement ETL/ELT pipelines using Azure Data Factory.
• Design and manage enterprise data warehouses including dimensional modeling and
schema optimization.
• Manage Azure components including Storage Accounts, Data Lakes, Azure SQL, and Synapse.
• Drive automation initiatives across data ingestion and transformation workflows.
• Collaborate with business and technical stakeholders to translate requirements into scalable solutions.
• Mentor team members and enforce engineering best practices.
• Serve as the technical anchor responsible for ensuring high-quality, on-time delivery.
Skills and Qualification
• Strong hands-on experience with Azure Data Factory, Azure Storage, Azure SQL/Synapse.
• Deep understanding of data warehousing concepts: star/snowflake schemas, fact/dimension modeling.
• Experience with automation-led data engineering solutions.
• Strong troubleshooting, optimization, and analytical skills.
• Excellent communication and stakeholder management abilities.
• Proven experience as a Technical Lead leading teams and delivery.
Must Have
• Min of 5 years of relevant data engineering experience.
• Strong Azure Data Engineering and Data Warehousing expertise.
• Proven Technical Lead experience.
• Ability to work from office and customer site.
• Strong ownership mindset with a focus on quality and delivery excellence.
Sr. Data Engineer
Location: Pune
Responsibilities
· Lead the end-to-end design and development of scalable, high-performance data pipelines and ETL/ELT frameworks aligned with modern data engineering best practices.
· Architect complex data integration workflows that bring together structured, semi-structured, and unstructured data from both cloud and on-premise sources.
· Build robust real-time, batch, and on-demand pipelines with built-in observability—monitoring, alerting, and automated error handling.
· Partner with analysts, data scientists, and business leaders to define and deliver reliable data models, quality frameworks, and SLAs that power key business insights.
· Ensure optimal pipeline performance and throughput, with clearly defined SLAs and proactive alerting for data delivery or quality issues.
· Collaborate with platform, DevOps, and architecture teams to build secure, reusable, and CI/CD-enabled data workflows that align with enterprise architecture standards.
· Establish and enforce the best practices in source control, code reviews, testing automation, and continuous delivery for all data engineering components.
· Lead root cause analysis (RCA) and preventive maintenance for critical data failures, ensuring minimal business impact and continuous service improvement.
· Guide the team in establishing standards for data modeling, transformation logic, and governance, ensuring long-term maintainability and scalability.
· Design and execute comprehensive testing strategies—unit, integration, and system testing—ensuring high data reliability and pipeline resilience.
· Monitor and fine-tune data pipeline and query performance, optimizing for reliability, scalability, and cost-efficiency.
· Create and maintain detailed technical documentation, including data architecture diagrams, process flows, and integration specifications for internal and external stakeholders.
· Facilitate and lead discussions with business and operational teams to understand data requirements, prioritize initiatives, and drive data strategy forward.
Qualifications
· 7 to 10 years of hands-on experience in data engineering roles with a proven record of building scalable and secure data platforms.
· Over 5 years of experience in scripting languages such as Python for data processing, automation, and ETL development.
· 4+ years of experience with Snowflake, including performance tuning, security model design, and advanced SQL development.
· 5+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion.
· 5+ years of experience in writing complex, highly optimized SQL queries on large datasets.
· Proven experience integrating and managing APIs, JSON, XML, and webhooks for data acquisition.
· Hands-on experience with cloud platforms (Azure/AWS) and orchestration tools like Apache Airflow or equivalent.
· Experience with CI/CD pipelines, automated testing, and code versioning tools (e.g., Git).
· Familiarity with dbt or similar transformation tools and best practices for modular transformation development.
· Exposure to data visualization tools like Power BI for supporting downstream analytics is a plus.
· Strong interpersonal and communication skills with the ability to lead discussions with technical and business stakeholders.
Education
Bachelor’s or Master’s degree in Computer Science/Information technology or related field.
Equivalent academic and work experience can be considered.
15+ years of IT Delivery and Technology Services experience.
15+ years managing large offshore delivery organizations.
Proven leadership of portfolios exceeding 200+ resources.
Financial Services or Banking experience is a MUST
Extensive technical experience in Data Engineering, Data Platforms, Data Brics.
Cloud Data Transformation Programs, Data Warehousing, Azure Data Platform and compliance experience













