Business Intelligence & Reporting Consultant

Stratainformationgroup; Pune District; Hybrid; INR 2,950,000 - 3,330,000; Full time

Job summary

Strata Information Group (SIG) is building its first engineering Center of Excellence in Pune. This hands‑on BI role focuses on SQL development, data modeling, and reporting across Oracle and PostgreSQL environments.

You will design data models, build reporting solutions, and support data warehouses while interacting with clients to gather requirements and present solutions. The ideal candidate has 4–7 years in BI, strong SQL skills, experience with data warehouses/ETL, and proficiency in BI

Qualifications

• 4–7 years of experience in Business Intelligence, SQL development, reporting, data engineering, or related fields.
• Advanced SQL expertise, including query optimization, performance tuning, indexing, and execution plans.
• Experience with Oracle SQL and/or PostgreSQL.
• Strong data modeling experience, including normalized (3NF) and dimensional/star schema design.
• Experience building or supporting data warehouses and ETL/data integration processes.
• Hands‑on experience with BI and reporting tools such as Power BI, Tableau, Cognos, or similar.
• Strong analytical and problem‑solving skills with the ability to work independently.
• Excellent written and verbal English communication skills.

Responsibilities

• Write, optimize, and troubleshoot complex SQL queries in Oracle and PostgreSQL.
• Translate reporting requirements into reports, dashboards, and data extracts.
• Design and maintain data models, data warehouses, and ETL/data integration processes.
• Develop BI solutions using tools such as Power BI, Tableau, Cognos, or similar platforms.
• Validate and reconcile data across multiple systems and large relational datasets.
• Partner with clients and stakeholders to gather requirements, present solutions, and support delivery.
• Leverage AI-assisted development tools to improve productivity and solution quality.

Skills

SQL development

Data modeling

BI reporting

Data warehousing

Analytical thinking

English communication

Tools

Power BI

Tableau

Cognos

Oracle SQL

PostgreSQL

Job description

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 exposesa very largeAPI 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 APIsactually servethat 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 businessneedto endpoint. You build that understanding, and it becomes some of the most valuable knowledge you carry.

The second half is API security. These APIs move student records, employee data, and financial transactions. You need to understand authentication and authorization flows, how tokens and scopes work, and how to request only the access an integration genuinely needs. Getting this wrong is not a bug — it is a data exposure.

We are looking for depth here, not familiarity. Someone who has run a few SELECT statements will struggle. Someone who has written, tuned, and debugged complex SQL against real schemas and designed the models behind it will do well.

What You Will Do

• Write, optimize, and troubleshoot complex SQL queries in Oracle and PostgreSQL.
• Translate reporting requirements into reports, dashboards, and data extracts.
• Design and maintain data models, data warehouses, and ETL/data integration processes.
• Develop BI solutions using tools such as Power BI, Tableau, Cognos, or similar platforms.
• Validate and reconcile data across multiple systems and large relational datasets.
• Partner with clients and stakeholders to gather requirements, present solutions, and support delivery.
• Leverage AI-assisted development tools to improve productivity and solution quality.

Required Qualifications

• 4–7 years of experience in Business Intelligence, SQL development, reporting, data engineering, or related fields.
• Advanced SQL expertise, including query optimization, performance tuning, indexing, and execution plans.
• Experience with Oracle SQL and/or PostgreSQL.
• Strong data modeling experience, including normalized (3NF) and dimensional/star schema design.
• Experience building or supporting data warehouses and ETL/data integration processes.
• Hands‑on experience with BI and reporting tools such as Power BI, Tableau, Cognos, or similar.
• Strong analytical and problem‑solving skills with the ability to work independently.
• Excellent written and verbal English communication skills.

Preferred Qualifications

• Experience with cloud data platforms and modern ETL/ELT tools.
• Experience using AI tools such as GitHub Copilot, Claude, or similar in a professional environment.
• Experience supporting ERP, SIS, HRMS, or Finance systems.
• Prior exposure to Higher Education technology or Ellucian solutions (Banner, Colleague, ODS, EDW) is a plus, but not required.

What we need from you is the ability to absorb a new domain fast and start contributing inside two months.

Working Hours

Flexible schedule with a Tuesday - Thursday overlap requirement of 3–4 hours with US Eastern morning, 2:00 - 10:00 PM IST. Outside that overlap window, you manage your own hours. We care about what you deliver, not when you are logged in.

Who Does Well Here

• You are self-driven. You unblock yourself, ask sharp questions, and do not wait to be assigned work.
• You are curious about the tools that make you faster, and youactually trythem.
• You are comfortable being early. This team is being built now, and the process is not fully written.
• You can talk to a non-technical client and explain what you built without making them feel lost.

Strata Information Group is an equal opportunity employer.

The listed salary range for this position is indicative and subject to adjustment based on the candidate's unique skills and location. Final compensation will be determined through mutual agreement between the successful candidate and SIG.

SIG is an Equal Employment Opportunity employer

California Consumer Privacy Act Notice