Business Intelligence & Data Solutions Architect

Overview

Shimmick is seeking a highly experienced and visionary Business Intelligence & Data Solutions Architect to lead the design, governance, and evolution of the company’s enterprise data and application ecosystem. This role combines strategic architecture leadership, hands‑on data engineering, and direct oversight of BI and application development resources to enable reliable, scalable, and actionable analytics across the organization.

This role will work closely with leadership, IT, and business leaders to architect and maintain the SQL Server and data lake environments, translate raw data into meaningful structures, and drive the development of custom applications and reporting tools that support estimating, opportunity evaluation, analytics, and long‑term historical data management.

Backed by over 100 years of expertise and driven by innovation and an entrepreneurial spirit, Shimmick is one of the most dynamic infrastructure builders in the industry. With market leadership in water resources, sustainable transportation, and complex electrical construction, we’re well‑positioned to lead during a time of rapid change. As project delivery models, regulatory frameworks, supply chains, and technology continue to evolve, our ability to stay flexible and agile in our safety approach is essential to our success.

• Lead the design, configuration, and governance of the SQL Server environment, including database structure, performance, security, and access.
• Partner w/ IT staff to provision and maintain SQL Server instances and related infrastructure.
• Establish and oversee robust backup, recovery, and disaster‑recovery strategies to ensure data availability and integrity.
• Collaborate with IT to define standards for patching, upgrades, and environment monitoring.

• Translate data from the data lake and other raw sources into well‑modeled, usable SQL schemas optimized for applications and reporting.
• Ensure data structures support consistent, trusted metrics and align with business terminology and requirements.
• Document data definitions, lineage, and transformation logic to build and maintain trust in enterprise data.

• Design and maintain cyclical data update processes, including job scheduling, orchestration, and performance tuning of refresh and load routines.
• Monitor data refresh health, troubleshoot failures, and continuously improve reliability and performance of data pipelines.
• Own ongoing maintenance of enterprise data assets, including schema evolution, refactoring, and technical debt remediation.
• Define standards and patterns for integrations between source systems, the data lake, and SQL/reporting environments.

• Partner with estimating, operations, and business development teams to design, architect, and oversee custom applications that improve efficiency.
• Provide architectural guidance and hands‑on support for modern web and low‑code applications (e.g., SQL‑backed web apps, Power Apps, and related services).
• Ensure applications are built on scalable, secure, and well‑documented data models that support both operational workflows and analytic needs.
• Promote reusability and standardization of components, integrations, and UI/UX patterns across applications.

• Manage and mentor data analysts, BI developers, and application developers, providing technical direction, code review, and coaching.
• Set and enforce best practices for data modeling, development, testing, deployment, and documentation within the BI and data solutions team.
• Contribute to project intake and prioritization, helping determine which initiatives are pursued and in what sequence based on impact and capacity.
• Play a central role in selecting and evaluating vendors, tools, and platforms related to data, BI, and automation, including participation in proof‑of‑concept efforts.

Minimum Requirements:

• 10+ years of progressive experience in data architecture, enterprise application development, and BI/analytics, with substantial…