| Required Business Systems Data Analyst Hybrid Multiple Locations [US Citizen only] at Remote, Remote, USA |
| Email: [email protected] |
| From: Bhavya Nikhil, KPG99 Inc. [email protected] Reply to: [email protected] Hi, Hope you are doing well. Please find the Job description below and let me know your interest. Position : Business Systems/Data Analyst Location : Hybrid 3 days a week onsite from any of the locations listed (No Relocations Please) 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 Duration : 12+ month Mode of interview : Video Job description : This role is now open to any insurance suite Duck Creek, Majesco, Guidewire , etc to name a few. Just looking for a Business Systems Analyst (Not just a BA they need to write the requirements), that has pulled data from any of these suites and mapped them to a data warehouse. This role is top priority over the next few days. Client is asking for resumes, theyre ready to move. Notes: NOT a BA role , working with Business to create BRD or TRD / use cases, instead This is handed to a data analyst or BSA who figures out how to get all the data needed to complete the task; i.e.,how to extract from GW and put in DW; so that the reporting people has the proper data to create reports. Data needs to be pulled directly from OLTP application database, pre-existing reporting database does not exist , need to get raw data from the application NOT ETL people this is different from the previous informatica or production support roles Source to target mapping Extract from Guidewire and land in Data Warehouse P&C Domain *Must have some form of insurance suite experience (Guidewire, Majesco, Duck Creek, Vertafore, Insurity) ROLE SUMMARY The Data Analyst is a hands-on position with a focus on defining the data needs for the enterprise data warehouse. The position will work within IT to help Sompo International create an industry-leading data warehouse architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organizations operations. ROLE RESPONSIBILITIES Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse. Create source (OLTP applications) to target (DWH) 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 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 the data warehouse model / optimal ways to use it. TECHNICAL QUALIFICATIONS Proven 5+ years experience of data analysis extraction of OLTP data within an enterprise data warehouse. Possess 5+ years of Policy & Claims Insurance subject-matter expertise. Candidate has advanced level SQL knowledge. Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures. Candidate is 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. Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus. GENERAL QUALIFICATIONS Candidate has 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. EDUCATION REQUIREMENTS B.S. Degree in Computer Information Science, Information Management, or Statistics. NOTE: - IF I MISSED YOUR CALL EMAIL IS THE BEST WAY TO REACH ME Bhavya Nikhil I Technical Recruiter I KPG99 Inc. Direct (609-236-2769) I [email protected] LinkedIn : https://www.linkedin.com/in/bhavya-nikhil-kujur-418511149/ htt:// www.kpg99.com/ 3240 E State St EXT, Hamilton, Nj 08619 Keywords: cprogramm continuous deployment business analyst business intelligence information technology trade national California Colorado Illinois Kansas Massachusetts Montana New Jersey New York North Carolina North Dakota Pennsylvania Rhode Island Tennessee Texas Required Business Systems Data Analyst Hybrid Multiple Locations [US Citizen only] [email protected] |
| [email protected] View all |
| Tue Aug 06 19:53:00 UTC 2024 |