ETL Developer, Lead

Morristown, NJ 07960

Posted: 03/10/2023 Employment Type: Perm Industry: IT Job Number: 240133

Job Description

Job Description


Key Objectives/Responsibilities: 
  • The ETL Lead is a hands-on expert for supporting a team consisting of ETL developers and Data Engineers who support the Data Warehouse (i.e. EDW), Data Marts, and Data Lake
  • This will be 50% hands-on and 50% tech lead role

·        A strong understanding of common data integration challenges within the insurance industry, as well as the best practice technical approaches & solutions available through data integration, data warehouse, and data lake technologies

·        Ability to lead by example, having worked as a technical build resource

·        Experience in how technology solutions can enable the business transformation
  • Incorporate and implement ETL/ELT best practices within the group
  • Identify and recommend new ETL/ELT features/tools and design and develop the optimal solution to address business requirements
  • Responsible for the development and maintenance of ETL/ELT Processes
  • Translate functional requirements into technical specifications and solutions
  • Perform ad hoc analysis using SQL to extract data sets
  • Research innovative technologies and provide ideas for technological or workflow/process improvements
  • Identifies opportunities to re-engineer existing solutions to utilize technology better, optimize performance, and simplify support
  • Analyze current processes to determine or update Key Performance Metrics
  • Identify, manage, and document processes; review and coordinate testing, verify counts and ensure accuracy
  • Mentor and support team members on best practices
  • Identify and incorporate automation into our existing and new processes
  • Perform design review to ensure the solution will meet future growth and business requirements 
  • Work closely with BA, Architects, and QA Teams to execute unit testing, support integration testing, and regression testing for all business processes
  • Create, configure, test, deploy and maintain jobs for inbound and outbound processing
  • Develop new or improve the existing ETL solutions as the company & data grows
  • Incorporate CI/CD best practices within processes

  • Knowledge of the Property & Casualty Insurance industry is a plus
  • Ability to recognize past issue patterns and apply them to the existing problem-resolution process
  • Self-motivated, team player with the ability to work and manage resources in different regions

·        Ability to lead the ETL development team (onshore, nearshore, and offshore) in the implementation of an on-premise and cross-platform cloud data integration solution
  • Understanding of SSIS, SQL Server. SQL, relational database, etc. - 3 to 5 years 
  • 5+ years SSIS ETL experience
  • Excellent Analytical, problem-solving, written, and oral communication skills
  • Experience with Azure or cloud technology - 0-2 years - good to have
  • Experience with Snowflake - 0-2 years - good to have
  • Comfortable working with large data sets
  • Organized with Strong written and Verbal communication skills
  • Familiar with Jira, Confluence, and Agile Processes

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs: