Senior Analyst - Business Intelligence

Principal Global Services

0 years

0 Lacs

Pune Maharashtra India

Posted:1 week ago| Platform:

Apply

Skills Required

etl development testing management model retrieval design checks controls adf sql power aws scripting powershell data addition accounting valuation analysis aggregation reporting extract reports excel monitoring analyze mathematics finance research communication

Work Mode

On-site

Job Type

Full Time

Job Description

Responsibilities

ETL Development, Testing, and Management: Develop and manage ETLs for IFP model runs and result retrieval. Design dataflows, establish checks and controls, and validate ETL processes. Skills required: Knowledge of IDM, ADF, IFP, Integrate App, MG-ALFA, SQL, Power BI, AWS, and basic scripting in PowerShell. Criticality: High. Approx time efforts: 90 hours per month.
Data Input and Updates: Process monthly recurring input updates, including addition or removal of inputs, Schema changes, Metadata changes, etc. Manage additional updates accounting for model valuation enhancements. Perform testing and deviation analysis. Skills required: Familiarity with key assumptions, policy attributes, and data aggregation for different purposes. Criticality: High. Approx time efforts: 90 hours per month.
Reporting and Dashboards: Extract daily and job compute reports. Segment records by model, project, and business unit levels. Publish Power BI dashboards with data segregations for analysis. Skills required: Proficiency in Excel, Power BI, and SQL. Criticality: Medium. Approx time efforts: 2 to 4 hours per week.
Performance Monitoring: Analyze run times and propose changes for reducing it while keeping the original functionality of the ETLs. Clean up the data transforms to make sure the process is streamlined. Skills required: Analytical skills to compare ETL run times and suggest modifications. Criticality: Low. Approx time efforts: 2 to 4 days per month.
Independent Projects: Work on various independent projects identified from time to time.

Qualifications

Professional Background: Prior experience working in an insurance company is an added advantage.
Education: Bachelor’s degree in mathematics, Science, Finance, Economics, or any related field.
Positive Attitude: Ability to work under pressure while maintaining a positive and proactive approach.
Analytical and Research Skills: Strong ability to analyze data, identify issues, and develop solutions.
Communication Skills: Excellent verbal and written communication to collaborate with stakeholders effectively.

More Jobs at Principal Global Services

Analyst - Accounting

Hyderabad, Telangana, India

2 - 2 yrs

Salary: Not disclosed

Senior Software Engineer

Hyderabad, Telangana, India

4 - 6 yrs

Salary: Not disclosed

Lead Software Engineer

Pune

6 - 8 yrs

INR 25 - 30 Lacs

Software Engineer - Salesforce

Pune, Maharashtra, India

2 - 4 yrs

Salary: Not disclosed

Product Manager I

Pune, Maharashtra, India

2 - 2 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.