Senior Data Architecture Engineer - ETL, AWS, Data Warehouse

Hitachi; United States; Remote; USD 120,000 - 150,000; Full time

Job summary

Hitachi Vantara is seeking an experienced Data Engineer in the United States to build data pipelines, ETL processes, and dashboards that power data-driven decisions. You’ll collaborate across teams to integrate data from diverse sources, ensure quality, and support the data warehouse with actionable analytics.

The ideal candidate has hands-on experience with SQL, data warehousing, ETL/ELT, and AWS (Redshift/Airflow/S3).

Qualifications

• Proven work experience as a Data Engineer or in a related role.
• Proficiency in SQL, Data warehousing, Data modeling, PBI Reporting.
• Strong understanding of data methodologies and processes.
• Hands on experience in ETL/ELT.
• Solid understanding of data engineering principles, including statistical analysis.
• Familiarity with the AWS ecosystem, including Redshift, Airflow, S3, and related services.
• Demonstrated experience handling large datasets and relational databases.
• Ability to work effectively in a dynamic, research-oriented team with multiple concurrent projects.
• Understanding of data privacy regulations.
• Knowledge on Oracle EBS/Salesforce Finance and Supply chain modules.
• Knowledge on Batch/Powershell, REST API’s.
• Excellent communication, problem-solving, and collaboration abilities.

Responsibilities

• Build data pipelines to clean, transform, and aggregate data from disparate sources.
• Design, build, and maintain ETL processes while working with large and complex datasets.
• Perform quality assurance on imported data and collaborate with multiple teams as needed.
• Manage and design the reporting environment, including data sources, security, and metadata.
• Support the data warehouse by identifying and refining reporting requirements.
• Develop and troubleshoot reports and dashboards using single or multiple data sources.
• Evaluate changes and updates to source production systems.
• Collaborate with business stakeholders to understand business needs.
• Experience in elicitation, stakeholder management, business process analysis, and documentation.

Skills

Proven data engineering experience

Strong SQL

Data warehousing

Data modeling

Power BI reporting

Tools

AWS Redshift

Apache Airflow

S3

REST APIs

Oracle EBS

Salesforce Finance

Job description

Hitachi Vantara is seeking an experienced Data Engineer in the United States to build data pipelines, ETL processes, and dashboards that power data-driven decisions. You’ll collaborate across teams to integrate data from diverse sources, ensure quality, and support the data warehouse with actionable analytics.

The ideal candidate has hands-on experience with SQL, data warehousing, ETL/ELT, and AWS (Redshift/Airflow/S3).