ETL Developer

Pingwind

United States

Remote

Who this role is best for

Aimed at mid-level ETL developers who have experience with Microsoft tools and can work remotely on federal government projects.

Best fit for

Mid-level ETL developers with strong Microsoft SQL Server and SSIS expertise and a track record of working on federal government contracts.
— “supporting the Department of Veterans Affairs”
Candidates who have managed ETL workflows and are comfortable with peer reviews and cross-team coordination.
— “Peer review code written by other ETL Developers”
Individuals with a background in data validation and testing, who can ensure data quality and traceability in large-scale systems.
— “Perform a robust set of data integrity operations/checks throughout the ETL process”

Things to consider

U.S. citizenship is mandatory due to the Public Trust clearance requirement.
— “U.S. Citizenship; Ability to obtain Public Trust clearance”
The role demands a high level of organization and attention to detail for tracking system performance and deviations.
— “Track, by manual and automated means, any notable deviations from target thresholds”

How to stand out

Highlight your experience with Microsoft SSIS and SQL Server in your resume and interview responses.
— “Proficient with Microsoft SSIS ETL Tools”
Demonstrate your ability to coordinate across workstreams and ensure proper team staffing.
— “Coordinate across workstreams to ensure Scrum teams are properly staffed”
Showcase your track record in delivering data-driven results and ensuring report traceability.
— “Outcome-oriented approach focused on delivering value to end users backed by measurable, data-driven results”
Emphasize your experience with GitHub for ETL package management and version control.
— “Develop and validate ETL workflows and store the resulting ETL packages in GitHub”
Demonstrate your ability to train and share knowledge effectively with team members.
— “Ensure all team members are trained on best practices and common coding guidelines”

Pace · Fast PacedCollaboration · HighAutonomy · MediumDecision Impact · TeamLevel · Mid

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

Design robust ETL processes
Ensure data integrity
Coordinate across workstreams

Typical background

5+ years of relevant experienceBachelor's Degree in computer science, engineering or technical discipline

Skills & requirements

Required

ETL DevelopmentMicrosoft SSISMicrosoft SQL ServerSharepointMicrosoft TeamsPowerappsPower BI

Preferred

TableauObieeData BricksAzure Cloud

Stack & domain

SharepointMicrosoft TeamsPowerappsPower BIMicrosoft SSIS ETL ToolsMicrosoft SQL ServerCommunicationClient ManagementResearchAnalyticalProblem-solvingFlexibleAble To AdaptOutcome-orientedData-drivenETLCloud MigrationAI CapabilitiesData IntegrityData WarehouseEnterprise Applications

About the role

Original posting from Pingwind via Lever

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.

Source: Pingwind careers (Lever)