Information Technology & Management
Senior Business Intelligence Consultant
Location
United States
Posted
83 days ago
Salary
$90K - $120K / year
Seniority
Senior
Job Description
Senior Business Intelligence Consultant
Strata Information Group
• 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)
Job Requirements
- 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
Benefits
- Health, Vision, Dental & Life Insurance
- Short & Long Term Disability
- Paid Parental Leave
- 3 Weeks Vacation, Sick Leave & Paid Holidays
- 401(K) with a 5% Employer Contribution
- Pet Insurance
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Analyst Jobs
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. Position Summary & Responsibilities SIG is seeking seasoned professionals with multiple years of college or university experience developing and deploying business intelligence solutions based on the Ellucian Banner® reporting tools. SIG offers competitive salaries and benefits. SIG is an Equal Employment Opportunity/Affirmative Action Employer. - 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) Required Qualifications - 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 Preferred Qualifications - Ellucian Banner/Colleague experience. - Knowledge of data modelling, star schema, data warehouse best practices Pay and Benefits - The salary range is $90,000 -$120,000 + bonus - Health, Vision, Dental & Life Insurance - Short & Long Term Disability - Paid Parental Leave - 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. SIG is an Equal Employment Opportunity employer California Consumer Privacy Act Notice
Role Description We are seeking a highly skilled Power BI & GCP Solution Architect to design, implement, and optimize enterprise data solutions that enable actionable insights and business intelligence at scale. This role requires expertise in Power BI for reporting and visualization, as well as hands-on experience with Google Cloud Platform (GCP) services for data integration, transformation, and analytics. The ideal candidate will bridge the gap between business requirements and technical implementation, ensuring scalable, secure, and high-performing solutions. Key Responsibilities - Solution Architecture & Design - Design and implement end-to-end data analytics and reporting solutions leveraging Power BI and GCP. - Define data models, architecture patterns, and best practices for enterprise-scale reporting. - Collaborate with business stakeholders to translate requirements into technical solutions. - Power BI Development & Governance - Develop interactive dashboards, reports, and data visualizations in Power BI. - Establish governance frameworks for dataset management, workspace structure, and access control. - Optimize Power BI performance, ensuring efficiency across large datasets. - GCP Data Engineering & Integration - Participate in architecting data pipelines using BigQuery, Dataflow, Pub/Sub, Cloud Storage, Composer, Dataproc, and other GCP services. - Overview the implementation of ETL/ELT processes for integrating structured and unstructured data sources. - Ensure high availability, scalability, and security in cloud data architectures. - Collaboration & Leadership - Work closely with data engineers, analysts, and business teams to deliver high-quality solutions. - Provide technical leadership, mentoring, and guidance to development teams. - Stay updated on emerging technologies, tools, and industry trends. Qualifications - Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field. - 8+ years of experience in data architecture, BI, or analytics solutions. - Strong expertise in Power BI (DAX, Power Query, data modeling, governance, administration). - Deep knowledge of GCP services such as BigQuery, Dataflow, Pub/Sub, Dataproc, Composer, Looker Studio, Cloud Storage. - Proven experience in data warehousing, ETL/ELT processes, and cloud migration projects. - Strong SQL skills and familiarity with Python/Java/Scala for data transformations. - Solid understanding of data governance, security, and compliance in cloud environments. - Excellent communication skills with the ability to engage both technical and non-technical stakeholders. - Previous experiences leading and managing enterprise data programs. - Proven ability to handle ambiguity. Preferred Qualifications - GCP Professional Cloud Architect or Data Engineer certification. - Experience with CI/CD pipelines, Infrastructure-as-Code (Terraform, Deployment Manager). - Exposure to modern data platforms (e.g., Databricks, Snowflake) alongside GCP. - Familiarity with Agile methodologies and DevOps practices. Benefits - Work with experienced consultants on meaningful, high-visibility and high-impact projects. - Flexible remote work culture. - Collaborative environment focused on client success and personal growth.
Data & Reporting Analyst
Prime TherapeuticsReimagining pharmacy management to provide the same care we would want for our loved ones
• Develop reporting solutions following internal reporting standards and best practices by collecting, validating, interpreting, and organizing various types of data into meaningful reports and/or summaries for designated client groups • Maintain and improve the reliability, efficiency and functionality of existing reports • Facilitate team request intake sessions to collect reporting requirements and determine project prioritization • Recommend quality and system improvements by analyzing the data issues, maintaining and enhancing data iteration processes, and collaborating with system owners to improve upstream processes • Train users and team members as needed • Other duties as assigned
Lead, BI & Data Analytics
SiteOne Landscape SupplySiteOne Landscape Supply is the largest national distributor of landscaping products across the United States and Canada. As a leading supplier of wholesale goods for green industry professionals, we have a long history of serving those who design, build, and maintain outdoor spaces – from lawns and gardens to golf courses, sport fields and more. We pride ourselves on knowing our customers and their business better than anyone else and providing them with a one-stop shop of extensive inventory covering irrigation, lighting, turf and landscape maintenance, hardscapes, nursery, and pest control supplies. At SiteOne, we are passionate about delivering an outstanding customer experience and will stop at nothing to help our customers win. We know that our associates are the key to this success, and our commitment to the SiteOne DNA and support for our associates through development programs, benefits, and perks align with our vision to "Be a Great Place to Work for Our Associates". We foster a culture of safety, teamwork, and continuous improvement. With over 700 locations and exciting expansion ahead, now is the perfect time to join SiteOne and grow Stronger Together™!
Company Overview Lead, Business Intelligence & Analytics - Remote SiteOne Landscape Supply is the largest national distributor of landscaping products across the United States and Canada. As a leading supplier of wholesale goods for green industry professionals, we have a long history of serving those who design, build, and maintain outdoor spaces – from lawns and gardens to golf courses, sport fields and more. We pride ourselves on knowing our customers and their business better than anyone else and providing them with a one-stop shop of extensive inventory covering irrigation, lighting, turf and landscape maintenance, hardscapes, nursery, and pest control supplies. At SiteOne, we are passionate about delivering an outstanding customer experience and will stop at nothing to help our customers win. We know that our associates are the key to this success, and our commitment to the SiteOne DNA and support for our associates through development programs, benefits, and perks align with our vision to "Be a Great Place to Work for Our Associates". We foster a culture of safety, teamwork, and continuous improvement. With over 700 locations and exciting expansion ahead, now is the perfect time to join SiteOne and grow Stronger Together™! Position Overview Role Overview Analytics Lead responsible for translating business problems into scalable data solutions and actionable insights across multiple domains. This role combines deep technical expertise with team leadership, ensuring that business intelligence solutions are reliable, well-designed, and aligned with organizational priorities. They will be part of a larger Business Intelligence organization, partnering with Data Engineering and business experts. Key Responsibilities Analytics Delivery & Solution Design - Design and deliver scalable analytical solutions - Translate business needs into structured requests, dashboards, and insights - Translate ambiguous business questions into structured analytical problems, identifying the metrics, data sources, and analytical approach required to drive decisions - Ensure solutions are maintainable, scalable, and aligned standards Technical Expertise - Develop advanced analytics solutions using Power BI and DAX - Write and optimize SQL queries for analytical workflows and troubleshooting - Work with business leaders to define, document, and maintain consistent KPI definitions, ensuring metrics are measurable, repeatable, and aligned across reporting and analytics solutions - Partner with Data Engineering to ensure semantic models support reporting and analytics needs - Validate semantic models accurately reflect business processes and operational definitions, providing feedback on structure to ensure usability and performance - Leverage enterprise semantic models to build scalable dashboards, analytics, and insights Team Leadership & Workflow Management - Directly lead and mentor an Analyst responsible for incoming ad hoc requests and analytics intake - Manage workflow prioritization, balancing reactive requests with planned project work - Translate incoming demand into structured backlog items and projects - Identify recurring ad hoc requests and convert them into scalable analytics solutions or reporting assets that improve efficiency and reduce reactive demand Stakeholder Partnership - Partner with business leaders to identify opportunities where analytics can improve operational decision making - Communicate insights through clear storytelling and effective data visualization - Influence mid-level leaders and operational partners through data-driven recommendations Process & Operational Improvement - Continuously improving analytics delivery processes including work intake, prioritization, and solution development - Maintain strong discipline in documentation, governance, and design standards - Support adoption of self-service analytics through training and solution design Image of Success - Analytics solutions are delivered reliably and adopted by partners - Ad hoc requests are effectively managed without disrupting strategic project delivery - The Analyst role develops and becomes increasingly autonomous in managing intake and initial analysis - Solutions follow strong governance standards and have documentation - Business partners view the BI team as trusted advisors in decision makin Skills We Are Seeking - 5-8 years of experience in Business Intelligence, Analytics, or Data Engineering - Experience delivering BI solutions directly with business stakeholders - Demonstrated experience leading projects and mentoring analysts with knowledge of RACI Project Management Terminology - Advanced analytics solutions using Power BI and DAX - Experience writing and optimizing SQL queries for analytical workflows and troubleshooting - Experience managing priorities across multiple initiatives and business units - Bachelor’s degree in business, analytics, computer science, or related field - Wholesale Distribution or Retail Operations support experience preferred Compensation & Benefits: - Competitive Compensation - Medical, Dental and Vision plans - Paid Time Off, Paid Holidays - DailyPay available! - 401k with company match - Tuition Reimbursement - Lucrative Associate Referral Program - Company Apparel and Work Boot Vouchers - Opportunity for Advancement - Paid Training and Business Certifications Available - Free Counseling Services/Employee Assistance Program - Life Insurance and Short- and Long-Term Disability Insurance - Product Discounts - Most Branches never work Sundays! THE INFORMATION CONTAINED HEREIN IS NOT INTENDED TO BE AN EXHAUSTIVE LIST OF ALL RESPONSIBILITIES, DUTIES AND QUALIFICATIONS REQUIRED OF INDIVIDUALS PERFORMING THE JOB. THE QUALIFICATIONS DETAILED IN THIS JOB DESCRIPTION ARE NOT CONSIDERED THE MINIMUM REQUIREMENTS NECESSARY TO PERFORM THE JOB, BUT RATHER AS GUIDELINES. THEY MAY VARY FROM POSITION TO POSITION. SiteOne Landscape Supply is strongly committed to providing equal employment opportunities for all associates and all applicants for employment. All employment decisions at SiteOne-including those relating to hiring, promotion, transfers, benefits, compensation, placement, and termination-will be made without regard to race, color, national origin, genetic information, creed, sex, sexual orientation, gender, gender identity, religion, age, veteran status, uniform service, pregnancy, disability, or any other factor protected by applicable law. If you are ever unsure whether a message is really from SiteOne, here’s how to protect yourself from recruiting scams: - SiteOne will never ask for payment, sensitive personal info, or documents over email, messaging apps., or interviews - All SiteOne job openings and updates will be posted on our official careers page: https://careers.siteone.com/ - SiteOne job related emails will be sent with a @siteone.com. All other variations are likely fraudulent. - You can always reach our SiteOne team directly at Recruiting@siteone.com to confirm Starting pay will depend on factors such as location and experience, and will always meet or exceed applicable state and local minimum wage laws.

