Data Warehouse Architect

{
  "content_hash": "c4fca487aeea214f60b39ec4ad309bf8124add201dd2399f77e6c0b326f2b428",
  "source_hash": "6560f286ab8956f383cdeffb75e5dcd48c50344fec803f6c44f2d274c614f39e",
  "last_changed_at": "2026-05-31T17:45:31.544Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Lansing, MI, United States",
    "city": "Lansing",
    "region": "MI",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T11:03:34.582Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Lansing, MI, United States",
      "city": "Lansing",
      "region": "MI",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "id": "743999659816691",
  "ref": "https://api.smartrecruiters.com/v1/companies/askitconsulting/postings/743999659816691",
  "name": "Data Warehouse Architect",
  "uuid": "f7592153-8cd3-4a51-88b3-8aa45d4993b5",
  "detail": {
    "id": "743999659816691",
    "name": "Data Warehouse Architect",
    "uuid": "f7592153-8cd3-4a51-88b3-8aa45d4993b5",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p><span>Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models. Development experience in implementation of data warehousing utilizing RDBMS. Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. Expertise in SQL and proficiency in database tuning techniques. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.</span></p>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p><span>Ask ITC Inc. is a software development Company. <span>Our<span> </span></span><strong>passion</strong><span><span> </span>is delivering technology<span> </span></span><strong>strategies</strong><span><span> </span>&amp; digital<span> </span></span><strong>solutions</strong><span><span> </span>that assist our clients<span> </span></span><span>with building<span> </span></span><strong>competitive</strong><span>,<span> </span></span><strong>innovative</strong><span><span> </span>and<span> </span></span><strong>successful<span> </span></strong><span>companies.</span></span><br /></p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>All your information will be kept confidential according to EEO guidelines.</p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "80373eb2-8280-4173-9625-1598527c6da2",
    "active": true,
    "company": {
      "name": "Ask IT consulting",
      "identifier": "AskITConsulting"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "acb9b308-2a2a-4971-b9ba-1f4cf3ce2640",
    "applyUrl": "https://jobs.smartrecruiters.com/AskITConsulting/743999659816691-data-warehouse-architect?oga=true",
    "function": {
      "id": "information_technology",
      "label": "Information Technology"
    },
    "industry": {
      "id": "it_and_services",
      "label": "Information Technology And Services"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Lansing",
      "hybrid": false,
      "region": "MI",
      "remote": false,
      "country": "us",
      "latitude": "42.73253499999999",
      "longitude": "-84.55553470000001",
      "fullLocation": "Lansing, MI, United States"
    },
    "refNumber": "REF628O",
    "postingUrl": "https://jobs.smartrecruiters.com/AskITConsulting/743999659816691-data-warehouse-architect",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "COUNTRY",
        "valueId": "us",
        "fieldLabel": "Country/Region",
        "valueLabel": "United States"
      },
      {
        "fieldId": "58b7e74de4b0885c92cd9f24",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "Ask IT consulting"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/AskITConsulting/publication/f7592153-8cd3-4a51-88b3-8aa45d4993b5?dcr_ci=AskITConsulting",
    "defaultJobAd": true,
    "releasedDate": "2017-09-14T15:17:41.000Z",
    "experienceLevel": {
      "id": "mid_senior_level",
      "label": "Mid-Senior Level"
    },
    "typeOfEmployment": {
      "id": "contract",
      "label": "Contract"
    }
  },
  "company": {
    "name": "Ask IT consulting",
    "identifier": "AskITConsulting"
  },
  "jobAdId": "acb9b308-2a2a-4971-b9ba-1f4cf3ce2640",
  "function": {
    "id": "information_technology",
    "label": "Information Technology"
  },
  "industry": {
    "id": "it_and_services",
    "label": "Information Technology And Services"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Lansing",
    "hybrid": false,
    "region": "MI",
    "remote": false,
    "country": "us",
    "latitude": "42.73253499999999",
    "longitude": "-84.55553470000001",
    "fullLocation": "Lansing, MI, United States"
  },
  "refNumber": "REF628O",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    },
    {
      "fieldId": "58b7e74de4b0885c92cd9f24",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "Ask IT consulting"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2017-09-14T15:17:41.000Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "mid_senior_level",
    "label": "Mid-Senior Level"
  },
  "typeOfEmployment": {
    "id": "contract",
    "label": "Contract"
  }
}