We are looking for a Senior Data Engineer / Data Mart Architect to design and build a data mart from scratch that will power business intelligence, reporting, and analytics across the organization.

This role involves integrating data from Infor LN ERP and legacy systems, creating scalable ETL pipelines and data models, and enabling seamless consumption through BI tools.

Key Responsibilities

1. Data Mart Design & Development
- Design and implement a scalable data mart architecture using open-source databases (e.g., PostgreSQL, MySQL).
- Define data models (star/snowflake schema) aligned with business reporting needs.
- Ensure high performance, reliability, and scalability of the data mart.

2. ETL & Data Integration
- Build and maintain ETL pipelines for extracting data from:
- Infor LN ERP
- Legacy systems
- External data sources (if applicable)
- Create robust data staging layers for transformation and cleansing.
- Automate data workflows and ensure data freshness.

3. Data Quality & Governance
- Implement data validation, cleansing, and reconciliation processes.




- Ensure data consistency across systems.
- Maintain proper documentation and data lineage.

4. BI & Analytics Enablement
- Structure data for easy consumption by BI tools (Power BI, Tableau, etc.).
- Collaborate with business teams to understand reporting requirements.
- Optimize queries and datasets for faster dashboard performance.

5. Performance Optimization
- Tune database performance (indexes, partitioning, query optimization).
- Monitor ETL jobs and resolve bottlenecks.

Technical Skills

• Solid expertise in ETL processes and data staging concepts.

• Hands-on experience with:

o SQL (advanced level)

o Open-source databases (PostgreSQL preferred)

• Experience integrating ERP systems like Infor LN (or similar ERP systems such as SAP, Oracle).

• Familiarity with ETL tools (Talend, Pentaho, Airflow, or custom pipelines).

• Understanding of data modeling techniques (Star Schema, Snowflake).

B

📌 Data Engineer (Mumbai)
🏢 Jewelex India
📍 Mumbai