Padmi
3Pillar logo
3Pillar

AI transformation · AI-native products

Data Architect (EDW)

Remote · CAPosted 2 months ago
DataUnspecifiedFull Time
Apply at 3Pillar

Opens the source posting on jobs.lever.co

Source description

About the role

View original

Architecture & Solution Design

Architect & Design end-to-end EDW and BI solutions

Design and implement scalable dimensional data models (star schemas, fact/dimension design, conformed dimensions)

End-to-End Delivery Ownership

Own full lifecycle delivery: requirements → design → build → deploy → adoption → optimization & support

Ensure performance, scalability, and reliability across EDW and BI platforms

Drive cloud deployment and production readiness of analytics solutions

Take accountability for solution outcomes, adoption, and continuous improvement

Data Engineering & Integration

Translate business requirements into scalable data analytics solutions

Design and oversee scalable data pipelines (ETL/ELT) supporting enterprise analytics

Lead development of data transformation, cleansing, and enrichment processes

Implement data quality, validation, and monitoring frameworks

Integrate analytics data ingested across high-volume, multi-source environments (APIs, relational systems, SaaS, flat files, JSON/XML) and make it available for various data consumers

Integrate and enhance large scale BI solutions both on prem and in the cloud

Leadership & Stakeholder Engagement

Facilitate architecture and technical design sessions

Act as a trusted advisor bridging business strategy and technical delivery

Lead and mentor BI developers, data engineers, and analysts

Governance & Best Practices

Establish and enforce data governance, data stewardship, security, and reporting standards

Define best practices across:

Data modeling

Data engineering pipelines

Visualization standards

Performance optimization

Deliver scalable, reusable, and enterprise-aligned solutions

More at 3Pillar

Related open roles

View all roles