Solution Architect/Technology Lead – Data Analytics-Mumbai

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

We're hiring a Data Analyst to turn raw data into clear, actionable insight. You'll partner with product, sales, marketing, and operations teams to answer their most important questions with data — building dashboards, running deep-dive analyses, and defining the metrics the business runs on. The ideal candidate is fluent in SQL, comfortable wrangling messy datasets, and just as strong at telling the story behind the numbers as they are at producing them. You'll own the accuracy and trustworthiness of the reporting stakeholders rely on to make decisions.

Key Responsibilities

• Design, build, and maintain dashboards and recurring reports across business functions
• Write and optimize SQL queries to extract, join, and transform data from multiple sources
• Run ad-hoc and deep-dive analyses to answer specific business questions
• Define, document, and standardize metrics and KPIs alongside stakeholders
• Investigate data-quality issues and ensure the numbers people see are accurate
• Translate analysis into clear recommendations and present them to non-technical audiences
• Support experimentation and A/B test analysis where relevant
• Automate repetitive reporting to free up time for higher-value analysis

Requirements

• 3+ years in a data analyst or business-intelligence role
• Strong SQL and hands-on experience with Power BI and/or Tableau
• Working knowledge of Python (pandas/numpy) for analysis
• Solid grounding in statistics and analytical methods
• Advanced Excel and strong data-visualization / storytelling skills
• Ability to work independently with stakeholders across functions

Nice to have

• Experience with cloud data warehouses (BigQuery, Snowflake, Redshift)
• Exposure to dbt or other ETL/transformation tooling

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.

The Power BI Intern will assist the analytics team in using Microsoft Power BI to create interactive dashboards and reports. Working with actual datasets to assist well-informed business decision-making, this position provides practical exposure to data analysis, visualization, and business intelligence techniques.

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 5–8 Years

Base Location Hyderabad

Work Mode Hybrid / On-site

Working Timings IST Timings

Employment Type Contract – Renewable Every 3 Months

Interview Process 3 Rounds – 2 Remote + 1 In-Person

Background Verification Mandatory upon selection

Job Summary

Ampleopp Solutions is looking for an experienced SAP BI / Datasphere / SAP BDC Developer with 5–8 years of experience in SAP Data & Analytics. The candidate will work on modern SAP data and analytics solutions involving SAP S/4HANA, SAP BW/BW4HANA, SAP Datasphere, SAP Analytics Cloud (SAC), and SAP Databricks. The role requires strong hands-on experience in data extraction, data integration, data modeling, transformation, analytics, and reporting, with the ability to work across traditional SAP BI/BW and modern SAP Business Data Cloud environments.

Key Technologies

·       SAP S/4HANA

·       SAP BW / BW4HANA

·       SAP Datasphere

·       SAP Analytics Cloud (SAC)

·       SAP Databricks

·       SAP Business Data Cloud (BDC)

·       SQL

·       Python / PySpark

·       Data Modeling

·       Data Integration

·       CDS Views

Key Responsibilities

SAP S/4HANA & Data Extraction

• Extract and integrate data from SAP S/4HANA to SAP Datasphere / SAP BW.
• Work with S/4HANA tables, CDS Views, and data sources.
• Develop and maintain data extraction and integration processes.
• Perform data validation and reconciliation.

SAP BI / BW / BW4HANA

• Develop and maintain BW/BW4HANA data models and data flows.
• Work with ADSO, CompositeProviders, Transformations, DataSources, and DTPs.
• Develop ETL processes and troubleshoot data-load issues.
• Support BW modernization and migration to Datasphere.

SAP Datasphere

• Develop Spaces, Views, Data Flows, and Analytical Models.
• Build scalable data models for reporting and analytics.
• Implement SAP and non-SAP data integration.
• Work with federation, replication, and transformation.
• Optimize data models and ensure data quality.

SAP Analytics Cloud (SAC)

• Develop dashboards, Stories, and analytical applications.
• Build SAC solutions using Datasphere/BW models.
• Configure Live and Import connections.
• Develop calculations, filters, and analytical components.

SAP Databricks / Data Engineering

• Develop data pipelines using SAP Databricks / Databricks.
• Work with SQL, Python, PySpark, and Apache Spark.
• Perform data transformation, cleansing, and enrichment.
• Implement data-quality checks and optimize data-processing jobs.

SAP Business Data Cloud (BDC)

• Support SAP Business Data Cloud solutions involving Datasphere, Databricks, and SAC.
• Integrate SAP and non-SAP data sources.
• Support BDC data products and analytical use cases.

Participate in BDC implementation and troubleshoot data-integration issues.

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

We are hiring a Tableau Developer to build insightful dashboards for business teams.

Responsibilities

• Build interactive Tableau dashboards and reports
• Prepare and model data with SQL and Tableau Prep
• Publish and manage content on Tableau Server
• Work with stakeholders to define metrics

Requirements

• 1+ years of Tableau development
• Strong SQL skills
• Good understanding of data visualisation practices

We are looking for a Power BI Developer to turn business data into clear, reliable dashboards.

Responsibilities

• Build interactive Power BI reports and dashboards
• Write DAX measures and Power Query transformations
• Design star-schema data models
• Work with business teams to define KPIs

Requirements

• 1+ years of Power BI development
• Strong DAX and SQL skills
• Experience with data modelling and report performance tuning

Job Summary

We are looking for a skilled and experienced Data Engineer to join our growing data team. The ideal candidate will have strong expertise in Python, PySpark, Data Modeling, and Power BI, with hands-on experience in designing, developing, and optimizing scalable data solutions. The role requires working closely with business stakeholders, data architects, and analytics teams to build robust data pipelines and semantic models that enable data-driven decision-making.

Technical Skills

• Strong hands-on experience in Python and PySpark development.
• Expertise in building and optimizing Data Engineering solutions and ETL pipelines.
• Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Dimensional Modeling).
• Experience with Power BI Data Modeling and Semantic Layer development.
• Proficiency in DAX (Data Analysis Expressions).
• Experience designing and managing Semantic Models in Power BI.
• Strong SQL skills and experience working with large datasets.
• Knowledge of data warehousing concepts and best practices.

Preferred Skills

• Experience with cloud platforms such as Azure, AWS, or GCP.
• Exposure to modern data platforms like Databricks.
• Understanding of data governance and data quality frameworks.