Urgent requirement For Data Engineer &BI Engineer

63 moons; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

63 Moons in Mumbai seeks a Data & BI Engineer with 5+ years to design scalable data solutions, build dashboards, and integrate multiple data sources. You will optimize databases and develop ETL processes to support business reporting.

The role requires strong SQL skills (MySQL, MSSQL, PostgreSQL), Python, REST APIs, and experience with Grafana, Superset, and MSBI. Collaboration with business users and documentation are essential.

Qualifications

• 5+ years of hands-on experience with MySQL, MSSQL, and PostgreSQL.
• Strong expertise in complex SQL query writing, joins, CTEs, window functions, and query optimization.
• Experience with Grafana, Apache Superset, and MSBI; design interactive dashboards and KPI scorecards.

Responsibilities

• Develop, maintain, and optimize databases and SQL queries.
• Build ETL processes and automate data ingestion from databases, APIs, Excel, and CSV files.
• Create interactive dashboards and reports with real-time capabilities and KPI tracking.
• Configure scheduled reports, alerts, and automated report delivery; develop Python scripts for data extraction and API integration.
• Validate data accuracy and provide production support; maintain technical documentation.

Skills

MySQL

MS SQL Server

PostgreSQL

SQL (advanced)

Python (Pandas/SQLAlchemy)

REST APIs

Excel/CSV

ETL

Data warehousing

Data modeling

Git/Linux scripting

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

Grafana

Apache Superset

MSBI (SSIS/SSRS/Power BI)

Power BI

Job description

Job Description Data & BI Engineer

Experience: 5+ Years

Employment Type:

The ideal candidate will develop scalable data solutions, build interactive dashboards, integrate multiple data sources, and support business reporting needs.

Key Responsibilities

• Develop, maintain, and optimize databases using MySQL, Microsoft SQL Server, and PostgreSQL. Write, debug, and optimize complex SQL queries, stored procedures, views, functions, and triggers.
• Perform database performance tuning, indexing, and query optimization. Develop ETL processes and automate data ingestion from databases, APIs, Excel, and CSV files. Integrate third‑party applications using REST APIs, JSON/XML, and other data exchange mechanisms.
• Design, develop, and maintain interactive dashboards and reports using Grafana, Apache Superset, and MSBI (SSIS/SSRS/Power BI). Build dashboards with KPIs, filters, drill‑down capabilities, and real‑time reporting.
• Configure and maintain scheduled reports, email subscriptions, alerts, and automated report delivery. Develop Python scripts for data extraction, transformation, automation, API integration, and reporting.
• Validate data accuracy and ensure data quality across multiple systems. Troubleshoot database, ETL, and reporting issues and provide production support.
• Collaborate with business users to understand reporting requirements and deliver data‑driven solutions. Prepare and maintain technical documentation.

Required Skills

Required Skills: 5+ years of hands‑on experience with MySQL, MSSQL, and PostgreSQL.

• Strong expertise in complex SQL query writing, joins, CTEs, window functions, and query optimization.
• Good understanding of database design, indexing, normalization, and performance tuning.
• Experience with Grafana, Apache Superset, and/or Microsoft BI (SSIS/SSRS/Power BI). Experience designing interactive dashboards, KPI scorecards, and operational reports. Knowledge of report scheduling, automated report distribution, and dashboard management. Strong proficiency in Python, including Pandas, SQLAlchemy, Requests, and OpenPyXL.
• Experience integrating third‑party systems using REST APIs.
• Experience working with Excel/CSV data imports and data transformation.
• Good understanding of ETL processes, data warehousing, and data modeling concepts.
• Familiarity with Git, Linux, and scripting is preferred.

Preferred Skills

• Knowledge of Apache Airflow, Docker, Kafka, or cloud platforms (AWS/Azure/GCP).
• Experience in FinTech, Banking, E-commerce, or Crypto domains.
• Exposure to Agile/Scrum development methodologies.

Qualifications

• Bachelors degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of relevant experience in Data Engineering, Database Development, or Business Intelligence.
• Strong analytical, problem‑solving, communication, and teamwork skills.