ETL Developer at Pingwind | Torre

ETL Developer

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: To be defined

Compensation
USD92k - 128k/year
location_on
Remote (anywhere)
Shared by
Emma of Torre.ai
about 2 months ago

Responsibilities


DescriptionPingWind 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.ResponsibilitiesServe 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) capabilitiesResponsible for overall technical execution of all activities performed by the ETL Developers who are matrixed into Scrum TeamsDesign robust ETL processes that facilitate seamless data integration from multiple sources into applications or the data warehouseCoordinate across workstreams to ensure Scrum teams are properly staffed with the necessary resourcesPeer review code written by other ETL DevelopersEnsure all team members are trained on best practices and common coding guidelines, promoting knowledge sharing across the teamPerform 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 jobsTrack 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 reportDevelop and validate ETL workflows and store the resulting ETL packages in GitHubTrack, 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 usersRequirementsBachelor's Degree in computer science, engineering or technical discipline5 years relevant experience.Proficient working with SharePoint, Microsoft Teams, PowerApps, and Power BIProficient with Microsoft SSIS ETL ToolsProficient with Microsoft SQL ServerOutstanding written and verbal communication skillsExpert communication and client management skillsSelf-motivated, detail-oriented, and organizedStrong research, analytical, and problem-solving skillsFlexible, able to adapt to different customer groups and expectationsExperience working in and with cross-functional teamsOutcome-oriented approach focused on delivering value to end users backed by measurable, data-driven resultsU.S. Citizenship; Ability to obtain Public Trust clearanceDesired QualificationsPrevious experience with Tableau, OBIEE, and ETLExperience with Data BricksExperience with Azure CloudAbout PingWindPingWind 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.Our benefits include:Eleven Federal HolidaysPaid Time Off accrued each pay periodParental LeaveThree medical plan choices with generous employer contributionDental and Vision InsuranceCompany paid Short-Term and Long-Term DisabilityCompany paid Life and AD&D Insurance401k with competitive matching and vesting scheduleContinuing education assistanceShort Term / Long Term Disability & Life InsuranceMedical, Dependent Care and Commuter Flexible Spending AccountsEmployee Assistance ProgramWellness benefits include Calm Health app and WellHub gym subsidy (formerly GymPass)529 College Savings PlanLegal InsurancePet Insurance