CLOUD AMAZE - DW Architect (Practice) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Hexaware Technologies · 1 month ago

CLOUD AMAZE - DW Architect (Practice)

Hexaware Technologies is seeking a Data Lake/Lakehouse Data Modeler with extensive experience in building data models on Azure for banking applications. The role involves designing data schemas to support various banking analytics and ensuring compliance with regulatory standards.

BankingConsultingInfrastructureInsuranceInsurTechSoftware
check
H1B Sponsor Likelynote

Responsibilities

Design logical and physical models across raw, curated, and consumption layers optimized for lakehouse patterns
Define canonical models and source-to-target mappings for transactions, accounts, customers, loans, payments, and exposures
Define retention, archival, encryption (CMK), and access controls using Azure Key Vault and Azure AD
Work with data engineers and platform teams to implement models in Databricks and Synapse with CI/CD and tests
Perform data profiling, validation, and iterative tuning to meet performance and SLAs for BI and ML consumers

Qualification

Data Lake modelingAzure DatabricksAzure Synapse AnalyticsADLS Gen2CDCStreamingSpark SQLPower BIStakeholder engagementModel governanceAzure certificationsModeling tools experienceDocumentation

Required

Proven experience modeling lakehouse or data lake solutions for banking or financial services
Deep domain knowledge of payments, ledgers, credit lifecycle, risk metrics, and regulatory reporting needs
Hands-on experience with ADLS Gen2, Azure Databricks (Delta Lake), and Azure Synapse Analytics
Practical experience with CDC, streaming, low-latency analytics, and schema evolution strategies
Familiarity with Purview, Azure AD, Key Vault, network isolation, and regulatory compliance controls
Delta Lake, Parquet/ORC, schema evolution, partitioning and Z-order/clustering strategies
Spark SQL, Databricks notebooks, dbt or similar modeling frameworks, and strong SQL proficiency
Ingestion and orchestration with ADF/Synapse Pipelines, Event Hubs, Stream Analytics, and Airflow/Jobs
BI and analytics integration using Power BI, Synapse SQL, and Databricks SQL for served models
Strong stakeholder engagement across compliance, risk, finance, engineering, and data science teams
Clear documentation, model governance, and ability to present designs for audits and architecture reviews

Preferred

10 + years of experience in data modeling or data engineering with banking experience preferred
5 plus years of experience with different modeling tools like Erwin/ Embarcadero or ER Studio
Azure or Databricks certifications valued

Company

Hexaware Technologies

company-logo
At Hexaware, we're not just a global technology and business process services company; we're a community of 31,600+ Hexawarians dedicated to one singular purpose: creating smiles through the power of great people and technology.

H1B Sponsorship

Hexaware Technologies has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (629)
2024 (703)
2023 (510)
2022 (648)
2021 (647)
2020 (1064)

Funding

Current Stage
Public Company
Total Funding
$67.69M
Key Investors
MAPE Advisory GroupGeneral Atlantic
2021-10-23Acquired
2013-01-01Post Ipo Equity
2006-10-01Post Ipo Equity

Leadership Team

leader-logo
P R Chandrasekar
Vice Chairman & CEO
linkedin
leader-logo
Srikrishna Ramakarthikeyan
CEO
linkedin
Company data provided by crunchbase