We are seeking a talented and experienced Data Engineer to join our dynamic team. As a Data Engineer, you will play a crucial role in designing, developing, and maintaining our data architecture. You will work closely with cross-functional teams to ensure the smooth flow of data and contribute to the overall success of our projects. **Key Duties/Tasks:** + Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals. + Collaborate with data engineers, data consumers, and other team members to produce simple, functional, and elegant solutions that balance the data needs across the organization. + Solve complex data problems to deliver insights that helps the organization achieve its goals. + Create data products that will be used throughout the organization. + Advise, consult, mentor and coach other data and analytic professionals on data standards and practices. + Develop and deliver documentation on data engineering capabilities, standards, and processes; participate in coaching, mentoring, design reviews and code reviews. **Technical Qualifications:** + 5+ years relevant and progressive data engineering experience. + Deep Technical knowledge and experience in Databricks, Python, Spark, Scala, AWS architecture and platform including Glue, Lambda pipelines etc. + Hands-on experience working with data pipelines using a variety of source and target locations (e.g., Databricks, SQL Server, Data Lake, file-based, SQL and No-SQL database). + Experience in engineering practices such as development, code refactoring, and leveraging design patterns, CI/CD, and building highly scalable data applications and processes. + Experience developing batch ETL pipelines; real-time pipelines are a must. + Knowledge of advanced data engineering concepts such as dimensional modeling, ETL, data governance, data warehousing involving structured and unstructured data. + Thorough knowledge of SQL Server including T-SQL and stored procedures. + Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. **Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP:** ADP is committed to an inclusive, diverse and equitable workplace, and is further committed to providing 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, protected veteran status or disability. Hiring decisions are based upon ADP’s operating needs, and applicant merit including, but not limited to, qualifications, experience, ability, availability, cooperation, 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.