ETL Developer

PingWind; United States; On-site; USD 92,000 - 128,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

401k with matching

Education assistance

Job summary

PingWind is seeking an ETL Developer to join our team supporting the Department of Veterans Affairs. This fully remote role focuses on data integrity, ETL design, and enterprise analytics across multiple sources and a data warehouse.

The ideal candidate brings 5 years of relevant experience or 8 years with a degree, plus strong skills in SharePoint, Power BI, SSIS, and SQL Server, and excellent communication within cross-functional teams.

Qualifications

• Bachelor's degree in computer science, engineering or related technical discipline.
• 5 years relevant experience; degree may be substituted for 8 years experience.
• Proficient with SharePoint, Microsoft Teams, PowerApps, and Power BI.
• Proficient with Microsoft SSIS ETL Tools.
• Proficient with Microsoft SQL Server.

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 AI capabilities.
• Design robust ETL processes for data integration into applications or the data warehouse.
• Coordinate across workstreams to ensure Scrum teams are properly staffed with resources; peer review code.
• Perform data integrity checks throughout ETL, run daily SQL validation scripts, and ensure reports have traceability of underlying data.
• Develop and validate ETL workflows and store packages in GitHub; monitor performance and availability of ETL processes.

Skills

SharePoint

PowerApps

Power BI

SQL

Strong communication

Cross-functional collaboration

Data analysis

Education

Bachelor's Degree in Computer Science or related

Tools

Microsoft SSIS

Microsoft SQL Server

Job description

Location: Remote

Required Clearance: Public Trust

Required Certifications: N/A

Required Education: Bachelor's Degree in Information Technology or related discipline

Required Experience: 5 years of relevant experience; Degree may be substituted for 8 years of experience

Description

PingWind is seeking an ETL Developer to join our team supporting the Department of Veterans Affairs. This is a fully remote position responsible for data integrity, including management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for enterprise applications.

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

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
• Proficient with Microsoft SSIS ETL Tools
• Proficient with Microsoft SQL Server
• 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

Desired Qualifications

• Previous experience with Tableau, OBIEE, and ETL
• Experience with Data Bricks
• Experience with Azure Cloud

About PingWind

PingWind is focused on delivering outstanding services to the federal government. We have extensive experience in the fields of cybersecurity, development, IT infrastructure, supply chain management and other professional services such as system design and continuous improvement. PingWind is an SBA certified Service-Disabled Veteran-Owned Small Business (SDVOSB) with offices in Northern Virginia and Huntsville AL.

www.PingWind.com

Our benefits include:

• Eleven Federal Holidays
• Paid Time Off accrued each pay period
• Parental Leave
• Three medical plan choices with generous employer contribution
• Dental and Vision Insurance
• Company paid Short-Term and Long-Term Disability
• Company paid Life and AD&D Insurance
• 401k with competitive matching and vesting schedule
• Continuing education assistance
• Short Term / Long Term Disability & Life Insurance
• Medical, Dependent Care and Commuter Flexible Spending Accounts
• Employee Assistance Program
• Wellness benefits include Calm Health app and WellHub gym subsidy (formerly GymPass)
• 529 College Savings Plan
• Legal Insurance
• Pet Insurance

Salary Range

$92k-$128K

The pay range for this job is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) job responsibilities, education, certifications, experience, as well as internal equity mapping and alignment with market data, or other applicable laws.

Veterans are encouraged to apply

PingWind, Inc. does not discriminate in employment opportunities, terms, and conditions of employment, or practices on the basis of race, age, gender, religious or political beliefs, national origin or heritage, disability, sexual orientation, or any characteristic protected by law.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.