ETL/ELT Integration Development Lead_Remote

PCRecruiter - Recruitment Software & Applicant Tracking System; United States; Remote; USD 100,000 - 130,000; Full time

Job summary

Une entreprise de logiciels de recrutement recherche un leader pour le développement d'intégration ETL/ELT. Vous travaillerez avec des clients du secteur de l'assurance pour concevoir des solutions analytiques, superviser des projets d'intégration de données et diriger des équipes. Des compétences approfondies en ETL/ELT, ainsi qu'une expérience avérée dans la direction de projets d'intégration, sont essentielles.

Qualifications

• 3-5 ans d'expérience en projets d'intégration d'assurance.
• 6+ ans d'expérience pratique en conception de modèles d'intégration.
• Capacité à diriger 3+ personnes à travers le cycle de vie du développement.

Responsibilities

• Diriger les exigences d'intégration ETL/ELT et planification de la construction.
• Créer des documents d'intégration technique et commercial.
• Assurer la qualité pour répondre aux exigences commerciales.

Skills

ETL

ELT

data profiling

data cleansing

communication

organizational skills

time management

Tools

SSIS

Azure Data Factory

JSON

XML

Job description

Job Title: ETL/ELT Integration Development LEAD

Job Description:

This person will work with Insurance clients, and our Business and Data Analysts to gather data and analytics integration requirements, and then design and develop solutions to provide business insights and manage business performance. The person will be responsible for LEADING the ETL/ELT integration analysis, design and build for data warehouses, operational data stores, data lakes, data marts, and extending and implementing our inhouse data and analytics platform.

Summary of Duties & Responsibilities:

• Lead ETL and ELT integration requirements, design and build planning and execution
• Create business and technical integration documents from which solutions will be designed.
• Help design new solutions by analyzing and interpreting clients' requirements.
• Perform the typical Capture, Ingest, Store, Validation, Analysis and Visualization processes.
• Lead data mapping between source and target systems and perform ETL or ELT processes.
• Responsible for developing and maintaining batch and real-time integration patterns.

• Design and development of the end-to-end error logging, checking and correction process
• Performance tuning the integration process.
• Defining and developing the integration process for conversionand historical load.

• Will have quality assurance responsibilities to ensure the solution meets business requirements.
• Lead/facilitate client and team meetings.
• Handle complex issues and problems and engage higher-level staff on risks and issues
• Acts a subject matter expert on integration methods, processes, and patterns

Minimum Qualifications/Experience/Attributes:

• Must have 3-5 Years Insurance (P&C or Life) integration project experience
• 6+ years of hands-on ETL experience designing integration patterns for data lakes, data warehouse, ODS, & data marts
• 6+ years SSIS, Azure Data Factory, JSON, XML Dataflow, experience.
• 6+ years of data profiling and data cleansing
• Strong communication, organizational, interpersonal and time management skills
• Experience leading 3+ others through the full development life-cycle

Annual Salary: MARKET based