1+ months

Senior Data Engineer/ETL Developer

Alpharetta, GA 30009

Position Description

Unlock Your Career Potential: Technology at ADP. Do you enjoy exploring, identifying and inspiring the future of the workplace and the lives of millions of people? At ADP, the world's largest B2B cloud company, our Technology team is comprised of brilliant engineers, architects, data scientists, infrastructure experts, and more. We were first in our industry to offer a SaaS solution and continue to push the envelope utilizing the latest operating platforms to deliver the highly automated, intelligent and predictive solutions that are redefining what is possible. Named one of Forbes' "Most Innovative Companies" and one of Computerworld's "100 Best Places to Work in IT", we are committed to leading the way in product development and research, empowering you to bring to life the latest innovations that will forever change the way businesses manage their most vital asset, employees.

GSS Analytics is dynamic shared-services team comprised of data architects, data scientists, analysts and analytic translators charged with providing data science and deep analytics expertise to support all ADP business units to solve their most challenging issues. GSS Analytics drives measurable business outcomes with leading-edge analytics approaches. By leveraging our extensive big-data infrastructure, the team uses machine learning, artificial intelligence, speech analytics, natural language processing and applied statistics to streamline processes and automate decision making.

ADP/GSS Analytics is hiring a Sr. Data Engineer / ETL Developer with demonstrated experience in providing leadership, technology expertise in the development, integration, and maintenance of new and existing applications.

The Candidate will be responsible for the enhancement and refinement of the overall database structure of GSS Analytics. The Candidate will be accountable for creating SQL & Python scripts and SSIS packages that support Data Science Operations. In addition, the Sr. Data Engineer will be responsible for ensuring high data integrity as well as optimizing database performance within the environment.

The Candidate will design, analyze, develop, troubleshoot, and maintain SQL stored procedures, databases and Python Scripts.

THINGS YOU'LL DO:

  • Perform complex database programming by writing SQL procedures on large-scale databases
  • Work closely with our business teams to understand business reporting and analytic requirements
  • Develop new database schema/objects and/or review existing objects to improve storage efficiency and access
  • Creating, reviewing, analyzing, and modifying SQL scripts, procedures and supporting programs to ensure proper execution, efficient operation, and sustainable coding constructs.
  • Writing technical procedures and/or supporting documentation for the applications including operational usage or procedures, user guides, etc.
  • Proven ability to perform technical troubleshooting to diagnose, isolate and correct data and database issues.
  • Knowledge of data analysis, end user requirements analysis, and business requirements analysis to ensure a clear understanding of the business needs and to incorporate these needs into technical solutions
  • Conducting data analysis to identify data integrity issues within databases, interfaces, or other data related repositories.
  • Applying quality controls to work functions including appropriate testing and validation of new or modified programs prior to deployment.
  • Demonstrating and applying reasonable and practical security controls within the SQL and database environments to minimize security risks.

EXPERIENCE YOU'LL NEED:

  • Bachelor's degree in engineering, computer science or related field
  • 7+ years of experience working on MS SQL Server, Oracle & Hadoop
  • Solid experience in building data pipelines using SQL, Python & MS SSIS Tools.
  • 4+ years of experience working with an Enterprise BI environment specially using Data Analytics & Engineering, Big data projects.
  • Strong knowledge and use of SSIS functionality for Batch Job Management using SQL Server Agent & SSIS Catalog.
  • Proven knowledge of SQL and relational database concepts including security and performance optimization.
  • Working Knowledge of Microsoft .NET stack & Tableau is a big plus
  • Ability to think at an architectural level in creating, growing, maintaining, and documenting scalable systems
  • Strong analytical and problem-solving skills.
#LITECH

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.

Categories

Industry

  • Other
Posted: 2021-06-25 Expires: 2021-08-29
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:

Senior Data Engineer/ETL Developer

ADP
Alpharetta, GA 30009

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast