The #1 Site for Finance Jobs - search all Finance jobs.
Mfz6r76k64ryng4hsmb

Senior ETL Business Data Analyst (Insurance)

Description


JOB DESCRIPTION:

Must-Have Primary Skill
Data Analyst-SQL
Business Consulting-ETL Processes
Business Consulting-Data Management

Day to Day job Duties:
* Outstanding Business English speaking and writing skills
* The Business Data Analyst, reporting to the ETL Architect / Sr. Data Migration Architect (On-Shore) across both workstreams of a System Migration project from existing Oracle to SQL Server 2018. The ETL tool is 2018 SQL Server Data Tools
* The project ETL Design includes scripting to auto-generate the interim target data model for a custom ~1000 tables Claims Module of a proprietary large insurance management system. Unusual challenges with Data Movement Verification and Metadata Management are anticipated and the Position will be responsible to collect and interpret Business Data Usage and Quality Requirements to the technical team through the project life cycle. All will be recorded in Dairy fashion future Break / Fix / Enhancements
* Documentation Responsibilities include: Maintenance of the various ETL Support Catalogues for all Subject Areas, possibly within SQL Server Data Tools
* Some amount of interaction with existing system users to assist in design of Business-Critical Queries to be used for Referential Integrity validation and Summary Reporting.
* Business Requirements for Cross Functional queries which will be created to mask the significant amount of Personal Data to provide subsets of sanitized Test Data for the Off-Shore ETL and Application teams at a defined service level.
* All published documentation and Team Communications
* The Position will contribute to the High Level Design and the Detail Design for Data Management of all Subject Areas which will include full Data Lineage, as well as the Build and Test Phases

Must Have Skills:
* 6+ Insurance industry experience with installs of Insurance management systems or similar financial background
* 4+ years of ETL-related Business Analysis experience across the Financial and Insurance industries in similar positions
* 4+ years recent testing support experience working with User Representatives and Testing Managers to validate / troubleshoot the New Administration System from the Data Perspective

Requirements

 

Job Snapshot

Location US-NC-Winston-Salem
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Information Technology
Apply

Company Overview

AIC (part of ACS Group)

Analysts International Corporation (AIC) is an IT services firm fully dedicated to the success and satisfaction of its customers. From IT staffing to project-based solutions, AIC provides a broad range of services designed to help businesses and government agencies drive value, control costs and deliver on the promise of a more efficient and productive enterprise. Learn More

Contact Information

US-NC-Winston-Salem
AIC
Icon-social-facebookIcon-social-linkedinIcon-social-twitter
Snapshot
AIC (part of ACS Group)
Company:
US-NC-Winston-Salem
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Information Technology
Store Type:

Description


JOB DESCRIPTION:

Must-Have Primary Skill
Data Analyst-SQL
Business Consulting-ETL Processes
Business Consulting-Data Management

Day to Day job Duties:
* Outstanding Business English speaking and writing skills
* The Business Data Analyst, reporting to the ETL Architect / Sr. Data Migration Architect (On-Shore) across both workstreams of a System Migration project from existing Oracle to SQL Server 2018. The ETL tool is 2018 SQL Server Data Tools
* The project ETL Design includes scripting to auto-generate the interim target data model for a custom ~1000 tables Claims Module of a proprietary large insurance management system. Unusual challenges with Data Movement Verification and Metadata Management are anticipated and the Position will be responsible to collect and interpret Business Data Usage and Quality Requirements to the technical team through the project life cycle. All will be recorded in Dairy fashion future Break / Fix / Enhancements
* Documentation Responsibilities include: Maintenance of the various ETL Support Catalogues for all Subject Areas, possibly within SQL Server Data Tools
* Some amount of interaction with existing system users to assist in design of Business-Critical Queries to be used for Referential Integrity validation and Summary Reporting.
* Business Requirements for Cross Functional queries which will be created to mask the significant amount of Personal Data to provide subsets of sanitized Test Data for the Off-Shore ETL and Application teams at a defined service level.
* All published documentation and Team Communications
* The Position will contribute to the High Level Design and the Detail Design for Data Management of all Subject Areas which will include full Data Lineage, as well as the Build and Test Phases

Must Have Skills:
* 6+ Insurance industry experience with installs of Insurance management systems or similar financial background
* 4+ years of ETL-related Business Analysis experience across the Financial and Insurance industries in similar positions
* 4+ years recent testing support experience working with User Representatives and Testing Managers to validate / troubleshoot the New Administration System from the Data Perspective

Requirements

 
MoneyJobs Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using moneyjobs.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Senior ETL Business Data Analyst (Insurance) Apply now