ETL Developer

Summary

Join PingWind as an ETL Developer to support the Department of Veterans Affairs in a fully remote position. You will be responsible for data integrity, including management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for enterprise applications. This role involves designing robust ETL processes, coordinating across workstreams, ensuring team training, performing data integrity checks, and tracking process efficiency. You will also develop and validate ETL workflows, track deviations from target thresholds, and ensure solutions are properly configured. The position requires a Bachelor's degree, 5 years of relevant experience, and proficiency with various tools. PingWind offers a comprehensive benefits package.

Requirements

• Bachelor's Degree in computer science, engineering or technical discipline
• 5 years relevant experience
• Proficient working with SharePoint, Microsoft Teams, PowerApps, and Power BI
• Outstanding written and verbal communication skills
• Expert communication and client management skills
• Self-motivated, detail-oriented, and organized
• Strong research, analytical, and problem-solving skills
• Flexible, able to adapt to different customer groups and expectations
• Experience working in and with cross-functional teams
• Outcome-oriented approach focused on delivering value to end users backed by measurable, data-driven results
• U.S. Citizenship; Ability to obtain Public Trust clearance

Responsibilities

• Serve as the ETL Developer supporting sustainment services for VA, migration of large-scale systems to the cloud, and delivery of advanced analytics, including Artificial Intelligence (AI) capabilities
• Responsible for overall technical execution of all activities performed by the ETL Developers who are matrixed into Scrum Teams
• Design robust ETL processes that facilitate seamless data integration from multiple sources into applications or the data warehouse
• Coordinate across workstreams to ensure Scrum teams are properly staffed with the necessary resources
• Peer review code written by other ETL Developers
• Ensure all team members are trained on best practices and common coding guidelines, promoting knowledge sharing across the team
• Perform a robust set of data integrity operations/checks throughout the ETL process (quality control, unit testing, functional testing, and system testing)
• Ensure SQL validation scripts are run daily to check the status and data integrity of the overnight ETL jobs
• Track the efficiency and performance of all automated processes to verify they are operating within defined timelines/service levels and they are producing high-quality/valid reports with traceability of data used to generate each report
• Develop and validate ETL workflows and store the resulting ETL packages in GitHub
• Track, by manual and automated means (i.e., triggers on sensing/logging systems), any notable deviations from target thresholds on availability, server load, disc I/O rates, etc
• Ensure solutions are appropriately configured, available, and accessible for users

Preferred Qualifications

Previous experience with Tableau, OBIEE, and ETL

Benefits

• Paid Federal Holidays
• Robust Health & Dental Insurance Options
• 401k with matching
• Paid vacation and sick leave
• Continuing education assistance
• Short Term / Long Term Disability & Life Insurance
• Employee Assistance Program through Sun Life Financial EAP Guidance Resources