Analytics Engineer (Power BI & Semantic Modeling) at The Blue Owls Solutions · Pune · 2 - 5 years · ₹10L - ₹18L / yr · Bootstrapped · Posted 18 May 2026

Analytics Engineer (Power BI & Semantic Modeling)
Tech Stack: Power BI, DAX, SQL, Microsoft Fabric
The Role
You are the bridge between raw data and business decisions.You will be responsible for taking processed data and transforming it into high-performance, scalable semantic models. Your goal is to ensure that the data is structured so perfectly that building a report becomes the easiest part of the job.
Key Responsibilities
- Semantic Architecture: Design and build Star Schemas that serve as the single source of truth.
- Gold Layer Ownership: Transform Silver-layer tables into business-ready dimensions and facts.
- Advanced DAX: Write clean, optimized DAX for complex business logic (not just basic sums).
- Visual Storytelling: Build intuitive Power BI reports that focus on clarity and actionable insights.
- Performance Tuning: Optimize models for fast load times, query folding, and efficient refreshes.
- Stakeholder Sync: Work with clients to define KPIs and ensure the model actually answers their questions.
What We’re Looking For
- Modeling DNA: You think in Star Schemas and understand why a flat table is a bad idea for Power BI.
- DAX Proficiency: Deep understanding of Filter vs. Row context and time-intelligence functions.
- SQL Fluency: You can write complex queries to validate your models against the source data.
- Visual Logic: You have a sharp eye for UI/UX—no cluttered dashboards or "chart junk."
- Fabric Familiarity: Experience with (or a strong desire to learn) the Microsoft Fabric ecosystem.
Why Work With Us?
- Microsoft Partner Edge: Hands-on with the latest Fabric and Power BI features before they go mainstream.
- Flat Hierarchy
- Technical Autonomy: You own the Gold layer architecture; you set the modeling standards.
- High-Stakes Projects: Solve real data problems for enterprise clients in Healthcare and Government.
- Career Growth: Structured learning paths to master the wider Azure Data & AI stack.
- Competitive Pay
- Flexible Hours

About The Blue Owls Solutions
About
At TheBlueOwls, we are passionate about harnessing the power of data analytics and artificial intelligence to transform businesses and drive innovation. With a team of experts and cutting-edge technology, we help our clients unlock valuable insights from their data and leverage AI solutions to stay ahead in today's competitive landscape.
Our Founder
Our company was founded by Puran Ticku, an ex-Microsoft Architect with over 20+ years of experience in the field of data and digital health. Puran Ticku has a deep understanding of the potential of data analytics and AI and has successfully led transformative solutions for numerous organizations.
Our Expertise
We specialize in providing comprehensive data analytics services, helping businesses make data-driven decisions and uncover hidden patterns and trends. With our advanced AI capabilities, we enable our clients to automate processes, enhance productivity, and gain a competitive edge in their industries.
Our Approach
At TheBlueOwls, we believe that the key to successful data analytics and AI implementation lies in a holistic approach. We work closely with our clients to understand their unique challenges and goals, and tailor our solutions to meet their specific needs. Our team of skilled professionals utilizes state-of-the-art technology and industry best practices to deliver exceptional results.
Our Commitment
We are committed to delivering the highest level of quality and value to our clients. We strive for excellence in every project we undertake, ensuring that our solutions are not only effective, but also scalable and sustainable. With our deep domain expertise and customer-centric approach, we are dedicated to driving success for our clients and helping them achieve their business objectives.
Contact us today to learn more about how TheBlueOwls can empower your organization with data analytics and AI solutions that drive growth and innovation.
Tech stack
Candid answers by the company
We build and scale Data and AI solution across several verticals.
As Microsoft Solution Partners we are Azure Experts that help our clients unlock the value of their data.
Similar jobs (10)
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.

