Note: The job is a remote job and is open to candidates in USA. Zealogics Technologies is seeking an experienced Senior Data Engineer to architect, model, and optimize foundational data infrastructure for a new strategic project. The role focuses on integrating heterogeneous data sources, implementing data cataloging and lineage, optimizing database performance, building ETL/ELT pipelines, and collaborating with architects and technical teams to deliver scalable data architectures.
Responsibilities
- Architect conceptual, logical, and physical data models for a new enterprise solution. Identify, map, and resolve complex entity relationships across SAP Core, PostgreSQL, MySQL, and legacy systems
- Implement enterprise data cataloging, metadata tracking, and end-to-end data lineage to ensure visibility, governance, and auditability across all data layers
- Analyze execution plans, optimize complex SQL queries, fine-tune database configurations, indexing, and partitioning to ensure high throughput and minimal latency
- Design and maintain robust metadata indexing mechanisms for large-scale document management systems (e.g., In-house DMS, Azure Blob Storage)
- Build reliable ETL/ELT data pipelines integrating structured, semi-structured, and enterprise data repositories into a unified system
- Partner with enterprise architects, product owners, and global client technical teams to translate business requirements into scalable data architectures
Skills
- * **Experience:** 5–8 years of dedicated hands-on experience in Data Engineering, Data Architecture, and Enterprise Data Modeling
- * **Data Modeling Mastery:** Proven expertise in dimensional modeling, Data Vault, ER diagrams, and multi-source relationship mapping
- * **Heterogeneous Databases:** Solid expertise in working with **SAP Core**, **PostgreSQL**, and **MySQL**
- * **Governance & Lineage:** Experience with modern data cataloging and lineage tools (e.g., OpenMetadata, Apache Atlas, Microsoft Purview, Collibra, or dbt docs)
- * **Performance Tuning:** Expert knowledge in SQL optimization, indexing strategies, memory tuning, and query troubleshooting
- * **Cloud & Modern Data Stack:** Hands-on experience with cloud ecosystems (**Azure/AWS**) and pipeline orchestration tools (Spark, Databricks, dbt, Airflow, etc.)
- * **Strong verbal and professional communication** skills to deal with architects & data engineers across globe
- * Proven ability to extract, index, and manage metadata for large enterprise document repositories (**In-house DMS, Azure Blob Storage**, S3)
- * Exposure to OCR/document metadata workflows and semi-structured cataloging
- * Prior experience delivering high-impact solutions for global clients and internal products
Benefits
- Fully remote work arrangement
Company Overview
Company H1B Sponsorship