FBS Data Analyst II

Capgemini; Pune; Hybrid; INR 600,000 - 1,000,000; Full time

Benefits offered by this job

Bonus

Benefits

Career development

Flexible work

Inclusive culture

Health Insurance

Pension Plan

Paid Time Off

Training & Development

Job summary

Capgemini is seeking a data reporting professional to respond to data requests, extract data from relational databases and data warehouses, and format results for business use. You will develop reports, automate scripts, and support testing for system enhancements.

Collaboration between business and IT is essential to address data quality and project requirements. The role emphasizes extracting data with SQL-based tools, delivering datasets for analytical models, and maintaining documentation

Qualifications

• Insurance/Domain knowledge at least intermediate
• Understanding of data analytics concepts and datasets across multiple LOBs
• Experience with data warehouses and data modeling is a plus

Responsibilities

• Respond to new requests for reports/data and estimate hours/timeline
• Extract data using Cognos ReportNet, OBIEE Answers, or similar interfaces
• Extract data from relational databases (Oracle, SQL Server) and data warehouses
• Format data for business use in Excel, Access, or similar tools
• Produce reports manually and via automated scripts; maintain scripts/macros
• Support testing for enhancements or system upgrades; identify data quality issues
• Deliver data for analytic purposes and document datasets; share data extraction techniques
• Act as liaison between business and IT to resolve technical issues and priorities

Skills

Insurance Domain

Data Analytics

Data Warehouse

Tools

Snowflake

DBT

Job description

Provide data in response to one-time or recurring requests for reports or analysis. Understand customer objectives and processes; effectively communicate system capabilities and limitations; and deliver available data. Analyze data quality and take corrective action. Analyze impact of system changes to data/reporting infrastructure (support testing and implementation activities). Contribute data and expertise to the success of complex analysis projects.

Essential Job Functions

• Respond to new requests for reports/data: understand customer objectives and processes; review and refine requirements; and commun icate estimated hours and timeline to complete;
• Extract data using Cognos ReportNet, OBIEE Answers, or similar business query interfaces;
• Extract data directly from relational databases (e.g. Oracle, SQL Server), data warehouses, or other data stores using SQL;
• Format data for business use in Excel, Access, or similar format;
• Produce reports manually and through automated scripting; create and maintain scripts and macros used to automate reports;
• Support application testing for enhancements or system upgrades; identify and communicate data quality issues or data differences;
• Scope and deliver data for analytic purposes (data designed for the construction of advanced mathematical models); measure, document, and address data quality issues; maintain datasets and dataset documentation; and contribute knowledge and expertise to the success of the project; and
• Act as liaison between business and IT; collaborate on technical issues that require IT involvement and business priority to fix. Communicate effectively:
• Be concise and precise in written communication;
• Incorporate best practices in developing intuitive reports to share with a broad audience; and
• Describe and document unique aspects or limitations of data to aid understanding. Demonstrate business understanding:
• Develop in-depth knowledge of data associated with multiple lines of business (LOBs), and effectively support the data needs of those LOBs; and
• Demonstrate commitment to lifelong learning. Exemplify good teamwork:
• Proactively communicate with customers and team members;
• Provide excellent customer service by making realistic commitments and keeping them;
• Work productively on assigned tasks;
• Collaborate effectively with other team members;
• Demonstrate accountability to management and customers for hours spent on assigned tasks;
• Diligently strive to deliver value in the fewest possible hours; and
• Share effective SQL or other data extraction/manipulation techniques with team members; debug problems with report automation or queries; propose and implement remedies

Requirements

• Insurance Domain - Intermediate
• Data Warehouse - Intermediate
• Data Analytics - Intermediate

Software / Tool Skills

• Snowflake - Intermediate (4-6 Years)
• DBT - Intermediate (4-6 Years)
• Python - Entry Level (1-3 Years)

Benefits

Competitive compensation and benefits package:

• Competitive salary and performance-based bonuses
• Comprehensive benefits package
• Career development and training opportunities
• Flexible work arrangements (remote and/or office-based)
• Dynamic and inclusive work culture within a globally renowned group
• Private Health Insurance
• Pension Plan
• Paid Time Off
• Training & Development

Note: Benefits differ based on employee level.

About Capgemini

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.

https://www.capgemini.com/us-en/about-us/who-we-are/