Description
Job Summary We are seeking a skilled AWS Data Engineer to join our team, specializing in building, and maintaining modern data pipelines using ETL/ELT methodologies. The ideal candidate will have extensive experience in transforming unstructured data into structured datasets, creating CI/CD automation, and ensuring high-quality, validated data for analytical purposes. Key Responsibilities Data Pipeline Development: Design, develop, and maintain robust ELT pipelines using databricks. Data Modeling & Transformation: Apply advanced SQL techniques (CTEs, Window functions, joins, aggregations) to build clean, actionable, and scalable data models. Automation & CI/CD: Develop and maintain automated CI/CD deployment pipelines for dbt projects using Git to ensure smooth production deployments. Data Quality & Validation: Perform comprehensive validation between source and target tables, utilizing Q-Test for test case creation, execution, and defect tracking. Automation: Python scripts for validation and automation. Version Control: Git, Pull requests, Code reviews. Data Migration: Hands-on experience with migrating data between heterogeneous systems (Excel, Flat Files, XML, JSON) and SQL servers. Analytical Skills: Strong problem-solving skills with the ability to adapt quickly in fast-paced environments. Production Support: Troubleshoot and resolve production issues, data discrepancies, and job failures to ensure data reliability. Stakeholder Collaboration: Coordinate with business users and stakeholders to gather requirements and translate them into technical solutions. Documentation: Create technical documentation, demo documents, and wiki pages for all developed jobs and queries. Preferred Qualifications Cloud Platform: AWS Visualization: Databricks / Oracle PL/SQL (Nice to have) / Oracle EBS AR ( Nice to Have) Develop and deploy Agentic AI solutions, including autonomous workflows, AI agents, and GenAI-powered automation tools. ##LI-DNIJob Summary We are seeking a skilled AWS Data Engineer to join our team, specializing in building, and maintaining modern data pipelines using ETL/ELT methodologies. The ideal candidate will have extensive experience in transforming unstructured data into structured datasets, creating CI/CD automation, and ensuring high-quality, validated data for analytical purposes. Key Responsibilities Data Pipeline Development: Design, develop, and maintain robust ELT pipelines using databricks. Data Modeling & Transformation: Apply advanced SQL techniques (CTEs, Window functions, joins, aggregations) to build clean, actionable, and scalable data models. Automation & CI/CD: Develop and maintain automated CI/CD deployment pipelines for dbt projects using Git to ensure smooth production deployments. Data Quality & Validation: Perform comprehensive validation between source and target tables, utilizing Q-Test for test case creation, execution, and defect tracking. Automation: Python scripts for validation and automation. Version Control: Git, Pull requests, Code reviews. Data Migration: Hands-on experience with migrating data between heterogeneous systems (Excel, Flat Files, XML, JSON) and SQL servers. Analytical Skills: Strong problem-solving skills with the ability to adapt quickly in fast-paced environments. Production Support: Troubleshoot and resolve production issues, data discrepancies, and job failures to ensure data reliability. Stakeholder Collaboration: Coordinate with business users and stakeholders to gather requirements and translate them into technical solutions. Documentation: Create technical documentation, demo documents, and wiki pages for all developed jobs and queries. Preferred Qualifications Cloud Platform: AWS Visualization: Databricks / Oracle PL/SQL (Nice to have) / Oracle EBS AR ( Nice to Have) Develop and deploy Agentic AI solutions, including autonomous workflows, AI agents, and GenAI-powered automation tools.
A little about ADP: We are a comprehensive global provider of cloud-based human capital management (HCM) solutions that unite HR, payroll, talent, time, tax and benefits administration and a leader in business outsourcing services, analytics, and compliance expertise. We believe our people make all the difference in cultivating a down-to-earth culture that embraces our core values, welcomes ideas, encourages innovation, and values belonging. We've received recognition for our work by many esteemed organizations, learn more at ADP Awards and Recognition.
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.
