Senior Specialist - Architecture (Finance Data Modeling)

Vivantify Technology Solutions India Private Limited; Pune District; On-site; INR 2,400,000 - 3,800,000; Full time

Job summary

Vivantify Technology Solutions India Private Limited seeks an experienced Data Modeler with strong finance domain expertise to design and maintain enterprise data models for finance systems and data warehouses. The role supports financial reporting, accounting, risk, treasury, and regulatory initiatives while ensuring scalable, governed data structures.

You will collaborate with Finance, Business, Data Engineering, and Architecture teams, and support ETL/ELT development through mappings and

Qualifications

• Experience designing conceptual, logical, and physical data models for finance systems.
• Ability to translate business requirements into scalable data structures.
• Experience with star/snowflake dimensional models for reporting.
• Knowledge of data governance and metadata documentation.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for finance systems and data warehouses.
• Translate business requirements into scalable 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.

Skills

Finance domain data modeling

Dimensional data modeling

Data modeling

BI solutions architecture

Power BI

Tableau

SQL

Oracle

Snowflake

Data warehousing

Data vault

Financial reporting

Treasury reporting

Education

Bachelor's degree in Computer Science, Information Systems, Finance, or related field

Tools

ERwin

ER/Studio

PowerDesigner

Job description

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