star-schema-jobs-in-sonipat, Sonipat

5 Star Schema Jobs nearby Sonipat

Toggle to save search
posted 1 week ago
experience4 to 8 Yrs
location
Haryana
skills
  • Tableau
  • SQL
  • ETL
  • Data Modeling
  • Data Governance
  • Databricks
  • PySpark
Job Description
Role Overview: As an ETL cum BI Engineer with expertise in Tableau and Databricks, your primary responsibility will be to maintain, optimize, and enhance the reporting infrastructure. You will focus on dashboard maintenance, data flow management, and enabling new analytical capabilities for multiple regions and business units. Your role is crucial in ensuring high data accuracy, reliability, and availability for recurring reporting needs. Key Responsibilities: - Maintain and troubleshoot existing Tableau dashboards to guarantee accuracy, performance, and reliability. - Oversee active dashboards for recurring reporting, ensuring they meet stakeholder requirements. - Enhance dashboards by incorporating new filters, drilldowns, and visual elements based on feedback. - Integrate economic impact data and expand scorecard views for comprehensive insights. - Build and integrate new benchmarks such as Regional, International (excluding US), and Global Benchmark views. - Ensure successful data uploads and transformations between systems including SurveyMonkey, Databricks, and Tableau. - Monitor and update mapping tables to reflect data changes or new business logic. - Optimize data structures and schemas in Databricks to support efficient reporting and analytics. - Develop and maintain mapping documentation for survey answer options with clear traceability and version control. - Create new Tableau dashboards for specific stakeholder groups and international geographies. - Collaborate with stakeholders to translate reporting requirements into scalable data solutions and visualizations. - Support data quality checks, pipeline monitoring, and ETL troubleshooting for consistent data delivery. Qualifications Required: - Bachelor's degree in Computer Science, Information Systems, Mathematics, or related field. - 3-6 years of experience in BI development, ETL, or data analytics roles. - Proven expertise in Tableau (dashboard design, data source management, performance optimization). - Proficiency in Databricks, SQL, and data transformation for reporting and analytics. - Understanding of data modeling and reporting best practices (star/snowflake schema, data lineage, etc.). - Experience managing data pipelines from external sources like SurveyMonkey or similar survey platforms. - Ability to work independently and manage multiple projects simultaneously. Additional Company Details: The preferred qualifications and skills for this role include familiarity with Delta Lake, PySpark, or other distributed data processing tools. Knowledge of data governance, metadata documentation, and version control (Git) is advantageous. Strong analytical and problem-solving skills, attention to detail in data accuracy and consistency, as well as excellent communication and collaboration skills are essential. Prior experience in sports, gaming, and entertainment industries is a plus.,
ACTIVELY HIRING

Top Companies are Hiring in Your City

For Multiple Roles

Jio Platforms Ltd
Jio Platforms Ltdslide-preview-Genpact
posted 3 weeks ago
experience3 to 7 Yrs
location
Haryana
skills
  • BI
  • Supply Chain
  • Data Engineering
  • Data Science
  • Machine Learning
  • Software Engineering
  • Data Visualization
  • Agile Methodologies
  • Scrum
  • Kanban
  • SAFe
  • Power BI
  • Tableau
  • JIRA
  • Confluence
  • Cloud Computing
  • Azure
  • AWS
  • GCP
  • Snowflake
  • ERP
  • WMS
  • TMS
  • MRP
  • ROI
  • Communication Skills
  • Data Product Owner
  • IA
  • BI Analytics
  • Qlik
  • APS
  • KPIs
  • English Proficiency
Job Description
Role Overview: As a Data Product Owner Senior IA & BI in Supply Chain at EY FABERNOVEL, you will be responsible for preparing, coordinating, and overseeing the implementation of data/IA/BI projects from conception to delivery, focusing on innovative and data-driven solutions. You will play a central role in orchestrating projects and serving as the primary point of contact between technical teams (Data engineers, Data scientists, BI Analysts, Machine Learning Engineers, Software Engineers), business teams (Supply Chain, Production, Logistics, Finance, Marketing), and clients. Key Responsibilities: - Gather business needs related to operational and logistical performance in Supply Chain. - Facilitate design workshops to identify high-impact data/IA/BI use cases (cost-to-serve reduction, stock optimization, customer promise enhancement, etc.). - Define and write functional specifications/User Stories aligned with business and technical challenges. - Collaborate with technical teams (developers & testers) to ensure solution quality (IA models, data pipelines, BI dashboards, APIs). - Supervise the lifecycle of IA/data/BI products, from POC to industrialization. - Design and oversee performance dashboards (cockpits, control towers) for operational management. - Define relevant business and operational KPIs (cost, margin, service rate, stock level, etc.). - Ensure visualization quality and user adoption. - Select and integrate suitable BI tools (Power BI, Tableau, Qlik, etc.). - Assist teams in tool adoption and analytics integration into target processes. - Manage projects using agile methodologies (Scrum, Kanban, SAFe). - Develop a product vision, data product mapping, and product-oriented roadmap. - Monitor deliverables, establish schedules, track budgets and deadlines, conduct Agile/SAFe ceremonies, manage dependencies with other Agile teams. - Update the data product data dictionary. - Utilize management tools such as JIRA, Confluence, or equivalents. - Ensure deliverables comply with quality standards (model accuracy, scalability, operational efficiency). - Deliver data-driven solutions that result in tangible benefits (cost reduction, service improvement, flow optimization). - Act as the main client contact for Supply Chain data/IA/BI projects. - Maintain smooth communication and strategic alignment between client objectives and delivered solutions. Qualification Required: - Bachelor's degree in engineering or a data/IA/BI-oriented program with a minimum of 3 years" experience in managing data or IA projects applied to operations/Supply Chain. - Strong understanding of data-related tools and concepts, modern data stack, IA, and BI: data pipelines, machine learning, cloud computing (Azure, AWS, GCP, Snowflake), BI tools (Power BI, Tableau, Qlik), BI development principles (star schema, fact/dimension tables). - Familiarity with Supply Chain environment data and tools/processes (ERP, WMS, TMS, APS, MRP, etc.). - Knowledge of Supply Chain KPIs: processing cost, service rate, stock level, margin, ROI. - Ability to translate business needs into concrete data-driven solutions. - Excellent communication skills, capable of simplifying complex concepts. - Proficiency in professional English. Company Details: EY FABERNOVEL, founded in 2003, is dedicated to leveraging technology to create a more sustainable future for businesses and society. Following its integration with EY Consulting in 2022, EY FABERNOVEL combines digital transformation expertise with a global network's strength, serving as a transition accelerator for clients. The company focuses on Design for sustainable future, Digital Data & AI Engineering, and Digital & Data-Driven Marketing to support clients in their digital and ecological transitions. EY FABERNOVEL operates by combining individual talents and cutting-edge methodologies to empower clients and help them develop products tailored to their business needs. Join EY Consulting for a rewarding and sustainable career experience, working with top international clients, personalized training programs, zero-carbon consultancy, global mobility opportunities, involvement in internal networks promoting ecology, diversity, and inclusion, and participation in flagship events like T-DAY and Sustainable Futures. EY values diversity, equity, and inclusion, considering all applications equally, including those from individuals with disabilities.,
ACTIVELY HIRING
posted 2 months ago

