Sr. Data & BI Engineer

Location
Noida
Workplace
On-site

About this role

  • Develop and maintain advanced Power BI dashboards and reports using DAX, Power Query, data modeling, RLS, and Power BI Service.

  • Design and manage end-to-end ETL/ELT data pipelines using Azure Data Factory and Microsoft Fabric.

  • Write and optimize complex SQL queries for data extraction, transformation, and analytics.

  • Design scalable data models, including Star Schema, fact and dimension tables.

  • Work with SQL Server, Azure SQL, Snowflake, Azure Synapse, and Lakehouse environments.

  • Use Python, Spark/PySpark, and Delta Lake for data processing and automation.

  • Integrate data from databases, APIs, files, and transactional systems while ensuring data quality.

  • Optimize Power BI reports, DAX, SQL, data models, pipelines, and refresh performance.

  • Troubleshoot end-to-end data flow from source systems → pipelines → warehouse/lakehouse → Power BI.

  • Collaborate with Data Engineers, Business Analysts, and stakeholders to deliver scalable BI solutions.

  • Perform data reconciliation, root-cause analysis, and issue resolution.

  • Follow Git/version-control practices and contribute to technical standards and documentation.

  • Mentor junior team members and support technical decision-making.

  • Take ownership of BI and data engineering solutions from development through deployment and optimization.



Requirements

  • Experience with Snowflake, Azure Synapse Analytics, dbt, or Airflow.

  • Experience with CI/CD and Azure DevOps for BI/data solutions.

  • Experience working in Microsoft Fabric end-to-end environments.

  • Exposure to data governance, data security, and enterprise BI architecture.

  • Experience working with APIs and cloud-based data sources.

  • Experience in designing or contributing to enterprise-scale BI/data architectures.

  • Experience working with globally distributed teams or international stakeholders.



Benefits

  • Working hours: 10:00 AM – 7:00 PM

  • Working days: 5 days a week (plus 1st & 3rd Saturdays working)

  • Medical Insurance coverage for employees

  • Provident Fund (PF) facility

  • Quarterly parties and yearly outings/trips for team bonding

  • Regular check-ins with leadership for growth and feedback

  • Recognition awards to celebrate high performance

  • Fun activities and team engagement sessions throughout the year



Tired of cold applications?

Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.

Know someone who'd be great for this?

Top Benefits

  • Medical Insurance
  • Provident Fund
  • Quarterly parties
  • Yearly outings
  • Recognition awards