Business Intelligence Consultant

SIG (Strata Information Group); United States; On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Short & Long Term Disability

3 Weeks Vacation

Sick Leave & Paid Holidays

401(K) with a 5% Employer Contribution

Pet Insurance

Job summary

A leading education technology consulting firm in the United States is looking for a Business Intelligence Senior Consultant. This role involves translating institutional data into actionable insights and developing business intelligence strategies with college clients. Ideal candidates will have strong SQL skills, experience with BI tools, and knowledge of the higher education landscape. The position offers a salary range of $90,000 - $120,000, along with benefits like 401(K) contributions and paid vacation.

Qualifications

• Experience working within higher education environments.
• Proven ability to lead requirements gathering and business analysis.
• Knowledge of data warehouse best practices.

Responsibilities

• Develop business intelligence strategies for clients.
• Provide training and consulting support at client sites.
• Create and maintain dashboards using BI tools.
• Translate business requirements into analytics solutions.
• Ensure data accuracy and integrity across reporting.

Skills

Higher Education Experience with Ellucian Banner Expertise

Strong SQL proficiency

Experience in Oracle Database

Experience in PostgreSQL

Hands-on experience with BI tools

Stakeholder management skills

Cross-functional communication skills

Knowledge of data modelling

Tools

Microsoft Power BI

Tableau

Ellucian Argos

IBM Cognos Analytics

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.

Behind every successful student, program, and strategic decision is data that tells the right story.

As a Business Intelligence Senior Consultant - Higher Education, you’ll help translate institutional data into actionable insights that support your Higher Education client's academic mission, operational effectiveness, and long‑term planning. If you enjoy working collaboratively, solving ambiguous problems, and making data usable for non‑technical audiences, this role offers meaningful impact in a higher‑education consulting environment.

Responsibilities

• Develop business intelligence strategies in collaboration with college and university clients
• Perform implementation services such as training, functional consulting, and technical support at client sites
• Develop and deploy business intelligence solutions based on the Ellucian Banner® reporting tools, including Argos, Cognos, Operational Data Store (ODS), and the Banner® Enterprise Data Warehouse (EDW)
• Design, develop, and maintain interactive dashboards, reports, and scorecards using BI and visualization tools (e.g., Power BI, Tableau, Looker, or similar).
• Translate business requirements into reporting and analytics solutions that align with organizational goals.
• Develop standardized and ad-hoc reports to support operational, financial, and strategic initiatives.
• Ensure data accuracy, consistency, and integrity across all reporting outputs.
• Collaborate with business leaders, analysts, and technical teams to understand reporting needs.
• Present insights and recommendations to both technical and non-technical audiences.
• Provide consulting support by advising on best practices for data visualization and analytics.
• Gather feedback and continuously improve BI solutions.

Qualifications

• Higher Education Experience with Ellucian Banner Expertise
• Strong SQL proficiency with experience in Oracle Database and PostgreSQL
• Experience working with Relational Database Management Systems (RDBMS) in complex data environments
• Hands‑on experience building dashboards and reporting in BI tools such as Microsoft Power BI, Tableau, Ellucian Argos, or IBM Cognos Analytics
• Experience working within higher education environments
• Proven ability to lead requirements gathering, business analysis, and technical documentation
• Strong stakeholder management and cross‑functional communication skills
• Ellucian Banner or Colleague experience is strongly preferred
• Knowledge of data modelling, star schema, data warehouse best practices

Pay range and compensation package

• The salary range is $90,000 -$120,000 + bonus
• Short & Long Term Disability
• 3 Weeks Vacation, Sick Leave & Paid Holidays
• 401(K) with a 5% Employer Contribution
• Pet Insurance

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.

Equal Opportunity Statement

SIG is an Equal Employment Opportunity employer