Analytics Developer

Aiprus Software Private Limited
experience4 to 8 Yrs
location
Haryana
skills
  • Power BI
  • ETL
  • Python
  • Scala
  • DAX
  • Data Modeling
  • Data Governance
  • SQL
  • Communication Skills
  • Databricks
  • Azure Data Factory
  • Data Analysis Expressions
  • ETLELT
  • Azure Cloud Platforms
  • Analytical Thinking
Job Description
As an Analytics Developer, you will be responsible for designing, developing, and deploying advanced analytics solutions using your deep expertise in Databricks, Power BI, and ETL technologies. Your focus will be on creating robust data pipelines, implementing business intelligence frameworks, and delivering insightful dashboards and reports to drive strategic decision-making. Collaboration with technical teams and business stakeholders is crucial to ensure that analytics initiatives align with organizational objectives. - Leverage Databricks to develop and optimize scalable data pipelines for real-time and batch data processing. - Design and implement Databricks Notebooks for exploratory data analysis, ETL workflows, and machine learning models. - Manage and optimize Databricks clusters for performance, cost efficiency, and scalability. - Use Databricks SQL for advanced query development, data aggregation, and transformation. - Incorporate Python and/or Scala within Databricks workflows to automate and enhance data engineering processes. - Develop solutions to integrate Databricks with other platforms, such as Azure Data Factory, for seamless data orchestration. - Create interactive and visually compelling Power BI dashboards and reports to enable self-service analytics. - Leverage DAX (Data Analysis Expressions) for building calculated columns, measures, and complex aggregations. - Design effective data models in Power BI using star schema and snowflake schema principles for optimal performance. - Configure and manage Power BI workspaces, gateways, and permissions for secure data access. - Implement row-level security (RLS) and data masking strategies in Power BI to ensure compliance with governance policies. - Build real-time dashboards by integrating Power BI with Databricks, Azure Synapse, and other data sources. - Provide end-user training and support for Power BI adoption across the organization. - Develop and maintain ETL/ELT workflows, ensuring high data quality and reliability. - Implement data governance frameworks to maintain data lineage, security, and compliance with organizational policies. - Optimize data flow across multiple environments, including data lakes, warehouses, and real-time processing systems. - Collaborate with data governance teams to enforce standards for metadata management and audit trails. - Work closely with IT teams to integrate analytics solutions with ERP, CRM, and other enterprise systems. - Troubleshoot and resolve technical challenges related to data integration, analytics performance, and reporting accuracy. - Stay updated on the latest advancements in Databricks, Power BI, and data analytics technologies. - Drive innovation by integrating AI/ML capabilities into analytics solutions using Databricks. - Contribute to the enhancement of organizational analytics maturity through scalable and reusable solutions. - Bachelors degree in Computer Science, Data Science, or a related field (Masters preferred). - Microsoft Certified: Azure Data Engineer Associate. - Databricks Certified Data Engineer Professional. - Microsoft Certified: Power BI Data Analyst Associate. - 8+ years of experience in analytics, data integration, and reporting. - 4+ years of hands-on experience with Databricks, including proficiency in Databricks Notebooks for development and testing. - Advanced skills in Databricks SQL, Python, and/or Scala for data engineering. - Expertise in cluster management, auto-scaling, and cost optimization. - 4+ years of expertise with Power BI, including advanced DAX for building measures and calculated fields. - Proficiency in Power Query for data transformation. - Deep understanding of Power BI architecture, workspaces, and row-level security. - Strong knowledge of SQL for querying, aggregations, and optimization. - Experience with modern ETL/ELT tools such as Azure Data Factory, Informatica, or Talend. - Proficiency in Azure cloud platforms and their application to analytics solutions. - Strong analytical thinking with the ability to translate data into actionable insights. - Excellent communication skills to effectively collaborate with technical and non-technical stakeholders. - Ability to manage multiple priorities in a fast-paced environment with high customer expectations.,
ACTIVELY HIRING
question

Are these jobs relevant for you?

posted 1 week ago

Lead/Sr. ETL Engineer

Grazitti Interactive
experience5 to 9 Yrs
location
Panchkula, Haryana
skills
  • DataStage
  • Informatica
  • Talend
  • SQL
  • Python
  • AWS
  • Azure
  • Tableau
  • Power BI
  • Data modeling
  • ETL tools like SSIS
