Solution Architect/Technology Lead – Data Analytics-Mumbai at TSG Global Services Private Limited · Mumbai · 10 - 15 years · ₹8L - ₹15L / yr · Profitable · Posted 10 Mar 2023

Solution Architect/Technology Lead – Data Analytics-Mumbai
Exp-Min 10 Years
Location Mumbai
Sal-Nego
Powerbi, Tableau, QlikView,
Solution Architect/Technology Lead – Data Analytics
Role
Looking for Business Intelligence lead (BI Lead) having hands on experience BI tools (Tableau, SAP Business Objects, Financial and Accounting modules, Power BI), SAP integration, and database knowledge including one or more of Azure Synapse/Datafactory, SQL Server, Oracle, cloud-based DB Snowflake. Good knowledge of AI-ML, Python is also expected.
- You will be expected to work closely with our business users. The development will be performed using an Agile methodology which is based on scrum (time boxing, daily scrum meetings, retrospectives, etc.) and XP (continuous integration, refactoring, unit testing, etc) best practices. Candidates must therefore be able to work collaboratively, demonstrate good ownership, leadership and be able to work well in teams.
- Responsibilities :
- Design, development and support of multiple/hybrid Data sources, data visualization Framework using Power BI, Tableau, SAP Business Objects etc. and using ETL tools, Scripting, Python Scripting etc.
- Implementing DevOps techniques and practices like Continuous Integration, Continuous Deployment, Test Automation, Build Automation and Test-Driven Development to enable the rapid delivery of working code-utilizing tools like Git. Primary Skills
Requirements
- 10+ years working as a hands-on developer in Information Technology across Database, ETL and BI (SAP Business Objects, integration with SAP Financial and Accounting modules, Tableau, Power BI) & prior team management experience
- Tableau/PowerBI integration with SAP and knowledge of SAP modules related to finance is a must
- 3+ years of hands-on development experience in Data Warehousing and Data Processing
- 3+ years of Database development experience with a solid understanding of core database concepts and relational database design, SQL, Performance tuning
- 3+ years of hands-on development experience with Tableau
- 3+ years of Power BI experience including parameterized reports and publishing it on PowerBI Service
- Excellent understanding and practical experience delivering under an Agile methodology
- Ability to work with business users to provide technical support
- Ability to get involved in all the stages of project lifecycle, including analysis, design, development, testing, Good To have Skills
- Experience with other Visualization tools and reporting tools like SAP Business Objects.

About TSG Global Services Private Limited
About
Connect with the team
Similar jobs (10)
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.
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.
Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets
2
Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.
3
Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis
4
Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.
5
Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows
6
Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation
7
Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.
8
Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.
9
Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture
10
Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.
11
Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.
12
Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.
13
Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)
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.
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.
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.
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
Immediate Joining
We are looking for a Dedicated Resource on Contract for –
Role: Data Engineer
Experience: 5+ Years
Location: Remote
Duration: 3+ Months
Strong hands-on experience with Snowflake, including writing SQL queries, creating views, stored procedures, and functions.
Good knowledge of AI tools such as Claude.
Experience with ETL tools like Alteryx is good to have.
Power BI experience is good to have.
Strong communication skills.
OBIEE Developer + ETL Lead
🔹 Experience: 8+ Years
🔹 Location: PAN India
🔹 Work Mode: Work From Office – 5 Days
🔹 Joining: Immediate Joiners Preferred
🔹 Communication: Excellent communication skills required
💼 Key Skills:
• #OBIEE Development
• #ETL / #DataIntegration
• #BIReporting & Analytics
• #ETL Lead / Technical Leadership
• Strong #SQL & #Database Concepts















