Sr. Business Intelligence Analyst at Larson Design Group

Cranberry, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

19 Sep, 26

Salary

123000.0

Posted On

21 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, Tableau, SQL, Data Modeling, ETL/ELT Processes, Azure, AWS, AI Integration, RAG Pipelines, LLM APIs, Data Validation, Stakeholder Management, Technical Documentation, Project Management, Business Intelligence Strategy, Microsoft Office Suite

Industry

Civil Engineering

Description

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.

Responsibilities

The Senior BI Analyst leads the design and optimization of advanced dashboards, data models, and reporting architectures to drive data-driven decision making. They partner with cross-functional leaders to define analytics strategies and integrate AI capabilities into existing software architectures.