Data Engineer (Power BI)

Company Description

Acronotics Limited specializes in cutting-edge robotic automation and artificial intelligence solutions. By applying human intelligence to build advanced AI-fueled systems, Acronotics transforms businesses with technologies like AI and Robotic Process Automation (RPA). As a consulting and services firm, we are dedicated to creating automated solutions that will redefine how products are made, sold, and consumed. Our mission is to help clients implement and run game-changing robotic automation and artificial intelligence-based solutions. Explore our product, Radium AI, which automates bot monitoring and support activities, on our website: Radium AI.

Role Description

This is a full-time, on-site role for a Data Engineer (Power BI) based in Bengaluru. You will design and manage data pipelines that connect Power BI, OLAP cubes, documents (pdfs, presentations) and external data sources to Azure AI. Your role ensures structured and unstructured financial data is indexed and accessible for semantic search and LLM use.

Key Responsibilities:

• Extract data from Power BI datasets, semantic models, and OLAP cubes.
• Connect and transform data via Azure Synapse, Data Factory, and Lakehouse architecture.
• Preprocess PDFs, PPTs, and Excel files using Azure Form Recognizer or Python-based tools.
• Design data ingestion pipelines for external web sources (e.g., commodity prices).
• Coordinate with AI engineers to feed cleaned and contextual data into vector indexes.

Requirements:

• Strong experience with Power BI REST/XMLA APIs.
• Expertise in OLAP systems (SSAS, SAP BW), data modelling, and ETL design.
• Hands-on experience with Azure Data Factory, Synapse, or Data Lake.
• Familiarity with JSON, DAX, M queries.