Data Modeling Architect / Data Architect

We are hiring a Data Modeling Architect to design and optimize enterprise data models and architectures across cloud and on-prem environments.

Key Responsibilities

• Build conceptual, logical & physical data models for RDBMS, ODS, data marts, and data lakes (SQL/NoSQL).
• Design and document data architecture & modeling solutions for BI, analytics, ML & enterprise systems.
• Translate business requirements into effective Data Lake/Data Mart models.
• Conduct impact analysis, estimations, and model enhancements.
• Apply normalization (1NFBCNF) and data quality best practices.
• Optimize data architecture, performance, and query efficiency.
• Collaborate with BI/Data Engineering teams on mapping, defect analysis & issue resolution.
• Maintain documentation and support DWH/data services operations.

Required Skills

• 3+ years in Cloud Architecture (Azure/AWS/GCP).
• Experience with Synapse, Databricks, Snowflake, Redshift.
• Strong in SQL, NoSQL, DBT, PySpark, Python.
• Expertise in data modeling tools & data warehousing concepts.
• Strong SQL/Python development & stored procedures knowledge.
• Experience with Power BI, Tableau, Qlik, MicroStrategy.
• Knowledge of API/SFTP data integrations.
• Experience in Agile/Scrum, problem solving, and communication.