Production Support - BI Reporting Analyst

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 BI Reporting Analyst in New York NY. This role must work 3 days a week onsite in: 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. Summary: The role is a handson position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help Company maintain the enterprise data warehouse architecture. Furthermore the data warehouse architecture will measure performance in all aspects of the organization s operations.

Responsibilities:

• Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
• Create sourcetotarget mapping documents to capture additional application data elements.
• Load the sourcetotarget mapping documents from source systems into the enterprise data warehouse.
• Collaborate with the ETL team to ensure the sourcetotarget mapping documents are in correct ETL code.
• Ensure the ETL code align with STM requirements * Perform data validation to insure 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.

Required Skills : * Proven 3 years of experience of data analysis within an enterprise data warehouse * Possess 2 years of Policy and Claims Insurance subjectmatter expertise * Advanced level SQL knowledge * Possess optimal knowledge for concepts and frameworks for Data Warehousing ETL and BI Architectures * Proven knowledge of RDBMS platforms (e.g. SQL Server DB2) with experience in generating DDL * Possess knowledge of Guidewire Policy Center Guidewire Claims Center SAP FSRI and SAP FSCD applications with their data is considered a plus * Strong interpersonal skills including both written and verbal communication skills * Strong organizational skills and analysis skills * Capable of creating and tuning Semantic layer Reporting Views * Able to facilitate data discovery sessions which will include an audience of business subjectmatter experts * Possess the ability to work as part of a team
Rank :A2
Requested Date :