Sr. Business Intelligence Analyst

Larson Design Group; Cranberry Township (Butler County); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Flexible work environment

Paid training for licensures

Competitive benefits

Bonus plans

Company-funded ESOP

Job summary

Larson Design Group is seeking a Senior Business Intelligence (BI) Analyst to enhance their data strategy by leading BI development and designing analytical solutions. You will collaborate with leadership to shape data-driven decision-making across the organization.

The ideal candidate possesses over 5 years of BI experience, strong proficiency in Power BI and SQL, and a background in professional services. This role offers a dynamic work environment with opportunities for professional growth and development.

Qualifications

• 5+ years of experience in BI or data analytics.
• Experience in A/E or professional services environments preferred.
• Professional certifications in BI or analytics strongly preferred.

Responsibilities

• Leads the design and optimization of BI dashboards and reporting systems.
• Partners with leadership to define analytics strategy and initiatives.
• Ensures high-quality enterprise reporting through advanced data validation.

Skills

Power BI

SQL

Data Analytics

Cloud Solutions (Azure/AWS)

ETL/ELT Processes

Data Modeling

Leadership

Education

Bachelor's degree in Data Analytics or related field

Tools

Tableau

ERP Systems

CRM Systems

Job description

United States, Pennsylvania, Cranberry Township

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 shapingdatadrivendecision making across the organization.

Reporting to the Director - Business Intelligence, this role partners closely withcrossfunctionalleaders to define analytic needs, architect data models, oversee complex reporting solutions, and ensure LDG's BI environmentoperateswith accuracy, reliability, and governance discipline.

The Senior BI Analyst combines deep technicalexpertise, 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 asubjectmatterexpert 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 ensurehighqualityenterprise reporting.
• Overseesdocumentation of BI systems, data models, workflows, governance standards, and future-state architecture.
• Designs and enhances complex queries, ETL/ELT processes, data pipelines, andcrossplatformintegrations.
• Provides guidance and mentorship to analysts, offering technical review andbestpracticerecommendations.
• Leads stakeholder engagements to define business requirements, evaluate reporting needs, and develop actionable insights.
• Conducts indepth analysis of operational, financial, and projectbased performance data; delivers executiveready insights.
• Drives improvements to ERP, CRM, project performance dashboards, and contract management reporting systems.
• Researchesemerging analytics tools, technologies, andpractices;recommends enhancements to data architecture and BI strategy.
• Develops andmaintainsrobust application interfaces thatintegrate AI capabilities(e.g.,RAG pipelines,LLM APIs) into new and existing software architectures.

Education and Experience

• Education:Bachelor's degree in DataAnalytics, Information Systems, Computer Science, Business, or related field preferred
• Experience:5+ yearsof 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)stronglypreferred.

Preferred Qualifications

• Expert-levelproficiencywith 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 andcloudbaseddata solutions (Azure/AWS).
• Deep understanding of ERP, CRM, and operational systems (DeltekVision/Vantagepoint a strong plus).
• Experiencedeveloping withand integrating AI tooling into existing code basisis stronglypreferred.
• Demonstrated ability to create andmaintaintechnical documentation and governance artifacts.
• Strong analytical,criticalthinking, andproblemsolvingabilities.
• Proven ability to communicate complex findings to executives andnontechnicalaudiences.
• Demonstrated leadership, mentoring, andprojectmanagementcapabilities.
• Ability to manage complex,crossfunctionalinitiatives with multiple stakeholders.

EEO Statement

Larson Design Group, Inc. is an Affir