Senior Finance Data Architect / Data Modeler

🚀 We're Hiring: Senior Finance Data Architect / Data Modeler

Hi,

Hope you are doing great today!

We are looking for an experienced Senior Finance Data Architect / Data Modeler to join our team for a 6-month contract with a strong possibility of extension. The ideal candidate should have strong healthcare finance domain knowledge, hands-on data architecture and modeling experience, and excellent communication skills.

📌 Job Details

• Job Title: Senior Finance Data Architect / Data Modeler
• Location: Minnetonka, MN (Local Candidates Only)
• Duration: 6-Month Contract (Likely Extension)
• Open Positions: 1
• Work Arrangement: Local to Minnetonka, MN

🔹 Role Overview

The Senior Finance Data Architect / Data Modeler will own enterprise finance data architecture and data models connecting healthcare operational transactions with subledger, ERP/General Ledger (GL), reconciliation, and analytics platforms.

This role requires strong business acumen in healthcare finance, particularly in payment processing, invoicing, financial adjustments, reconciliation, and financial reporting. The candidate will collaborate with Finance, Accounting, Solution Architecture, Data Engineering, ERP, and BI teams to translate business requirements into scalable data solutions.

🔹 Key Responsibilities

1. Finance Data Architecture & Modeling

• Define target-state finance data architecture and conceptual, logical, and physical data models.
• Model General Ledger (GL), Chart of Accounts, subledger, AP/AR, premium billing, claims expenses, payments, accruals, budgeting, forecasting, and actuals.
• Design enterprise data warehouse, data marts, dimensional models, and curated data structures.
• Define historical, adjustment, reversal, and financial-period modeling strategies.

2. Healthcare Finance Data Domains

• Model healthcare data domains, including claims, membership, eligibility, premiums, provider, pharmacy, capitation, and risk adjustment.
• Establish relationships between healthcare business events, payments, subledger, journal entries, and GL transactions.
• Collaborate with Finance and Accounting teams on financial close, accruals, reconciliation, and control requirements.

3. ERP / Workday Financial Data

• Design data models supporting Workday Financials or comparable ERP platforms such as SAP, Oracle, or PeopleSoft.
• Define financial dimensions, including legal entity, account, cost center, business unit, department, vendor/customer, currency, and fiscal calendar.
• Develop source-to-ERP mappings and Chart of Accounts crosswalks.

4. Data Integration & Source-to-Target Architecture

• Define canonical data structures, source-to-target mappings, transformations, validations, and interface contracts.
• Support ETL/ELT, batch, API, CDC, and event-driven integration patterns.
• Design business and transaction keys for traceability, duplicate detection, and reprocessing.
• Collaborate with engineering teams on scalable data pipelines and exception handling.

5. Reconciliation & Financial Controls

• Design reconciliation processes across source systems, curated finance data, subledger, ERP/GL, and reporting.
• Define control totals, record counts, completeness checks, variance workflows, and exception handling.
• Ensure financial transactions are traceable to originating business events with auditable history.

6. Data Governance & Quality

• Establish finance data standards, metadata, business glossaries, data dictionaries, and lineage.
• Define data quality rules and ensure accuracy, completeness, consistency, and security.
• Support PHI/PII protection, access controls, retention, and audit requirements.

7. Finance Analytics & Reporting

• Design curated finance data models for Controllers, FP&A, Treasury, and executive reporting.
• Support Power BI or equivalent analytics platforms.
• Ensure clear distinctions between operational financial views and reconciled, GL-posted financial results.

8. Architecture & Delivery Collaboration

• Partner with Solution Architects, Systems Analysts, Data Engineers, ERP teams, and BI teams.
• Translate business requirements into data structures, mappings, and technical specifications.
• Participate in architecture and data governance reviews.
• Create ERDs, architecture diagrams, source-to-target mappings, lineage documentation, and data dictionaries.

🔹 Required Qualifications

• 8 years of experience in Data Architecture, Data Modeling, Enterprise Data, or Data Engineering Architecture.
• Strong conceptual, logical, physical, and dimensional data modeling skills.
• Advanced SQL and relational database knowledge.
• Strong understanding of GL, Chart of Accounts, AP/AR, subledger, journals, payments, reconciliation, accruals, and financial close.
• Experience with ERP/financial system integration and enterprise data warehouses or cloud data platforms.
• Experience with source-to-target mapping, canonical models, metadata, lineage, data quality, and governance.
• Strong business acumen in the finance domain, preferably healthcare finance.
• Excellent communication skills and the ability to work directly with Finance, Accounting, Architecture, Engineering, and business stakeholders.

🔹 Preferred Qualifications

• Healthcare payer/provider experience with claims, membership, premiums, payments, PBM/pharmacy, capitation, risk adjustment, or IBNR.
• Experience with Workday Financials, Workday Accounting Center, or Worktags.
• Experience with SAP, Oracle, or PeopleSoft financial systems.
• Familiarity with Snowflake, Databricks, Microsoft Fabric, Azure/AWS, and Power BI.
• Experience with MDM, metadata catalogs, data lineage, finance transformation, and Chart of Accounts harmonization.
• Knowledge of healthcare regulatory requirements, PHI/PII, audit, and financial controls.

📩 Interested or Know Someone Who Might Be a Good Fit?

If you are interested in this opportunity or know someone who may be a good fit, please share your updated resume or reach out to me directly.