FBS Data Analyst II

Overview

Provide data and analysis in response to one-time or recurring reporting requests, acting as liaison between business and IT on FBS (insurance domain) data.

What you'll do

• Understand customer objectives and processes; review and refine requirements; communicate estimated hours and timeline to complete new requests.
• 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 formats.
• 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.
• Analyze data quality and take corrective action; analyze the impact of system changes to data and reporting infrastructure.
• Scope and deliver data for analytic purposes (data designed for building advanced mathematical models); measure, document, and address data quality issues; maintain datasets and dataset documentation.
• Collaborate with IT on technical issues that require IT involvement and business priority to fix.
• Develop in-depth knowledge of data associated with multiple lines of business and support their data needs.
• Share effective SQL or other data extraction and manipulation techniques with team members; debug report automation and query problems and propose and implement remedies.

What you'll need

• Insurance domain knowledge at an intermediate level.
• Data warehouse knowledge at an intermediate level.
• Data analytics skills at an intermediate level.
• Snowflake at an intermediate level (4-6 years).
• DBT at an intermediate level (4-6 years).
• Python at an entry level (1-3 years).

Details

• Location: Hyderabad, Telangana, India; Pune, Maharashtra, India.
• Work arrangement: flexible (remote and/or office-based).