SQL Expert / Data Modeler Development / 5-10 years

Miracle Software Systems, Inc.; India; On-site; INR 600,000 - 900,000; Full time

Job summary

A technology consulting firm in India is looking for a skilled SQL Developer to enhance reporting processes. The role involves developing SQL queries, designing data models, and converting SAP BW queries into Power BI views. The ideal candidate should have experience with data optimization and collaboration with cross-functional teams to define reporting needs. This position offers an opportunity to work in a dynamic environment focused on improving analytics capabilities.

Qualifications

• Experience in developing complex SQL queries and data models.
• Familiarity with Power BI and SAP BW is essential.
• Knowledge of data governance and reporting workflows.

Responsibilities

• Develop and maintain SQL queries for analytics.
• Design data models using star and snowflake schemas.
• Convert SAP BW queries into SQL views.
• Collaborate with teams to gather reporting requirements.
• Optimize SQL queries for better performance.

Skills

SQL queries

Data modeling

Power BI

SAP BW

Database optimization

Job description

We are an Equal Opportunity Employer

Applicants are considered for employment without attention to or discrimination against race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. All employment is decided on the basis of qualifications, merit and business need.

Responsibilities

• Develop and maintain complex SQL queries, views, and stored procedures to support analytics and enterprise reporting workloads.
• Design logical and physical data models including fact and dimension structures using star schema and snowflake schema approaches.
• Convert SAP BW cubes and queries into SQL based views to enable migration of SAP Business Objects reports to Power BI.
• Work with business analysts and reporting teams to support the transition of legacy SAP BO reports into Power BI dashboards and datasets.
• Optimize SQL queries through indexing, query tuning, and efficient database design to improve reporting performance.
• Validate and maintain data accuracy and consistency across SAP BW sources, SQL transformation layers, and Power BI reporting outputs.
• Collaborate with cross functional teams to gather reporting requirements and translate business needs into structured data models.
• Troubleshoot SQL scripts, reporting queries, and data pipeline issues during migration and post migration phases.
• Document SQL logic, data models, and reporting workflows to support governance, maintenance, and future reporting enhancements.