6+ Snow flake schema Jobs in Mumbai | Snow flake schema Job openings in Mumbai

Data Modeller (Dimensional Modelling & SQL Focus)

Core Responsibilities:

Design and implement dimensional data models (star/snowflake schemas) optimized for reporting and analytics.

.Key Skills:

Deep understanding of data warehousing principles and Kimball/Inmon methodologies.

Expertise in SQL, Databricks SQL, and data cataloging tools.

Ability to work with source system SMEs to understand data lineage and semantics. Reporting

Relevance :Ensures data structures are optimized for Power BI, Tableau, or other BI tools, enabling performant and intuitive reporting.

Role Overview:

We are seeking a talented and experienced Data Architect with strong data visualization capabilities to join our dynamic team in Mumbai. As a Data Architect, you will be responsible for designing, building, and managing our data infrastructure, ensuring its reliability, scalability, and performance. You will also play a crucial role in transforming complex data into insightful visualizations that drive business decisions. This role requires a deep understanding of data modeling, database technologies (particularly Oracle Cloud), data warehousing principles, and proficiency in data manipulation and visualization tools, including Python and SQL.

Responsibilities:

• Design and implement robust and scalable data architectures, including data warehouses, data lakes, and operational data stores, primarily leveraging Oracle Cloud services.
• Develop and maintain data models (conceptual, logical, and physical) that align with business requirements and ensure data integrity and consistency.
• Define data governance policies and procedures to ensure data quality, security, and compliance.
• Collaborate with data engineers to build and optimize ETL/ELT pipelines for efficient data ingestion, transformation, and loading.
• Develop and execute data migration strategies to Oracle Cloud.
• Utilize strong SQL skills to query, manipulate, and analyze large datasets from various sources.
• Leverage Python and relevant libraries (e.g., Pandas, NumPy) for data cleaning, transformation, and analysis.
• Design and develop interactive and insightful data visualizations using tools like [Specify Visualization Tools - e.g., Tableau, Power BI, Matplotlib, Seaborn, Plotly] to communicate data-driven insights to both technical and non-technical stakeholders.
• Work closely with business analysts and stakeholders to understand their data needs and translate them into effective data models and visualizations.
• Ensure the performance and reliability of data visualization dashboards and reports.
• Stay up-to-date with the latest trends and technologies in data architecture, cloud computing (especially Oracle Cloud), and data visualization.
• Troubleshoot data-related issues and provide timely resolutions.
• Document data architectures, data flows, and data visualization solutions.
• Participate in the evaluation and selection of new data technologies and tools.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field.
• Proven experience (typically 5+ years) as a Data Architect, Data Modeler, or similar role. 
• 
  
• Deep understanding of data warehousing concepts, dimensional modeling (e.g., star schema, snowflake schema), and ETL/ELT processes.
• Extensive experience working with relational databases, particularly Oracle, and proficiency in SQL.
• Hands-on experience with Oracle Cloud data services (e.g., Autonomous Data Warehouse, Object Storage, Data Integration).
• Strong programming skills in Python and experience with data manipulation and analysis libraries (e.g., Pandas, NumPy).
• Demonstrated ability to create compelling and effective data visualizations using industry-standard tools (e.g., Tableau, Power BI, Matplotlib, Seaborn, Plotly).
• Excellent analytical and problem-solving skills with the ability to interpret complex data and translate it into actionable insights. 
• Strong communication and presentation skills, with the ability to effectively communicate technical concepts to non-technical audiences. 
• Experience with data governance and data quality principles.
• Familiarity with agile development methodologies.
• Ability to work independently and collaboratively within a team environment.
• 
  

Application Link- https://forms.gle/km7n2WipJhC2Lj2r5

• Strong Snowflake Cloud database experience Database developer.
• Knowledge of Spark and Databricks is desirable.
• Strong technical background in data modelling, database design and optimization for data warehouses, specifically on column oriented MPP architecture 
• Familiar with technologies relevant to data lakes such as Snowflake
• Candidate should have strong ETL & database design/modelling skills. 
• Experience creating data pipelines
• Strong SQL skills and debugging knowledge and Performance Tuning exp.
• Experience with Databricks / Azure is add on /good to have . 
• Experience working with global teams and global application environments
• Strong understanding of SDLC methodologies with track record of high quality deliverables and data quality, including detailed technical design documentation desired

• +2 years experience working as a react.js developer.
• In-depth knowledge of JavaScript, CSS, HTML, and front-end languages.
• Knowledge of REACT tools including React.js, Redux, Material UI.
• Experience with user interface design & user experience design
• Knowledge of performance testing frameworks including Mocha and Jest.
• Experience with browser-based debugging and performance testing software.
• Excellent troubleshooting skills.
• Good project management skills.
• Developing applications in React including component design and state management for specific use cases
• Experience working with at least one SQL and NoSQL Database (MongoDB, SQL Server, Snowflake, Postgres preferred)
• Basic experience with AWS platform