Data Analyst - Production Support (DWH Ops)

{
  "content_hash": "a03b2620088882b82d1562a584a463e3295193976dd5d91e8f5448c05b5c414f",
  "source_hash": "7449da8b98bb020caada3e31dfc7ed32e11cfd41170e9aeb43e6468a0ebb7fb3",
  "last_changed_at": "2026-05-31T17:39:30.937Z",
  "active_status": "active"
}

{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "Addison, TX, United States",
    "city": "Addison",
    "region": "TX",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-20T11:09:38.996Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Addison, TX, United States",
      "city": "Addison",
      "region": "TX",
      "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": "744000003690110",
  "ref": "https://api.smartrecruiters.com/v1/companies/shirotechnologiesinc/postings/744000003690110",
  "name": "Data Analyst - Production Support (DWH Ops)",
  "uuid": "7b30e438-6fa1-4440-b954-5afc3257e40c",
  "detail": {
    "id": "744000003690110",
    "name": "Data Analyst - Production Support (DWH Ops)",
    "uuid": "7b30e438-6fa1-4440-b954-5afc3257e40c",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p>Key Skills:<br>\nEnterprise DWH, Insurance Domain (P&amp;C) SME, Advanced SQL, SQL Server, DB2, DDL, frameworks, ETL, BI Architecture.</p><p>ROLE SUMMARY<br>\nThe Production Support Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help Client maintain the enterprise data warehouse architecture. Furthermore, the data warehouse architecture will measure performance in all aspects of the organization’s operations.</p><p>ROLE RESPONSIBILITIES<br>\nWork with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.<br>\nCreate source-to-target mapping documents to capture additional application data elements.<br>\nLoad the source-to-target mapping documents from source systems into the enterprise data warehouse.<br>\nCollaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.<br>\nEnsure the ETL code align with STM requirements.<br>\nPerform data validation, to insure correct data movement into the enterprise data warehouse architecture.<br>\nConsult with reporting teams to develop a general understanding for any identified variances – between the enterprise data warehouse and source system applications.</p><p>TECHNICAL QUALIFICATIONS<br>\nProven 8+ years’ experience of data analysis within an enterprise data warehouse.<br>\nPossess 4 years of Policy &amp; Claims Insurance subject-matter expertise. &#xa0;<br>\nCandidate has advanced level SQL knowledge.<br>\nPossess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.<br>\nCandidate is capable of creating and tuning Semantic layer Reporting Views.<br>\nAble to facilitate data discovery sessions, which will include an audience of business subject-matter experts.<br>\nProven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.<br>\nPossess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI &amp; SAP FS-CD applications with their data is considered a plus.</p>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "<p>B.S. Degree in Computer Information Science, Information Management, or Statistics.</p>",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p>SHIRO TECHNOLOGIES LLC is a multidimensional global technology services and outsourcing company. We are a critical source for innovative, bespoke IT solutions. We are focused on advancing technology, and by leveraging our years of industry experience, consummate capabilities across all industries and business functions we are able to offer a continuum of services to our customers: strategic advisory, leadership, tailored solutions, including those in enterprise mobility, process automation, data analytics, web &amp; mobile app, cloud and custom application development (SaaS, Web and On Premise).</p><p>We have assisted many of the world’s top management teams in surpassing the competition by providing long lasting IT solutions. Our customers have outperformed Standard &amp; Poor’s by nearly four to one, majorly impacting ROIs, creating lasting economic value, and reducing costs. With multiple locations &amp; cutting edge technological experience, Shiro Technologies delivers a new realm of possibilities that are poised for serious growth in today and tomorrow’s world.</p><p>Shiro Technologies was founded in 2002, an entrepreneurial spirited, ambitious young engineer started a small telecom technology firm providing technology advices for startups. From the beginning, Shiro Technologies took on great challenges and huge risks, requiring years of dedication, relentless effort, and patience. Project after project, client after client, Shiro Technologies has become a dynamic force in today’s competitive market. The decision to go against their grain of conventional business models bought huge gains for us and our clients. Headquartered In Addison, Texas, Shiro Technologies has a growing global presence by opening additional offices in India. Shiro Technologies, is an organization that promotes and supports innovation, understands the impressiveness of nurturing ideas, keeping an open dialogue for new approaches, finding solutions that fit, and building collaborative partnerships to help clients turn into high-performing significant businesses.</p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>All your information will be kept confidential according to EEO guidelines.</p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "8abf36f0-ba96-4886-a908-7bc344703d5d",
    "active": true,
    "company": {
      "name": "SHIRO Technologies Inc",
      "identifier": "SHIROTechnologiesInc"
    },
    "creator": {
      "name": "Chandra Shekar",
      "avatarUrl": ""
    },
    "jobAdId": "9a4ecec0-d8e6-4353-bc3f-ccf6af509c79",
    "applyUrl": "https://jobs.smartrecruiters.com/SHIROTechnologiesInc/744000003690110-data-analyst-production-support-dwh-ops-?oga=true",
    "function": {
      "id": "information_technology",
      "label": "Information Technology"
    },
    "industry": {
      "id": "computer_software",
      "label": "Computer Software"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Addison",
      "hybrid": false,
      "region": "TX",
      "remote": false,
      "address": "5080 Spectrum Drive",
      "country": "us",
      "latitude": "32.95454340000001",
      "longitude": "-96.82354629999999",
      "postalCode": "75001",
      "fullLocation": "Addison, TX, United States"
    },
    "refNumber": "REF216T",
    "postingUrl": "https://jobs.smartrecruiters.com/SHIROTechnologiesInc/744000003690110-data-analyst-production-support-dwh-ops-",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "COUNTRY",
        "valueId": "us",
        "fieldLabel": "Country/Region",
        "valueLabel": "United States"
      },
      {
        "fieldId": "58b7e8c4e4b09a6d37a0d61f",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "SHIRO Technologies Inc"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/SHIROTechnologiesInc/publication/7b30e438-6fa1-4440-b954-5afc3257e40c?dcr_ci=SHIROTechnologiesInc",
    "defaultJobAd": true,
    "releasedDate": "2024-07-30T19:33:59.907Z",
    "experienceLevel": {
      "id": "mid_senior_level",
      "label": "Mid-Senior Level"
    },
    "typeOfEmployment": {
      "id": "contract",
      "label": "Contract"
    }
  },
  "company": {
    "name": "SHIRO Technologies Inc",
    "identifier": "SHIROTechnologiesInc"
  },
  "creator": {
    "name": "Chandra Shekar"
  },
  "jobAdId": "9a4ecec0-d8e6-4353-bc3f-ccf6af509c79",
  "function": {
    "id": "information_technology",
    "label": "Information Technology"
  },
  "industry": {
    "id": "computer_software",
    "label": "Computer Software"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Addison",
    "hybrid": false,
    "region": "TX",
    "remote": false,
    "address": "5080 Spectrum Drive",
    "country": "us",
    "latitude": "32.95454340000001",
    "longitude": "-96.82354629999999",
    "postalCode": "75001",
    "fullLocation": "Addison, TX, United States"
  },
  "refNumber": "REF216T",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    },
    {
      "fieldId": "58b7e8c4e4b09a6d37a0d61f",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "SHIRO Technologies Inc"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2024-07-30T19:33:59.907Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "mid_senior_level",
    "label": "Mid-Senior Level"
  },
  "typeOfEmployment": {
    "id": "contract",
    "label": "Contract"
  }
}