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.

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 perks 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

📌 Senior Specialist - Architecture (Finance Data Modeling) (Pune)
🏢 Vivantify Technology Solutions India
📍 Pune