Business Intelligence & Reporting Consultant

Strata Information Group (SIG) is a trusted leader in higher ‑ education technology consulting, supporting colleges and universities with ERP/SIS modernization, digital transformation, CRM, cybersecurity, and strategic advisory services. As a long ‑ standing and deeply embedded partner within the higher ‑ education sector, SIG brings together technical depth, operational insight, and a culture rooted in integrity, collaboration, and exceptional client service. Our heritage is built on hands ‑ on expertise, genuine relationships, and a commitment to delivering value with humility and excellence—values that continue to define us as we scale. Business Intelligence & Reporting Consultant Oracle SQL / PostgreSQL | Client-facing designation: Technical Consultant Location: Pune, India (Hybrid) Employment Type: Full-time (via SIG's Employer of Record in India) Experience: 4–7 years Fixed Base Compensation: ₹29.5–₹33.3 lakh per year About SIG Strata Information Group (SIG) is a US-based leader in higher-education technology consulting. We help colleges and universities modernize the systems that run their institutions — student information, HR, and finance — through ERP/SIS implementation, integration, digital transformation, CRM, and cybersecurity work. We are building our first engineering Center of Excellence in Pune. This is a founding-team role. You will not be joining a large delivery pool with a fixed process; you will help set how this team builds. The Role This is a hands-on SQL and reporting role for someone who enjoys working with complex data and transforming business requirements into meaningful reports, dashboards, and data solutions. You will work across large Oracle and PostgreSQL environments, designing data models, building reporting solutions, and supporting data warehouses that enable institutional decision-making. While the role includes client interaction, the primary focus is on data analysis, SQL development, and business intelligence. We are not looking for someone who has simply used SQL. We want a BI professional who can independently analyze complex schemas, build robust reporting solutions, and translate business requirements into trusted data products. Higher education experience is not required; strong SQL, data modeling, and reporting expertise are. APIs Are the Core of This Work If there is one thing to take from this description, it is this: your primary skill is working with APIs. Ellucian exposes a very large API surface across its student, HR, and finance platforms. A significant part of the job is knowing that catalog — reading a business requirement, working out which APIs actually serve that function, understanding what each one returns and what it does not, and then writing the code that meets the requirement. Nobody hands you a mapping from business need to endpoint. You build that understanding, and it becomes some of the most valuable knowledge you carry. The second…