5 Star schema Jobs in India

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

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

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

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

Role Overview:

The SEO Analyst is responsible for optimizing the organization’s online presence by improving search engine rankings, driving organic traffic, and enhancing user engagement. This role requires expertise in SEO strategies, analytics, and a strong understanding of mental health-related content to ensure alignment with the organization’s mission.

Key Responsibilities:

1. SEO Strategy Development and Execution:

• Develop and implement effective SEO strategies to improve website rankings and increase organic traffic.
• Conduct keyword research to identify high-value terms relevant to mental health services and integrate them into the content strategy.

1. Content Optimization:

• Collaborate with content teams to optimize on-page elements, including meta tags, headers, and keywords.
• Ensure that content adheres to SEO best practices while maintaining accuracy and sensitivity in mental health-related topics.

1. Performance Monitoring and Reporting:

• Monitor website performance using tools such as Google Analytics, Google Search Console, and other SEO software.
• Analyze data to evaluate the effectiveness of SEO efforts and provide regular reports to the marketing team.

1. Technical SEO Management:

• Conduct technical audits to identify and resolve issues affecting website performance, such as page speed, mobile usability, and broken links.
• Ensure the website is optimized for search engine crawlers and adheres to the latest algorithm updates.

1. Competitor and Market Analysis:

• Conduct competitive analysis to identify trends, opportunities, and gaps in the market.
• Research emerging SEO techniques and tools to maintain a competitive edge in the mental health sector.

1. Local SEO:

• Develop and manage local SEO strategies to enhance visibility in specific geographic areas.
• Optimize Google My Business profiles and manage location-based search strategies.

1. Collaboration and Training:

• Work closely with content creators, developers, and social media teams to align SEO initiatives with broader marketing goals.
• Provide training and guidance to team members on SEO best practices.

Qualifications and Requirements:

Education:

• Bachelor’s degree in Marketing, Computer Science, or a related field.

Experience:

• 2–5 years of experience as an SEO Analyst or in a similar role.
• Proven experience in optimizing content for the mental health or healthcare sector is mandatory.

Skills and Knowledge:

• Proficiency in SEO tools such as Google Analytics, Google Search Console, SEMrush, and Ahrefs.
• Strong understanding of technical SEO, keyword research, and link-building strategies.
• Familiarity with content management systems (e.g., WordPress).
• Knowledge of HTML, CSS, and basic coding practices is a plus.
• Excellent analytical and problem-solving skills.

Personal Attributes:

• Strong attention to detail with the ability to manage multiple projects simultaneously.
• Excellent communication and collaboration skills.
• Sensitivity and awareness when working with mental health-related content.

Key Competencies:

• Expertise in SEO strategies and best practices.
• Data-driven decision-making and performance analysis.
• Ability to adapt strategies to the unique needs of mental health-related audiences.
• Strong alignment with the organization’s mission to promote mental health awareness.