Sr. Business Intelligence Analyst

Reposted Yesterday
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
HQ: Pittsburgh, PA
372 Employees
Year Founded: 1986

What We Do

Larson Design Group is a national, award‐winning provider of Architecture, Engineering, and Consulting services, with a vision to deliver more by elevating our client relationships, enriching the careers and lives of our employee-owners, and enhancing the communities in which we operate. Founded in 1986, we serve clients nationwide. We embrace sustainable growth and provide innovative value‐added solutions with unrivaled depth and breadth of capabilities. We apply our collective passion, vision and expertise to focused opportunities and exercise our core values in everything we do. For more than 30 years, these principles have guided our work and fueled our continued growth. Our core values: CLIENT SERVICE EXCELLENCE | INNOVATION | TEAMWORK | PERFORMANCE | LEARNING | STEWARDSHIP Visit www.larsondesigngroup.com to learn more.

Similar Jobs

Comcast Logo Comcast

Sr. Analyst, Enterprise BI Data Products & Governance

Digital Media • Information Technology • News + Entertainment
Hybrid
Philadelphia, PA, USA
115000 Employees
80K-133K Annually

OpenX Technologies Logo OpenX Technologies

Senior Data Analyst

AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Easy Apply
Remote or Hybrid
US
420 Employees
106K-125K Annually

BNY Logo BNY

Data Analyst

Fintech • Financial Services
In-Office
Pittsburgh, PA, USA
41739 Employees

Similar Companies Hiring

Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
108 Employees
Northslope Thumbnail
Artificial Intelligence • Information Technology • Software • Analytics • Consulting • Generative AI
London, GB
100 Employees
Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account