Data Analyst/ETL Specialist

{
  "content_hash": "5bb810f208fd7b99c65e1801e444ea8eb46a5499dedd3aa450c41b9f96d15526",
  "source_hash": "ac19777509f65f8483393fd8a6c8954f454a3031a9b44d7e6f50e26195b98148",
  "last_changed_at": "2026-06-18T13:12:05.312Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Fairfield, NJ, US, Fairfield, NJ",
    "city": "Fairfield",
    "region": "NJ",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.95
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-18T13:12:05.306Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Fairfield, NJ, US, Fairfield, NJ",
      "city": "Fairfield",
      "region": "NJ",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.95
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "detail": {
    "links": [],
    "itemID": "9200366073273_1",
    "postDate": "2021-11-05T13:12:00.000-04:00",
    "workLevelCode": {
      "shortName": "Full Time"
    },
    "customFieldGroup": {
      "dateFields": [
        {
          "nameCode": {
            "codeValue": "PostingDate"
          },
          "dateValue": "2021-11-05T13:12Z"
        },
        {
          "nameCode": {
            "codeValue": "CurrentServerDateTime"
          },
          "dateValue": "2026-06-18T09:12Z"
        }
      ],
      "numberFields": [
        {
          "numberValue": 0,
          "categoryCode": {
            "codeValue": "ApplicantCount"
          }
        },
        {
          "categoryCode": {
            "codeValue": "AwardAmount"
          }
        }
      ],
      "stringFields": [
        {
          "nameCode": {
            "codeValue": "ExternalJobID"
          },
          "stringValue": "380104"
        },
        {
          "nameCode": {
            "codeValue": "CareerCenterRefId"
          }
        },
        {
          "nameCode": {
            "codeValue": "GuidelineOid"
          }
        },
        {
          "nameCode": {
            "codeValue": "CurrencySymbolOrCode"
          }
        },
        {
          "nameCode": {
            "codeValue": "HomeDepartment"
          },
          "stringValue": ""
        },
        {
          "nameCode": {
            "codeValue": "JobClass"
          }
        }
      ],
      "indicatorFields": [
        {
          "nameCode": {
            "codeValue": "PriortyStatusFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "InternalPostingFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "MinValue"
          },
          "indicatorValue": true
        },
        {
          "nameCode": {
            "codeValue": "IsVsidApplicable"
          },
          "indicatorValue": true
        },
        {
          "nameCode": {
            "codeValue": "IsSassDlReqForExtPostFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "IsSassDlReqForIntPostFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "IsMonetaryFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "IsNonMonetaryFlag"
          },
          "indicatorValue": false
        }
      ]
    },
    "requisitionTitle": "Data Analyst/ETL Specialist",
    "clientRequisitionID": "1030",
    "organizationalUnits": [],
    "postingInstructions": [],
    "additionalProperties": {},
    "requisitionLocations": [
      {
        "address": {
          "cityName": "Fairfield",
          "postalCode": "07004",
          "countrySubdivisionLevel1": {
            "codeValue": "NJ"
          }
        },
        "nameCode": {
          "shortName": " Fairfield, NJ, US"
        },
        "aliasNames": []
      },
      {
        "address": {
          "cityName": "Berlin",
          "postalCode": "",
          "countrySubdivisionLevel1": {
            "codeValue": "Berlin"
          }
        },
        "nameCode": {
          "shortName": " Berlin, Berlin, DE"
        },
        "aliasNames": []
      },
      {
        "address": {
          "cityName": "Wokingham",
          "postalCode": "",
          "countrySubdivisionLevel1": {
            "codeValue": "Wokingham"
          }
        },
        "nameCode": {
          "shortName": " Wokingham, Wokingham, GB"
        },
        "aliasNames": []
      },
      {
        "address": {
          "cityName": "Weymouth",
          "postalCode": "02189",
          "countrySubdivisionLevel1": {
            "codeValue": "MA"
          }
        },
        "nameCode": {
          "shortName": " Weymouth, MA, US"
        },
        "aliasNames": []
      }
    ],
    "screeningRequirements": [],
    "requisitionDescription": "\n    <link href=\"https://static.workforcenow.adp.com/mas/mdf-components/21.43.15/styles/froala_editor.pkgd.min.css\" rel=\"stylesheet\" type=\"text/css\" />\n    <link href=\"https://static.workforcenow.adp.com/mas/mdf-components/21.43.15/styles/froala_style.min.css\" rel=\"stylesheet\" type=\"text/css\" />\n\n    <div class=\"fr-view\">\n      <div><div><link href=\"https://static.workforcenow.adp.com/mas/mdf-components/21.43.15/styles/froala_editor.pkgd.min.css\" rel=\"stylesheet\" type=\"text/css\">&nbsp;<link href=\"https://static.workforcenow.adp.com/mas/mdf-components/21.43.15/styles/froala_style.min.css\" rel=\"stylesheet\" type=\"text/css\"><div class=\"fr-view\"><div><h1 id=\"isPasted\">Data Analyst/ETL Specialist</h1><p>Keypoint Intelligence is a global leader in business-to-business information and product testing with offices in Weymouth, Massachusetts, Fairfield, New Jersey, Wokingham, United Kingdom, Tokyo, Japan, and Hong Kong, China. &nbsp; We are seeking a Data Analyst/ETL Specialist with at least three years relevant experience working in a similar industry or position. This position offers the flexibility to work from home with periodic travel into a local office, as necessary. The ideal candidate should be located in the Eastern United States, the UK, or Europe, in order to be best integrated with our Data Engineering teams working in those regional offices.</p><h1>Role</h1><p>This individual will primarily be tasked with managing various internal data sets, from the initial ETL workflows required to integrate the content into our data warehouse, to generating analytics and insights for both internal and external audiences. As a key member of the Forecast team you will be responsible for supporting the wider organization through the management, design and implementation of existing and new forecasting models and methodologies, helping to improve the overall process as well as time to market for our external client deliverables.</p><p>This position will also be responsible for development and support of back-end tools utilized for both manual data entry and automated ingestion of content into our front-end websites and tools, which range from standalone spreadsheets to client-server apps to intranet websites. This individual will be required to become expert in these systems to be able to manage the most complex tasks independently.</p><h1>Skills</h1><ul><li>Data Intuition</li><li>Data Visualization &amp; Communication</li><li>Data Wrangling</li><li>Data Warehousing</li><li>Basic Understanding of Statistical Modeling</li><li>Programming Skills - Low Code, Workflow, .NET</li><li>Knowledge in Machine Learning</li><li>Advanced Excel Knowledge</li></ul><h1>Desired Platforms and Languages</h1><ul><li>DOMO (or other reporting platform, such as Tableau)</li><li>KNIME (or other ETL/Workflow Automation platform)</li><li>SQL Server</li><li>Microsoft Office Tools and Services</li></ul><p><strong>Keypoint Intelligence is an EOE</strong><br>&nbsp;We offer a dynamic work environment and a competitive compensation, PTO, and benefits package which includes a 401k plan, medical, dental, vision, and life insurance plans. &nbsp;</p></div></div></div></div>\n    </div>\n  \n",
    "sponsoredVisaTypeCodes": []
  },
  "list_job": {
    "links": [],
    "itemID": "9200366073273_1",
    "postDate": "2021-11-05T13:12:00.000-04:00",
    "workLevelCode": {
      "shortName": "Full Time"
    },
    "customFieldGroup": {
      "dateFields": [
        {
          "nameCode": {
            "codeValue": "PostingDate"
          },
          "dateValue": "2021-11-05T13:12Z"
        },
        {
          "nameCode": {
            "codeValue": "CurrentServerDateTime"
          },
          "dateValue": "2026-06-18T09:12Z"
        }
      ],
      "numberFields": [
        {
          "numberValue": 0,
          "categoryCode": {
            "codeValue": "ApplicantCount"
          }
        },
        {
          "categoryCode": {
            "codeValue": "AwardAmount"
          }
        }
      ],
      "stringFields": [
        {
          "nameCode": {
            "codeValue": "ExternalJobID"
          },
          "stringValue": "380104"
        },
        {
          "nameCode": {
            "codeValue": "CareerCenterRefId"
          }
        },
        {
          "nameCode": {
            "codeValue": "GuidelineOid"
          }
        },
        {
          "nameCode": {
            "codeValue": "CurrencySymbolOrCode"
          }
        },
        {
          "nameCode": {
            "codeValue": "HomeDepartment"
          },
          "stringValue": ""
        },
        {
          "nameCode": {
            "codeValue": "JobClass"
          }
        }
      ],
      "indicatorFields": [
        {
          "nameCode": {
            "codeValue": "PriortyStatusFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "InternalPostingFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "MinValue"
          },
          "indicatorValue": true
        },
        {
          "nameCode": {
            "codeValue": "IsVsidApplicable"
          },
          "indicatorValue": true
        },
        {
          "nameCode": {
            "codeValue": "IsSassDlReqForExtPostFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "IsSassDlReqForIntPostFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "IsMonetaryFlag"
          },
          "indicatorValue": false
        },
        {
          "nameCode": {
            "codeValue": "IsNonMonetaryFlag"
          },
          "indicatorValue": false
        }
      ]
    },
    "requisitionTitle": "Data Analyst/ETL Specialist",
    "clientRequisitionID": "1030",
    "organizationalUnits": [],
    "postingInstructions": [],
    "additionalProperties": {},
    "requisitionLocations": [
      {
        "address": {
          "cityName": "Fairfield",
          "postalCode": "07004",
          "countrySubdivisionLevel1": {
            "codeValue": "NJ"
          }
        },
        "nameCode": {
          "shortName": " Fairfield, NJ, US"
        },
        "aliasNames": []
      },
      {
        "address": {
          "cityName": "Berlin",
          "postalCode": "",
          "countrySubdivisionLevel1": {
            "codeValue": "Berlin"
          }
        },
        "nameCode": {
          "shortName": " Berlin, Berlin, DE"
        },
        "aliasNames": []
      },
      {
        "address": {
          "cityName": "Wokingham",
          "postalCode": "",
          "countrySubdivisionLevel1": {
            "codeValue": "Wokingham"
          }
        },
        "nameCode": {
          "shortName": " Wokingham, Wokingham, GB"
        },
        "aliasNames": []
      },
      {
        "address": {
          "cityName": "Weymouth",
          "postalCode": "02189",
          "countrySubdivisionLevel1": {
            "codeValue": "MA"
          }
        },
        "nameCode": {
          "shortName": " Weymouth, MA, US"
        },
        "aliasNames": []
      }
    ],
    "screeningRequirements": [],
    "sponsoredVisaTypeCodes": []
  },
  "detail_meta": {
    "url": "https://workforcenow.adp.com/mascsr/default/careercenter/public/events/staffing/v1/job-requisitions/380104?cid=7f60d94d-515a-4335-852d-d44784d86938&ccId=19000101_000001&lang=en_US&locale=en_US",
    "http_status": 200,
    "content_type": "application/json;charset=UTF-8",
    "response_bytes": 6222
  },
  "detail_errors": []
}