Pre-Sales Solution Architect – BI & AI‑Driven Analytics (Power BI, Tableau)

Insight Global; Dunwoody (GA); On-site; USD 100,000 - 140,000; Full time

Job summary

A leading analytics firm is seeking a Solution Architect specializing in Business Intelligence & AI-driven analytics to work in their Dunwoody, GA office. In this role, you will help architect and deliver impactful BI solutions using Power BI and Tableau, while collaborating with clients and internal stakeholders. The position requires 6+ years of experience in BI with strong expertise in Power BI, SQL, and cloud data platforms, alongside a consulting mindset and exceptional communication skills. Expect approximately 50% travel for client engagement.

Qualifications

• 6+ years of experience in BI or analytics roles.
• Advanced understanding of Power BI and Tableau.
• Strong SQL skills and cloud data platform experience.
• Proven ability to translate requirements into dashboards.

Responsibilities

• Lead BI strategy and current-state assessments.
• Design semantic models in BI tools.
• Collaborate with architects to optimize data performance.
• Create executive dashboards and operational reports.
• Facilitate requirements workshops with stakeholders.

Skills

Power BI expertise

Tableau experience

SQL skills

Data modeling

DAX proficiency

Data storytelling

Workshop facilitation

Tools

Snowflake

Databricks

Redshift

Synapse

Job description

Solution Architect – Business Intelligence & AI‑Driven Analytics (Power BI, Tableau)

• Primary location is our Atlanta, GA office; expectation of 4 days per week in office and 1 day remote.
• This is a client‑facing solutioning role with approximately 50% travel for technical workshops, stakeholder discussions, and on‑site collaboration with customers.

About this role

This role centers on architecting modern, AI‑augmented Business Intelligence solutions with Power BI and Tableau to deliver trusted, actionable insights and predictive signals to decision‑makers. You will sit at the intersection of business and data/ML platform teams, shaping semantic models, defining KPIs and features, and designing intuitive, high‑impact analytics and decision‑intelligence experiences.

As a BI Solution Architect within the Data & AI Solutions Team, you will lead clients from requirements and KPI definition through production‑ready dashboards, governed self‑service analytics, and integrated ML/GenAI insights. You will combine deep hands‑on expertise in Power BI/Tableau with strong storytelling and advisory skills, helping organizations make better, faster decisions and selectively apply AI features-such as natural language, automated narratives, and predictive indicators-that enhance insight consumption and business value. You will also help shape and refine our analytics and BI offerings by standardizing KPI and feature frameworks, dashboard patterns, and enablement assets that can be reused across clients.

What you’ll do

• Lead BI and decision‑intelligence strategy and current‑state assessments, and define target‑state architecture for reporting, advanced analytics, and self‑service experiences.
• Design semantic models and datasets in Power BI and Tableau, including dimensional modeling, KPI and feature definitions, and row‑level security to support ML‑ and AI‑driven use cases.
• Collaborate with data and ML platform architects to ensure warehouses, lakehouses, and feature stores are structured for BI performance, trustworthy metrics, and downstream AI consumption.
• Create and review executive dashboards, operational reports, and reusable data sets that surface descriptive, diagnostic, predictive, and prescriptive insights.
• Introduce practical AI capabilities such as natural language query, automated narratives, anomaly detection, and embedded ML/LLM outputs where supported by the BI stack.
• Facilitate requirements workshops and design sessions with business stakeholders; translate their questions and decisions into metrics, features, visuals, and navigation flows.
• Support deal cycles by scoping BI and analytics work, building AI‑enhanced demo dashboards, and contributing to proposals, estimates, and value cases.
• Define and promote BI and analytics governance practices, standards, and documentation, including KPI/feature catalogs, semantic models, and report certification processes.
• Guide delivery teams through design reviews, performance tuning, model‑to‑dashboard integration, and testing to ensure solutions meet usability and performance SLAs.
• Provide mentoring and best‑practice guidance to BI developers, analysts, and power users on advanced analytics, data storytelling, and responsible use of AI‑driven insights.
• Shape and refine our analytics and BI offerings by standardizing KPI and feature frameworks, dashboard patterns, and enablement assets that can be reused across clients.

What you’ll need to succeed

• 6+ years in BI, analytics, or data warehousing roles working with business stakeholders in enterprise environments.
• Advanced, hands‑on expertise with Power BI, including data modeling, DAX, RLS/OLS, workspace management, and governance.
• Strong experience with Tableau (or a comparable enterprise BI tool), including calculations, extracts, and dashboard design and optimization.
• Deep understanding of semantic and dimensional modeling for analytics, including star/snowflake schemas and KPI modeling.
• Strong SQL skills and experience working with cloud data platforms such as Snowflake, Databricks, Redshift, or Synapse.
• Proven ability to run workshops, gather requirements, and translate them into intuitive dashboards and robust semantic models.
• Nice to have: Basic awareness of Databricks and Snowflake internals and how ML/LLM outputs can be surfaced through BI tools.
• Nice to have: Light Python or R exposure for advanced analytics or integration of statistical/ML models into BI solutions.
• Excellent communication, presentation, and data storytelling skills tailored to technical and non‑technical audiences.
• Consulting mindset with experience in scoping and estimation for BI and analytics engagements.