{"id":778,"date":"2025-11-06T14:03:00","date_gmt":"2025-11-06T14:03:00","guid":{"rendered":"https:\/\/sankalptechnology.com\/?post_type=jobpost&p=778"},"modified":"2025-11-06T14:10:27","modified_gmt":"2025-11-06T14:10:27","slug":"data-engineer-sql-data-warehouse-analytics","status":"publish","type":"jobpost","link":"https:\/\/sankalptechnology.com\/?jobpost=data-engineer-sql-data-warehouse-analytics","title":{"rendered":"Data Engineer \u2013 \/ SQL (Data Warehouse Analytics)"},"content":{"rendered":"\n

Location: Remote \/ Fulltime<\/p>\n\n\n\n

Experience: 8 Years<\/p>\n\n\n\n

Budget: 1.8 LPM<\/p>\n\n\n\n

JD: <\/p>\n\n\n\n

Work Timings:<\/strong> 11:00 AM \u2013 8:00 PM (Aligned with SAST Time Zone)
Candidates must be flexible to stretch during project urgencies.<\/em><\/p>\n\n\n\n

Reporting To:<\/strong> Head of Data Engineering \/ Project Manager<\/p>\n\n\n\n

\n\n\n\n

Overview<\/strong><\/h3>\n\n\n\n

We are seeking a highly skilled Data Engineer<\/strong> proficient in Ab Initio<\/strong> and SQL<\/strong> to support the design and implementation of a Data Warehouse solution<\/strong>. The ideal candidate will be responsible for data analysis, source-to-target mapping, and close collaboration with cross-functional teams to ensure high-quality data integration and performance.<\/p>\n\n\n\n

\n\n\n\n

Key Responsibilities<\/strong><\/h3>\n\n\n\n

Data Warehouse Development<\/strong><\/h4>\n\n\n\n
    \n
  • Design and build a scalable Data Warehouse<\/strong> tailored to business requirements.<\/li>\n\n\n\n
  • Optimize data storage<\/strong>, ETL performance<\/strong>, and query efficiency<\/strong>.<\/li>\n\n\n\n
  • Ensure seamless integration of data across various business units.<\/li>\n<\/ul>\n\n\n\n

    Data Analysis & Mapping<\/strong><\/h4>\n\n\n\n
      \n
    • Conduct detailed data analysis and profiling to understand existing systems.<\/li>\n\n\n\n
    • Create comprehensive Source-to-Target Mapping (STM)<\/strong> documentation.<\/li>\n\n\n\n
    • Identify data gaps, anomalies, and inconsistencies in source systems.<\/li>\n<\/ul>\n\n\n\n

      ETL Development (Ab Initio)<\/strong><\/h4>\n\n\n\n
        \n
      • Develop and maintain robust ETL pipelines<\/strong> using Ab Initio.<\/li>\n\n\n\n
      • Build reusable components for efficient data processing and transformation.<\/li>\n<\/ul>\n\n\n\n

        SQL & Data Validation<\/strong><\/h4>\n\n\n\n
          \n
        • Write complex SQL queries<\/strong> for data transformation, cleansing, and validation.<\/li>\n\n\n\n
        • Validate datasets for completeness, accuracy, and readiness<\/strong> for analytics and reporting.<\/li>\n<\/ul>\n\n\n\n
          \n\n\n\n

          Qualifications<\/strong><\/h3>\n\n\n\n
            \n
          • Minimum 7+ years<\/strong> of experience in Data Engineering<\/strong> or a similar role.<\/li>\n\n\n\n
          • Hands-on expertise in Ab Initio tools<\/strong> (GDE, EME, Conduct>It).<\/li>\n\n\n\n
          • Strong command of SQL<\/strong> for data transformation and validation.<\/li>\n\n\n\n
          • Experience in financial reporting<\/strong>, especially Return on Capital<\/strong> or related KPIs, is highly preferred.<\/li>\n\n\n\n
          • Exposure to multi-country data integration<\/strong> or multinational projects<\/strong>.<\/li>\n\n\n\n
          • Proven ability to translate business requirements into technical design<\/strong>.<\/li>\n<\/ul>\n\n\n\n
            \n\n\n\n

            Soft Skills<\/strong><\/h3>\n\n\n\n
              \n
            • Excellent written and verbal communication.<\/li>\n\n\n\n
            • Strong analytical and problem-solving mindset.<\/li>\n\n\n\n
            • Proactive, self-motivated, and deadline-driven.<\/li>\n\n\n\n
            • Collaborative team player with cross-functional and cross-geographical experience.<\/li>\n<\/ul>\n\n\n\n
              \n\n\n\n

              Application Instructions<\/strong><\/h3>\n\n\n\n

              Interested candidates are invited to share their updated CV<\/strong> and a brief cover letter<\/strong> highlighting relevant experience with Ab Initio<\/strong>, SQL<\/strong>, and data warehousing projects<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

              Location: Remote \/ Fulltime Experience: 8 Years Budget: 1.8 LPM JD: Work Timings: 11:00 AM \u2013 8:00 PM (Aligned with SAST Time Zone)Candidates must be flexible [\u2026]<\/span><\/p>\n","protected":false},"author":3,"featured_media":0,"menu_order":0,"template":"","jobpost_category":[],"jobpost_job_type":[17,19],"jobpost_location":[],"jobpost_tag":[],"class_list":["post-778","jobpost","type-jobpost","status-publish","hentry","jobpost_job_type-full-time","jobpost_job_type-remote"],"_links":{"self":[{"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=\/wp\/v2\/jobpost\/778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=\/wp\/v2\/jobpost"}],"about":[{"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=\/wp\/v2\/types\/jobpost"}],"author":[{"embeddable":true,"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"wp:attachment":[{"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=778"}],"wp:term":[{"taxonomy":"jobpost_category","embeddable":true,"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=%2Fwp%2Fv2%2Fjobpost_category&post=778"},{"taxonomy":"jobpost_job_type","embeddable":true,"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=%2Fwp%2Fv2%2Fjobpost_job_type&post=778"},{"taxonomy":"jobpost_location","embeddable":true,"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=%2Fwp%2Fv2%2Fjobpost_location&post=778"},{"taxonomy":"jobpost_tag","embeddable":true,"href":"https:\/\/sankalptechnology.com\/index.php?rest_route=%2Fwp%2Fv2%2Fjobpost_tag&post=778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}