Overview
Skills
Job Details
What Working at Hexaware Offers:
Hexaware is a dynamic and innovative IT organization committed to delivering cutting-edge solutions to our clients worldwide. We pride ourselves on fostering a collaborative and inclusive work environment where every team member is valued and empowered to succeed.
Hexaware provides access to a vast array of tools that enhance, revolutionize, and advance professional profiles. We complete the circle with excellent growth opportunities, chances to collaborate with high-profile customers, opportunities to work alongside brilliant minds, and the perfect work-life balance.
Job Title: Data Lake / Lakehouse Data Modeler Azure (Banking)
Duration: Full-time
Location: Jersey City, NJ
Mode of work: Hybrid/Onsite (3 days office / Per week)
Role Summary
Seeking a Data Lake/Lakehouse Data Modeler with deep hands-on experience building governed, secure, and high-performance data models on Azure for banking use cases. The role will design logical and physical schemas across landing, curated, and serving layers to support regulatory reporting, risk & finance analytics, fraud detection, AML, customer 360, and ML use cases while ensuring compliance, lineage and operational SLAs.
Key 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. Required Qualifications:
- 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.
Technical Skills:
- 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.
Experience & Education:
- 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.
- Deliverables: Model artifacts and data dictionaries, source-to-target mappings, lineage for audits, and measurable performance and quality improvements.
Equal Opportunities Employer:
Hexaware Technologies is an equal opportunity employer. We are dedicated to providing a work environment free from discrimination and harassment. All employment decisions at Hexaware are based on business needs, job requirements, and individual qualifications. We do not discriminate based on race including colour, nationality, ethnic or national origin, religion or belief, sex, age, disability, marital status, sexual orientation, parental status, gender reassignment, or any other status protected by law. We encourage candidates of all backgrounds to apply.