Senior AWS Cloud Data Engineer I

Job description

Job Purpose

The Data Engineer designs, builds, and maintains scalable data solutions to enable advanced analytics and business intelligence across Honda’s enterprise.

Key Accountabilities

Data Pipeline Development: Design and implement ETL pipelines using AWS services (Glue, EMR, DMS, S3, Redshift). Orchestrate workflows with AWS Step Functions, EventBridge, and Lambda. Integrate CI/CD pipelines with GitHub and AWS CDK for automated deployments.

Data Modeling & Transformation

Develop conceptual, logical, and physical data models for operational and analytical systems. Optimize queries, normalize datasets, and apply performance tuning techniques. Use Python, PySpark, and SQL for data transformation and automation.

Security & Governance

Implement IAM roles and encryption policies for data protection. Ensure compliance with governance standards using tools like Informatica CDGC/CDQ.

Monitoring & Optimization

Monitor pipeline performance using CloudWatch and Glue job logs. Troubleshoot and resolve data quality and performance issues proactively. Qualifications, Experience, and Skills Minimum educational qualifications: A Bachelor's degree in Computer Science / Data Science / Applied Mathematics / Information Technology / Informations Sciences / Electronics or a related field of study or, equivalent relevant work experience.

Minimum work experience At least 3 years of demonstrable work experience in the industry, in data engineering or related roles. Proven track record in Amazon Web Services (AWS) based data solutions and orchestration Integration with ERP systems (SAP, Homegrown ERP Systems) API-based Data Exchange between Manufacturing, Supply Chain legacy applications and AWS pipelines

Metadata Management for compliance attributes Audit Trails & Reporting for compliance verification Expertise in cloud to design, build, and maintain data-driven solutions Skilled in Data Architecture and Data Engineering with a strong background in Supply Chain domain Experienced in Data Modeling (Conceptual, Logical, and Physical), ETL optimizations, Query optimizations and

Performance tuning Other job specific skills: Technical Skills: Programming languages: Python, PySpark, SQL AWS Services: Glue, EMR, EC2, Lambda, DMS, S3, Redshift, RDS Data Governance: Informatica CDGC/CDQ DevOps Tools: Git, GitHub, AWS CDK Security: IAM, encryption policies Monitoring: CloudWatch, Glue Catalog, Athena Strong integration background with DB2, UDB, SQL Server etc Soft Skills: Strong communication and collaboration skills.

Ability to work with cross-functional teams and stakeholders. Workstyle The position will require the employee to work onsite at our corporate office in Marysville, OH, at least 4 days per workweek. One remote workday per week may be possible with prior departmental approval.