Job Description
Role Overview: As a skilled and experienced Lead/Senior ETL Engineer with 4-8 years of experience, you will be joining our data engineering team. Your primary responsibility will be designing and developing high-performing ETL solutions, managing data pipelines, and ensuring seamless integration across systems. Additionally, you will be contributing to architectural decisions, leading delivery planning, and providing mentorship to team members. Your hands-on expertise in ETL tools, cloud platforms, and scripting will be crucial in building efficient, scalable, and reliable data solutions for enterprise-level implementations. Key Responsibilities: - Design and develop ETL workflows and data integration strategies. - Create and review high and low-level designs adhering to best practices. - Collaborate with cross-functional teams to deliver enterprise-grade middleware solutions. - Coach and mentor junior engineers to support skill development and performance. - Ensure timely delivery, escalate issues proactively, and manage QA and validation processes. - Participate in planning, estimations, and recruitment activities. - Work on multiple projects simultaneously, ensuring quality and consistency in delivery. - Have experience in Sales and Marketing data domains. - Exposure to reporting and analytics projects. - Strong problem-solving abilities with a data-driven mindset. - Ability to work independently and collaboratively in a fast-paced environment. - Prior experience in global implementations and managing multi-location teams is a plus. Qualifications Required: - Strong hands-on experience with ETL tools like SSIS, DataStage, Informatica, or Talend. - Deep understanding of Data Warehousing concepts, including Data Marts, Star/Snowflake schemas, Fact & Dimension tables. - Proficient in working with relational databases: SQL Server, Oracle, Teradata, DB2, or MySQL. - Solid scripting/programming skills in Python. - Hands-on experience with cloud platforms such as AWS or Azure. - Knowledge of middleware architecture and enterprise data integration strategies. - Familiarity with reporting/BI tools like Tableau and Power BI. - Strong grasp of data modeling principles and performance optimization. - Ability to write and review high and low-level design documents. - Strong communication skills and experience working with cross-cultural, distributed teams.,
ACTIVELY HIRING
posted 2 months ago

Lead Consultant - Qlik

IRT Digital Analytics Solutions Pvt. Ltd.
experience3 to 7 Yrs
location
Haryana
skills
  • Business Intelligence
  • QlikView
  • Qlik Sense
  • Data Modeling
  • Dimensional Modeling
  • Star Schema
  • Server Administration
  • Data Visualization
  • Report Design
  • Troubleshooting
  • Performance Tuning
  • Technical Requirements
  • Analytical Skills
  • Communication Skills
  • Team Management
  • Snowflake Schema
  • Nprinting
  • Decisionmaking
Job Description
Role Overview: As a Senior Consultant/Lead Consultant specializing in Business Intelligence, you will be responsible for performing complex analysis, design, programming, test plans, testing, debugging, modification, and support for QlikView and Qlik Sense. Your role will involve providing advanced technical troubleshooting for Qlik Sense and QlikView, as well as applying advanced administration, management, and performance tuning techniques. Additionally, you will be tasked with researching solutions to various business and technical problems, evaluating alternatives, scoping appropriately, and presenting recommendations with justification to management. Your responsibilities will also include data visualization mockup, report design, and data modeling. Key Responsibilities: - Perform complex analysis, design, programming, test plans, testing, debugging, modification, and support for QlikView and Qlik Sense. - Provide advanced technical troubleshooting for Qlik Sense and QlikView. - Apply advanced administration, management, and performance tuning techniques. - Research solutions to various business and technical problems, evaluate alternatives, scope appropriately, and present recommendations with justification to management. - Data visualization mockup, report design, and data modeling. Qualification Required: - Minimum 3 years of experience in implementing end-to-end business intelligence using QlikView and Qlik Sense. - Experience in designing and developing Qlik Sense and QlikView dashboards, reports, and solutions, configuring server components (QMC task, setting up the server, server administration). - Data modeling using dimensional modeling, Star schema, snowflake schema. - Real-time hands-on experience with at least 2 projects in QlikView/Qlik Sense with Nprinting project implementation. - Develop reports, dashboards, scorecards, unit, integration test the developed components. - Gather business requirements, elicit technical requirements, and prepare report specifications. - Strong analytical skills, good written and verbal communication skills, and strong decision-making capabilities. - Self-motivated, ability to work independently with minimal direction, and be team-oriented with the ability to communicate to a wide variety of audiences. - Strong team management skills. Company Additional Details: The company requires candidates with Education: BE/B.Tech/MCA or equivalent and Experience: 3+ years experience in QlikView, Qlik Sense, Nprinting & QMC.,
ACTIVELY HIRING
posted 3 days ago

BI Manager

HARJAI COMPUTERS PRIVATE LIMITED
HARJAI COMPUTERS PRIVATE LIMITED
experience5 to 10 Yrs
Salary8 - 12 LPA
location
Gorakhpur
skills
  • lake
  • systems
  • scada
  • power
  • etl
  • sql
  • data
  • dax
  • power bi
  • processes
  • query
Job Description
Extensive hands-on experience with Power BI, including Power Query (M language), DAX, and Power BI service/report server administration. o Strong expertise in SQL and Database Management of relational and potentially non-relational databases. o Proven experience working with large and complex datasets from various sources, including Data Lakes (e.g., Azure Data Lake, AWS S3, HDFS), ERP systems (e.g., SAP, Oracle, Microsoft Dynamics), and SCADA systems. o Proficiency in Python R programming for data manipulation, statistical analysis, and integration with BI tools. o Proven experience in designing and managing complex data models (e.g., star schemas, snowflake schemas). o Solid understanding of ETL/ELT processes and tools. o Demonstrated ability to create compelling and effective visual graphics for data representation and storytelling. 
INTERVIEW ASSURED IN 15 MINS
posted 2 weeks ago

Abinitio Developer

CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED
CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED
experience5 to 10 Yrs
location
Delhi, Bangalore+7

Bangalore, Noida, Chennai, Hyderabad, Gurugram, Kolkata, Pune, Mumbai City

skills
  • ab initio
  • unix shell scripting
  • sql
Job Description
Key Responsibilities Design, develop, and implement ETL processes using Ab Initio GDE (Graphical Development Environment). Build and maintain Ab Initio graphs, plans, and sandboxes for data extraction, transformation, and loading. Work with business teams to understand data integration requirements and deliver efficient solutions. Use Ab Initio EME for version control, dependency management, and metadata governance. Perform data profiling, data validation, and quality checks using Ab Initio components and tools. Optimize ETL workflows for performance, scalability, and maintainability. Implement robust error handling, restartability, and logging mechanisms. Collaborate with DBAs, data modelers, and analysts to ensure data accuracy and consistency. Schedule and monitor jobs using Ab Initio Control Center (AICC) or enterprise schedulers. Support production systems, troubleshoot issues, and perform root cause analysis. Required Technical Skills Strong hands-on experience in Ab Initio GDE, EME, Co>Operating System, and Control Center. Proficiency with Ab Initio components such as Input/Output, Transform, Partition, Sort, Join, Lookup, Rollup, Reformat, Scan, and Dedup Sort, along with error handling using Rejects, Error Tables, and Error Ports for robust ETL design. Expertise in ETL design, development, and deployment for large-scale data environments. Proficiency in SQL and relational databases such as Oracle, Teradata, DB2, or SQL Server. Experience with UNIX/Linux shell scripting for automation and workflow integration. Understanding of data warehousing concepts (star schema, snowflake schema, slowly changing dimensions). Strong performance tuning and debugging skills in Ab Initio. Familiarity with data quality, metadata management, and data lineage.  
INTERVIEW ASSURED IN 15 MINS
posted 5 days ago
experience10 to 15 Yrs
location
All India
skills
  • Data Modeling
  • DBT
  • SQL
  • Snowflake
  • Data Governance
  • AWS
  • Azure
  • GCP
  • BI Tools
  • Git
  • Agile Development
  • ETL Design
  • Ecom
  • Order Supply Chain Management
  • Redshift
  • BigQuery
  • Data Lineage
  • Data Quality Frameworks
  • CICD
