Sr. Data & BI Engineer at ScaleUp Ally in Noida, Uttar Pradesh, IN

• 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