Technical Lead-AWS/ETL

Novalink Solutions LLC•Raleigh, NC

19h

About The Position

We are seeking a Technical Lead to support the PM and Technical Project Manager by handling technical responsibilities across multiple pipelines involved in the data modernization initiative for the Division of Public Health. This role involves providing expertise and guidance to ensure the successful execution of technical aspects within the project. The Technical Lead will provide guidance and mentorship to developers, perform thorough code reviews, and promote a collaborative and supportive team environment. They will ensure the team adheres to the project schedule and timeline, maintains high-quality standards, and produces code that is both reliable and efficient. This role will serve as the intermediary between developers, product managers, and stakeholders, effectively translating requirements into clear technical tasks. The Technical Lead will also implement best practices and comprehensive documentation to enhance overall efficiency and streamline workflows.

Requirements

Proficient in using various AWS services (e.g., VPC, EC2, S3, Lambda, ECS, EKS, RDS, API Gateway, Glue Crawlers, Athena) to build and manage cloud environments.
Experience leading and mentoring technical teams.
Experience in modernizing applications, including refactoring, migration, and cloud-native development.
Knowledge of modern database technologies and strategies for migrating and modernizing database systems.
Experience working with creating AWS ETL jobs, data pipelines with high volumes of data.
Experience with DevOps practices and automation tools.
Experience in software development with hands-on skills in Java - strong Java, J2EE, Java Spring framework & hibernate technology.
Strong communication and collaboration skills to work with cross-functional teams, including developers, business analysts, and stakeholders.

Nice To Haves

Experience in modernizing legacy applications, which should include refactoring/migrating in-house legacy applications to the cloud environment.
Proficient in utilizing AWS services and related components towards building enterprise level Data Lakes.
Experience working with any transactional or RDMS databases.
SQL - Writing Complex Queries, understanding Database Relationships, debugging and performance tuning.
ETL tools - Hands-on experience with cloud-based tool.
Understanding data modeling.
Knowledge / experience using any ETL tools, experience with data analytics using PowerBI or AWS QuickSight etc. is a plus.
Must have experience/familiar with Agile/Scrum Framework environments.
Experience with data analytics, business intelligence solutions (like Power BI or AWS QuickSight).
AWS Certification.
State Government experience.

Responsibilities

Provide guidance and mentorship to developers.
Support project manager and technical project manager by handling technical responsibilities across multiple pipelines.
Collaborate with stakeholders to collect requirements and suggest effective modernization strategies.
Support teams in designing, developing, and testing Java-based, cloud-native applications and backend systems.
Help teams design, build, and maintain ETL pipelines.
Assist teams in analyzing data models and business requirements.
Perform data validation by querying the database to ensure data is accurately inserted, updated, and deleted, maintaining data integrity.
Aid teams in designing, creating, and executing test cases.
Support teams in validating back-end logic and data processing that may not be immediately visible through the user interface.
Collaborate closely with developers and business analysts to understand data needs and guarantee thorough test coverage.
Assist teams in using AWS services within application architecture.
Help teams develop, test, debug, and deliver projects on time using the best tools and practices.
Assist teams with code reviews, enforce security best practices, and maintain clean, efficient code.
Support monitoring of application performance and optimize for cost, security, and reliability.
Identify, analyze, and resolve technical issues and challenges.
Ensure compliance with standards and best practices.
Work with product managers, business stakeholders, and team members to refine requirements and deliver solutions.