Job Title: ETL/ELT Developer

Job Description:

This person will work with our lead ETL Developers, Architects, and our Business and Data Analysts to design and develop solutions to provide business insights and manage business performance. The person will be responsible for developing 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:

  • Build ETL and ELT integration solutions based on requirements and pre-existing design patterns.
  • Help identify efficiency improvements in existing processes and design patterns.
  • Assist in create business and technical integration documents
  • Help design new solutions by analyzing and interpreting clients' requirements.
  • Perform the typical Capture, Ingest, Store, Validation 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 conversion, and historical load.
  • Will have quality assurance responsibilities to ensure the solution meets business requirements.
  • Participate in client and team meetings.
  • Identify and help resolve complex issues and problems and engage higher-level staff on risks and issues
  • Subject matter expert on integration methods, processes, and patterns

Minimum Qualifications/Experience/Attributes:

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

This person will be a critical member of our team. The position has a great deal of growth opportunity moving into ETL Lead and Architecture positions.

Annual Salary: MARKET based