ETL Developer, Lead
Company: Softworld
Location: Mine Hill
Posted on: March 18, 2023
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
processesQualifications/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
Desired Skills and Experience
ETL Developer, SSIS Developer, SSIS, SSIS Packages, Data Warehouse,
Azure, Snowflake. Lead ETL Developer, ETL Lead, SQL Server
Integration Services, SSIS, Insurance, Financial, SQL, SQL Server,
SSIS, ETL, Tech Lead, ETL Lead
Keywords: Softworld, Newark , ETL Developer, Lead, IT / Software / Systems , Mine Hill, New Jersey
Didn't find what you're looking for? Search again!
Loading more jobs...