Senior Specialist - Architecture (Finance Data Modeling)

Vivantify Technology Solutions India Pvt. Ltd.; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Competitive salary and benefits

Professional growth opportunities

Collaborative work environment

Challenging projects

Job summary

Vivantify Technology Solutions India Pvt. Ltd. is seeking an experienced Data Modeler with strong Finance domain expertise.

This role involves designing and maintaining enterprise data models for finance systems and collaborating with diverse teams. The ideal candidate should possess a Bachelor’s degree in Computer Science or Finance and have 7–11 years of experience, along with proficiency in data modeling and BI tools.

Qualifications

• 7–11 years of experience in finance data modeling.
• Hands-on expertise with BI tools and data warehouses.
• Strong understanding of finance processes and reporting.

Responsibilities

• Design and maintain data models for finance systems.
• Translate business requirements into effective data structures.
• Ensure compliance with data governance and regulatory standards.

Skills

Finance domain data modeling

Conceptual, Logical, and Physical Data

Dimensional Data Modeling

BI Solutions Architecture

Power BI and Tableau

SQL and database design expertise

ERwin or ER/Studio

Oracle, SQL Server

Education

Bachelor's degree in Computer Science

Degree in Finance or related field

Tools

Power BI

Tableau

Azure Data Factory

Azure Databricks

Snowflake

Job description

About The Role

We are seeking an experienced

Location

Pune

Experience

7–11 Years

About The Role

We are seeking an experienced Data Modeler with strong Finance domain expertise to design and maintain conceptual, logical, and physical data models. The role supports financial reporting, accounting, risk, treasury, and regulatory initiatives while ensuring scalable, governed, and high-quality data structures.

Job Description

The candidate will design enterprise data models for finance systems and data warehouses, translating business requirements into scalable data structures. The role involves developing dimensional models, maintaining data dictionaries and metadata, and documenting data lineage.

You will collaborate with Finance, Business, Data Engineering, and Architecture teams while supporting ETL/ELT development through source-to-target mappings and model reviews. The position also requires adherence to data governance, data quality, and applicable regulatory standards.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for finance systems and data warehouses.


• Translate business requirements into scalable and effective data structures.


• Develop Star/Snowflake dimensional models for reporting and analytics.


• Create and maintain data dictionaries, metadata, and data lineage documentation.


• Collaborate with Finance, Business, Data Engineering, and Architecture teams.


• Support ETL/ELT development through source-to-target mappings and data model reviews.


• Ensure compliance with data governance, quality, and regulatory standards.


• Support finance use cases including GL, AP/AR, financial reporting, treasury, and regulatory risk reporting.

Required Skills

• Finance domain data modeling


• Conceptual, Logical, and Physical Data Modeling


• Dimensional Data Modeling


• BI Solutions Architecture


• Power BI and Tableau


• Hands-on experience with ERwin, ER/Studio, PowerDesigner, or similar tools


• Strong SQL and database design expertise


• Experience with Oracle, SQL Server, Snowflake, Azure SQL, or PostgreSQL


• Data Warehousing and Data Vault


• Financial Reporting, Treasury, and Risk Reporting

Mandatory Skills

• BI Solutions Architecture


• Dimensional Data Modeling


• Power BI


• Tableau

Preferred / Good To Have

• Azure Databricks


• Azure Data Factory


• Azure Synapse


• Snowflake


• Experience in Banking, Capital Markets, or Financial Services


• Knowledge of IFRS, US GAAP, or Basel regulations

Candidate Profile

The ideal candidate should have strong hands-on experience in data modeling with a solid understanding of Finance processes and reporting requirements. A Bachelor's degree in Computer Science, Information Systems, Finance, or a related field is expected, along with the ability to work effectively across business, data, and architecture teams.

Benefits Package

• Competitive salary and benefits package


• Opportunities for professional growth and development


• A collaborative and inclusive work environment


• The opportunity to work on exciting and challenging projects with leading clients