1+ months

Lead ETL Developer

Roseland, NJ 07068

ADP Technology Services, Inc. seeks a Lead ETL Developer at our Roseland, NJ location.


We believe people make great companies, not the other way around. Our people make all the difference in delivering innovative HR technologies and solutions that help employees all over the world do their jobs better. The result? We're building the next generation of ADP technologies.


A little about ADP: We are a global leader in HR technology, offering the latest AI and machine learning-enhanced payroll, tax, HR, benefits, and much more. We believe our people make all the difference in cultivating an inclusive, down-to-earth culture that welcomes ideas, encourages innovation, and values belonging. ADP has a deep commitment to diversity, equity, and inclusion as a global Best Places to Work, DiversityInc® Top 50 Company, Best CEO and company for women, LGBTQ+, multicultural talent, and more. Learn more about ADP's commitment on our YouTube channel: http://adp.careers/DEI_Videos


Responsibilities: Participate in relevant aspects of the Software Development Life Cycle (SDLC), including planning, constructions, testing, reviews, and demonstrations. Develop and review software requirements, create design documents, write programs, and package, test, configure, and deploy software. Work with clients, product managers, analysts, architects, and engineers to plan, design, develop, test, and implement information technology solutions. Develop and enhance software programs and data structures that meet business objectives. Design, develop, test, and refine software deliverables. Review and create system, software, and functional design specifications.


Things You'll Do:

  • Define, design and develop new data models and architectures
  • Modify and maintain existing data models and architectures
  • Construct migration strategies between different data models and architectures
  • Generate physical and logical data models
  • Analyze business and technical requirements and collaborate with Subject Matter Experts, Technical Consultants, Solution Architects and Developers to drive the design and development process.
  • Elaborate User Stories.
  • Apply reverse engineering techniques to understand and document existing data stores.
  • Definition of business rules.
  • Document data capture, storage, and manipulation requirements.
  • Specify data currency, accuracy and precision, retention, and security requirements.
  • Model System Interactions.
  • Specify appropriate Integration patterns for the given use story.
  • Conduct stakeholder reviews on all data architecture deliverables.
  • React quickly to emerging customer requirements and technologies. Ability to anticipate future needs and design with reusability in mind.
  • Mediate between project stakeholders.
  • Ensure quality in the production of data assets.
  • Assist in the development of overall project plans and timetables, analysis and identification of intermediate deliverables.
  • Work with the ongoing support teams as needed to resolve production defects.
  • Strong awareness of current web developer APIs and standards.


  • Bachelor's degree in Computer Science, Engineering or related discipline
  • 7+ years of Database development experience and at least 5 years experience in solution/integration/data architecture.
  • Strong Data modeling experience from Conceptual, logical, and physical designs using UML.
  • Expert relational Data Base knowledge
  • Professional proficiency with SQL Server, SQL Server Integration Services (SSIS) and other database management tools
  • Experience in writing complex SQL queries, T SQL programs, procedures, functions and packages is desirable.
  • Experience working with large volumes of data
  • Index plan strategy and administration
  • Experience with Database Administrator roles (backup, restore, security) a plus
  • Hands-on experience designing RESTful APIs including best practices in its design with XML and JSON.
  • Knowledge of industry proven Web service interaction patterns.
  • Experience developing JSON and XML schemas.
  • Demonstrated ability in capturing business requirements, design of data driven systems including analysis, understanding technical specification, feasibility study, and level of effort estimations.
  • Hands-on experience in configuration and connectivity with data sources such as SQL databases, csv files.
  • Experience with other APIs is desirable.
  • Excellent written and verbal communication skills are a must.
  • Experience with agile development is desirable.
  • An ability to listen, to communicate, to influence -- a desire to work with other smart innovators.
  • The ability to self-manage one's own time, work one's own deliverables


  • Have courageous team collaboration. Courage comes from how associates are willing to have difficult conversations, speak up, be an owner, and challenge one another's ideas to find the best solution.
  • Deliver at epic scale. We deliver real user outcomes using strong judgment and good instincts. We're obsessed with the art of achieving simplicity with a focus on client happiness and productivity.
  • Be surrounded by curious learners. We align ourselves with other smart people in an environment where we grow and elevate one another to the next level. We encourage our associates to listen, stay agile, and learn from mistakes.
  • Act like an owner & doer. Mission-driven and committed to leading change, you will be encouraged to take on any challenge and solve complex problems. No tasks are beneath or too great for us. We are hands-on and willing to master our craft.
  • Give back to others. Always do the right thing for our clients and our community and humbly give back to the community where we live and work. Support our associates in times of need through ADP's Philanthropic Foundation.
  • Join a company committed to equality and equity. Our goal is to impact lasting change through our actions.


What are you waiting for?  Apply today!


Find out why people come to ADP and why they stay: https://youtu.be/ODb8lxBrxrY

(ADA version: https://youtu.be/IQjUCA8SOoA )


Explore our COVID-19 page https://tech.adp.com/covid19/ to understand how ADP is approaching safety, travel, the hiring interview process, and more.

Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP: ADP affirms that inequality is detrimental to our associates, our clients, and the communities we serve. Our goal is to impact lasting change through our actions. Together, we unite for equality and equity. ADP is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.

Ethics at ADP: ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws. We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace. Click https://jobs.adp.com/life-at-adp/ to learn more about ADPs culture and our full set of values.



  • Other
Posted: 2021-10-21 Expires: 2022-02-20
Sponsored by:
ADP Logo

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Lead ETL Developer

Roseland, NJ 07068

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast