Lead Software Engineer

Lead Software Engineer

ADP Technology Services, Inc. is hiring Lead Software Engineers at our Roseland, New Jersey location.

• Build high‑performing teams that thrive, sharing knowledge and motivating others.
• Continuously learn new technologies and processes, attending conferences and using training resources.
• Create results, proactively solving issues and delivering polished products.
• Collaborate with associates to share ideas and keep up with evolving technologies.
• Handle varied work, from coordinating with remote team members to addressing ad‑hoc requests.
• Present to senior leaders, product owners, and peers with a compelling voice and executive presence.
• Solve inevitable challenges by seeking effective solutions.
• Engineer and deliver end‑to‑end data solutions using IDMC, Databricks and Denodo.
• Analyze large data sets, design, build, and maintain reliable, scalable ETL pipelines.
• Administer, troubleshoot and manage IDMC, Address Doctor and Denodo environments.
• Create automations to replace manual tasks and write LINUX and Python scripts for ETL enhancements.
• Collaborate with business users to acquire and analyze data to meet business needs.
• Investigate data issues by tracing data flows and writing SQL queries.
• Support data load processes and participate in Agile ceremonies and continuous improvement.

• Bachelor’s degree in Computer Science, Engineering, Information Systems or related field plus six years of related experience (Master’s degree with four years of experience accepted).
• At least three years of experience designing and developing ETL pipelines, data flows and control flows using Python, Informatica IDMC, Informatica Power Center and related components.
• Experience creating data quality solutions, administering Informatica, IDMC and Denodo environments, writing and tuning complex SQL queries in Oracle and SQL Server.
• Knowledge of data modeling techniques such as dimensional and hierarchical modeling, star schemas.
• Proficiency writing Python and UNIX shell scripts to automate manual processes.
• Experience with Salesforce data and APIs, including bulk APIs and Change Data Capture.
• Adept at troubleshooting and identifying root causes of data issues throughout the data lifecycle.

• Medical, Dental, Vision, Life Insurance.
• Matched Retirement Savings.
• Wellness Program, Short‑ and Long‑Term Disability.
• Charitable Contribution Match, Paid Volunteer Time Off.
• Holidays, Personal Days & Vacation.