ADP is seeking a Lead ETL Developer - Remote!
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.
We're building the next generation of ADP technologies.
At ADP we are driven by your success.
We engage your unique talents and perspectives.
We welcome your ideas on how to do things differently and better.
In your efforts to achieve, learn and grow, we support you all the way.
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
What you'll do:
The key responsibility in this role is determining business solutions by creating and maintaining data integrations to support business operations and advanced analytics team to help maximize efficiency and productivity
Engage with internal clients to discern their need.
Translate their need into technical solutions to improve products, processes, or services
Design and develop data integration automation to extract data from various sources, apply transformation logic, and load into our data warehouse using tools such as SQL, SSIS, and Python API scripts
Identify, design, and implement internal process improvements; automate manual processes, optimize data delivery, re-design infrastructure for greater scalability
Create required project artifacts, including Functional Design Documents (FDD’s) as well as supporting documentation, such as process flows and/or data mapping, requirements workshops, business process descriptions, Use Cases, business analysis and task and workflow analysis
Work with cross functional multi-disciplinary teams (Business Intelligence, Information Technology, Database and Data Warehouse Developers, Project Managers) to support the solution delivery process
5+ Years of extensive hands-on experience developing database queries, imports, and associated code in a Microsoft SQL Server environment.
5+ Years of experience developing ETL interfaces with emphasis on SQL and API automation (such as Python, Flask, Express.js, etc)
Experience with API Development (Python) is a plus
Strong experience with data interchange formats (JSON, XML, CSV etc.) is required
Expertise in SQL coding and creating, deploying, and scheduling SSIS Jobs
Bachelor's degree in Computer Science or related field or equivalent combination of education and experience
Exposure to Cloud platforms like Google Cloud or AWS, including services such as Amazon Redshift, S3 bucket, RDS, etc
Experience with Pendo, Splunk, Google Analytics API integration
YOU'LL LOVE WORKING HERE BECAUSE YOU CAN:
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?
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 ADP’s culture and our full set of values.
Please enter your email to receive a job alert when similar jobs are available. You can cancel job alerts at any time!