Apply on Employer Site

Tata Consultancy Services · 4 hours ago

Solution Architect

Philadelphia, PA

Full-time

Onsite

Senior Level, Lead/Staff

$100K/yr - $120K/yr

15+ years exp

Tata Consultancy Services is seeking a Solution Architect with extensive experience in data and solution architecture. The role involves leading the design of scalable data solutions that unify supply chain and finance data, ensuring accurate reporting and operational insights.

Business Information SystemsConsultingInformation TechnologyIT Management

H1B Sponsor Likely

Responsibilities

Own end-to-end data architecture for finance + supply chain analytics, reporting, and operational use-cases. Define target-state architecture (lakehouse/warehouse, streaming, APIs, metadata) aligned to enterprise standards

Design robust data ingestion and integration patterns (batch/stream, CDC, API-based, file-based)

Ensure architecture supports auditability, reconciliation, and financial controls (traceability from source to report)

Architect Domain-aligned Datasets For Procure-to-Pay (P2P): requisitions, purchase orders, invoices, payments

Inventory & Warehousing: receipts, transfers, adjustments, stock valuation

Costing: standard/actual costing, landed cost, freight, BOM where relevant

Vendor & Spend: vendor master, contracts, pricing, spend categorization

Logistics: shipment tracking, carrier costs, delivery performance

Enable integration between supply chain events and finance outcomes (e.g., GR/IR, accruals, capitalization, write-offs)

Create and maintain conceptual, logical, and physical data models (3NF, dimensional, Data Vault as applicable)

Define canonical models and enterprise semantic layers for KPI consistency

Define and implement data governance: data ownership, stewardship, definitions, lineage, retention

Build data quality frameworks: rules, profiling, anomaly detection, completeness and reconciliation checks. Ensure compliance with privacy and security standards (PII/PCI/SOX-like controls where applicable). Drive processes for data issue management, root cause analysis, and remediation

Partner With Data Engineering Teams To Implement ETL/ELT pipelines, orchestration, CI/CD, environment management

Performance tuning, partitioning, indexing, clustering strategies

Observability (logging, monitoring, SLA/SLI, cost optimization)

Guide design for self-service analytics and reusable data products

Engage Finance, Supply Chain, Procurement, and IT stakeholders to translate needs into architecture

Lead architecture reviews, technical documentation, and implementation roadmaps

Work with program/product managers to define scope, milestones, dependencies, and risk mitigation

Qualification

Data ArchitectureData ModelingCloud PlatformsData IntegrationData GovernanceSupply Chain KnowledgeFinance IntegrationAdvanced SQLStakeholder ManagementTechnical Documentation

Required

15+ years in data/solution architecture with strong ownership of enterprise-scale implementations

Strong experience designing data warehouses/lakehouses, enterprise integration, and analytics platforms

Expert in data modeling (dimensional + normalized) and semantic layer design

Strong Understanding Of Supply Chain Business Processes And Data: procurement, inventory, logistics, supplier management, costing

Solid Finance Integration Knowledge: GL mapping, accrual logic, inventory valuation, cost allocations, reconciliation

Cloud & Data Tech Stack: Cloud: Azure / AWS / GCP (any one strong; multi-cloud is a plus)

Data platforms: Snowflake / Databricks / BigQuery / Redshift / Synapse

Data integration: Informatica / ADF / Fivetran / dbt / Airflow (any relevant)

Storage & formats: Parquet/Delta/Iceberg; S3/ADLS/GCS

Querying: advanced SQL; performance tuning; data partition strategies

Data governance: Collibra / Purview / Alation (or equivalent)

BI/Analytics: Power BI / Tableau / Looker (semantic + KPI definitions)

Masters in PowerBI, Finance Solution Data Architect with deep expertise in Supply Chain data and its intersection with Finance (Procure-to-Pay, Inventory Accounting, Costing, CapEx/OpEx, Vendor Spend Analytics)

Own end-to-end data architecture for finance + supply chain analytics, reporting, and operational use-cases

Define target-state architecture (lakehouse/warehouse, streaming, APIs, metadata) aligned to enterprise standards