ETL Developer, Lead

Morristown, NJ 07960

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

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

Qualifications/Skills:
  • 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 
Required
  • 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
Apply with LinkedIn Apply with Facebook Apply with X

Send an email reminder to:

Share This Job:

Related Jobs:

About Morristown, NJ

Discover exciting job opportunities in and around Morristown, New Jersey! This vibrant area, located in Morris County, offers not only a thriving job market but also a rich tapestry of historical landmarks, charming boutiques, and delectable cuisine. From the Morris Museum and Mayo Performing Arts Center to the Morristown National Historical Park and Jockey Hollow, this region is a treasure trove of culture and history. With proximity to major metropolitan areas like New York City and Philadelphia, as well as easy access to outdoor recreation at parks like Lewis Morris County Park, Morristown provides a perfect blend of urban excitement and natural beauty for job seekers to explore. Start your next career adventure in Morristown and experience the unique charm and endless growth opportunities this area has to offer!