Job Title: Data Architect – Finance (GL, AR, AP) with Strong Azure Services W2 Role 12+ years of exp only- please dont submit if you dont have Finance (GL, AR, AP) experience Complete remote

Job Summary

We are seeking a highly skilled Data Architect with strong expertise in financial domains including General Ledger (GL), Accounts Receivable (AR), and Accounts Payable (AP). The ideal candidate will have the ability to understand complex business data and design scalable, efficient data models that support financial reporting, analytics, and compliance. This role requires deep experience in architecting modern data platforms using Microsoft Azure.

Key Responsibilities

Understand business requirements and translate them into scalable data architecture and data models.

Design conceptual, logical, and physical data models for finance systems (GL, AR, AP).

Architect and implement end-to-end data solutions on Microsoft Azure.

Build and maintain enterprise data warehouse and data lake architectures.

Integrate data from ERP systems (SAP, Oracle, NetSuite) and other upstream sources.

Develop and optimize ETL/ELT pipelines using Azure Data Factory and Databricks.

Enable batch and real-time data processing using Azure-native services.

Ensure data quality, consistency, and reconciliation across financial systems.

Support financial reporting including P&L, Balance Sheet, and Cash Flow.

Implement data governance, lineage, and cataloging using Azure Purview.

Collaborate with finance, business, and engineering teams for solution delivery.

Optimize performance, scalability, security, and reliability of data platforms.

Core Skills & Qualifications

Strong ability to understand business data and design effective data models.

Expertise in data modeling techniques (ER modeling, dimensional modeling – star/snowflake schema).

Strong hands-on experience with Microsoft Azure data services, including:

Azure Data Factory (ADF)

Azure Synapse Analytics

Azure Data Lake Storage (ADLS Gen2)

Azure Databricks

Azure SQL Database / Managed Instance

Azure Event Hub & Stream Analytics (real-time ingestion)

Azure Functions & Logic Apps (integration and automation)

Azure Purview (data governance and lineage)

Experience with data warehousing platforms (Snowflake, Redshift, Azure Synapse, BigQuery).

Strong proficiency in SQL and data transformation frameworks.

Knowledge of ETL tools (Informatica, Talend, DataStage, ADF).

Familiarity with BI tools (Tableau, Power BI, MicroStrategy).

Understanding of data lakehouse architecture and medallion design (Bronze/Silver/Gold).

Strong understanding of accounting principles and financial processes.

Domain Expertise

General Ledger (GL): Journal entries, chart of accounts, financial close

Accounts Receivable (AR): Billing, invoicing, collections

Accounts Payable (AP): Vendor invoices, payments, procure-to-pay cycle

Preferred Qualifications

Experience with ERP systems (SAP FI/CO, Oracle Financials, NetSuite)

Knowledge of compliance standards (SOX, GAAP, IFRS)

Experience in finance transformation and data migration programs

Strong experience in Azure cloud architecture and implementation

Nice to Have

Experience with real-time streaming technologies (Kafka, Spark)

Knowledge of Python or scripting languages

Experience working in large enterprise environments

This is a remote position.