Experience: 7–10+ years | Industry Preference: Financial Services / BFSI
Role Overview
We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive
enterprise reporting, analytics, and data insights across the organization. This is a senior,
hands-on role requiring deep technical expertise across the Microsoft data and BI stack,
strong business acumen, and the ability to operate with minimal hand-holding. The ideal
candidate will act as a bridge between business leadership and technical teams, translating
complex business questions into scalable, reliable data models and executive-ready insights.
Key Responsibilities
Serve as the primary owner of enterprise reporting and BI solutions, from data
ingestion through executive dashboards.
Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using
STAR schema best practices.
Partner closely with business stakeholders and C-level executives to define KPIs,
metrics, and reporting requirements.
Lead and present weekly reporting and insights sessions with senior and executive
leadership.
Ensure data accuracy, consistency, and trust across all reports and analytics outputs.
Proactively identify data quality issues, root causes, and remediation strategies.
Drive automation of reporting, alerts, and data refresh processes to reduce manual
effort.
Collaborate with engineering, data, and application teams to align business logic with
source system data structures.
Mentor junior analysts and establish BI standards, best practices, and documentation.
Technical Skills – Data & Backend
Advanced SQL: complex queries, views, stored procedures, and validation against
source systems (RDN, Recovery Connect).
Azure Data Factory: build and manage copy pipelines from SQL sources to data
warehouses / dedicated pools.
Incremental refresh, parameterized pipelines, and schema replication.
Data warehouse design: STAR schema, fact vs dimension tables, handling deleted
records and SCDs.
Technical Skills – Reporting & Frontend
Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.
Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).
Query folding and performance optimization best practices.
Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.
Power Automate integration for alerts and workflow-driven notifications.
Data Quality & Analytics
Ability to clean, normalize, and reconcile data across multiple systems.
Strong troubleshooting skills when business definitions and data do not align.
Translate business terminology into accurate technical mappings and calculations.
Communication & Leadership
Serve as a key liaison between business stakeholders and technical teams.
Comfortable working directly with C-level executives and senior leadership.
Ability to lead executive-level meetings and clearly communicate insights.
Self-starter mindset with minimal hand-holding.
Qualifications
7–10+ years of experience in BI, analytics, or enterprise reporting roles.
Preferred experience in financial services or regulated environments.
Strong experience across the Microsoft BI ecosystem.
Preferred Certifications
Microsoft PL-300 (Power BI Data Analyst)
Microsoft DP-600 (Fabric Analytics Engineer)
Microsoft DP-700 (Fabric Data Engineer)
What Success Looks Like
Executive leadership trusts and relies on BI dashboards for decisions.
Reporting is automated, accurate, and scalable.
BI functions as a strategic partner to the business.
Job Summary
We are looking for an experienced professional with strong expertise in Power BI, Power Apps, Power Automate, Excel, data analysis, and executive reporting. The candidate will be responsible for developing interactive dashboards, automating business processes, analyzing data, and preparing management reports to support business decision-making.
Key Responsibilities
- Develop, maintain, and enhance interactive dashboards and reports using Power BI.
- Build Power Apps solutions to improve business processes and user productivity.
Required Technical Skills
- Power BI: Dashboard development, report creation, data modeling, and visualization.
- Power Apps: Canvas apps, forms, and business application development.
- Power Automate: Workflow automation, approvals, notifications, and process automation.
- Microsoft Excel: Advanced formulas, PivotTables, lookups, data cleaning, and analysis.
- Data Analysis: Data interpretation, trend analysis, KPI tracking, and business insights.
- Executive Reporting: Management dashboards, performance reports, and KPI presentations.
- DAX & Power Query: Data transformation, calculations, and report optimization.
Preferred Skills
- Experience integrating multiple data sources.
- Knowledge of Microsoft 365 and SharePoint.
- Understanding of business intelligence and reporting best practices.
- Strong analytical, problem-solving, and communication skills.
- Ability to interact with business stakeholders and senior management.
Experience and Qualification
- Minimum 5+ years of relevant experience in BI, data analytics, reporting, or Microsoft Power Platform.
- Hands-on experience with Power BI, Power Apps, Power Automate, and Excel.
Role Overview
We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive enterprise reporting, analytics, and data insights across the organization. This is a senior, hands-on role requiring deep technical expertise across the Microsoft data and BI stack, strong business acumen, and the ability to operate with minimal hand-holding. The ideal candidate will act as a bridge between business leadership and technical teams, translating complex business questions into scalable, reliable data models and executive-ready insights.
Key Responsibilities
· Serve as the primary owner of enterprise reporting and BI solutions, from data ingestion through executive dashboards.
· Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using STAR schema best practices.
· Partner closely with business stakeholders and C-level executives to define KPIs, metrics, and reporting requirements.
· Lead and present weekly reporting and insights sessions with senior and executive leadership.
· Ensure data accuracy, consistency, and trust across all reports and analytics outputs.
· Proactively identify data quality issues, root causes, and remediation strategies.
· Drive automation of reporting, alerts, and data refresh processes to reduce manual effort.
· Collaborate with engineering, data, and application teams to align business logic with source system data structures.
· Mentor junior analysts and establish BI standards, best practices, and documentation.
Technical Skills – Data & Backend
· Advanced SQL: complex queries, views, stored procedures, and validation against source systems (RDN, Recovery Connect).
· Azure Data Factory: build and manage copy pipelines from SQL sources to data warehouses / dedicated pools.
· Incremental refresh, parameterized pipelines, and schema replication.
· Data warehouse design: STAR schema, fact vs dimension tables, handling deleted records and SCDs.
Technical Skills – Reporting & Frontend
· Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.
· Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).
· Query folding and performance optimization best practices.
· Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.
· Power Automate integration for alerts and workflow-driven notifications.
Data Quality & Analytics
· Ability to clean, normalize, and reconcile data across multiple systems.
· Strong troubleshooting skills when business definitions and data do not align.
· Translate business terminology into accurate technical mappings and calculations.
Communication & Leadership
· Serve as a key liaison between business stakeholders and technical teams.
· Comfortable working directly with C-level executives and senior leadership.
· Ability to lead executive-level meetings and clearly communicate insights.
· Self-starter mindset with minimal hand-holding.
Qualifications
· 7–10+ years of experience in BI, analytics, or enterprise reporting roles.
· Preferred experience in financial services or regulated environments.
· Strong experience across the Microsoft BI ecosystem.
Preferred Certifications
· Microsoft PL-300 (Power BI Data Analyst)
· Microsoft DP-600 (Fabric Analytics Engineer)
· Microsoft DP-700 (Fabric Data Engineer)
What Success Looks Like
· Executive leadership trusts and relies on BI dashboards for decisions.
· Reporting is automated, accurate, and scalable.
· BI functions as a strategic partner to the business.
We are looking for a skilled Power BI / Power Platform Analyst with experience in data analysis, dashboard development, automation, and executive reporting. The ideal candidate should be proficient in Power BI, Power Apps, Power Automate, and advanced Excel to transform business data into actionable insights and improve operational efficiency.
Responsibilities
- Develop interactive dashboards and reports using Power BI to support business decision-making.
- Build and maintain applications using Microsoft Power Apps to streamline business processes.
- Design automated workflows using Power Automate to reduce manual tasks and improve efficiency.
- Perform data analysis, data validation, and data cleansing using Excel and other relevant tools.
- Prepare executive-level reports, KPI dashboards, and management presentations.
- Gather reporting requirements from stakeholders and translate business needs into analytical solutions.
- Integrate data from multiple sources and ensure data accuracy and consistency.
- Identify trends, performance gaps, and opportunities for process improvement.
Required Skills
- Strong experience in Power BI, Power Apps, and Power Automate.
- Advanced Excel skills, including PivotTables, lookup functions, and data analysis.
- Experience in dashboard development, KPI tracking, and executive reporting.
- Strong analytical, problem-solving, and data interpretation skills.
- Good communication and stakeholder management skills.
- Knowledge of SQL, DAX, Power Query, and data modelling is an added advantage.
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.
Hiring: Data Modeler
Experience: 6+ years
Location: Bangalore/Gurugram/Pune
Required Skills
- Hands-on experience in conceptual, logical, and physical data modeling.
- Strong knowledge of ER modeling, dimensional modeling, star/snowflake schemas, fact/dimension tables, and SCDs.
- Strong SQL skills for data profiling, validation, and quality checks.
- Experience with source-to-target mapping, data dictionaries, metadata, and data lineage.
- Proficiency in Erwin, ER/Studio, or similar modeling tools.
- Exposure to Snowflake, Databricks, Redshift, SQL Server, or other data platforms.
- Understanding of data governance, UAT, reconciliation, and Agile methodologies.
- Strong analytical, documentation, and stakeholder management skills.
Preferred Qualifications
- Experience in enterprise data warehousing or lakehouse modeling.
- Knowledge of data products, data contracts, quality SLAs, and reusable datasets.
- Exposure to dbt, data cataloging, metadata management, and governance tools.
- Ability to work independently in a fast-paced environment.
If interested please share your cv at : snigdhaattheratebeanhr.com

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
Data Engineer
Experience - 5+ years
6-7 LPA
Remote
Duration: 1 month contract (We can take as a tentative, It can be extended)
Scope: Subscriber Activation, Churn, FTE and future reporting requirements, with BigQuery as the centralized data warehouse and Power BI as the proposed reporting layer.
Key Skills:
Strong hands-on experience with GCP & BigQuery
Data warehouse architecture, design and implementation
Data ingestion/integration across multiple source systems
ETL/ELT and data pipeline development
Data modelling for reporting and analytics
Experience integrating BigQuery with Power BI or similar reporting tools
We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.
Qualifications and Skills:
- Minimum 5 years of experience as a Data Engineer
- Hands-on experience with Azure cloud-based data solutions
- Expertise in database design and management, including SQL databases such as SQL Server
- Proficient in ETL (Extract, Transform, Load) design for data integration and processing
- Strong knowledge of data modeling principles and techniques
- Ability to analyze and translate data into actionable insights, reports, and visualizations
- Proficiency in Power BI for reporting and data visualization
Desirable Skills:
- Experience with Power BI Report Builder / Reporting Services
- Knowledge of statistical analysis or Data Science
- Experience within the UK Insurance industry is a plus
- Python or R coding skills
Responsibilities:
- Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
- Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
- Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
- Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
- Implement different methods of streaming data and create reconciliations for datasets
- Build analytical models to support reporting and analytics
- Collaborate with an agile delivery team to work on the backlog of specified work











