378 Dimensional Modeling Jobs - Page 6

As a Data Warehousing Architect, you will be responsible for the following key aspects: Role Overview: You will be involved in dimensional modeling (conceptual, logical, physical) and have a strong understanding of Data Warehousing concepts. Working closely with the business, you will gather functional requirements and lead the development of a strategy to meet current and future needs. Collaboration with the technical team of customers to gather technical requirements and ensuring architectural alignment of designs and development will be a crucial part of your role. Additionally, you will be responsible for producing design documentation, setting development standards, leading ETL/Dataware...

As a Senior ETL & Data Streaming Engineer at DataFlow Group, a global provider of Primary Source Verification solutions and background screening services, you will be a key player in the design, development, and maintenance of robust data pipelines. With over 10 years of experience, you will leverage your expertise in both batch ETL processes and real-time data streaming technologies to ensure efficient data extraction, transformation, and loading into our Data Lake and Data Warehouse. - Design and implement highly scalable ETL processes using industry-leading tools. - Architect batch and real-time data streaming solutions with technologies like Talend, Informatica, Apache Kafka, or AWS Kine...

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation. At YASH, were a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future. We are looking forward to hireData Modeling Professionals in the following areas : Experience 10-12 Years Job Description Design and develop conceptual, logical, and physical data models for OLTP and O...

Employment Type: Contract / Permanent (as per project need) Senior Data Engineer with strong expertise in SQL, Looker, and Snowflake f2f interview contract Opti Value Tek is seeking a skilled Senior Data Engineer with strong expertise in SQL, Looker, and Snowflake to join our team The ideal candidate will design, develop, and optimize scalable data pipelines, ensuring reusability, performance, and business alignment Roles & Responsibilities Write reusable, modular SQL code for data engineering solutions Work with dimensional modelling (facts, dimensions, SCD, star schemas) Build and maintain Looker semantic layers over Snowflake with focus on scalability and accuracy Define LookML models, ex...

Opti Value Tek is seeking a skilled Senior Data Engineer with strong expertise in SQL, Looker, and Snowflake to join our team The ideal candidate will design, develop, and optimize scalable data pipelines, ensuring reusability, performance, and business alignment Roles & Responsibilities Write reusable, modular SQL code for data engineering solutions Work with dimensional modelling (facts, dimensions, SCD, star schemas) Build and maintain Looker semantic layers over Snowflake with focus on scalability and accuracy Define LookML models, explores, views, and dashboards Collaborate with business teams to define metrics and dimensions aligned to business goals Ensure design and QA alignment with...

