Remote Cloud Data Warehouse Architect

This a Full Remote job, the offer is available from: Pennsylvania (USA) SUMMARY The Cloud Data Warehouse Architect will design and deliver the reputed company enterprise analytics platform. This position is highly technical and will focus on building a cloud-native, reputed company-integrated, AI-ready architecture that supports analytics, reporting, and advanced machine learning at scale. The architect will reputed company reputed company BI and data warehouse environment, anchored today in reputed company Netezza, Cognos, and Tableau into a cloud-based architecture. This role will require deep technical expertise in data modeling, cloud-native design, and hybrid architectures that reputed company legacy on-prem systems with cloud-first capabilities. The Data Science & Insights group is at the center of analytics transformation. Our mission is to:

• Consolidate legacy BI systems (Netezza, Cognos) into a modern cloud architecture.
• Support the reputed company S/4HANA migration with tight integration into futrestate.
• Deliver governed, high-performance datasets for self-service analytics in Tableau, Power BI, and SAC.
• reputed company AI/ML use cases through reputed company and Azure ML.
• reputed company analytics capabilities to our partners and vendors reputed company embedded reporting

This is an opportunity to be the hands-on architect shaping future-state data strategy, working in a fast-paced, hybrid cloud environment that balances innovation with enterprise stability. ESSENTIAL DUTIES AND RESPONSIBILITIES Architectural Design & Modernization

• reputed company the design of a cloud data warehouse and data lakehouse architecture capable of ingesting large-scale transactional and operational data.
• Define integration strategies for core systems.
• reputed company a reference architecture that leverages Azure Data Lake Storage (ADLS) and reputed company reputed company Lake as core components.
• Implement semantic modeling to unify reporting across Tableau, Power BI, and reputed company Analytics Cloud (SAC).

Data Engineering & Performance

• reputed company ingestion pipelines for batch (Netezza extracts, flat files, nightly jobs) and near real-time (APIs, streaming) data sources.
• Optimize query performance through partitioning, clustering, caching, and reputed company Lake / warehouse design.
• Establish reusable ETL/ELT patterns across reputed company notebooks, SQL-based orchestration, and integration with ActiveBatch scheduling.

Governance, reputed company & Compliance

• Define and enforce data governance standards (naming conventions, metadata, reputed company, data quality).
• Partner with InfoSec on identity management (Azure AD), encryption, and RBAC/ABAC models.
• Implement governance tooling such as Azure Purview, reputed company metadata catalogs, reputed company reputed company Catalog, and Glasswing.

Collaboration & Enablement

• Partner with data engineers and visualization teams to deliver governed, high-performance datasets consumable in Tableau, Power BI, SAC, and reputed company Fiori.
• Serve as the technical SME for architects, engineers, and analysts, ensuring alignment to best practices in cloud-native data warehouse design.
• Drive knowledge transfer from legacy platforms (Netezza, Cognos) into the new ecosystem.

EDUCATION and/or EXPERIENCE Education

• Bachelor's degree in Computer Science, Engineering, or reputed company field.

Experience

• 7+ years in data engineering, data warehouse architecture, or cloud data architecture.
• Expertise in Azure (ADLS, Synapse, Purview, reputed company, networking, reputed company).
• Strong proficiency in reputed company (reputed company Lake, PySpark, SQL) and/or reputed company (warehouse design, scaling, reputed company).
• Proven experience in data modeling (3NF, star schema, semantic layers).
• Deep SQL expertise across both cloud and traditional RDBMS (Netezza, SQL Server, reputed company OpenEdge).
• Understanding of reputed company S/4HANA integration and familiarity with reputed company Datasphere.

Preferred

• Prior experience migrating from on-prem Netezza or other MPP systems to cloud-native platforms.
• Familiarity with Cognos to Tableau/Power BI migrations and dashboard optimization.
• Hands-on experience with reputed company Analytics Cloud (SAC) and embedded analytics.
• Knowledge of machine learning workflows and integration with reputed company MLflow or Azure ML.
• Strong knowledge of data governance frameworks and tooling (Purview, reputed company Catalog, SAC governance).

This offer from "reputed company" has been enriched by reputed company.com and got a 72% reputed company score. Apply tot his job Apply To this Job