Senior Data Warehouse/Integration Engineer

{
  "content_hash": "d924fc87a6a871e3823243282714a01affc6285696636f61971f139b573f0a61",
  "source_hash": "fa481fe144d56bed76539b216b3f4f64b1a656a852e1d9b51b9559efc0aeee0a",
  "last_changed_at": "2026-06-06T20:00:40.214Z",
  "active_status": "active"
}

{
  "language": "en-us",
  "location": {
    "raw": "Remote (United States), United States",
    "city": null,
    "region": null,
    "country": "United States",
    "is_remote": true,
    "confidence": 0.98,
    "workplace_type": "remote"
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T20:00:40.204Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en-us",
    "location": {
      "raw": "Remote (United States), United States",
      "city": null,
      "region": null,
      "country": "United States",
      "is_remote": true,
      "confidence": 0.98,
      "workplace_type": "remote"
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "remote",
  "salary_period": null,
  "workplace_type": "remote",
  "salary_currency": null
}

{}

{
  "list_job": {
    "id": "449f284f-43eb-4483-8782-3dd0e4e7fe9e",
    "url": "https://ats.rippling.com/conceptplus/jobs/449f284f-43eb-4483-8782-3dd0e4e7fe9e",
    "name": "Senior Data Warehouse/Integration Engineer",
    "language": "en-US",
    "locations": [
      {
        "city": null,
        "name": "Remote (United States)",
        "state": null,
        "country": "United States",
        "stateCode": null,
        "countryCode": "US",
        "workplaceType": "REMOTE"
      }
    ],
    "department": {
      "name": "Health/Federal Civilian Sector"
    }
  },
  "detail_job": {
    "url": "https://ats.rippling.com/conceptplus/jobs/449f284f-43eb-4483-8782-3dd0e4e7fe9e",
    "name": "Senior Data Warehouse/Integration Engineer",
    "uuid": "449f284f-43eb-4483-8782-3dd0e4e7fe9e",
    "board": {
      "logo": {
        "url": "https://prod-images.rippling.com/2a35d0dc06492601dff5371c54a7debe5f2996b4.png?Expires=1780862439&Signature=HYIMesg3z66HtiohhUnWJo0U6MHNYjCCIicDYHkDgkgFCrlxl~Ekoq47vZGUlvETQVA6q9PJlUq~7Y090TYE5VQpJG-~J2RmOtvi4MgkQkZh6BLt4r8AHD72-N4hpZbGW~GAJsrFWgXCsSKxVNKNYihPdCTPz3-CigJB3eeF9jSijijKBb861Zx5TDV8g-tzrQDqqUrMzbL7-y442QOX4mTwsVDu3-5I7u7pZXt9wOh1FpIqf7s4muYta39UIEyUCaLgXjXtFeWqOlAt0uAPHNgcvGV2dmZwyJJ~gfAyKSFMb0OPrpZY-twj6zqQTAwDs7XWBHbIJVv3GMl1OX5L5A__&Key-Pair-Id=K2Y26R2ZPP26PH",
        "name": "cp-full-tagline-colored (1).png",
        "type": "image/png"
      },
      "slug": "conceptplus",
      "title": "Concept Plus Careers",
      "banner": {
        "url": null,
        "name": "",
        "type": ""
      },
      "boardURL": "https://ats.rippling.com/conceptplus/jobs",
      "fontType": "ARIAL_SANS_SERIF",
      "subtitle": "Innovate, Grow, Succeed with US",
      "boardType": "RIPPLING",
      "linkColor": null,
      "buttonColor": "#283891",
      "legalNotice": null,
      "buttonTextColor": null,
      "noOpeningsMessage": null,
      "groupJobsByLocation": false,
      "showBoardLogoOnJobPost": false,
      "showCompanyInfoUnderJobPost": false
    },
    "createdOn": "2026-05-29T05:59:28.657000-07:00",
    "department": {
      "name": "Health/Federal Civilian Sector",
      "base_department": "Health/Federal Civilian Sector",
      "department_tree": [
        "Health/Federal Civilian Sector"
      ]
    },
    "companyName": "Concept Plus",
    "description": {
      "role": "<meta><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;\"><b><strong style=\"font-size:18pt;white-space:pre-wrap;\">About the role</strong></b></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">The Senior Data Warehouse/Integration Engineer will support the development, maintenance, and modernization of a large-scale enterprise data warehouse and related system-to-system integrations. The ideal candidate brings strong expertise in Informatica PowerCenter, advanced SQL skills, and experience in complex, mission-critical data integration environments. </span></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;\"><b><strong style=\"font-size:18pt;white-space:pre-wrap;\">What you'll do</strong></b></p><ul data-pattern=\"discCircleSquare\" data-depth=\"1\" style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;margin:8px 0px;line-height:1.6;padding:0px 0px 0px 32px;list-style-type:disc;\"><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Design, build, and maintain Informatica PowerCenter mappings, sessions, workflows, web services, and related data integration pipelines </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Build and support cross-system interfaces, including automated and manual data conversion processes, in alignment with project milestones </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Create and maintain accurate data mapping, operations, and maintenance documentation, including standard procedures and recurring checklists </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Assess system performance and implement tuning strategies for Informatica workflows, SQL queries, and related database processes </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Support ongoing integration reliability, scalability, and operational readiness across enterprise data warehouse environments</span></li></ul><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;\"><b><strong style=\"font-size:18pt;white-space:pre-wrap;\">Qualifications</strong></b></p><ul data-pattern=\"discCircleSquare\" data-depth=\"1\" style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;margin:8px 0px;line-height:1.6;padding:0px 0px 0px 32px;list-style-type:disc;\"><li style=\"font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"font-size:11pt;white-space:pre-wrap;\">US Citizen</span></li><li style=\"font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);font-size:11pt;white-space:pre-wrap;\">BS in Computer Science, a related field or equivalent experience </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);font-size:11pt;white-space:pre-wrap;\">5+ year’s experience with advanced SQL and relational data modeling </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);font-size:11pt;white-space:pre-wrap;\">5+ year’s experience with data integration, ETL/ELT, and enterprise data warehouse environments </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);font-size:11pt;white-space:pre-wrap;\">Strong analytical and problem-solving skills </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);font-size:11pt;white-space:pre-wrap;\">Knowledge of Windows and/or Perl scripting </span></li><li style=\"color:rgb(0,0,0);font-size:11pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);font-size:11pt;white-space:pre-wrap;\">Strong written and verbal communication skills</span></li></ul><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;\"><b><strong style=\"font-size:18pt;white-space:pre-wrap;\">Preferred</strong></b></p><ul data-pattern=\"discCircleSquare\" data-depth=\"1\" style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;margin:8px 0px;line-height:1.6;padding:0px 0px 0px 32px;list-style-type:disc;\"><li style=\"color:rgb(0,0,0);font-size:10pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Experience tuning Informatica and database performance </span></li><li style=\"color:rgb(0,0,0);font-size:10pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Knowledge of scripting languages such as Windows scripting and Perl </span></li><li style=\"color:rgb(0,0,0);font-size:10pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Experience migrating from Informatica PowerCenter to Informatica Data Management Cloud </span></li><li style=\"color:rgb(0,0,0);font-size:10pt;margin:3px 0px;letter-spacing:0.25px;line-height:1.6;\"><span style=\"color:rgb(0,0,0);white-space:pre-wrap;\">Familiarity with APIs and web services in ITSM products such as ServiceNow and/or Learning Management Systems such as Cornerstone OnDemand</span></li></ul><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><i><em style=\"font-size:11pt;white-space:pre-wrap;\">Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.</em></i></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;\"><br></p>",
      "company": "<meta><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><b><strong style=\"font-size:18pt;white-space:pre-wrap;\">About Concept Plus</strong></b><br><br><span style=\"white-space:pre-wrap;\">Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA, we bring the agility, responsiveness, and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.</span></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><br></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><span style=\"white-space:pre-wrap;\">Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.</span></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><br></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><span style=\"white-space:pre-wrap;\">We offer competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.</span></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:justify;\"><br></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:start;\"><span style=\"white-space:pre-wrap;\">For more information, visit&nbsp;</span><a href=\"http://www.conceptplus.com/\" target=\"_blank\" title=\"http://www.conceptplus.com\" class=\"css-173makr-linkStyle\" style=\"color:rgb(30,74,169);cursor:pointer;\"><span style=\"white-space:pre-wrap;\">www.conceptplus.com</span></a><span style=\"white-space:pre-wrap;\">.</span></p><p style=\"font-family:&quot;Basel Grotesk&quot;,Arial,sans-serif;font-size:11pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px 0px;padding:0px;text-align:start;\"><br></p>"
    },
    "workLocations": [
      "Remote (United States)"
    ],
    "employmentType": {
      "id": "Salaried, full-time",
      "label": "SALARIED_FT"
    },
    "payRangeDetails": [],
    "activeJobApplication": {
      "basicQuestions": [
        {
          "oid": "first_name",
          "title": "First name",
          "required": true,
          "fieldType": "SHORT_ANSWER"
        },
        {
          "oid": "last_name",
          "title": "Last name",
          "required": true,
          "fieldType": "SHORT_ANSWER"
        },
        {
          "oid": "email",
          "title": "Email",
          "required": true,
          "fieldType": "SHORT_ANSWER"
        },
        {
          "oid": "pronouns",
          "title": "Pronouns",
          "required": false,
          "fieldType": "PRONOUN"
        },
        {
          "oid": "current_company",
          "title": "Current company",
          "required": false,
          "fieldType": "SHORT_ANSWER"
        },
        {
          "oid": "phone_number",
          "title": "Phone number",
          "required": true,
          "fieldType": "PHONE_NUMBER"
        },
        {
          "oid": "location",
          "title": "Location (city only)",
          "required": true,
          "fieldType": "SHORT_ANSWER"
        },
        {
          "oid": "resume",
          "title": "Resume",
          "required": true,
          "fieldType": "FILE"
        },
        {
          "oid": "cover_letter",
          "title": "Cover letter",
          "required": false,
          "fieldType": "FILE"
        }
      ],
      "customQuestions": {
        "fields": [
          {
            "oid": "first_name",
            "title": "First name",
            "required": true,
            "fieldData": {},
            "fieldType": "SHORT_ANSWER"
          },
          {
            "oid": "last_name",
            "title": "Last name",
            "required": true,
            "fieldData": {},
            "fieldType": "SHORT_ANSWER"
          },
          {
            "oid": "email",
            "title": "Email",
            "required": true,
            "fieldData": {},
            "fieldType": "SHORT_ANSWER"
          },
          {
            "oid": "pronouns",
            "title": "Pronouns",
            "required": false,
            "fieldData": {},
            "fieldType": "PRONOUN"
          },
          {
            "oid": "current_company",
            "title": "Current company",
            "required": false,
            "fieldData": {},
            "fieldType": "SHORT_ANSWER"
          },
          {
            "oid": "phone_number",
            "title": "Phone number",
            "required": true,
            "fieldData": {},
            "fieldType": "PHONE_NUMBER"
          },
          {
            "oid": "location",
            "title": "Location (city only)",
            "required": true,
            "fieldData": {},
            "fieldType": "SHORT_ANSWER"
          },
          {
            "oid": "resume",
            "title": "Resume",
            "required": true,
            "fieldData": {},
            "fieldType": "FILE"
          },
          {
            "oid": "cover_letter",
            "title": "Cover letter",
            "required": false,
            "fieldData": {},
            "fieldType": "FILE"
          }
        ]
      },
      "additionalQuestions": [
        {
          "id": "6a19a26ed888a4c192e2179e",
          "form": {
            "sections": [],
            "questions": [
              {
                "tags": [],
                "title": "Are you currently subject to any restrictive covenant, non-compete agreement, non-solicitation, confidentiality, or other contractual restriction with a current or previous employer that could limit, restrict, or prohibit your ability to perform the duties of the position for which you are applying? ",
                "canEdit": false,
                "dataType": "enum",
                "isPrivate": false,
                "uniqueKey": "01fafe5e-c3c8-408b-91d5-b3d7cb31d6f4",
                "intChoices": [],
                "isRequired": true,
                "strChoices": [
                  "Yes",
                  "No"
                ],
                "description": "",
                "questionType": "SINGLE_SELECT_DROPDOWN",
                "allowComments": true,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": false
              }
            ],
            "skipLogic": [],
            "deletedSections": [],
            "deletedQuestions": []
          },
          "name": "Restrictive Covenants"
        },
        {
          "id": "6a19a26ed888a4c192e2179f",
          "form": {
            "sections": [],
            "questions": [
              {
                "tags": [],
                "title": "Are you a current or former federal employee?",
                "canEdit": false,
                "dataType": "enum",
                "isPrivate": false,
                "uniqueKey": "818309d9-c958-4e3f-9e49-56da84337bcf",
                "intChoices": [],
                "isRequired": true,
                "strChoices": [
                  "Yes",
                  "No"
                ],
                "description": "",
                "questionType": "SINGLE_SELECT_DROPDOWN",
                "allowComments": false,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": false
              },
              {
                "tags": [],
                "title": "What agency did you work for?",
                "canEdit": false,
                "dataType": "Text",
                "isPrivate": false,
                "uniqueKey": "07828bee-1fa3-4212-bb43-4fad1a4998aa",
                "intChoices": [],
                "isRequired": false,
                "strChoices": [],
                "questionType": "SHORT_ANSWER",
                "allowComments": false,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": false
              },
              {
                "tags": [],
                "title": "What were the dates of your federal service?",
                "canEdit": false,
                "dataType": "Text",
                "isPrivate": false,
                "uniqueKey": "cd243dc2-6ea4-4ef7-8d77-a4a87ba15819",
                "intChoices": [],
                "isRequired": false,
                "strChoices": [],
                "questionType": "SHORT_ANSWER",
                "allowComments": false,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": false
              }
            ],
            "skipLogic": [],
            "deletedSections": [],
            "deletedQuestions": []
          },
          "name": "Federal Employment Questionnaire"
        },
        {
          "id": "6a19a26ed888a4c192e217a0",
          "form": {
            "sections": [],
            "questions": [
              {
                "tags": [],
                "title": "Current US Residency Status: please select your current residency status in the United States: ",
                "canEdit": false,
                "dataType": "select",
                "isPrivate": false,
                "uniqueKey": "8c25186e-a4c9-496e-9fbf-e1e69b534f43",
                "intChoices": [],
                "isRequired": true,
                "strChoices": [
                  "US Citizen",
                  "Permanent Resident (Green Card Holder)",
                  "Work Visa Holder (e.g., H-1B, L-1, O-1)",
                  "Student Visa Holder (e.g., F-1, J-1)",
                  "Not Applicable"
                ],
                "description": "",
                "questionType": "KNOCKOUT",
                "allowComments": false,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": true
              }
            ],
            "skipLogic": [],
            "deletedSections": [],
            "deletedQuestions": [
              {
                "tags": [],
                "title": "Current US Residency Status: please select your current residency status in the United States: ",
                "canEdit": false,
                "dataType": "select",
                "isPrivate": false,
                "uniqueKey": "23c9c6ce-41a7-4ab3-b758-42aa7dca2060",
                "intChoices": [],
                "isRequired": true,
                "strChoices": [
                  "US Citizen",
                  "Permanent Resident (Green Card Holder)",
                  "Work Visa Holder (e.g., H-1B, L-1, O-1)",
                  "Student Visa Holder (e.g., F-1, J-1)",
                  "Not Applicable"
                ],
                "description": "",
                "questionType": "KNOCKOUT",
                "allowComments": false,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": true
              }
            ]
          },
          "name": "US Residency Status"
        },
        {
          "id": "6a19a26ed888a4c192e217a1",
          "form": {
            "sections": [],
            "questions": [
              {
                "tags": [],
                "title": "Minimum Salary:",
                "canEdit": false,
                "dataType": "Text",
                "maxChars": 7,
                "isPrivate": false,
                "uniqueKey": "8c25186e-a4c9-496e-9fbf-e1e69b534f43",
                "intChoices": [],
                "isRequired": true,
                "strChoices": [],
                "description": "Please enter your minimum salary expectation (in USD per year)",
                "questionType": "SHORT_ANSWER",
                "allowComments": false,
                "isOtherEnabled": false,
                "isMultiSelectEnabled": false
              }
            ],
            "skipLogic": [],
            "deletedSections": [],
            "deletedQuestions": []
          },
          "name": "Minimum Salary"
        }
      ]
    },
    "hasAIEvaluationsEnabled": true,
    "eeocQuestionnaireEnabled": true,
    "applicationConfirmationTemplate": "66f477feea16f0cac05e322f",
    "eeocQuestionnaireEnabledForJobPost": true
  },
  "detail_meta": {
    "url": "https://ats.rippling.com/api/v2/board/conceptplus/jobs/449f284f-43eb-4483-8782-3dd0e4e7fe9e",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 17404
  },
  "detail_errors": []
}