Business Analyst at Affine · Bengaluru (Bangalore) · 3 - 5 years · Profitable · Posted 28 Nov 2024

We are looking for a detail-oriented Business Analyst with expertise in Tableau, statistics, SQL, and Excel. The role involves data analysis, creating interactive dashboards, and providing actionable insights to support business decisions and improve operations.
Key Responsibilities:
- Data Analysis & Visualization: Use Tableau for dashboards and conduct statistical analysis.
- SQL & Data Management: Write and optimize SQL queries, ensure data accuracy.
- Reporting: Develop Excel spreadsheets, analyze business processes, and provide reports.
- Collaboration: Work with cross-functional teams to gather requirements and deliver insights.
- Project Management: Manage multiple projects, deliver timely reports, and support teams with data insights.

About Affine
About
Affine is a pioneering consulting firm that specializes in AI-driven enterprise transformation. With a robust focus on Generative AI, we deliver cutting-edge solutions that redefine industry standards.
Our comprehensive capabilities span the entire analytical value chain, from data to insights and transformation. We provide Cloud Advisory and Assessment, Cloud Migration, Data Lake Design and Development, Big Data Powered Advanced Analytics, AI & Deep Learning Solutions, and Deployment Consulting with Architecture Design.
Similar jobs (10)
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
Experience Required: Minimum 8 Years
About the Role:
Key Responsibilities
- Design and manage organization-wide MIS reports, dashboards, and executive reports.
- Develop automated reporting solutions using Python, VBA Macros, Power Query, and Advanced Excel.
- Analyze large datasets and provide business insights to leadership.
Eligibility Criteria
- 5+ years of experience in Business Intelligence, MIS, Business Analytics, or Data Analytics.
- Strong analytical and logical thinking with the ability to understand business requirements and convert data into meaningful business insights.
- Experience in developing dashboards and management reports using any Business Intelligence tool (Power BI, Tableau, Zoho Analytics, etc.).
Apply Now:
Key Responsibilities
- Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
- Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
- Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
- Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
- Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
- Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
- Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
- Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
- Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.
Required Skills & Qualifications
- Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
- Proven experience (1–3 years or as per company requirement) in MIS, data reporting/analysis, or similar role.
- Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
- Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
- Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
- Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
- Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.
This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.
Work Mode: WORK FROM OFFICE
Role Descriptions:
- Perform detailed data analysis and support business decision-making
- Gather and document business requirements and translate them into technical specifications
- Work closely with stakeholders to define data needs and reporting requirements
- Create user stories, functional specifications, and support UAT activities
- Ensure alignment between business objectives and data solutions
Required Skills:
- Strong expertise in SQL and data querying
- Proven experience in data analysis, requirement gathering, and stakeholder management
- Ability to translate business requirements into technical solutions and user stories
- Good understanding of data models, reporting, and analytics concepts
Skills: Business Analysis~ORACLE SQL
Locations: ~HYDERABAD~PUNE~
Desire candidate
- Candidate should have valid PF.
At Nineleaps, we work on bleeding-edge technology with class-leading engineering practices on products that touch the lives of millions of users. We endeavor on doing things the right way, while also promoting a culture of excellence.
About the Role:
We are looking for a Data Analyst with strong analytical and problem-solving skills to transform complex data into meaningful, actionable business insights. The role involves working with large datasets, conducting deep-dive analysis, driving automation, and supporting data-driven product and business decisions.
Key Responsibilities:
- Analyse historical and large datasets to understand data sources, identify trends and patterns, and uncover meaningful insights.
- Write complex SQL queries and leverage Python to perform data analysis, ad hoc investigations, and solve business problems.
- Create reports and translate analytical findings into clear, concise, and actionable recommendations for stakeholders.
- Identify opportunities to drive automation and process improvements, improving efficiency and reducing manual effort.
- Communicate data-driven insights effectively to both technical and non-technical stakeholders in a clear and impactful manner.
- Maintain accurate documentation, ensure high-quality deliverables, and consistently meet defined timelines.
Requirements:
- 3–6 years of experience in Data Analytics, Business Intelligence, Data Engineering, or a similar analytical role.
- Strong hands-on expertise in Python and advanced SQL, with the ability to work with and analyse large datasets.
- Experience working with Google Sheets, and implementing automation through data pipelines or workflows.
- Strong analytical and problem-solving skills, with the ability to interpret complex data and derive actionable insights.
- Excellent communication skills with the ability to effectively present methods, results, and recommendations to stakeholders.
- Ability to collaborate effectively with remote and geographically distributed teams across different time zones.
Company Link: https://www.nineleaps.com/
Company LinkedIn: https://www.linkedin.com/company/nineleaps/
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,
Strong Data Analyst Profile with advanced Excel and SQL expertise
2
Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst
3
Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots
4
Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts
5
Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)
6
Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy
7
Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)
8
Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.
9
Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person
10
Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts
About the Role
Work at the intersection of business and technology, supporting operations, data analysis, automation, and digital tools to improve efficiency and growth.
Responsibilities
- Support business operations using tech tools (Excel, CRM, dashboards)
- Analyze data and generate insights for decision-making
- Assist in automation workflows and process improvements
- Coordinate between tech and business teams
- Help in implementing digital solutions and tools
Skills Required
- Basic knowledge of Excel / Google Sheets
- Good analytical and problem-solving skills
- Understanding of business processes
- Interest in technology and automation
Details
- Duration: 3–6 months
- Mode: Remote
- Certificate + PPO based on performance
Job Title: Technical Business Analyst| B2B
Work Location: Work from Home
Job Type: Full-time
Experience: 1+ year
Company Location : Work from Home
Website : https://www.mayuraconsultancy.com/careers/mcs-business-systems-analyst-opening?r=jlp
Skills:
- Proficiency in business analysis tools (e.g., Microsoft Excel) and documentation tools (e.g., JIRA, Confluence).
- Strong understanding of business processes and requirement gathering
- Excellent communication and stakeholder management skills.
- Experience with Agile methodologies is a plus.
About Us:
Mayura Consultancy Services (MCS) is a leading software consultancy and development company, serving a customer base in more than 25 countries. Specializing in digital transformation, MCS offers a comprehensive range of innovative solutions tailored to diverse business needs. Our offerings include custom software development, e-Commerce development, mobile and web applications, cloud integration, and enterprise resource planning (ERP) systems that enhance efficiency and streamline operations.
Job Overview
We are seeking a skilled and motivated Business Analyst to join our dynamic team. The Business Analyst will be responsible for gathering, analyzing, and documenting business requirements, and working closely with cross-functional teams to ensure that business needs are met. This role will play a key part in improving business processes, optimizing systems, and ensuring the successful delivery of projects.
What You Will Be Doing:
- Requirement Gathering & Documentation: Work with stakeholders to gather and document business requirements through interviews, workshops, and research. Develop detailed specifications and use cases.
- Process Analysis & Optimization: Analyze current business processes and workflows to identify areas for improvement. Propose solutions and strategies to enhance business performance.
- Data Analysis & Reporting: Conduct data analysis to support decision-making and provide insights into business performance. Create dashboards and reports for business stakeholders.
- Collaboration with Teams: Work closely with product managers, developers, and other business units to ensure seamless implementation of business requirements.
- Project Management Support: Assist in project management activities, including tracking progress, managing timelines, and ensuring project goals are met.
- Stakeholder Management: Communicate effectively with stakeholders at all levels to ensure expectations are aligned, and business needs are understood and delivered.
Benefits of Working with MCS:
- Work From Home: Enjoy the flexibility of working entirely from the comfort of your home, achieving a better work-life balance while contributing to impactful research initiatives.
- Direct Collaboration with Founders: Collaborate directly with MCS's founding team, gaining valuable insights and mentorship while contributing to the company's growth.
- Access to Premium Tools: Utilize the latest research tools and software to enhance your work efficiency and effectiveness.
- Recognition and Growth Opportunities: Potential for career advancement based on performance, with opportunities to take on more responsibilities and grow within the company.
- Comprehensive Benefits: Enjoy insurance coverage, paid leaves, and additional perks that support your well-being and work-life balance.
Ready to start your journey as a Business Analyst? Apply Now!
Apply : Please apply using the URL below Once you complete the application form, we will review your profile and get back to you.
Website:
https://www.mayuraconsultancy.com/careers/mcs-business-systems-analyst-opening?r=jlp
Role Overview
We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.
Key Responsibilities
- Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
- Build and maintain data models to support business processes, reporting needs, and integration workflows.
- Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
- Work closely with cross-functional teams to gather data requirements and understand business logic.
- Develop and execute integration test plans, including functional, data validation, and regression testing.
- Support data migration activities, including extraction, transformation, and loading (ETL).
- Monitor and troubleshoot integration issues, ensuring timely resolution.
- Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
- Ensure integration security, data integrity, and compliance with organizational standards.
Required Skills & Qualifications
- 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- Hands-on experience with data mapping, data modelling, and database schema design.
- Proficiency in SQL (complex joins, stored procedures, performance tuning).
- Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
- Strong analytical and problem-solving skills.
- Experience with API-based integrations (REST/SOAP) is a plus.
- Familiarity with testing methodologies for integrations and data validation.
- Ability to work with business users, understand workflows, and translate requirements into technical solutions.
Preferred Qualifications
- Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
- Knowledge of JSON, XML, CSV transformation.
- Exposure to scripting languages (Python, Shell).
- Experience in Agile/Scrum environments.
- Prior involvement in ERP implementation or upgrade projects.
Competencies
- Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
- Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
Why Join Us?
- Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
- Work on impactful projects that make a difference across industries.
- Opportunities for professional growth and continuous learning.
- Competitive salary and benefits package.
Application Details
Ready to make an impact? Apply today and become part of the QX Impact team!
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.






