Senior Data Analyst - Tekfortune Inc.

Boston, MA

About the Job

Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world s leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the future of work. To support the active project demands and skills gaps, our staffing experts can help you find the best job for you.

Role: Senior Data Analyst
Location: Multiple Locations
Duration: 6+ Months
Required Skills: Data analysis, OLTP, ETL, Guidewire
Job Description:

Preferred/Desired skills

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.

Please share the Detailed Job Description

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.
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.
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.

For more information and other jobs available please contact our recruitment team at careers@tekfortune.com. To view all the jobs available in the USA and Asia please visit our website at https://www.tekfortune.com/careers/.

Source : Tekfortune Inc.