Finance Data Architect


Nsight
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Fact & Dimension Modeling
- MuleSoft
- Boomi
- SOX
- ITGC
- ICFR
- Financial Reporting
Summary
Job Description
Nsight is seeking an experienced Finance Data Architect to lead the architecture and design of modern finance data platforms for enterprise clients.
The ideal candidate will have a strong combination of financial domain expertise and technical architecture experience, particularly with Snowflake, ERP financial data, dimensional modeling, enterprise integrations, and data governance.
This role requires close collaboration with Finance, FP&A, Accounting, Controllership, and IT stakeholders to build scalable, trusted, and well-governed financial data platforms.
This is a business-facing architecture role that requires the ability to translate complex financial requirements into practical data architecture solutions.
Key Responsibilities
Finance Data Architecture
- Lead requirements gathering and architecture workshops with Finance, FP&A, Accounting, and IT stakeholders.
- Design enterprise financial data warehouse architectures using Snowflake.
- Develop logical and physical data models covering GL, AP, AR, Procurement, Purchase Orders, Vendors, Employees, Cost Centers, Projects, Budgets, and Forecasts.
- Design fact and dimension models for financial reporting, planning, and analytics.
- Establish reliable and reconciled sources of financial data.
ERP & Systems Integration
- Architect integrations between ERP platforms, finance applications, and Snowflake.
- Work extensively with NetSuite financial data, including GL, AP, AR, PO, and Vendor domains.
- Define ERP-to-Snowflake ingestion and transformation patterns.
- Design integration solutions using Workato, MuleSoft, Boomi, Azure Data Factory, or similar platforms.
- Establish reconciliation, auditability, error-handling, and data-quality controls.
Snowflake Architecture
- Design scalable Snowflake environments for enterprise financial reporting and analytics.
- Define data layers, transformation patterns, dimensional models, security, and access controls.
- Partner with data engineering teams to implement production-ready data models.
- Establish reusable architecture patterns and performance optimization standards.
Master Data Management & Governance
- Define governance practices for Chart of Accounts, Cost Centers, Legal Entities, Projects, Programs, Vendors, Employees, and Departments.
- Establish data ownership, stewardship, naming standards, and data-quality rules.
- Define master data change management and approval processes.
- Maintain architecture documentation and data decision logs.
Finance Stakeholder Engagement & Compliance
- Facilitate workshops with Finance executives, Controllers, FP&A, and operational teams.
- Translate financial reporting and accounting requirements into technical architecture.
- Understand financial statements, accounting structures, ERP transactions, and management reporting.
- Support architecture requirements related to SOX, IT ICFR, data lineage, audit trails, and financial reconciliation.
- Communicate technical architecture decisions effectively to business and IT stakeholders.
Required Qualifications
- 10+ years of experience in Data Architecture, Data Warehousing, or Enterprise Data Platforms.
- 5+ years of experience in a Lead, Principal, or Senior Data Architect role.
- Strong hands-on experience with Snowflake architecture.
- Strong expertise in dimensional modeling, including Fact and Dimension modeling.
- Experience architecting financial, ERP, or enterprise finance data solutions.
- Strong understanding of General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Procurement, Vendors, Cost Centers, and Chart of Accounts.
- Experience working directly with Finance, FP&A, and Accounting stakeholders.
- Experience designing enterprise data integration architecture.
- Experience with Master Data Management (MDM) and data governance.
- Understanding of SOX, IT ICFR, and enterprise data controls.
- Excellent communication, stakeholder management, and workshop facilitation skills.
- Ability to create architecture diagrams, logical/physical data models, and technical design documentation.
Preferred Qualifications
- SnowPro Core or SnowPro Advanced Architect certification.
- Hands-on experience with Oracle NetSuite financial data.
- Experience with Workato, MuleSoft, Boomi, or Azure Data Factory.
- Experience supporting US public companies.
- Knowledge of SOX compliance and financial reporting controls.
- Experience in pharmaceutical or life sciences industries.
- Experience with Workday Adaptive Planning or similar FP&A platforms.
- Experience with modern BI, analytics, and semantic-layer platforms.
- Experience supporting ERP modernization, acquisitions, or enterprise finance transformation initiatives.
- Dice Id: 10197390
- Position Id: 9147953
- Posted 2 hours ago
Company Info
About Nsight
The SAP practice team is lead by Top Tier Consultants who have provided SAP Project leadership from Conceptualization to Implementation and managed implementation teams of mid-size to large-size consultants. We have invested in our methodology and reusable models, and templates related to SAP Architecture and SAP Design Services. Some of our practitioners have been speakers and subject matter experts at SAP user conferences while making close ties with SAP America.
Our SAP Practitioners have an average SAP exposure of 9 years and have diverse experience in a wide spectrum of industries and understand the markets in which our clients do business. Our consultants keep themselves up to date with current technologies and have the business and technical experience to help clients align their business and IT strategies. The Nsight team has a proven track record to deliver projects on time and within budget. Our consultants are well versed in different methodologies, processes and tools. We deliver a great quality of work and provide a positive experience to clients with a sense of trust and comfort. Our best talented consultants offer complete business and IT solutions converging with the SAP suite of applications.
Locations
California, Minnesota, Canada, & India
Career Website
www.nsight-inc.com/career.html
News
www.nsight-inc.com/news.html
Careers

