Apply on Kit Job: kitjob.in/job/45zzbv

Data Mart & BI Engineer

About Our Client: Like the multiple facets of a diamond, this corporate goes beyond the value chain by providing superior products, customer care and services that are acknowledged within the global jewelry industry. We are among the world's leading vertically integrated diamond and jewelry companies known for integrity, innovation and trust.

Job Title: Data Mart & BI Engineer

Education: BE / Btech / Bsc, BCA, MSC

Experience: 5–7 years of experience in Data Engineering / Data Warehousing / BI Engineering.

Location: Seepz, Andheri E, Mumbai

Working Days: Mon-Sat/ 17 Saturdays off annually

About the Role: We are looking for an experienced Data Mart & BI Engineer to design, build, and

manage a scalable data mart that will serve as the foundation for business intelligence,

reporting, and advanced analytics. The role involves working with data from Infor LN ERP and multiple legacy systems, building robust data staging, ETL pipelines, and transformation layers, and enabling seamless integration with BI tools.

Key Requirements:

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:

o Infor LN ERP

o Legacy systems

o 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.

Responsibilities:

- Proven experience in building data marts or data warehouses from scratch.

Technical Skills:

- Strong 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).

BI & Analytics

- Experience working with BI tools such as Power BI / Tableau / Looker.
- Ability to translate business requirements into data models

Nice to Have:

- Experience in manufacturing or jewellery industry data systems.
- Exposure to cloud platforms (AWS/GCP/Azure).
- Knowledge of Python for data processing.

Soft Skills:

- Strong problem-solving and analytical thinking.
- Ability to work with cross-functional teams (IT, business, operations).
- Positive communication and documentation skills.

About Hireginie: Hireginie is a prominent talent search company specializing in connecting top talent with leading organizations. We are committed to excellence and offer customized recruitment solutions across industries, ensuring a seamless and transparent hiring process. Our mission is to empower both clients and candidates by matching the right talent with the right opportunities, fostering growth and success for all.

Apply on Kit Job: kitjob.in/job/45zzbv

📌 Business Intelligence Engineer (Nellore)
🏢 Hireginie
📍 Nellore