Senior ETL Developer (Insurance Industry / 100% Remote)

Lead ETL Data Integration DevelopmentThis 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.

Primary Responsibilities:Project Lead of ETL and ELT integration requirements, design, build, planning and execution of complex Insurance-based projects.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 processPerformance tuning the integration process.Defining and developing the integration process for conversion and historical load.Will have quality assurance responsibilities to ensure the solution meets business requirements.Handle complex issues and problems and engage higher-level staff on risks and issuesActs a subject matter expert on integration methods, processes, and patterns

Minimum Technical Skills Required:3-5 Years Insurance (P&C or Life) integration project experience, required6+ years of hands-on ETL experience designing integration patterns for data lakes, data warehouse, ODS, & data marts6+ years SSIS, Azure Data Factory, JSON, XML Dataflow, experience.6+ years of data profiling and data cleansingStrong communication, organizational, interpersonal and time management skillsExperience leading 3+ others through the full development life-cycle

Key Skills

• Azure