Job Description
As a highly experienced Data Modeler/ETL Architect with expertise in data modeling, ETL design, and DBT frameworks, your role will involve designing, implementing, and optimizing scalable data models, pipelines, and data architecture to support enterprise-level analytics and data warehouse solutions. - Design and maintain conceptual, logical, and physical data models for enterprise data platforms. - Lead the architecture, development, and optimization of ETL/ELT workflows using DBT, SQL, and modern data integration tools. - Define and implement data modeling standards, best practices, and governance frameworks. - Collaborate with data engineers, analysts, and business stakeholders to translate requirements into robust data solutions. - Architect data pipelines ensuring data quality, integrity, and consistency across multiple systems. - Optimize data models for performance, scalability, and reusability in analytical workloads (Snowflake, Redshift, BigQuery, etc.). - Oversee data lineage, metadata management, and documentation for transparency and maintainability. - Provide technical leadership and mentorship to data engineers and analysts in data modeling and DBT development. - Participate in data architecture reviews, performance tuning, and troubleshooting. Qualifications: - 10+ years of experience in data engineering, data modeling, or data architecture. - Expertise in ETL/ELT design and architecture using modern data integration platforms. - Proficiency in SQL and experience with cloud data warehouses (e.g., Snowflake, Redshift, BigQuery, Azure Synapse). - Hands-on experience with data modeling techniques (3NF, star schema, data vault, dimensional modeling). - Solid understanding of data governance, data lineage, and data quality frameworks. - Experience in cloud platforms (AWS, Azure, or GCP). - Understanding of business intelligence (BI) and analytics tools such as Looker, Power BI, or Tableau. - Familiarity with version control (Git), CI/CD for data pipelines, and agile development practices. - Strong problem-solving, analytical, and communication skills. Please note that the company details were not provided in the job description.,
ACTIVELY HIRING
posted 1 month ago
experience5 to 9 Yrs
location
All India
skills
  • Data Security
  • Workforce Planning
  • Data Reporting
  • Data Modeling
  • Metadata Modeling
  • Oracle HCM
  • Oracle Fusion Data Intelligence
  • OTBI
  • BIP Reporting
  • Predictive Models
  • AIML
  • Data Warehousing Solutions
  • Visualizations
  • Data Programs
  • Datadriven Insights
  • Digital Dashboards
  • Analytics Team Management
  • Stakeholder Coordination
  • Star Schemas
  • BI Tools Administration
Job Description
As a highly skilled and experienced Principal Analytics Data Scientist, you will play a crucial role in designing and implementing data warehousing solutions within the HCM domain. Your responsibilities will include creating visualizations, ensuring data security, and overseeing data programs related to workforce planning and predictive analytics. You will drive data-driven insights to optimize operational efficiency and improve decision-making within the organization. Key Responsibilities: - Lead the build and development of digital dashboards aligned with enterprise standards. - Lead and drive the analytics team to ensure deliverables align with enterprise objectives. - Coordinate analytics projects with stakeholders, including senior leadership, HR, IT, architects, and cross platforms. - Develop and secure FDI, OTBI, and BIP reports and analytics for data reporting. - Contribute to the strategic vision of the Data Science team, providing input on initiatives that align with business objectives. - Ensure data security and compliance with industry standards in Oracle HCM's OTBI/BIP and FDI. - Design star schemas, fact and dimension tables, and perform data modeling. - Administer BI tools, including metadata modeling, dashboards, and security. - Oversee data programs related to Workforce planning and Oracle HCM analytics. - Provide analytical support to HR leaders and develop data analytics strategies to optimize operational efficiency. Qualifications Required: - Strong background in Oracle HCM, Oracle Fusion Data Intelligence (formerly FAW), OTBI, and BIP Reporting. - Knowledge of predictive models and AI/ML. - Experience in leveraging data to drive strategic decision-making and enhance organizational effectiveness. (Note: The job description did not include any additional details about the company.),
ACTIVELY HIRING
posted 1 month ago

Technology Analyst

BayRock Labs
experience2 to 6 Yrs
location
Karnataka
skills
  • Python
  • Dimensional modeling
  • Star schema
  • ETLELT
  • Data handling
  • CICD tools
Job Description
You will be joining BayRock Labs, a leading product engineering firm based in Silicon Valley, known for pioneering innovative tech solutions that drive business transformation. The company provides full-cycle product development, leveraging cutting-edge technologies in AI, ML, and data analytics. BayRock Labs has a collaborative and inclusive culture that fosters professional growth and work-life balance. By joining the team, you will have the opportunity to work on ground-breaking projects and be a part of a team that values excellence, integrity, and innovation, collectively redefining what's possible in technology. Key Responsibilities: - Write advanced Python code for data transformation and loading. - Design and maintain data pipelines using dimensional models and star schema. - Build and manage CI/CD pipelines for automated deployment. - Debug and resolve issues in data pipelines and workflows. Qualifications Required: - Expertise in Python, particularly in ETL/ELT and data handling. - Strong knowledge of dimensional modeling and star schema is mandatory. - Hands-on experience with CI/CD tools such as GitHub Actions, GitLab CI, Jenkins, etc. Good to Have: - Familiarity with workflow orchestration tools like Prefect, Airflow, Dagster. - Basics of full stack development. - Knowledge of cloud platforms such as AWS, GCP, Azure. - Understanding of any ERP systems and business processes. Please note that the salary range for this position is 25 - 30 INR per year, with the job location being Hybrid (Bengaluru, Karnataka, IN).,
ACTIVELY HIRING
posted 3 weeks ago

Client Lead

Analyttica Datalab
experience4 to 8 Yrs
location
Karnataka
skills
  • Data Science
  • Analytics
  • ERP
  • PLM
  • Dimensional modeling
  • Data Lakehouse architectures
  • Star schemas
  • Snowflake schemas
Job Description
Role Overview: As a Lead Functional Consultant at the company, you will have the opportunity to partner with clients in designing, architecting, and delivering end-to-end solutions that drive meaningful business outcomes. This high-impact role requires a combination of functional leadership, solution architecture, and delivery ownership, making it ideal for individuals who are strategic thinkers while being hands-on. You will work closely across various business functions to lead discovery, uncover challenges, define future-state processes, and co-create scalable, integrated solutions tailored for manufacturing clients. Success in this role will depend on your adaptability, strong communication skills, and your ability to take ownership of outcomes. Key Responsibilities: - Lead discovery and solutioning across business functions for manufacturing organizations, focusing on digital transformation. - Define and design future-state business processes and solution architectures in collaboration with business and technical stakeholders. - Lead pre-sales engagements, clearly articulating the value proposition and ensuring alignment across executive leadership, functional teams, and end users. - Work hands-on with enterprise systems, including ERP platforms, PLM/product engineering databases, and sales platforms. - Lead the design and implementation of Data Lakehouse architectures based on functional discovery, utilizing star schemas, snowflake schemas, and dimensional modeling to support analytics and reporting. Qualifications Required: - You should be a solution-driven leader with strong business context and technical depth. - Thriving in fast-paced, evolving environments and bringing clarity to complexity is essential. - Being a hands-on consultant who leads by doing, not just advising, is crucial. You should be proactive and comfortable operating from high-level strategy to detailed execution. Company Details: The company is a leading provider of data and AI solutions, enabling organizations to transform their businesses through innovative analytics, actionable insights, and a culture of data literacy. They have a dynamic, forward-thinking culture that thrives on solving complex challenges and empowering individuals who are eager to learn, innovate, think big, and make an impact.,
ACTIVELY HIRING
posted 1 month ago

Data Modeller

Three Across
experience11 to 16 Yrs
location
All India
skills
  • Data Modeling
  • SQL
  • RDBMS
  • OLTP
  • OLAP
  • Star schema
  • Data warehousing
  • Teradata SQL
  • Azure
  • AWS
  • GCP
  • Data governance
  • Metadata management
  • ETL processes
  • Cloud platforms
  • Enterprise data warehousing technologies
  • Snowflake schema
  • Snowflake data platform
  • Integration techniques
  • ETL process design
  • SQL query optimization
Job Description
As a highly experienced Data Modeler / Data Analyst, you will play a crucial role in designing and maintaining robust data models that serve as the foundation for enterprise-wide data solutions. Your expertise in data modeling principles, ETL processes, cloud platforms, and enterprise data warehousing technologies will be essential for this role. **Key Responsibilities:** - Gather and analyze business requirements through JAD sessions and end-user interactions to design data solutions - Lead the design, development, and implementation of enterprise-wide data architecture for both structured and unstructured data - Build logical, physical, relational, and dimensional data models using industry-standard tools like Erwin - Ensure seamless data flow from transformation to consumption, including delivery via APIs - Perform data analysis, profiling, cleansing, migration, validation, auditing, and manipulation across diverse sources - Design ETL specifications, workflows, and flowcharts and collaborate with ETL teams for implementation - Develop and manage database objects such as tables, packages, stored procedures, and triggers - Utilize cloud platforms (AWS, Azure, GCP) for data integration, modeling, and delivery solutions - Implement best practices for naming conventions, metadata, and design standards across enterprise models - Ensure data consistency, reusability, and alignment with business requirements and governance frameworks - Evaluate existing data systems and recommend enhancements or redesigns as needed - Collaborate with stakeholders to optimize data warehouse and big data platforms for analytics and reporting - Maintain up-to-date data dictionaries and manage model documentation **Minimum Qualifications:** - Strong experience in Information Technology as a Data Analyst and Data Modeler - Expertise in data modeling tools such as Erwin - Solid knowledge of RDBMS (e.g., Teradata, Oracle) and concepts like OLTP, OLAP, Star, and Snowflake schema - Hands-on experience in Snowflake data platform - Proficiency in developing logical, physical, and dimensional data models - Deep understanding of SQL, data warehousing, and integration techniques - Experience in ETL process design and working with large data volumes If you are passionate about data architecture, cloud platforms, and building scalable, high-quality data models, apply now and be part of a team transforming enterprise data strategy.,
ACTIVELY HIRING
posted 2 months ago

Data Engineering

Hitachi Energy
experience2 to 6 Yrs
location
Chennai, Tamil Nadu
skills
  • SQL
  • Power BI
  • Data processing
  • Python
  • Azure
  • AI data analytics
  • PySpark
  • Data visualization tools
  • ETLELT pipeline
  • Star schema data modeling
  • Microsoft Power BI
  • Databricks
  • ADLS
  • Machine Learning algorithms
Job Description
As a Data Engineer at Hitachi Energy Indian Operations Center (INOPC), you will have a significant role in creating a global value chain to enhance value for Hitachi Energy customers worldwide. Your main responsibilities will include: - Demonstrating technical proficiency in AI data analytics within a team comprising diverse technical skills. - Constructing and managing precise and scalable data pipelines and infrastructure (e.g., SQL Warehouse, Data Lakes) utilizing Cloud platforms like MS Azure and Databricks. - Actively collaborating with business stakeholders to comprehend data lineage, definitions, and data extraction methods. - Developing production-quality SQL and PySpark code to establish the data architecture. - Merging SQL databases from various sources, data cleaning, and manipulation to prepare for analytics and machine learning. - Employing data visualization tools such as Power BI to generate professional-grade dashboards and reports. - Creating high-quality documentation for data processing across different projects to ensure reproducibility. - Upholding Hitachi Energy's core values of safety and integrity by taking ownership of your actions and showing consideration for your colleagues and the business. Qualifications required for this role: - BE / BS in Computer Science, Data Science, or related field with a minimum of 5 years of relevant work experience. - 5 years of experience in data engineering, including comprehension of lakehouse architecture, data integration framework, ETL/ELT pipeline, orchestration/monitoring, and star schema data modeling. - 5 years of proficiency in Python/PySpark and SQL. - 2 years of expertise in Microsoft Power BI. - 3 years of experience utilizing Azure-based environment like Databricks, ADLS, and Azure Machine Learning for data engineering purposes. - Basic knowledge of Machine Learning algorithms. - Capability to quickly grasp concepts outside one's core field; a rapid learning generalist capable of independently solving problems and adept at navigating a matrixed corporate setting. - Proficiency in both spoken and written English language is mandatory. Join the Hitachi Energy's INOPC team in Chennai, Tamil Nadu, India, as a Data Engineer and become part of a vibrant environment where innovation and excellence are embraced. Apply now to embark on this thrilling journey.,
ACTIVELY HIRING
posted 2 months ago
experience2 to 6 Yrs
location
All India
skills
  • SSIS
  • ETL
  • TSQL
  • SQL Mastery
  • GitGitHub
  • Star Snowflake schemas
  • Dimensional Relational modeling
  • CICD pipelines implementation
  • Snowflake Cloud Computing
Job Description
Role Overview: As an SSIS & ETL Expert with 6+ years of hands-on experience, you are responsible for SQL Mastery, proficient in T-SQL, complex queries & performance tuning, and expert in optimizing SSIS packages and SQL queries for maximum efficiency. Your strong knowledge of Star & Snowflake schemas (5+ years) and experience in Dimensional & Relational modeling (5+ years) will be essential in this role. Additionally, your experience in version control with Git/GitHub, deep understanding of database normalization best practices, and hands-on experience in CI/CD pipelines implementation will be valuable assets. Key Responsibilities: - Utilize your expertise in SSIS & ETL to optimize packages and SQL queries for maximum efficiency - Demonstrate proficiency in T-SQL, complex queries, and performance tuning - Apply strong knowledge of Star & Snowflake schemas and experience in Dimensional & Relational modeling - Work with Git/GitHub for version control and ensure database normalization best practices - Implement CI/CD pipelines for efficient workflow - Experience in Snowflake Cloud Computing is a plus Qualifications Required: - 6+ years of hands-on experience in SSIS & ETL - Proficiency in T-SQL, complex queries, and performance tuning - Strong knowledge of Star & Snowflake schemas (5+ years) - Experience in Dimensional & Relational modeling (5+ years) - 2+ years of working experience with Git/GitHub - Deep understanding of database normalization best practices,
ACTIVELY HIRING
posted 1 day ago
experience2 to 6 Yrs
location
All India
skills
  • Python
  • SQL
  • JavaScript
  • Data Visualization
  • Logging
  • Monitoring
  • RESTful APIs
  • Data Manipulation
  • Statistical Modeling
  • Data Mining
  • AngularJS
  • Ansible
  • Agile Methodologies
  • Infrastructure as Code
  • CICD
  • Feature Engineering
  • Machine Learning Algorithms
  • BI Concepts
  • Dashboard Solutions
  • React
  • Vue
  • Terraform
  • CloudFormation
Job Description
As a Sr. Associate, AI and Data Science Full Stack Engineer within the Data Science Industrialization team at Pfizer Digital's Artificial Intelligence, Data, and Advanced Analytics organization (AIDA), you will be a key player in advancing AI and data science applications from prototypes to full production. By contributing to the end-to-end build and deployment of data science and analytics products, developing server-side logic, and creating data visualizations, you will have the opportunity to impact Pfizer's digital transformation positively. **Role Responsibilities:** - Contribute to the end-to-end build and deployment of data science and analytics products and AI modules - Develop server-side logic using back-end technologies like Python - Contribute to the implementation of data ETL pipelines using Python and SQL - Build web applications with JavaScript frameworks - Create data visualizations and data applications to facilitate data exploration and insights generation - Manage infrastructure and tools for software development and deployment using Infrastructure as Code (IaC) tools - Automate processes for continuous integration, delivery, and deployment (CI/CD pipeline) to ensure smooth software delivery - Implement logging and monitoring tools to gain insights into system behavior - Collaborate with data scientists, engineers, and colleagues from across Pfizer to integrate AI and data science models into production solutions - Stay updated with emerging technologies and trends in the field **Basic Qualifications:** - Bachelor's or Master's degree in Computer Science or a related field (or equivalent experience) - 2+ years of experience in software engineering, data science, or related technical fields - Proficiency in programming languages such as Python or R - Familiarity with back-end technologies, databases (SQL and NoSQL), and RESTful APIs - Knowledge of data manipulation and preprocessing techniques, including data cleaning, data wrangling, and feature engineering - Self-motivated with the ability to work independently and collaboratively within a team - Willingness to tackle new challenges creatively and step outside of your comfort zone - Strong English communication skills (written and verbal) **Preferred Qualifications:** - Advanced degree in Data Science, Computer Engineering, Computer Science, Information Systems, or a related discipline - Experience in CI/CD integration (e.g., GitHub, GitHub Actions) and containers (e.g., Docker) - Understanding of statistical modeling, machine learning algorithms, and data mining techniques - Familiarity with data science enabling technology like Dataiku Data Science Studio, AWS SageMaker, or other data science platforms - Knowledge of BI backend concepts like Star Schema and Snowflake - Proficiency in building low code dashboard solutions using tools like Tableau, Power BI, Dash, and Streamlit - Experience in developing dynamic and interactive web applications; familiarity with React, AngularJS, Vue - Experience with Infrastructure as Code (IaC) tools such as Terraform, Ansible, or CloudFormation - Familiarity with cloud-based analytics ecosystems (e.g., AWS, Snowflake) - Hands-on experience working in Agile teams, processes, and practices Joining Pfizer Digital's AIDA organization will allow you to work non-traditional hours interacting with global teams, spanning across different regions. Pfizer is an equal opportunity employer, complying with all applicable equal employment opportunity legislation in each jurisdiction in which it operates.,
ACTIVELY HIRING
posted 1 week ago
experience8 to 12 Yrs
location
Punjab
skills
  • ETL tools
  • SQL Server
  • MySQL
  • Snowflake
  • Tableau
  • Power BI
  • Python
  • AWS
  • Azure
  • Data MartEDW methodologies
  • star schemas
  • snowflake schemas
  • fact
  • dimension tables
  • BigQuery
Job Description
As an experienced ETL & DWH Engineer/Data Analyst with over 8 years of expertise in data integration, warehousing, and analytics, your role is crucial in leading complex data engineering projects from design to deployment. Your deep technical knowledge in ETL tools, data modeling, and leadership abilities will be instrumental in ensuring project success. **Key Responsibilities:** - Hands-on experience (4+ years) with ETL tools like SSIS, Informatica, DataStage, or Talend. - Proficiency in relational databases such as SQL Server and MySQL. - Strong understanding of Data Mart/EDW methodologies. - Designing star schemas, snowflake schemas, fact and dimension tables. - Familiarity with Snowflake or BigQuery. - Knowledge of reporting and analytics tools like Tableau and Power BI. - Proficiency in scripting and programming using Python. - Experience with cloud platforms like AWS or Azure. - Leading recruitment, estimation, and project execution. - Exposure to Sales and Marketing data domains. - Working with cross-functional and geographically distributed teams. - Translating complex data problems into actionable insights. - Excellent communication and client management skills. - Self-starter with a collaborative attitude and problem-solving mindset. **Qualifications Required:** - Bachelor's degree in Computer Science, Information Technology, or related field. - Minimum 8 years of experience in ETL, data warehousing, and analytics. - Strong expertise in ETL tools, data modeling, and database management. - Proven track record of leading and delivering complex data engineering projects. - Certification in relevant technologies (e.g., AWS, Azure, ETL tools) is a plus. The company values your ability to deliver high-level and low-level design documents for middleware and ETL architecture, review data integration components, ensure delivery quality and timeliness, provide technical guidance to junior team members, drive QA processes, lead issue escalation, and support planning and resourcing across data engineering efforts. Your contributions will play a key role in the success of global data implementations and continuous improvement initiatives.,
ACTIVELY HIRING
posted 2 months ago
experience3 to 7 Yrs
location
All India
skills
  • Power BI
  • SQL
  • Tableau
  • Data Visualization
  • Business Intelligence
  • Analytics
  • DAX
  • Data Modeling
  • Star Schema
  • ETL
  • Conditional Formatting
  • Azure
  • GCP
  • AWS
  • Python
  • R
  • SAP BusinessObjects
  • Snowflake Schema
  • Power Query
  • M language
  • Schema Design
  • Advanced charting
  • KPIs
  • Drillthroughs
  • Tooltips
  • Tableau Server
Job Description
As a Power BI Developer, your role involves designing, developing, and deploying interactive Power BI dashboards, reports, and data visualizations. You will collaborate with business stakeholders to gather requirements, connect Power BI to various data sources, and optimize report performance. Additionally, you will implement data modeling techniques, develop DAX calculations, and manage report security in Power BI Service. Key Responsibilities: - Design, develop, and deploy interactive Power BI dashboards, reports, and data visualizations. - Collaborate with business stakeholders to gather requirements, understand KPIs, and define analytical needs. - Connect Power BI to various data sources including SQL Server, Oracle, SAP HANA, and BigQuery. - Optimize report performance, manage data refresh schedules, and ensure data accuracy and consistency. - Implement data modeling techniques including Star Schema, Snowflake Schema, and data relationships. - Develop DAX calculations, measures, and calculated columns to support complex business logic. - Manage report security, row-level security (RLS), and workspace governance in Power BI Service. - Perform data blending and transformations using Power Query (M language). - Publish and maintain reports on Power BI Service, manage user access, and schedule refreshes. - Collaborate with teams using other BI tools like Tableau and SAP BO for cross-platform analytics integration. - Provide end-user training, documentation, and post-deployment support. Technical Skills Required: - Primary Tools: Power BI Desktop, Power BI Service, Power Query, DAX - Database Skills: SQL, Oracle, Google BigQuery, SAP HANA - ETL/Modeling: Dataflows, Power Query Editor, Data Modeling, Schema Design - Visualization & Analytics: Advanced charting, KPIs, Drill-throughs, Tooltips, Conditional Formatting - Additional Tools: Tableau, SAP BusinessObjects (Web Intelligence, IDT/UDT), Lumira (nice to have) - Version Control & Deployment: Workspace management, Power BI Gateways, and Data Refresh automation. Preferred Experience: - Experience in enterprise-scale BI environments with tools like Tableau Server, SAP BO, and Power BI Service. - Exposure to cloud data sources (Azure, GCP, AWS). - Experience with KPI reporting and executive dashboards. - Knowledge of Python or R for data analytics (optional). This job is offered as Full-time, Contractual / Temporary, or Freelance with a contract length of 6 months. The expected hours are 45 per week, and the work location is remote.,
ACTIVELY HIRING
posted 2 months ago

Senior Software Engineer (Data Engineering)

Bigthinkcode Technologies Private Limited
experience5 to 9 Yrs
location
Chennai, Tamil Nadu
skills
  • Python
  • SQL
  • dbt
  • RDBMS
  • JSON
  • Avro
  • Snowflake
  • Git
  • Kafka
  • AWS
  • GCP
  • Azure
  • ETLELT frameworks
  • cloud data warehouses
  • Apache Airflow
  • AWS Glue
  • Parquet
  • Redshift
  • BigQuery
  • CICD
  • Kinesis
  • Spark Streaming
  • dimensional
  • star schema
