Sr. Business Intelligence Analyst

Posted 4 Days Ago
Be an Early Applicant
Cranberry Township, PA, USA
In-Office
Senior level
Other • Consulting
The Role
Lead design and delivery of scalable BI solutions, data models, dashboards, ETL/ELT pipelines, and integrations. Partner with leadership to define analytics strategy, validate data, produce executive insights, mentor analysts, and integrate AI capabilities into data architectures.
Summary Generated by Built In

About Us

Larson Design Group (LDG) is an award-winning, employee-owned Architecture, Engineering, and Consulting Firm. Guided by our core values, we’re expanding our team, opening new offices, and adding new offerings to provide responsive, innovative solutions to clients nationwide.   

Being 100% employee-owned directly impacts our culture: it drives our decision-making, motivates our teams, increases our productivity, improves retention, and contributes to the future success of our company. Our culture is one where we work hard for our clients and for each other – and we have fun collaborating, sharing experience and expertise, and learning along the way. We’re passionate about delivering exceptional quality, elevating client relationships, enriching the careers and lives of our employee owners, and enhancing the communities where we live and serve.     

At LDG, we strive to create an organization where people want to work. We offer a flexible work environment, paid training for required licensures, competitive benefits, bonus plans, and a company-funded Employee Stock Ownership Plan (ESOP) while supporting your professional and personal growth.    

Your Opportunity + Impact

The Senior Business Intelligence (BI) Analyst plays a key role in advancing LDG’s data strategy by designing scalable analytics solutions, leading BI development initiatives, and shaping data‑driven decision making across the organization. 

Reporting to the Director – Business Intelligence, this role partners closely with cross‑functional leaders to define analytic needs, architect data models, oversee complex reporting solutions, and ensure LDG’s BI environment operates with accuracy, reliability, and governance discipline. 

The Senior BI Analyst combines deep technical expertise, strong business acumen, and the ability to mentor others while driving continual improvement in LDG’s data and analytics ecosystem.

Key Responsibilities

  • Leads the design, development, and optimization of advanced dashboards, datasets, reporting architectures, and analytical models.
  • Serves as a subject‑matter expert in BI tools, data modeling best practices, and system integrations. 
  • Partners with leadership to define analytics strategy, prioritize initiatives, and ensure alignment with organizational goals. 
  • Performs advanced data validation, auditing, and troubleshooting to ensure high‑quality enterprise reporting. 
  • Oversees documentation of BI systems, data models, workflows, governance standards, and future-state architecture.
  • Designs and enhances complex queries, ETL/ELT processes, data pipelines, and cross‑platform integrations.
  • Provides guidance and mentorship to analysts, offering technical review and best‑practice recommendations.
  • Leads stakeholder engagements to define business requirements, evaluate reporting needs, and develop actionable insights. 
  • Conducts in‑depth analysis of operational, financial, and project‑based performance data; delivers executive‑ready insights. 
  • Drives improvements to ERP, CRM, project performance dashboards, and contract management reporting systems.
  • Researches emerging analytics tools, technologies, and practices; recommends enhancements to data architecture and BI strategy.
  • Develops and maintains robust application interfaces that integrate AI capabilities (e.g., RAG pipelines, LLM APIs) into new and existing software architectures. 

Education and Experience

  • Education: Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, or related field preferred
  • Experience: 5+ years of experience in BI, data analytics, reporting, or related technical fields. Experience in A/E or professional services environments preferred. 
  • Certifications: Professional certifications in BI or analytics (Power BI, Tableau, SQL, Azure, AWS) strongly preferred. 

Preferred Qualifications

  • Expert-level proficiency with Power BI (preferred), Tableau, or other enterprise BI tools. 
  • Advanced SQL skills and strong understanding of relational, dimensional, and semantic data modeling. 
  • Experience designing and managing ETL/ELT processes and cloud‑based data solutions (Azure/AWS). 
  • Deep understanding of ERP, CRM, and operational systems (Deltek Vision/Vantagepoint a strong plus). 
  • Experience developing with and integrating AI tooling into existing code bases is strongly preferred. 
  • Demonstrated ability to create and maintain technical documentation and governance artifacts. 
  • Strong analytical, critical‑thinking, and problem‑solving abilities. 
  • Proven ability to communicate complex findings to executives and non‑technical audiences. 
  • Demonstrated leadership, mentoring, and project‑management capabilities. 
  • Ability to manage complex, cross‑functional initiatives with multiple stakeholders. 
  • Proficiency in Microsoft Office Suite. 

EEO Statement

Larson Design Group, Inc. is an Affirmative Action and Equal Opportunity Employer (EEO) that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization.

Skills Required

  • 5+ years of experience in BI, data analytics, reporting, or related technical fields
  • Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business, or related field
  • Professional certifications in BI or analytics (Power BI, Tableau, SQL, Azure, AWS)
  • Expert-level proficiency with Power BI, Tableau, or other enterprise BI tools
  • Advanced SQL skills and strong understanding of relational, dimensional, and semantic data modeling
  • Experience designing and managing ETL/ELT processes and cloud-based data solutions (Azure/AWS)
  • Experience with ERP, CRM, and operational systems (Deltek Vision/Vantagepoint a strong plus)
  • Experience developing with and integrating AI tooling (RAG pipelines, LLM APIs) into code bases
  • Ability to create and maintain technical documentation and governance artifacts
  • Demonstrated leadership, mentoring, and project-management capabilities
  • Proficiency in Microsoft Office Suite
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
372 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account