Source description
About the role
Role Summary We are looking for a highly analytical and technically strong professional to manage business data requirements, build internal data structures, and develop scalable BI reporting solutions. The candidate will act as a bridge between business teams and technical systems, ensuring accurate, timely, and structured MIS and analytics delivery. The role requires strong expertise in Oracle, SQL, Power BI and foundational knowledge of Data Warehousing concepts. Key Responsibilities Understand and review existing database structures and schemasTranslate business requirements into structured data modelsBuild and maintain in-house data models using Power BI or similar tool.Develop complex Oracle, SQL queries for data extraction and transformationDesign and optimize fact-dimension models Work closely with business stakeholders (Sales, Investment, Operations, Compliance, Marketing)Ensure data accuracy, validation, and governance controlsIdentify gaps in current data architecture and propose improvementsSupport automation of MIS reporting processesCollaborate in future data warehouse migration or ETL activitiesDocument data definitions, logic, and reporting structures Required Technical Skills Strong hands-on experience in Oracle, SQL (mandatory)Experience in Power BI (DAX, Tabular Model, Data Modeling)Understanding of Data Warehousing concepts (Fact, Dimension, ETL basics)Ability to create optimized queries and performance tuningExperience in handling large datasetsUnderstanding of database normalization and schema designExposure to data governance & validation processes Good to Have Experience in Mutual Fund Services domainKnowledge of SharePlex / replication systemsBasic ETL tools knowledgePython for data processingExposure to cloud-based BI tools Qualification B.Tech / BE / MCA / M.Sc (IT / CS / Data Science)48 years relevant experience .
More at PPFAS MUTUAL FUND