Cloud Data Architect Location: 100% Remote

Job Description:

Cloud Data Architect

Location: 100% Remote

Experience Requirements

Bachelor's degree in Computer Science, Engineering, or related field and 10+ years of experience in enterprise data engineering, data warehouse architecture, or cloud data architecture, with demonstrated progression into architectural ownership and technical leadership roles.

Proven experience designing and owning end-to-end data architectures, including on-prem, cloud, and hybrid environments - not simply implementing architectures defined by others.

Deep understanding of hybrid data ecosystems, including:

Coexistence of on-prem and cloud data platforms

Strategies for moving, synchronizing, and governing data across environments

Designing architectures that support gradual migration rather than lift-and-shift

Strong data warehouse and lake house architecture expertise, including:

Designing and operating Bronze / Silver / Gold data layers

Blending and federating data across multiple warehouses (on-prem and cloud)

Supporting governed analytics, semantic layers, and enterprise reporting

Advanced data modeling skills, with hands-on experience designing:

3NF and normalized operational models

Dimensional/star schemas

Enterprise semantic and consumption layers for analytics and BI

Expert-level SQL proficiency across both cloud and traditional RDBMS platforms, with experience in systems such as:

Netezza or other MPP databases

SQL Server and similar enterprise relational platforms

Modern cloud data warehouses or lake house query engines

Cloud platform experience (Azure, AWS, or GCP) with a strong understanding of:

Cloud storage, compute, networking, and security concepts

Cost-aware architecture design, scaling strategies, and performance optimization

Designing platforms that are resilient, secure, and future-ready

Experience establishing data governance and architectural standards, including:

Defining data ownership, lineage, quality, and access patterns

Partnering with analytics, security, and business stakeholders to enforce governance at scale

Ability to operate as a senior technical leader, including:

Making architectural trade-off decisions and clearly articulating rationale

Guiding engineering teams while remaining hands-on at the design level

Translating business, analytics, and SAP requirements into durable platform designs

Preferred / Bonus Experience

Experience modernizing or migrating legacy on-prem data warehouses (e.g., Netezza or other MPP systems) to cloud-native lake house or warehouse architectures.

Hands-on experience with Databricks (Delta Lake, Spark/PySpark, SQL) and/or Snowflake, including:

Lakehouse or warehouse design patterns

Performance tuning and cost optimization

Security, data sharing, and governance controls

Familiarity with SAP-centric analytics ecosystems, including SAP Business Data Cloud / Datasphere, SAP Analytics Cloud (SAC) or Integration patterns with SAP S/4HANA and non-SAP data sources

Experience supporting or modernizing enterprise BI platforms, including migrations from tools such as Cognos to Tableau or Power BI, with a focus on architecture and semantic design (not report development).

Knowledge of data governance frameworks and tooling, such as: Azure Purview, Unity Catalog, or comparable platforms

Exposure to AI/ML enablement architectures

Working Place:

Remote, OR, USA

Company :

ESR Healthcare