Key Responsibilities Design, develop, and maintain scalable data pipelines and solutions using Snowflake. Create and optimize complex SQL queries, stored procedures, and views for business reporting and analytics. Implement data modeling techniques (star schema, snowflake schema, normalization/denormalization). Develop and manage ETL/ELT processes using tools like Informatica, Talend, Matillion, dbt, or native Snowflake features (Snowpipe, Streams, Tasks). Ensure data security, governance, and compliance using Snowflake roles, masking, and access controls. Optimize query performance and warehouse usage to manage costs effectively. Integrate Snowflake with external tools and platforms (BI too...

Collaborate with business analysts and stakeholders to understand business processes and requirements, translating them into data modeling solutions. Design and develop logical and physical data models that effectively capture the granularity of data necessary for analytical and reporting purposes. Migrate and optimize existing data models from traditional on-premises data stores to Azure/Databricks cloud environments, ensuring scalability and performance. Establish data modeling standards and best practices to maintain the integrity and consistency of the data architecture. Work closely with data engineers and BI developers to ensure that the data models support the needs of analytical and ...

Design and develop conceptual, logical, and physical data models for OLTP and OLAP systems. Collaborate with business analysts and data engineers to understand data requirements. Ensure models support data governance , data quality , and data integration standards. Maintain and update data models as business needs evolve. Create and manage metadata repositories and data dictionaries . Optimize data models for performance , scalability , and security . Work with database administrators to implement models in relational and NoSQL databases. Support ETL processes and data warehousing initiatives. Proven experience in data modeling tools (e.g., Erwin, SAP PowerDesigner, IBM InfoSphere). Strong u...

As an Azure Architect at Fractal, you will be part of a dynamic team in the Artificial Intelligence space dedicated to empowering human decision-making in the enterprise. You will contribute to the development and delivery of innovative solutions that assist Fortune 500 companies in making strategic and tactical decisions. Fractal is renowned for its cutting-edge products such as Qure.ai, Cuddle.ai, Theremin.ai, and Eugenie.ai, which leverage AI to drive business success. Your responsibilities will include: - Actively participating in client engagements - Developing end-to-end solutions for large projects - Utilizing Software Engineering principles to deliver scalable solutions To excel in t...

As an Infrastructure Engineer at PwC, your role involves designing and implementing secure IT systems to support business operations. Your primary goal is to ensure smooth functioning of networks, servers, and data centers to enhance performance and minimize downtime. In this position, you will be creating robust and scalable technology infrastructure solutions for clients, focusing on network architecture, server management, and cloud computing. Key Responsibilities: - Analyze and translate business needs into long-term data model solutions. - Evaluate existing data systems and suggest enhancements. - Define rules for translating and transforming data across various models. - Collaborate wi...

Job Opportunity Data Modeler | Forecasting & Prediction Location: Bangalore (Whitefield) | Hybrid (3 days office/week) Experience: 6+ years Notice Period: Immediate to 2 weeks only apply if you can join early Key Responsibilities: Design and develop logical and physical data models for forecasting and prediction use cases. Work with large, complex datasets to identify trends, patterns, and relationships. Translate business requirements into scalable data solutions. Optimize models for performance, accuracy, and maintainability. Document data definitions, structures, and design decisions. Ensure data quality and consistency across systems. Required Skills: Strong experience in data modeling (...

Lead Software Engineer Req number: R6225 Employment type: Full time Worksite flexibility: Remote Who we are CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise. Job Summary Job Description Summary As a Lead Software Engineer, you will be resp...

Role Description 6+ years of Anaplan experience (with exposure to a minimum of 3 end-to-end implementations on Anaplan) Expert skills in Anaplan modeling. Ability to optimize the Anaplan Models for performance. Anaplan Certified Model Builder ( at least L3 level certified ) Strong expertise and deep understanding of multi-dimensional modeling. Moderate skills in Excel spreadsheet modeling, macros, pivot tables, formulas, charts, etc. Ability to translate from model-building in Excel to multi-dimensional technologies. Strong understanding of Data Integrations Strong client-facing skills Must be organized and detail oriented. Superior written and oral communication skills are essential. A demo...

Role Proficiency: Act creatively to develop applications and select appropriate technical options optimizing application development maintenance and performance by employing design patterns and reusing proven solutions account for others' developmental activities Outcomes: Interpret the application/feature/component design to develop the same in accordance with specifications. Code debug test document and communicate product/component/feature development stages. Validate results with user representatives; integrates and commissions the overall solution Select appropriate technical options for development such as reusing improving or reconfiguration of existing components or creating own solu...

Experience- 5 to 8 years Location- Bangalore Mandatory Skills: Dimensional Data Modelling JD: -Perform IT analysis investigative data analysis system design and data modelling to support development teamsy. -Take lead or facilitating role to drive functional and nonfunctional requirements and analysis work that involves multiple stakeholders to design sustainable and value adding solutions. -Ensure alignment and transparency of requirements by acting as a bridge between IT and business teams -Build a contextual understanding of business processes on one hand and functional technical knowhow of our solutions on the other -Building understanding of data model its consumption by development Tea...

The Skills that will make you successful in this role Understand requirement, source to target mapping and Data model and create mappings. Ensuring associated applications adhere to architecture standards, risk management and security guidelines and data management policies Strong working knowledge in ETL Informatica. Good exposure to writing SQL, Snowflake queries Working knowledge in Unix Good Understanding of Data Warehousing concepts, Dimension modelling . Good knowledge in agile methodologies. Good knowledge of Scripting (Python scripting, Shell or PowerShell) AWS Cloud knowledge and infrastructure management ( EC2) Experience with scheduling tools like Control-M . Experience in working...

As a Data Modeler at our company, you will play a crucial role in designing conceptual, logical, and physical models for Azure Databricks and Azure Data Lake to support structured, semi-structured, and unstructured data. Your responsibilities will include: - Utilizing your 6+ years of experience in data modeling, with a preference for insurance industry datasets such as policies, claims, customer, or actuarial data. - Demonstrating advanced skills in data modeling tools like Erwin, ER/Studio, PowerDesigner, or Microsoft Visio, and version control using GitHub. - Applying deep understanding of relational, dimensional, and data lake modeling techniques optimized for Databricks/Spark-based proc...

Role Overview: You will be responsible for architecting and delivering highly scalable, distributed, cloud-based enterprise data solutions. Your role will involve designing scalable data architectures with Snowflake, integrating cloud technologies such as AWS, Azure, GCP, and ETL/ELT tools like DBT. Additionally, you will guide teams in proper data modeling, transformation, security, and performance optimization. Key Responsibilities: - Architect and deliver highly scalable, distributed, cloud-based enterprise data solutions - Design scalable data architectures with Snowflake and integrate cloud technologies like AWS, Azure, GCP, and ETL/ELT tools such as DBT - Guide teams in proper data mod...

Role & responsibilities 10+ years of experience in Data space. Decent SQL knowledge Able to suggest modeling approaches for a given problem. Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server) Real-time experience working in OLAP & OLTP database models (Dimensional models). Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data Governance, and Data quality. Eye to analyze data & comfortable with following agile methodology. Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP) Enthuse to coach team members & collaborate with various stakeholders across the organization and take compl...

