Senior ETL Developer

Senior ETL Developer

Senior ETL Developer Job Description:

This person leverages the latest ETL/ELT technologies including data pipeline design principles and integration patterns as a basis for supporting analytics and an enterprise data warehouse. Performs complex and senior level data integration pattern design and development activities in support of maintaining both legacy and modern data sourcing. Performs all aspects of the development life cycle. Delivers results through impeccable work ethic and perseverance to seek growth.

Senior ETL Developer Minimum Qualifications:

• Education: Bachelor's or master's degree in computer science, Computer Engineering, IT, or a closely related technical field.
• 6 years of ETL, development, and /or database architectural design experience.
• 2 years of experience with writing and optimizing existing complex SQL queries.
• 2 years of database application development experience
• 3 years of professional experience with database technologies and ETL/ELT tools and scripting.

Senior ETL Developer Preferred Skills:

• Knowledge of modernizing or consolidating legacy siloed databases.
• Strong knowledge across multiple database technologies including both columnar and row indexed relational DBs such as Vertica and SQL Server.
• Knowledge of schema driven design, development, and administration.
• Advanced knowledge of SQL, relational databases, query authoring
• Ability to execute SQL, T-SQL, ETL/ELT scripting, and automation techniques.
• Knowledge of common tools for Linux (logs, piping, redirections, grep, sed, yum)
• Knowledge of Linux scripting (Python, Perl, shell scripts)
• Experience with architecting data modeling and meeting requirements for data visualization or reporting tools
• Knowledge of data concepts around change data capture, and slowly changing dimensions

Senior ETL Developer Key Responsibilities:

• Creates, develops, modifies, and maintains data pipelines for internal and external facing data applications as part of an Agile/SCRUM engineering team.
• Collaborate heavily with data modeling and subject matter experts based on data driven industry best practices.
• Delivers solutions to provide full product life cycle support, collaborating within and across teams, database development and deployment.
• Explores new technologies and development techniques to foster innovation.
• Coordinates and communicates with users, developers, and product owners to design and implement solutions that services the end user.
• Mentors and develops junior engineers through code reviews, co-development and best practices.
• Assembles large and complex data sets that meet business requirements.
• Develops design patterns, standards, documentation, etc. and works with other developers for implementation.
• Provide data integration oversight for Third Party integrations and database core components.