← Back to jobs

Amtex Systems Inc Logo
Lead ETL Architect with SAP BODS

Amtex Systems Inc

 

United States

Posted On: 11 days ago
Experience: 8+ years
Availability: Remote
Openings: 1
Category: ETL Architect
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

You will design the Enterprise Data Warehouse architecture and lead the technical direction of the data engineering team.

This role is remote.

Responsibilities

  • Design the overall EDW architecture and oversee data modeling to support analytical needs.
  • Lead integration of data from various source systems by designing and developing ETL/ELT processes.
  • Optimize EDW performance through query tuning, index design, table partitioning, and caching strategies.
  • Build scalable solutions using micro-service architecture to enable a self-service data environment.
  • Collaborate with business analysts and stakeholders to define and extend the enterprise data model.

Required Skills

  • 8+ years of experience in business insights, advanced analytics, data analysis, or consulting.
  • 7+ years of experience as a data warehousing professional.
  • 3+ years of experience as a Data Architect.
  • 2+ years of experience in a project or team lead role.
  • 5+ years architecting ETL data flows using at least two enterprise tools (SAP BODS, SSIS, Informatica, Ab Initio, or IBM InfoSphere DataStage).
  • Proficiency with Oracle Database and Microsoft SQL Server.
  • Bachelor’s degree in Computer Science, Information Systems, or Data Analytics.
  • Expertise in data querying, analytics, and identifying business risks or opportunities.

Preferred Skills

  • Experience with big data platforms including Hadoop, GCP, AWS, BigQuery, or Azure.
  • Experience designing reporting semantic layers or using tools like IBM Cognos, SAP Business Objects, Tableau, or Microsoft Power BI.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs