Data Analyst - Production Support; DWH Ops

Data Analyst - Production Support (DWH Ops)

Contract

The 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 the Client maintain the enterprise data warehouse architecture. The architecture will measure performance in all aspects of the organization’s operations.

• Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
• Create source‑to‑target mapping documents to capture additional application data elements.
• Load the source‑to‑target mapping documents from source systems into the enterprise data warehouse.
• Collaborate with the ETL team to ensure the source‑to‑target mapping documents are in correct ETL code.
• Ensure the ETL code aligns with STM requirements.
• Perform data validation to ensure correct data movement into the enterprise data warehouse architecture.
• Consult with reporting teams to develop a general understanding for any identified variances – between the enterprise data warehouse and source system applications.

• Proven 8+ years’ experience of data analysis within an enterprise data warehouse.
• Possess 4 years of Policy & Claims Insurance subject‑matter expertise.
• Advanced level SQL knowledge.
• Concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
• Capability to create and tune semantic layer reporting views.
• Facilitate data discovery sessions with business subject‑matter experts.
• Knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
• Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS‑RI & SAP FS‑CD applications is a plus.

B.S. Degree in Computer Information Science, Information Management, or Statistics.

All your information will be kept confidential according to EEO guidelines.