Sr. Data & BI Engineer

About Us At ScaleupAlly, we believe that technology improves all aspects of lives. That is why we are geared towards becoming a tech ally of great ideas. The aim is to be the remote in-house tech team of these ideas. We work with Start-ups, Founders, and Leaders around the globe with ideas of Web and App Development, Business Intelligence and Data Visualization. We achieve our aim by building the long-lasting dynamic teams made of the top talent across the globe managed by experienced in-house Technical Leads. At ScaleupAlly, we build, manage and care our distributed teams like no one else. It’s a whole new approach to make you rethink what your idea is capable of. Job Description 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