FBS Data Analyst II
CapgeminiHyderabad, Telangana, India; Pune, Maharashtra, IndiaOn-Site
Needs a free Superjobs account. You'll finish on Capgemini's site.
Skill score
Summary
The FBS Data Analyst II provides data for one-time and recurring reports and analysis, extracting data with SQL and business query tools, checking data quality, and liaising between business and IT. The role suits someone with insurance-domain data experience who is comfortable with SQL, Snowflake and DBT, and clear written communication.
- Function
- Data Science
- Estimated salary
- Est. ₹5.5–8 LPA
- Estimated for a junior role, ~1 yr experience (typical for the level), India. Not published by the employer.
- Work mode and location
- On-Site, Hyderabad, Telangana, India; Pune, Maharashtra, India
- Employment type
- Full-time
Job description
Roles and responsibilities
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
Extract and manipulate data to solve business problems: • 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
Skills required
Top skills
- SQL
- Snowflake
- DBT
- Data warehouse
All skills (8)
- Data analytics
- Insurance domain
- Python
- Cognos ReportNet
- OBIEE Answers
- Oracle
- SQL Server
- Excel
Qualifications
Other Critical Skills
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)
Other details
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.
Company info
About Capgemini
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. 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