Power BI Architect at Ampera Technologies · Chennai, Bengaluru (Bangalore), Gurugram, Hyderabad · 10 - 15 years · Profitable · Posted 14 Sep 2026

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

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)

We are seeking a talented Senior Power BI Engineer to join our team and deliver high-quality business intelligence solutions for our clients.
Technical Skills:
- Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
- DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
- Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
- Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
- SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
- Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
- Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
- API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
- Knowledge of data visualization best practices and UI/UX principles for dashboard design
- Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)
- Looking out for only immediate joiners
Responsibilities:
- Design, develop, and deploy interactive Power BI dashboards and reports for client projects
- Build and optimize data models using star schema and snowflake schema design patterns
- Develop complex DAX measures and calculated columns to support business requirements
- Connect to and integrate data from multiple sources including SQL databases, Excel, APIs, cloud platforms, and data warehouses
- Implement data transformation and cleansing using Power Query (M language)
- Collaborate with clients and stakeholders to gather requirements and translate business needs into technical specifications
- Optimize report performance through query optimization, aggregations, and efficient data modeling
- Configure and manage Power BI Service including workspaces, datasets, dataflows, and row-level security (RLS)
- Create and maintain documentation for data models, reports, and development processes
- Provide training and support to end-users on Power BI reports and dashboards
- Design and implement custom visualizations using Power BI custom visuals and third-party visual libraries.
- Implement conditional formatting, dynamic titles, and dynamic content based on user selections
- Stay current with Power BI updates, new features, and industry best practices
Role Summary
We are looking for an accomplished PowerBi Solution architect to architect and drive scalable, insight-rich analytics solutions across the enterprise. This role sits at the intersection of data engineering, business intelligence, and solution architecture—ideal for a candidate with mastery of modern visualization tools, modeling strategies, and end-to-end data integration.
Key Responsibilities
● Architect and implement scalable Power BI solutions that span data modeling, integration, visualization, and performance tuning
● Design and lead the development of enterprise-grade data models using Star, Snowflake, and composite architecture
● Lead the integration of cloud-based data warehouse platforms including Oracle ADW and Snowflake
● Lead the development of scalable, interactive dashboards using Power BI, driving self-service analytics across business units
● Develop ETL and ELT pipelines to ingest and transform structured, semi-structured, and API-driven data sources
● Implement automated data ingestion and transformation using Python and shell scripting for performance and reliability
● Handle and harmonize data from diverse API sources across applications, platforms, and third-party services
● Deliver interactive dashboards and storytelling experiences tailored for executives, analysts, and operational teams
● Optimize semantic layers, DAX calculations, and deployment pipelines for reusability and governance
● Mentor BI developers and analysts, setting architectural standards and fostering collaboration across analytics teams
● Collaborate with cross-functional teams to translate strategic business goals into robust analytics solutions
Required Qualifications
● 8+ years in Power BI development and analytics Engineering, with 3+ years in architecture leadership roles
● Strong command of DAX, M Query, and performance tuning best practices
● Deep experience in data modeling (Star, Snowflake, composite) and cross-platform architecture
● Hands-on expertise in Oracle ADW, Snowflake, and API-based data ingestion
● Proficiency in Python, shell scripting, and automation of analytics pipelines
● Strong background in ETL/ELT development, data quality assurance, and deployment orchestration
● Demonstrated success in solution architecture across cloud ecosystems such as Azure, Oracle OCI
Preferred Skills
● Experience with Power BI Premium capacity management and deployment pipelines
● Experience with DAX, M language, and performance tuning technique
● Experience integrating third-party BI tools, data lakehouses, and stream processing services
● Effective communicator capable of translating technical architecture into business value
● Exposure to MS Fabric and Azure Data Factor
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.

Key Skills:
Technical Skills
- Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
- DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
- Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
- Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
- SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
- Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
- Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
- API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
- Knowledge of data visualization best practices and UI/UX principles for dashboard design
- Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)
Additional Required Qualifications
- Bachelor’s degree in computer science, Information Systems, Business Analytics, or related field
- Strong analytical and problem-solving abilities
- Excellent communication skills to work with both technical and non-technical stakeholders
- Ability to manage multiple projects and prioritize tasks effectively
- Detail-oriented with commitment to delivering high-quality work
- Client-facing experience with ability to gather requirements and present solutions
Preferred Qualifications
- Microsoft Power BI certification (PL-300 or equivalent)
- Experience with Azure ecosystem (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database)
- Knowledge of other Microsoft BI tools (SSRS, SSAS, Excel Power Pivot)
- Familiarity with Python or R for advanced analytics integration
- Experience with Dataflows and incremental refresh strategies
- Understanding of API development for custom visuals or Power BI embedded solutions
- Experience working in Agile/Scrum development environments
Title : Power BI and Microsoft Fabric
Experience : 5+ years
Location : Remote
Work type : Remote
Notice Period : Immediate
Work Day : Mon to Fri
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 architecture

