Capgemini Hiring for Data Analyst at Bengaluru, Karnataka, India Full Time

We are seeking a talented Data & BI Engineer with strong expertise in SQL, Power BI, Python, and PySpark. The ideal candidate will be responsible for designing and developing data models, dashboards, and analytical solutions that support business decision-making. This role requires a deep understanding of data engineering, visualization, and performance optimization techniques.

Key Responsibilities

• Design and develop database objects including tables, views, indexes, stored procedures, and functions.
• Optimize SQL queries and implement performance tuning techniques.
• Develop and maintain complex Power BI data models and dashboards.
• Ensure data integrity and consistency across Power BI reports.
• Identify and resolve performance bottlenecks in Power BI and SQL environments.
• Utilize Power Query and DAX for advanced data transformations and calculations.
• Apply strong analytical and problem-solving skills to resolve data-related issues.
• Develop Python scripts for data processing and automation.
• Work with PySpark for large-scale data manipulation using DataFrames and SparkSQL.

Primary Skills

• Proficiency in SQL, including database object creation and query optimization.
• Strong experience with Power BI development, data modeling, and visualization.
• Expertise in Power Query and DAX.
• Proficient in Python programming for data engineering tasks.
• Extensive experience with PySpark, including DataFrames and SparkSQL.
• Strong analytical and problem-solving abilities.

Secondary Skills

• Familiarity with performance tuning and optimization techniques in SQL and Power BI.
• Ability to identify and resolve data-related issues across platforms.
• Experience in integrating data from multiple sources and formats.

Preferred Qualifications

• Exposure to multi-language programming (e.g., Python, C#, MATLAB).
• Experience working in cross-functional and global teams.
• Certifications in relevant technologies (e.g., Microsoft Power BI, Python, Spark).

Works in the area of Software Engineering, which encompasses the development, maintenance and optimization of software solutions/applications.1. Applies scientific methods to analyse and solve software engineering problems.2. He/she is responsible for the development and application of software engineering practice and knowledge, in research, design, development and maintenance.3. His/her work requires the exercise of original thought and judgement and the ability to supervise the technical and administrative work of other software engineers.4. The software engineer builds skills and expertise of his/her software engineering discipline to reach standard software engineer skills expectations for the applicable role, as defined in Professional Communities.5. The software engineer collaborates and acts as team player with other software engineers and stakeholders.

Job Description – Grade Specific

Is fully competent in it’s own area and has a deep understanding of related programming concepts software design and software development principles. Works autonomously with minimal supervision. Able to act as a key contributor in a complex environment, lead the activities of a team for software design and software development. Acts proactively to understand internal/external client needs and offers advice even when not asked. Able to assess and adapt to project issues, formulate innovative solutions, work under pressure and drive team to succeed against its technical and commercial goals. Aware of profitability needs and may manage costs for specific project/work area. Explains difficult concepts to a variety of audiences to ensure meaning is understood. Motivates other team members and creates informal networks with key contacts outside own area.

Skills (competencies)

Verbal Communication