Back to Jobs
Recently postedTechnology

Finance Data Architect

NsightUnited States🇺🇸United States

Quick overview

Work modeHybrid
LocationUnited States
Stakeholder ManagementOracleSnowflakeAzureAzure Data Factory

Job description

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.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs