Save Job Back to Search Job Description Summary Similar JobsCompetitive SalaryOpportunity to work on cutting edge technology for project developmentAbout Our ClientOur client is a large organization operating within the industrial and manufacturing industry. They are committed to innovation and technological advancement, focusing on delivering high-quality solutions for their customers.Job DescriptionDesign, develop, and maintain enterprise-scale Data Warehouses, Lakehouses, and Data Marts to support business intelligence and analytics requirements.Develop and implement conceptual, logical, and physical data models using industry best practices.Design and optimize star schema, snowflake schema, and dimensional data models.Build, enhance, and maintain scalable ETL/ELT pipelines for data ingestion, transformation, and loading from multiple source systems.Develop and optimize data integration solutions using Microsoft Fabric Data Factory, Data Pipelines, Lakehouse, and Data Warehouse.Extract, transform, and load data from various sources, including databases, APIs, flat files, and cloud applications.Design and implement robust data quality, validation, and reconciliation processes.Monitor and troubleshoot data pipelines, ensuring data accuracy, reliability, and performance.Collaborate with business stakeholders, analysts, and developers to define data requirements and deliver data solutions.Support reporting, analytics, and AI/ML initiatives through the provision of trusted and governed data assets.Implement data governance, security, and compliance standards across the data platform.Drive continuous improvement in data architecture, development standards, and automation practices.Participate in solution design, code reviews, testing, and deployment activities.The Successful ApplicantProven experience designing and building enterprise Data Warehouses, including dimensional modeling, star schemas, snowflake schemas, and data mart development.Strong hands-on expertise in Microsoft Fabric, including OneLake, Data Factory, Data Pipelines, Lakehouse, Data Warehouse, and Power BI integration.Advanced SQL skills, with the ability to write complex queries, optimize performance, develop stored procedures, and troubleshoot database issues.Strong Python programming experience for data processing, automation, ETL/ELT development, and working with frameworks such as Pandas and PySpark.Extensive experience developing and maintaining ETL/ELT pipelines, integrating data from multiple sources while ensuring data quality, reliability, and scalability.Solid database experience across platforms such as SQL Server, Azure SQL, Synapse Analytics, Oracle, PostgreSQL, or MySQL, including database design and performance tuning.Strong understanding of cloud-based data architectures and modern data platform concepts, including Lakehouse, Medallion Architecture, Data Governance, and Data Security.Excellent problem-solving and stakeholder management skills, with the ability to translate business requirements into scalable, high-quality data solutions and work effectively with both technical and business teams.What's on OfferContract: 1 year - extendableMedical BenefitsOpportunity to work with cutting-edge technology alongside large scale international projects teamsCollaborative and innovative work environment.If you are passionate about technology and data engineering, apply now to join a forward-thinking organization in the industrial and manufacturing sector!ContactCharlene FernandezQuote job refJN-072026-7054579Phone number+60323024024Job summaryFunctionITSpecialisationIT Data AnalysisWhat is your area of specialisation?Industrial / ManufacturingLocationMalaysiaContract TypeTemporaryConsultant nameCharlene FernandezConsultant contact+60323024024Job ReferenceJN-072026-7054579