About The Role Project Role : Application Lead Project Role Description : Lead the effort to design, build and configure applications, acting as the primary point of contact. Must have skills : Microsoft SQL Server Integration Services (SSIS) Good to have skills : NA Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :We are seeking a highly skilled Microsoft SQL Server Integration Services and Microsoft SQL Server Developer with expertise in query writing, performance tuning, SSIS development, and data warehousing. As an Application Lead, you will lead the effort to design, build, and configure applications, acting as the primary poi...

Job ID: Azu-ETP-Pun-1090 Location: Pune,Other The Role: As a Lead Data Engineer specializing in Databricks, you will be a key player in designing, developing, and optimizing our next-generation data platform You will lead a team of data engineers, providing technical guidance, mentorship, and ensuring the scalable, and high-performance data solutions, Key Responsibilities Technical Leadership: Lead the design, development, and implementation of scalable and reliable data pipelines using Databricks, Spark, and other relevant technologies, Define and enforce data engineering best practices, coding standards, and architectural patterns, Provide technical guidance and mentorship to junior and mi...

As a Data Engineering Senior Associate at Microsoft, Fabric, Azure (Databricks & ADF), PySpark, your role will involve: - Requirement gathering and analysis - Designing and implementing data pipelines using Microsoft Fabric & Databricks - Extracting, transforming, and loading (ETL) data from various sources into Azure Data Lake Storage - Implementing data security and governance measures - Monitoring and optimizing data pipelines for performance and efficiency - Troubleshooting and resolving data engineering issues - Providing optimized solutions for any problem related to data engineering - Working with a variety of sources like Relational DB, API, File System, Realtime streams, CDC, etc. -...

Role & Responsibilities: Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, having experience in requirements gathering, creating data mapping documents, writing functional specifications, queries for Data Warehouse, Data Lake, Lakehouse, DataMart, OLTP, OLAP applications. Extensive experience in Entity-Relational, Data Vault and Dimensional Data modeling for creating ER Diagrams using Erwin, ER/Studio, Enterprise Architect and PowerDesigner data modeling tools. Integral part of the Data Management team performing Data Extraction, Data Analysis, Data Cleansing, Data Mapping and Data Profiling exercises using Informatica Analyst and other profiling tools. Worked o...

remote typeOn-site locationsBengaluru, KA time typeFull time posted onPosted 4 Days Ago job requisition idREQ423419 7+ years of overall experience in building data systems, of which 2+ years minimum in Azure Power BI. Excellent understanding of SQL and ability to write complex SQL queries in a performant way. Excellent understanding of Power BI dataset & dataflows design. Good understanding of row-level security models implemented in reporting solutions. Good understanding of Datawarehouse concepts; experience working with a dimensional model is a plus. Hands-on knowledge in writing structured Databricks code components using PySpark is a plus. Good knowledge of how ETL auditing works in a p...

remote typeOn-site locationsBengaluru, KA time typeFull time posted onPosted 5 Days Ago job requisition idREQ408131 Data Engineer 2 JLL Technologies COE- Bangalore What this job involves About the role #JLLTechAmbitions Azure Data Engineer for implementation of HR Datawarehouse project. Sounds like you? To apply you need to be Experience & Education 4+ years of overall experience in building data systems, of which 2+ years minimum in Azure Databricks. Excellent understanding of SQL and ability to write complex SQL queries in a performant way. Good understanding of Datawarehouse concepts; experience working with a dimensional model is a plus. Excellent hands-on knowledge in writing structured...