RICEFW Technologies
Production Support ETL Data Analyst
RICEFW Technologies, New York, New York, us, 10261
Please Note: As of July 22, 2021, our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates that do not have a LinkedIn.
NA has a client that is seeking a Production Support ETL Data Analyst in a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The Production Support ETL Data Analyst will work within IT to help the client maintain the enterprise data warehouse architecture. Furthermore, this person will measure performance in all aspects of the organization s operations. This role will be hybrid - 3 days onsite at one of these offices: Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS.
Responsibilities:Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouseCreate source-to-target mapping documents to capture additional application data elementsLoad the source-to-target mapping documents from source systems into the enterprise data warehouseCollaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL codeEnsure the ETL code align with STM requirementsPerform data validation, to insure correct data movement into the enterprise data warehouse architectureConsult with reporting teams to develop a general understanding for any identified variances - between the enterprise data warehouse and source system applications
Required Skills : * 3 years of experience of data analysis within an enterprise data warehouse * 2 years of Policy and Claims Insurance subject-matter expertise * Advanced level SQL knowledge * Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures * Capable of creating and tuning Semantic layer Reporting Views * Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts * Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL * Strong interpersonal skills, including both written and verbal communication skills * Possess the ability to work as part of a team * Candidate has strong organizational skills and analysis skills * Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI and SAP FS-CD applications with their data is considered a plusRank :A2Requested Date :2024-04-15
NA has a client that is seeking a Production Support ETL Data Analyst in a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The Production Support ETL Data Analyst will work within IT to help the client maintain the enterprise data warehouse architecture. Furthermore, this person will measure performance in all aspects of the organization s operations. This role will be hybrid - 3 days onsite at one of these offices: Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS.
Responsibilities:Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouseCreate source-to-target mapping documents to capture additional application data elementsLoad the source-to-target mapping documents from source systems into the enterprise data warehouseCollaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL codeEnsure the ETL code align with STM requirementsPerform data validation, to insure correct data movement into the enterprise data warehouse architectureConsult with reporting teams to develop a general understanding for any identified variances - between the enterprise data warehouse and source system applications
Required Skills : * 3 years of experience of data analysis within an enterprise data warehouse * 2 years of Policy and Claims Insurance subject-matter expertise * Advanced level SQL knowledge * Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures * Capable of creating and tuning Semantic layer Reporting Views * Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts * Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL * Strong interpersonal skills, including both written and verbal communication skills * Possess the ability to work as part of a team * Candidate has strong organizational skills and analysis skills * Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI and SAP FS-CD applications with their data is considered a plusRank :A2Requested Date :2024-04-15