Job Description
Sr.
Data Solution Architect/Consultant Job Poster :
Wisestep-Inc Skills:
Data Science, Cloud Computing, Data Engineering, Cloud Architecture, Data Visualization, Data Warehousing, Data Modeling, Data Governance, Data Integr | Location:
Philadelphia , Pennsylvania , United States Of America Views:
8 Sr. Data Solution Architect/Consultant
Key Responsibilities
Lead the design of scalable data solutions that unify supply chain and finance data across ERP, procurement, logistics, inventory, and billing systems.
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, Inventory & Warehousing, Costing, Vendor & Spend, and Logistics.
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.
Establish best practices for Master data, Reference data, and Hierarchies.
Define and implement data governance: data ownership, stewardship, definitions, lineage, retention.
Build data quality frameworks: rules, profiling, anomaly detection, completeness and reconciliation checks.
Partner with data engineering teams to implement ETL/ELT pipelines, orchestration, CI/CD, environment management, and performance tuning.
Required Qualifications
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:
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).
Bachelor of Engineering/Computers or equivalent.
Master's in Power BI or Finance Solution Data Architect.
Technical Skills & Experience
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).
ETL/ELT pipelines, orchestration, CI/CD, environment management, and performance tuning.
Observability (logging, monitoring, SLA/SLI, cost optimization).
Self-service analytics and reusable data products.
Preferred Qualifications
Master's in Power BI or Finance Solution Data Architect.
Strong expertise in Supply Chain data and its intersection with Finance (Procure-to-Pay, Inventory Accounting, Costing, CapEx/OpEx, Vendor Spend Analytics).
Experience with domain-aligned datasets for Procure-to-Pay, Inventory & Warehousing, Costing, Vendor & Spend, and Logistics.
Expertise in data modeling (dimensional + normalized) and semantic layer design.
Experience with cloud and data technologies such as Azure / AWS / GCP, Snowflake / Databricks / BigQuery / Redshift / Synapse, and Informatica / ADF / Fivetran / dbt / Airflow.
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.
