3+ Star schema Jobs in India

About the company:

Inteliment is a niche business analytics company with almost 2 decades proven track record of partnering with hundreds of fortunes 500 global companies. Inteliment operates its ISO certified development centre in Pune, India and has business operations in multiple countries through subsidiaries in Singapore, Europe and headquarter in India.

About the Role:

We are seeking an experienced Technical Data Professional with hands-on expertise in designing and implementing dimensional data models using Erwin or any dimensional model tool and building SQL-based solutions adhering to Data Vault 2.0 and Information Mart standards. The ideal candidate will have strong data analysis capabilities, exceptional SQL skills, and a deep understanding of data relationships, metrics, and granularity of the data structures.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Certifications with related field will be an added advantage.

Key Competencies:

1.Technical Expertise:

• Proficiency in Erwin for data modeling.
• Advanced SQL skills with experience in writing and optimizing performance driven queries.
• Hands-on experience with Data Vault 2.0 and Information Mart standards is highly preferred.
• Solid understanding of Star Schema, Facts & Dimensions, and Business Unit (BU) architecture.

2. Analytical Skills:

• Strong data analysis skills to evaluate data relationships, metrics, and granularities.
• Capability to troubleshoot and resolve complex data modeling and performance issues.

3.Soft Skills:

• Strong problem-solving and decision-making skills.
• Excellent communication and stakeholder management abilities.
• Proactive and detail-oriented with a focus on delivering high-quality results.

Key Responsibilities:

1. Dimensional Data Modeling:

• Design and develop dimensional data models using Erwin with a focus on Star Schema and BUS architecture (Fact and Dimension tables).
• Ensure models align with business requirements and provide scalability, performance, and maintainability.

2. SQL Development:

• Implement data models in SQL using best practices for view creation, ensuring high performance.
• Write, optimize, and refactor complex SQL queries for efficiency and performance in large-scale databases.
• Develop solutions adhering to Information Mart and Data Vault 2.0 standards. (Dimensional model that is built using Raw Data vault tables Hubs, Links, satellites, Effectivity satellites , Bridge and PIT tables from Data Vault.)

3. Data Analysis & Relationship Metrics:

• Perform in-depth data analysis to identify patterns, relationships, and metrics at different levels of granularity.
• Ensure data integrity and quality by validating data models against business expectations.

4. Performance Optimization:

• Conduct performance tuning of existing data structures, queries, and ETL processes.
• Provide guidance on database indexing, partitioning, and query optimization techniques.

5. Collaboration:

• Work closely with business stakeholders, data engineers, and analysts to understand and translate business needs into effective data solutions.
• Support cross-functional teams to ensure seamless integration and delivery of data solutions

Hybrid work mode

(Azure) EDW Experience working in loading Star schema data warehouses using framework

architectures including experience loading type 2 dimensions. Ingesting data from various

sources (Structured and Semi Structured), hands on experience ingesting via APIs to lakehouse architectures.

Key Skills: Azure Databricks, Azure Data Factory, Azure Datalake Gen 2 Storage, SQL (expert),

Python (intermediate), Azure Cloud Services knowledge, data analysis (SQL), data warehousing,documentation – BRD, FRD, user story creation.

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.