3+ Dimensional modeling Jobs in India
Apply to 3+ Dimensional modeling Jobs on CutShort.io. Find your next job, effortlessly. Browse Dimensional modeling Jobs and apply today!
About the Role
We are seeking a highly skilled and motivated Data Modeler with deep expertise in Cloud Data Platforms, SQL, Dimensional Modeling, and Performance Tuning to join our growing Data Engineering team. The ideal candidate will have experience in the Consumer-Packaged
Goods (CPG) domain and a proven track record of designing scalable, business-aligned data models that drive actionable insights.
You will work closely with cross-functional teams—including Sales, Trade, Supply Chain, Marketing, and Finance—to translate business requirements into robust data architectures.
This role demands both strong technical expertise and the ability to engage with business stakeholders to ensure data solutions are accurate, scalable, and aligned with strategic objectives.
Key Responsibilities
- Design, develop, and maintain dimensional, relational, and semantic data models that support analytical and operational use cases.
- Ensure models are scalable, flexible, and optimized for performance across various workloads.
- Partner with business stakeholders to understand processes, KPIs, and reporting needs, translating them into effective data models.
- Work closely with Data Engineers, Architects, and Analysts to ensure seamless data flow and model implementation.
- Conduct SQL performance tuning and query optimization for large-scale datasets.
- Recommend and implement strategies to enhance data retrieval speed and efficiency.
- Design and implement models on leading platforms such as Databricks and Snowflake.
- Leverage data modeling tools to build, visualize, and manage metadata-driven architectures.
- Ensure models comply with data governance, security, and quality standards.
- Maintain proper documentation, lineage, and metadata for all models.
- Apply CPG domain knowledge to model data relevant to sales forecasting, trade promotion, supply chain visibility, marketing analytics, and financial reporting.
- Build reusable and domain-specific data structures that reflect real-world business processes.
Required Skills & Competencies
- Strong expertise in SQL & Performance Tuning for analytical queries.
- Proven experience with Cloud Data Platforms (Databricks, Snowflake).
- Hands-on knowledge of Data Modeling Tools (Erwin, PowerDesigner, or similar).
- Solid understanding of Dimensional Modeling concepts (Star/Snowflake schemas, slowly changing dimensions, fact/dimension tables).
- Experience working with large datasets in a distributed/cloud environment.
- Strong communication skills with the ability to bridge business and technical discussions.
- Ability to work in a fast-paced, cross-functional environment and manage multiple priorities.
Preferred Qualifications
- Experience in the CPG domain, especially across Sales, Trade, Marketing, Finance, or Supply Chain data processes.
- Familiarity with ETL/ELT processes and modern data engineering frameworks.
- Exposure to Agile methodologies for data delivery
Advanced SQL, data modeling skills - designing Dimensional Layer, 3NF, denormalized views & semantic layer, Expertise in GCP services
Role & Responsibilities:
● Design and implement robust semantic layers for data systems on Google Cloud Platform (GCP)
● Develop and maintain complex data models, including dimensional models, 3NF structures, and denormalized views
● Write and optimize advanced SQL queries for data extraction, transformation, and analysis
● Utilize GCP services to create scalable and efficient data architectures
● Collaborate with cross-functional teams to translate business requirements(specified in mapping sheets or Legacy
Datastage jobs) into effective data models
● Implement and maintain data warehouses and data lakes on GCP
● Design and optimize ETL/ELT processes for large-scale data integration
● Ensure data quality, consistency, and integrity across all data models and semantic layers
● Develop and maintain documentation for data models, semantic layers, and data flows
● Participate in code reviews and implement best practices for data modeling and database design
● Optimize database performance and query execution on GCP
● Provide technical guidance and mentorship to junior team members
● Stay updated with the latest trends and advancements in data modeling, GCP services, and big data technologies
● Collaborate with data scientists and analysts to enable efficient data access and analysis
● Implement data governance and security measures within the semantic layer and data model
Responsibilities
- Design and implement Azure BI infrastructure, ensure overall quality of delivered solution
- Develop analytical & reporting tools, promote and drive adoption of developed BI solutions
- Actively participate in BI community
- Establish and enforce technical standards and documentation
- Participate in daily scrums
- Record progress daily in assigned Devops items
Ideal Candidates should have
- 5 + years of experience in a similar senior business intelligence development position
- To be successful in the role you will require a high level of expertise across all facets of the Microsoft BI stack and prior experience in designing and developing well-performing data warehouse solutions
- Demonstrated experience using development tools such as Azure SQL database, Azure Data Factory, Azure Data Lake, Azure Synapse, and Azure DevOps.
- Experience with development methodologies including Agile, DevOps, and CICD patterns
- Strong oral and written communication skills in English
- Ability and willingness to learn quickly and continuously
- Bachelor's Degree in computer science
Follow Cutshort