Job Description
As a skilled Data Engineer at BigThinkCode Technologies, your role involves designing, building, and maintaining robust data pipelines and infrastructure to optimize data flow and ensure scalability. Your technical expertise in Python, SQL, ETL/ELT frameworks, and cloud data warehouses, along with strong collaboration skills, will be crucial in partnering with cross-functional teams to enable seamless access to structured and unstructured data across the organization. **Key Responsibilities:** - Design, develop, and maintain scalable ETL/ELT pipelines for structured and unstructured data processing. - Optimize and manage SQL queries for performance and efficiency in handling large-scale datasets. - Collaborate with data scientists, analysts, and business stakeholders to translate requirements into technical solutions. - Ensure data quality, governance, and security across pipelines and storage systems. - Document architectures, processes, and workflows for clarity and reproducibility. **Required Technical Skills:** - Proficiency in Python for scripting, automation, and pipeline development. - Expertise in SQL for complex queries, optimization, and database design. - Hands-on experience with ETL/ELT tools such as Apache Airflow, dbt, and AWS Glue. - Experience working with both structured (RDBMS) and unstructured data (JSON, Parquet, Avro). - Familiarity with cloud-based data warehouses like Redshift, BigQuery, and Snowflake. - Knowledge of version control systems like Git and CI/CD practices. **Preferred Qualifications:** - Experience with streaming data technologies such as Kafka, Kinesis, and Spark Streaming. - Exposure to cloud platforms like AWS, GCP, Azure, and their data services. - Understanding of data modeling techniques like dimensional and star schema and optimization. The company offers benefits like a flexible schedule, health insurance, paid time off, and a performance bonus. Thank you for considering this opportunity at BigThinkCode Technologies.,
ACTIVELY HIRING
posted 2 days ago

Qlikview Developer

Full Stack Pantry
experience3 to 7 Yrs
location
All India
skills
  • Qlik Sense
  • data integration
  • scripting
  • visualization
  • insurance
  • SQL
  • star schema
  • KPI dashboards
  • summary reports
  • mashups
  • Agile methodology
  • Git
  • SVN
  • Power BI
  • Tableau
  • stakeholder management
  • BI application development
  • Third Party Administrator TPA
  • REST APIs
  • data modelling
  • snowflake schema
  • UXUI practices
  • Qlik Management Console QMC
  • selfservice pages
  • NPrinting
  • analytical thinking
Job Description
As a skilled and proactive Qlik Sense Developer with comprehensive expertise in end-to-end BI application development on the Qlik Sense Enterprise platform, your responsibilities will include the following: - Gather and understand business requirements and translate them into technical solutions using Qlik Sense. - Build Qlik Sense dashboards and data applications from scratch, including: - Data extraction from various sources (SQL, REST APIs, flat files, Excel, cloud platforms). - Data modelling and transformation using Qlik scripting (ETL within Qlik). - Building optimized data models with star schema or snowflake as appropriate. - Designing clean, interactive, and insightful dashboards with effective UX/UI practices. - Optimize data load performance and dashboard responsiveness. - Schedule and manage reload tasks on Qlik Sense QMC. - Collaborate with business analysts, domain experts, and stakeholders to deliver applications in tight timelines. - Troubleshoot issues related to data refresh, visual anomalies, or performance bottlenecks. - Implement Section Access for data security where required. - Maintain documentation for data models, load scripts, and user guides. - Stay updated with Qlik roadmap, extensions, and best practices. Required Skills & Experience: - 3+ years of hands-on experience in Qlik Sense Enterprise development. - Strong command over Qlik scripting and data transformation logic. - Solid experience in data source integration (SQL Server, Excel, REST APIs, etc.). - Deep understanding of data modelling techniques and performance tuning. - Expertise in creating KPI dashboards, summary reports, and self-service pages. - Familiarity with Qlik Management Console (QMC) task scheduling, user access, app publishing. - Ability to work independently and deliver high-quality apps under strict timelines. - Strong problem-solving skills and ability to manage changing priorities. Preferred Qualifications: - Experience or domain knowledge in Insurance / TPA / Claims Processing. - Knowledge of NPrinting, mashups, or Qlik extensions is a plus. - Familiarity with Agile methodology and version control (Git, SVN) is desirable. - Experience working with other BI tools (Power BI, Tableau) is an advantage. Soft Skills: - Strong communication and stakeholder management. - Analytical thinking with attention to detail. - Team player with a collaborative mindset. - Willingness to learn and adapt quickly. Education: - Bachelors degree in Computer Science, Information Systems. (Note: Work Location is Remote),
ACTIVELY HIRING
posted 2 months ago
experience6 to 10 Yrs
location
All India
skills
  • Data Modeling
  • SQL
  • RDBMS
  • OLAP
  • OLTP
  • Star schema
  • ETL
  • Data Governance
  • Data quality
  • Agile methodology
  • AWS
  • GCP
  • Dimensional models
  • Snowflake schema
  • Data Vault Modelling
  • Cloud services Azure
Job Description
As a Senior Data Engineer at Tiger Analytics, you will play a crucial role in solving organizational data management challenges to help them become a data-driven organization. Your responsibilities will include seamlessly transitioning between roles of an Individual Contributor, team member, and Data Modeling lead as required by each project to define, design, and deliver actionable insights. Here is what a typical day in this role may look like: - Engage with clients to understand business requirements and translate them into data models. - Create and maintain a Logical Data Model (LDM) and Physical Data Model (PDM) using best practices to provide valuable business insights. - Contribute to Data Modeling accelerators. - Develop and maintain the Source to Target Data Mapping document containing documentation of entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc. - Gather and publish Data Dictionaries. - Assist in maintaining data models and capturing them from existing databases, including recording descriptive information. - Utilize Data Modeling tools to create appropriate data models. - Contribute to the construction of data warehouses and data marts on the Cloud while conducting data profiling and quality analysis. - Use version control to manage versions of data models. - Collaborate with Data Engineers to design and implement data extraction and integration code modules. - Work with data engineers to strategize ingestion logic and consumption patterns. What we expect from you: - 6+ years of experience in the Data space. - Proficiency in SQL. - Extensive experience in one or more RDBMS (Oracle, DB2, SQL Server). - Hands-on experience with OLAP & OLTP database models (Dimensional models). - Strong understanding of Star schema, Snowflake schema, and Data Vault Modeling, as well as knowledge of ETL tools, Data Governance, and Data Quality. - Ability to analyze data and familiarity with agile methodology. - Preferably, familiarity with any of the cloud services (Azure, AWS, GCP). At Tiger Analytics, we value diversity and inclusivity, and we encourage individuals with varying skills and qualities to apply, even if they do not meet all the requirements for the role. We are dedicated to providing equal opportunities for all candidates. Please note that the job title and compensation will be determined based on your expertise and experience. Tiger Analytics offers competitive compensation packages within the industry.,
ACTIVELY HIRING
logo

@ 2025 Shine.com | All Right Reserved

Connect with us:
  • LinkedIn
  • Instagram
  • Facebook
  • YouTube
  • Twitter