Skip to content

Open nowPosted 4 days ago

Business Intelligence & Reporting Consultant

Strata Information Group13 open roles

Pay
₹30 – ₹33 an hour
Where
Pune, Maharashtra, India
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowBusiness Intelligence & Reporting ConsultantStrata Information Group · Pune, Maharashtra, India
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Strata Information Group's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.8% of postings close within 7 days. Measured by our own scanner across the market. Strata Information Group postings stay open a median of 9 days.

Share of postings closed within
  1. 1.7%1 day
  2. 3.5%3 days
  3. 7.8%7 days
  4. 14.6%14 days
  5. 34.1%30 days
This job: posted 4 days ago

Strata Information Group median: 9 days open

The posting

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 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 you actually try them.
  • 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

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Strata Information Group's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Strata Information Group's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Strata Information Group's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.