Design and maintain conceptual, logical, and physical data models for scalable data architectures. Implement Data Vault structures, including Hubs, Links, and Satellites, across enterprise data lakes and lakehouses. Deploy models using Azure data services, optimize performance, document data flows, and collaborate with engineers, scientists, analysts, and stakeholders. Apply data modeling best practices, integration techniques, security standards, and compliance requirements.
Primary Skills: Data Modeler Secondary Skills: Banking domain, Power Designer/ERWin/ER/Studio, Cloud Azure Job Description: We are seeking a skilled Sr. Data Modeler to join our team and contribute to the design and implementation of scalable and efficient data models. The ideal candidate will have experience with Data Modeling techniques, proficiency in Cloud Azure, and good to have working knowledge with Databricks. Responsibilities: Data Modeling: Design and develop data models to ensure robust, scalable, and flexible data architectures. Create and maintain conceptual, logical, and physical data models to support business requirements. Collaborate with stakeholders to understand data requirements and translate them into effective data models. Implement best practices for data modeling, including normalization, denormalization, and data integration. Data Vault Implementation: Utilize Data Vault techniques to build enterprise data lake and lake house and integrate disparate data sources. Design and implement Hubs, Links, and Satellites to ensure comprehensive data capture and historical tracking. Optimize data vault models for performance and scalability. Cloud Azure: Good to have(Secondary) Design and deploy data models on Azure Data Services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics. Ensure data security, compliance, and best practices in Azure environments. Collaboration and Communication: Work closely with data engineers, data scientists, and business analysts to understand data needs and ensure data model alignment. Document data models, data flows, and integration processes clearly and comprehensively. Data Modelling tools Azure: Data analysis and modeling tools (e.g. Power Designer, ERWin, ER/Studio)"
Hexaware Technologies Chicago, Illinois, USA Office
Chicago, United States, 0
Similar Jobs
Information Technology • Software • Analytics • Business Intelligence
Leads teams developing and maintaining complex cloud-based big data platforms and pipelines. Owns architecture, delivery strategy, data modeling, governance, observability, reliability, security, and cost optimization. Translates business requirements into technical plans, oversees coding and production support, manages risks and client communication, establishes quality and CI/CD practices, and mentors engineers while providing cross-team architectural governance.
Top Skills:
AlertingCi/CdCloud ComputingData CatalogingData GovernanceData LineageData ModelingEvent-Driven PipelinesGCPGitKappa ArchitectureLambda ArchitectureLoggingMicroservicesMonitoringObservabilityPythonScrumSQL
Information Technology • Consulting
Leads hands-on big data processing, data engineering, and analytics workflows using Azure Databricks, Python, and SQL. Develops insights and reporting with Power BI, Tableau, and Excel. Analyzes complex datasets, communicates findings to business stakeholders, manages competing priorities, meets deadlines, and promotes continuous improvement.
Top Skills:
Azure DatabricksExcelPower BIPythonSQLTableau
Information Technology • Consulting
Design, build, and optimize end-to-end ETL/ELT pipelines using Python and PySpark for large structured and unstructured datasets. Ensure data quality through validation and reconciliation, troubleshoot performance issues, implement CI/CD and code review practices, and collaborate with IT and business stakeholders to translate requirements into scalable data solutions.
Top Skills:
AWSAzureBitbucketCi/CdData WarehousingDistributed ComputingEtl/EltGCPGitHadoopMicrosoft Sql ServerPysparkPythonSparkSQL
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