Only Immediate joiners are considered.
Key Skills:
Technical Skills
- Power BI Development: 4-5 years of hands-on experience developing Power BI reports, dashboards, and data models
- DAX: Strong proficiency in DAX (Data Analysis Expressions) for creating measures, calculated columns, and complex calculations
- Power Query / M Language: Expertise in data transformation and ETL processes using Power Query
- Data Modeling: Solid understanding of dimensional modeling, star schema, and data warehouse concepts
- SQL: Proficient in SQL for data extraction, manipulation, and querying relational databases
- Power BI Service: Experience with Power BI Service administration, workspace management, scheduled refreshes, and deployment pipelines
- Custom Visualizations: Experience creating and configuring custom visuals, including use of AppSource visuals and custom visual development using Power BI Visuals SDK
- API Integration: Hands-on experience with Power BI REST APIs for automating deployments, managing workspaces, and embedding reports
- Knowledge of data visualization best practices and UI/UX principles for dashboard design
- Experience with data source connectivity (SQL Server, Azure SQL, Oracle, SAP, Excel, APIs, web services)
Additional Required Qualifications
- Bachelor’s degree in computer science, Information Systems, Business Analytics, or related field
- Strong analytical and problem-solving abilities
- Excellent communication skills to work with both technical and non-technical stakeholders
- Ability to manage multiple projects and prioritize tasks effectively
- Detail-oriented with commitment to delivering high-quality work
- Client-facing experience with ability to gather requirements and present solutions
Preferred Qualifications
- Microsoft Power BI certification (PL-300 or equivalent)
- Experience with Azure ecosystem (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database)
- Knowledge of other Microsoft BI tools (SSRS, SSAS, Excel Power Pivot)
- Familiarity with Python or R for advanced analytics integration
- Experience with Dataflows and incremental refresh strategies
- Understanding of API development for custom visuals or Power BI embedded solutions
- Experience working in Agile/Scrum development environments
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
Job description: Data Architect – Databricks / AWS
Job Summary
We are looking for an experienced Data Architect to define and drive the target data architecture for the Horizon MVP and its future evolution. The role will be responsible for designing a scalable, secure, governed cloud data platform covering ingestion, storage, processing, analytics, APIs, and downstream data consumption.
The architect will work closely with Data Engineering, Backend, DevOps, QA, and business stakeholders to establish architecture standards and ensure the platform is ready for advanced analytics, AI/ML, vector storage, and future LLM-based capabilities.
- Job Title: Data Architect
- Experience: 8+ Years
- Relevant Architecture Experience: 3+ Years in Data Architecture
- Location: Chennai / Pune
- Work Mode: Hybrid – 3 Days WFO
- Budget: Up to 24 LPA
- Payroll: Haparz
- Notice Period: Immediate Preferred
Key Responsibilities
- Define the target data architecture for the Horizon MVP and establish an architecture roadmap for future scalability.
- Design end-to-end architecture covering data ingestion, storage, processing, serving, reporting, APIs, and downstream applications.
- Establish canonical data models and schemas for travel signals, corridors, sources, evidence, scores, and generated insights.
- Define data normalization strategies for structured, semi-structured, and unstructured data from multiple external sources.
- Design and govern the Databricks platform architecture, including Unity Catalog, data schemas, access controls, and governance standards.
- Establish data-retention, lineage, data-quality, security, privacy, and compliance controls.
- Define secure integration patterns between Databricks, AWS PRODIGY, SharePoint, external APIs, and downstream applications.
- Design scalable data processing for 30-day signal windows, convergence/divergence scoring, corridor ranking, and spike detection.
- Define architecture patterns that support future vector storage, embeddings, LLM integration, and multi-year analytics.
- Design reliable batch and API-driven ingestion frameworks for structured and unstructured data.
- Review technical designs, identify architectural risks, and provide technical direction to engineering teams.
- Guide backend, data engineering, DevOps, and QA teams in implementing architecture standards.
- Ensure architecture decisions align with enterprise security, RBAC, PII handling, privacy, and operational requirements.
- Communicate architecture decisions, trade-offs, and technical recommendations effectively to technical and business stakeholders.
What We’re Looking For
- 8+ years of experience in data engineering, data platforms, or data architecture, with at least 3+ years in a Data Architect capacity.
- Strong hands-on experience designing cloud-based data platforms, lakehouses, or analytical platforms.
- Advanced knowledge of Databricks, Apache Spark/PySpark, Delta Lake, and Unity Catalog.
- Strong understanding of AWS data services, IAM, networking, and secure cloud integration patterns.
- Strong expertise in data modelling, metadata management, data lineage, data quality, retention, and governance.
- Experience architecting batch and API-based ingestion pipelines for structured, semi-structured, and unstructured data.
- Understanding of AI/ML workloads, feature pipelines, vector databases, embeddings, and LLM integration patterns.
- Experience designing APIs and downstream data-serving architectures.
- Strong knowledge of PII protection, RBAC, data privacy, and enterprise security controls.
- Excellent architectural communication and stakeholder-management skills.
10+ years of experience in Data Architecture, Data Engineering, or Data Platforms
• Strong expertise in IBM DB2 / On-Prem Relational Databases
• Strong expertise in PostgreSQL
• Hands-on experience with the Azure Data Ecosystem, including:
▪ Azure Data Factory (ADF)
▪ Azure Data Lake Storage Gen2 (ADLS Gen2)
▪ Azure Databricks / Synapse Analytics
▪ Azure Event Hub / Service Bus
▪ Azure Functions





