Remote Cloud Data Warehouse Architect

Hybrid in Camp Hill, PA, US • Posted 30 days ago • Updated 23 days ago

Full Time

On-site

BASED ON EXPERIENCE

EDI Specialists, Inc.

Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

DATA WAREHOUSE
DATA ARCHITECT
SQL
CLOUD
AZURE

Summary

SUMMARY
The Cloud Data Warehouse Architect will design and deliver the next-generation enterprise analytics platform. This position is highly technical and will focus on building a cloud-native, SAP-integrated, AI-ready architecture that supports analytics, reporting, and advanced machine learning at scale.

The architect will modernize current BI and data warehouse environment, anchored today in IBM 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 bridge 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 SAP S/4HANA migration with tight integration into futrestate.
Deliver governed, high-performance datasets for self-service analytics in Tableau, Power BI, and SAC.
Enable AI/ML use cases through Databricks and Azure ML.
Extend analytics capabilities to our partners and vendors via 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

Lead 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.
Develop a reference architecture that leverages Azure Data Lake Storage (ADLS) and Databricks Delta Lake as core components.
Implement semantic modeling to unify reporting across Tableau, Power BI, and SAP Analytics Cloud (SAC).

Data Engineering & Performance

Oversee 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 Delta Lake / warehouse design.
Establish reusable ETL/ELT patterns across Databricks notebooks, SQL-based orchestration, and integration with ActiveBatch scheduling.

Governance, Security & Compliance

Define and enforce data governance standards (naming conventions, metadata, lineage, data quality).
Partner with InfoSec on identity management (Azure AD), encryption, and RBAC/ABAC models.
Implement governance tooling such as Azure Purview, SAP metadata catalogs, Databricks Unity 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 SAP 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 related field.

Experience

7+ years in data engineering, data warehouse architecture, or cloud data architecture.
Expertise in Azure (ADLS, Synapse, Purview, Databricks, networking, security).
Strong proficiency in Databricks (Delta Lake, PySpark, SQL) and/or Snowflake (warehouse design, scaling, security).
Proven experience in data modeling (3NF, star schema, semantic layers).
Deep SQL expertise across both cloud and traditional RDBMS (Netezza, SQL Server, Progress OpenEdge).
Understanding of SAP S/4HANA integration and familiarity with SAP 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 SAP Analytics Cloud (SAC) and embedded analytics.
Knowledge of machine learning workflows and integration with Databricks MLflow or Azure ML.
Strong knowledge of data governance frameworks and tooling (Purview, Unity Catalog, SAC governance).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10107595
Position Id: 26-00017
Posted 30 days ago

Company Info

About EDI Specialists, Inc.

At EDI Staffing, we strive to provide the best staffing solutions for each of our business disciplines, in honest, resourceful, and creative techniques. Our mission is to connect talented people with great organizations across all industries, while maintaining our company values: accountability, innovation, integrity, teamwork and work ethic. Our commitment to our values becomes tangible in our daily customer interactions and lifetime customer relationships.

Careers

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.