Data Analyst: Dashboards, Automation & AI Tools

Insight Global; Palo Alto (CA); On-site; USD 93,600 - 124,800; Full time

Job summary

Insight Global is seeking a technical data analyst to own dashboard development and data maintenance across engineering and design management operations in Palo Alto. The role starts hands-on with reporting and data hygiene and grows into automation and cross-tool integration.

You will build and refine Power BI dashboards, ensure data accuracy across systems, and automate data pulls using Python and AI-assisted tools. Collaboration with engineering and SharePoint teams will be key.

Qualifications

• Bachelor's degree in computer science, data analytics, or similar.
• 0–3 years of experience in a data analyst, BI, or related technical role.
• Strong SQL skills.
• Experience with data visualization tools (Tableau, Power BI, etc.).
• Working knowledge of Python for scripting and automation.
• Comfort using AI coding assistants (Cursor, GitHub Copilot, Claude Code, or similar) as part of daily workflow.
• Strong attention to detail and comfort working with imperfect, multi-source data.
• Exposure to API integrations (Microsoft Graph API or similar).
• Familiarity with Power Automate or other low-code automation tools.
• Experience with SharePoint site structure, document libraries, and metadata/tag-based automation.
• Experience with Microsoft Planner, Procore, or similar project/engineering management platforms.
• Basic understanding of data modeling or data warehousing concepts.

Responsibilities

• Build, maintain, and refine dashboards in Power BI to track KPIs across engineering and operations
• Maintain data accuracy and consistency across source systems (MS Planner/Projects, SharePoint, and related tools)
• Write scripts (Python preferred) to automate routine data pulls, cleanup, and reporting tasks
• Use AI-assisted coding tools (Cursor, Copilot, or similar) to accelerate development — comfort with these tools is expected, not optional
• Troubleshoot data discrepancies and flag inconsistencies between systems
• Work independently, apply first principles of thinking to resolve design issues creatively and thoroughly coordinating with engineering counterparts
• Designing and building automations that connect multiple tools (Planner, ACONEX, and related workflows) rather than working within one system at a time
• Identifying and closing efficiency gaps between disparate software systems
• Supporting SharePoint site structure and document management, including automations that organize folders based on document type or metadata tags (e.g., auto-routing files on upload using Power Automate)
• Contributing to a more centralized data structure (e.g., a shared database or Dataverse) so dashboards pull from one consistent source instead of multiple live connections

Job description

Insight Global is seeking a technical data analyst to own dashboard development and data maintenance across engineering and design management operations in Palo Alto. The role starts hands-on with reporting and data hygiene and grows into automation and cross-tool integration.

You will build and refine Power BI dashboards, ensure data accuracy across systems, and automate data pulls using Python and AI-assisted tools. Collaboration with engineering and SharePoint teams will be key.