Integrations Engineer LeadRemote United States

We seek to move the world forward through innovative thinking.

Woolpert is an award-winning, global leader in architecture, engineering, and geospatial services. We blend design excellence with cutting-edge technology to deliver exceptional client value. Our team is passionate about their work and committed to building the next generation of industry leaders, and as a certified Great Place to Work, Woolpert embraces progress and innovation to create limitless opportunities for career growth.

Position Overview

Woolpert is hiring an Integrations Engineer Lead to join our dynamic Cloud Solutions & Interdisciplinary Systems. This position reports to the Technical Subject Mater Expert and is responsible for designing, building, and maintaining scalable data solutions that support business intelligence, analytics, and integration needs. This position combines hands-on data engineering expertise with integration responsibilities, including analysis of customer systems, business processes, and system constraints. The engineer will work closely with stakeholders to ensure data solutions are robust, secure, and aligned with organizational goals. U.S. Citizenship is required for this role.

We are unable to provide visa sponsorship for this position. Applicants must already possess work authorization in the country the job is located.

What You Will Do:

• Collaborate with stakeholders to gather and analyze business data requirements and translate them into scalable technical solutions.
• Design, build, and maintain efficient ETL/ELT pipelines to integrate data from diverse sources, including customer systems.
• Analyze, test, troubleshoot, and document existing customer systems (e.g., CAMA systems, SQL/Oracle/AS400/Informix) and integration points.
• Perform code/configuration changes and scripting related to SQL and other database systems to support integration and transformation processes.
• Develop and maintain data workflows using cloud-based and on-prem services and tools (e.g., AWS, Azure, GCP).
• Knowledge of Python, .NET, or Node.js to support data transformation and integration.
• Conduct extensive database research to understand customer business processes and system constraints.
• Implement data validation, quality checks, and monitoring to ensure data integrity and reliability.
• Document data architecture, pipelines, and integration processes for internal knowledge sharing and compliance.
• Apply security best practices to protect sensitive data and ensure compliance with data governance policies.
• Participate in agile ceremonies including sprint planning, reviews, and retrospectives.
• Apply Data Ops principles to managed workflows and systems
• Mentor junior engineers and collaborate with cross-functional teams including data analysts, and software developers.

What You Will Bring:

• Citizenship (required).
• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 3-5 years of experience in data engineering, integration, or a related technical role.
• Strong experience with SQL and NoSQL databases (e.g., PostgreSQL, MongoDB, Oracle, AS/400).
• Proficiency in building and maintaining ETL/ELT pipelines and working with large-scale data systems.
• Familiarity with cloud data platforms , data services, and data store solutions.
• Proficient in html, Python, .NET, or Node.js for data transformation and scripting.
• Familiarity with integration tools and protocols (e.g., ODBC, RDP/VPN, REST APIs).
• Strong analytical and troubleshooting skills for resolving data synchronization and integration issues.
• Knowledge of data modeling and schema design.
• Experience with business analysis and requirements gathering for data and integration projects.
• Excellent communication, documentation, and collaboration skills.
• Ability to manage multiple priorities and meet project deadlines in a fast-paced environment.
• Contribute to the development and maintenance of CI/CD pipelines for data workflows to support automated testing, deployment, and version control.
• Monitor data pipelines and infrastructure using observability tools to ensure performance, reliability, and uptime.
• Assist in automating data validation, quality checks, and error handling within ETL/ELT processes.
• Collaborate with DevOps and senior data engineers to implement infrastructure as code (IaC) for data environments.
• Participate in incident response and root cause analysis for data pipeline failures or anomalies.
• Maintain documentation for operational procedures, deployment processes, and monitoring configurations.
• Support the implementation of data governance policies through automated controls and audit logging.
• Help optimize pipeline performance and resource usage through profiling and tuning.
• Contribute to continuous improvement efforts by identifying inefficiencies and proposing enhancements to data operations workflows.

Benefits You Will Love

Certified as a Great Place to Work, Woolpert is one of the fastest-growing architecture, engineering, and geospatial companies in the world. With over 75 offices and countless projects around the globe, you'll work on meaningful assignments that improve quality of life around the world. In addition to offering competitive pay, we provide employees with a robust set of unique benefits, including:

• Freedom to Work program: Set your own schedule and location (as appropriate).
• Principal program: Earn the opportunity to become an owner of the firm.
• Flexible paid time off/vacation: Take time off when it makes sense for you and your team.
• Career development: Explore a wide range of learning and growth opportunities within and across industries.
• Health, life, vision, and dental insurance: Cover all your medical bases.
• Paid sick time, retirement plan, fitness reimbursement, pet insurance, identity protection, technology stipend, employee assistance program, and more!

Find out more about what Woolpert has to offer here: http://woolpert.com/about-us/

Woolpert is an equal-opportunity employer. Woolpert is committed to the full inclusion of all individuals. We recruit, train, compensate, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law. You may view more about EEO on our website: Equal-Employment-Opportunity-The-Law.pdf and EEO is the Law Poster Supplement.

Applicants who require an accommodation throughout the application and interview process should request this in advance by contacting askhr@woolpert.com

To all agencies: Please, no phone calls or emails to any employee of Woolpert or any of our subsidiaries about this requisition. All resumes submitted by search firms/employment agencies to any employee at Woolpert via email, the internet, or in any form and/or method will be deemed the sole property of Woolpert, unless such search firms/employment agencies were engaged by Woolpert's Talent Acquisition Team for this requisition and a valid agreement is in place. In the event a candidate who was submitted outside of Woolpert's applicant process is hired, no fee or payment of any kind will be paid.