ETL Developer

ETL Developer

Job Description

Application Development Advisor

This position is responsible for collaborating with Claims and Enrollment, Payment Integrity, and Quality Auditing engineering, infrastructure, and business teams to design, build, and maintain solutions for said business areas. This position will play an integral role as a apart of 1-2 scrum teams, handling software engineering needs under the leadership of a delivery manager. The ideal candidate will be expected to develop subject matter expert (SME) knowledge in a number of various areas that the candidate’s teams own. This role is critical for ensuring the reliability, efficiency, quality, and compliance of our data systems that support critical business operations and decisions. Responsibilities will include:

Design, develop, and maintain scalable and reliable ETL processes using SQL Server Integration Services (SSIS)
Create and optimize complex SQL queries, stored procedures, and functions to support data transformation and business logic
Modify and enhance existing ETL process to improve performance, scalability, and reliability
Perform data manipulation and ensure data quality and integrity across all systems
Work with large-scale data warehousing environments, including experience with Teradata.
Collaborate with cross-functional teams in an agile (Scrum) environment to deliver on data-related projects and initiatives.
Utilize Jira for task management, tracking progress, and reporting on development activities.
Manage and version control code using Git repositories, ensuring best practices for branching, merging, and code reviews.
Troubleshoot and resolve data-related issues in a timely manner.
Provide production support for existing data pipelines and processes, ensuring high availability and performance.
Monitor, modify, and maintain ETL processes within the AWS ecosystem, leveraging services like EC2, Lambda, and CloudWatch.

Required Qualifications:
Bachelors Degree and 4 years in Information Technology or relevant experience OR Technical Certification and/or College Courses and 6 years Information Technology experience OR 8 years Information Technology experience.
ETL expertise: proven experience with SSIS, including designing and building complex ETL packages from the ground up
SQL proficiency: Strong command of SQL, with the ability to write and optimize complex stored procedures, triggers, and queries
Data manipulation: demonstrated ability to manipulate and transform large datasets accurately and efficiently
Agile experience: experience working in an agile development environment, with a solid understanding of Scrum principles and practices
Version control: proficiency with Git repositories for code management
Collaboration tools: Familiarity with Jira for project and issue tracking
TriZetto experience: experience with TriZetto products is highly desirable
Business acumen: understanding of business priorities, industry trends, and market dynamics
Process improvement: ability to simplify and standardize complex concepts and processes
Communication: Excellent oral and written communication skills
Decision-making: ability to prioritize and make trade-off decisions to drive cross-functional execution
Adaptability: ability to introduce and manage change effectively
Teamwork: a strong sense of teamwork and collaboration
Analytical skills: strong analytical and problem-solving abilities, with a proven track record of resolving complex data-related challenges
Organizational skills: highly organized and detail-oriented, with a commitment to delivering high-quality, accurate solutions
AWS knowledge: foundational knowledge of the AWS ecosystem and hands-on experience with EC2, Lambda, and CloudWatch for monitoring and managing data processes

Preferred Qualifications:
Bachelor’s Degree (Computer Science, MIS, or related degrees).
Teradata experience: hands-on experience with the Teradata database platform is highly desirable
Cloud platforms: experience with cloud data platforms such as Azure Data Factory, AWS Glue, or similar services
Data modeling: understanding of data modeling principles and best practices
Communication skills: excellent verbal and written communication skills, with the ability to articulate technical concepts to both technical and non-technical audiences

Notes:
Remote

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.