Business Intelligence Analyst in Cranberry Township, Pennsylvania at Larson Design Group

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 Business Intelligence (BI) Analyst supports the development, enhancement, and maintenance of LDG’s BI environment. This role transforms raw data into meaningful insights that improve operational efficiency, inform strategic decision making, and support overall business growth.
Reporting to the Director – Business Intelligence, the BI Analyst collaborates with stakeholders across the organization to gather requirements, validate data, document systems, and develop dashboards, datasets, and analytical tools. This position blends analytical thinking, technical skill, and communication to help ensure LDG’s data assets and reporting systems are accurate, well documented, and aligned with governance standards.

Key Responsibilities

• Develops, maintains, and optimizes dashboards, reports, datasets, and visualizations supporting operational performance and strategic planning.
• Collaborates with the Director – Business Intelligence on scaling and modernizing LDG’s BI environment, including databases, reporting solutions, and integration tools.
• Gathers and documents business requirements to ensure analytics solutions meet user needs.
• Assists in documenting BI tools, data models, workflows, and processes to support knowledge continuity.
• Performs data validation, quality checks, and troubleshooting to ensure accurate reporting and analytics.
• Supports data governance efforts by maintaining metadata, naming conventions, field definitions, and data lineage.
• Develops queries, views, and datasets for analysis, ETL processes, and cross‑system integrations.
• Partners with internal stakeholders to translate business questions into actionable insights.
• Conducts ad hoc analysis and delivers clear summaries of business performance and trends.
• Assists with system and process improvements related to ERP, CRM, project performance dashboards, and contract reporting.
• Stays current with BI and analytics best practices, recommending improvements to tools and processes.
• Develops and maintains application interfaces and testing protocols 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 a related field preferred. Equivalent experience considered.
• Experience: Minimum of 2 years in data analytics, reporting, BI, or related technical fields. A/E or professional services industry experience is a plus.
• Certifications: BI or analytics tool certifications (Power BI, Tableau, SQL, Azure, AWS) preferred.

Preferred Qualifications

• Experience with BI tools such as Power BI (preferred) or Tableau.
• Strong SQL skills and knowledge of relational databases and data modeling.
• Familiarity with ETL/ELT tools, data pipelines, or cloud analytics.
• Experience working with ERP systems (Deltek Vision/Vantagepoint a plus).
• Ability to document systems, data models, and workflows.
• Experience developing with and integrating AI tooling into existing code bases is strongly preferred.
• Strong analytical skills, attention to detail, and commitment to data accuracy.
• Ability to communicate clearly with both technical and non‑technical audiences.
• Ability to manage multiple priorities and meet deadlines.
• Proficiency in Microsoft Office Suite.
• Demonstrated desire for continuous learning.

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.