Remote Cloud Data Warehouse Architect

Other Jobs To Apply

No other job posts for this day.

This a Full Remote job, the offer is available from: Pennsylvania (USA) 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 arenaflex 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 arenaflex 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 (arenaflex 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). This offer from "EDI Staffing, an EDI Specialists Company" has been enriched by Jobgether.com and got a 72% flex score. Apply tot his job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...