WSP · 12 hours ago
Assistant Team Leader/Data Engineer
Valhalla, NY
Full-time
Onsite
Mid Level
$91K/yr - $130K/yr
3+ years expWSP is currently seeking an Assistant Team Leader/Data Engineer for their Valhalla, NY office. The role involves collaborating on bridge inspection projects, performing inspections, and managing data engineering tasks including ELT/ETL processes.
Information Technology & Services
Responsibilities
Review previous inspection reports and assist in planning of field operations
Perform inspection work and compile reports under the direction of the Team Leader
Receive directions from Project Manager and other senior staff
Work collaboratively with other engineers, professionals, and infrastructure authorities on Federal, State, regional, local and privately funded improvement and development projects
Exercise responsible and ethical decision-making regarding company funds, resources and conduct, and adhere to WSP’s Code of Conduct and related policies and procedures
Perform additional responsibilities as required by business needs
Extract, load, and Transform (ELT/ETL) data from various sources, including on-premises and cloud-based systems, APIs, databases, and files
Develop APIs as needed to transform data in required format from various sources of bridge design and inspection
Design and develop CI/CD processes that ensure high availability and agility
Qualification
Required
Bachelor's Degree in Structural or Civil Engineering, or closely related discipline
3 to 5 years of relevant post education experience in design, construction, inspection, or other bridge engineering and related data engineering and management
Engineer in Training Certification
Strong understanding of data engineering concepts, ELT/ETL principles, and data modeling with experience in DevOps, Git Repos, and CI/CD pipelines for code deployment
Solid programming skills in languages such as Python, Pyspark, and SQL, functional knowledge of Microsoft Power BI
Excellent verbal, written and interpersonal communication skills
Physically capable of performing continuous field work, including working at heights and in close quarters, climbing, carrying ladders and gear, working in adverse weather conditions, etc
Valid, unrestricted driver license. Must successfully complete and pass WSP's Motor Vehicle screening
Effective self-leadership with attention to detail, results orientation, and managing multiple priorities in a dynamic work environment
Proven track record of upholding workplace safety and ability to abide by WSP's health, safety and drug/alcohol and harassment policies
Ability to work schedules conducive to project-specific requirements that may extend beyond the typical workweek
Preferred
Master's Degree in Engineering
Essential Professional Licensure/Certification
40-Hour OSHA Health & Safety Training (HAZWOPER) (29 CFR 1910.120) preferred
Experience with Azure Synapse Analytics, Azure Data Factory, Azure Data Lake Store, Microsoft Purview, and Power BI
Experience with major database platforms including Oracle, SQL Server as well as Cloud databases and NOSQL Databases
Benefits
Coverage related to medical, dental, vision, disability, and life
Retirement savings
Paid sick leave
Paid vacation (or other personal time)
Paid parental leave
Paid time off for purposes of bereavement, voting, and/or attendance at naturalization proceedings
Company
WSP
We are one of the world’s leading professional services firms, uniting our engineering, advisory and science-based expertise to shape communities to advance humanity.
Founded in 2011New York, New York, USA
10001+ employees
H1B Sponsorship
WSP has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (263)
2024 (207)
2023 (152)
2022 (185)
2021 (119)
2020 (130)
Funding
Current Stage
Late StageTotal Funding
$40.25MKey Investors
OneWest Bank
2013-09-02Corporate Round· $40.25M
Leadership Team
Michael Winterbottom
Vice President, RUC Operations & Analytics
Christopher Uckotter
CE1, SPECIALIST, INSPECTOR II
Recent News
2023-05-11
The Globe and Mail
2023-03-10
The Globe and Mail
2022-08-16
Company data provided by crunchbase