3+ Star schema Jobs in India

We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization. The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.

Key Responsibilities

1. Data Management & Reporting

• Collect, clean, validate, and consolidate data from multiple internal and external sources.
• Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.
• Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

• Manage and regularly update internal databases, spreadsheets, and reporting systems.
• Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.
• Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

• Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.
• Translate data findings into clear, actionable insights and recommendations to support strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

• Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.
• Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.
• Proactively suggest new automation tools, system enhancements, or integrations to improve efficiency, accuracy, and scalability.
• Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.
• Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

• Collaborate with Sales, HR, Finance, Operations, and other departments to understand reporting and data requirements.
• Provide support for ad-hoc analysis, custom reports, and special data requests.
• Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

• Maintain complete and updated documentation for MIS processes, reports, data models, automation logic, and system changes.
• Ensure compliance with company data governance policies and applicable data protection standards.

System Development & Data Structuring Responsibilities

• Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.
• Review existing manual and digital data systems to identify operational gaps, risks, and improvement opportunities.
• Recommend structured data models, reporting formats, and storage solutions aligned with business requirements.
• Coordinate with department heads to define data structures, access levels, and reporting standards.
• Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP integrations) with minimal operational disruption.
• Design structured data formats and role-based access controls to ensure secure and organized data management.
• Train employees on newly implemented systems and provide post-implementation support.
• Monitor system performance, resolve issues, and continuously improve systems based on user feedback and organizational growth.

Qualifications & Experience

• Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.
• 3–5 years of experience in data analytics, reporting, or system automation roles.
• Strong analytical thinking, logical reasoning, and problem-solving abilities.
• High attention to detail with excellent organizational and documentation skills.

Technical Skills (Must Have)

• Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts
• Python or R: Data cleaning, analysis, automation (Pandas, NumPy, etc.)
• BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)
• Data Warehousing Concepts: ETL processes, OLAP, Star/Snowflake schema
• Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization

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.