Data Engineer (ERP/ETL)
Location: Dallas, TX (Remote OK, but must travel to Dallas as required)
Duration: Full-time, at least 1 year
Visa: USC only (No OCI)
Domain: Aerospace (Confidential)
Mandatory Skills
- Proficient in relational databases (PostgreSQL, SQL Server, MySQL, others) and ETL to handle large data volumes using languages like Python, SQL, Data Virtualization
- Experience with SAP ECC, HANA, or S/4
- Ability to write tests against data, applications, and visualizations
Required Skills
Proficient in
Python, SQL. Experience with SAP ECC, HANA, or S/4, Supply chain domain, Building ETLs for large data volumes (hundreds of GBs), Relational databases (PostgreSQL, SQL Server, MySQL, etc.).
Strong understanding of Git source control. Ability to write tests against data, applications, and visualizations.
Familiar with supporting a virtual team. Experience with Agile development: Scrum, sprints, planning, Tools like Jira. Ability to quickly learn new tools.
Desired Skills
Experience with
SQL Server, AWS S3, OpenShift, Docker, Kubernetes, TIBCO Data Virtualization, Apache Spark, Creating and optimizing queries in TIBCO Data Virtualization, CI/CD development, Developing dashboards in Tableau, Full-stack development (frontend, backend, database, REST/SOAP), Orchestration tools like Airflow.
Responsibilities: Design data transformations using SAP HANA data warehouses.
Implement ETL pipelines to calculate metrics from SAP ERP data.
Create efficient queries to extract data from SAP HANA systems. Design user-friendly reports for supply chain metrics in Tableau. Support stakeholder queries. Troubleshoot and optimize queries. Conduct peer reviews to ensure quality and standards compliance. Collaborate with a cross-functional team for data warehousing, BI, and reporting. Ensure data security and compliance.