logo

JobNob

Your Career. Our Passion.

Data Architect /Data Analyst - Financial Forecasting


Vsynergize OutSourcing Pvt. Ltd


Location

Pune City | India


Job description

Professional Competencies


• Analytical mindset and problem-solving skills: exceptional ability to analyse data, identify

trends, and solve complex problems with a strong attention to detail.

• Communication: strong verbal and written communication skills, able to convey complex

data insight to technical and non-technical stakeholders.

• Collaboration: Able to work effectively in team environments, collaborating across

environments to achieve data-driven objectives.

• PM Skills: Capable to manage multiple projects simultaneously, and able to prioritize

tasks and meetings in a dynamic environment.

Technical Proficiencies

Critical Skill :

• Snowflake: Strong knowledge of Snowflake’s data warehousing solutions,

including ability to write efficient SQL queries for data extraction and

analysis.

• Power BI: Demonstrated proficiency in designing and implementing dynamic

Power BI dashboards, with specific experience in integrating Snowflake

views, Odatav4 feeds, MSFT Sharepoint. Ability to use DAX for complex

calculations and data manipulation where necessary.

• Data management skills: Ability to perform data sanitization and cleansing

to ensure data quality and accuracy.

• SOQL (Salesforce Object Query Language) proficiency in SOQL for querying

and extracting data from Salesforce is a plus. Ability to design custom reports

and dashboards within Salesforce is a plus.

• Anaplan – used Anaplan and Integration in set-up pipeline

• Worked on Snowflake , Power BI and Anaplan integration .

• Must have experience in Financial Reporting

• Understanding of Topline parameters such as TCV ,ACV , ARR , Revenue etc.

• Should be expert forecasting models based on Training data

• Cleaning and Transformation of Data

• Build forecast Models and how it works , how to fine tune models for

accuracy.

• Understanding of various Models ( ML algorithms )

• Scripting and API integration: Experience with Python scripting for data

automation tasks, including API integration for data ingestion and extraction

from multiple sources. API Scripting for Snowflake , Power BI and Anaplan

integration

• Must be able to understand the customer challenges and requirements

• Good Analytical Skills .

• Very Good Communication Skills

• High on Quality as this is Financial Data Forecasting , require very high

accuracy for work.

Requirements

Experience : 5 to 8 yrs

Salary range: 8 to 20 LPA (Depending on Last drawn CTC

Shift Timing: 5:00 PM IST to 2:00 AM IST

Availability - Immediate

Mode of Work - Work from Office only

Qualification:

• Bachelor’s degree in Computer Science, Information Technology or related field

• Master’s degree in Computer Science, Information Technology or related field is a plus

Nice to have:

• Azure or AWS S3: Experience accessing, navigating, managing data within

AWS S3. Including uploading, downloading, and organizing files, buckets

• Excel: knowledge of Pivot tables, VBA, advanced formulas, able to automate,

format, and prepare data according to specific schema requirements.

Responsibilities:

o Understand the Historical Data

o Data Cleaning and Transformation to Build the Model

o Design and Develop Forecasting Model

o Validation of Models

o Fine Tuning Model

o Execution and Run the Model

o Check and Manual and Automated Results for Accuracy

o Integration of Snowflake and Power BI

o Set-up Pipeline from Power BI to Anaplan

o Store the Generated Forecast into Anaplan

o Rapid Prototype and POC for Discovery Phase for the first financial

forecasting models

o Forecasting Reports: Create Static and Dynamic Reports and Ad-hoc

reports


Job tags



Salary

All rights reserved