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

Evergreen; Dunwoody (GA); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading data solutions firm is looking for a Solution Architect for Business Intelligence & AI-Driven Analytics in Dunwoody, GA. This role requires expertise in Power BI and Tableau to architect modern BI solutions that provide actionable insights and predictive analytics. You will work closely with clients and cross-functional teams to define KPIs and develop dashboards. With a focus on mentorship, you will also guide teams and ensure solutions meet performance standards, all while facilitating technical workshops and managing client relationships.

Qualifications

• 6+ years in BI, analytics, or data warehousing roles working with business stakeholders.
• Advanced expertise with Power BI, including data modeling and governance.
• Strong SQL skills and experience with cloud data platforms like Snowflake.

Responsibilities

• Lead BI and decision-intelligence strategy assessments.
• Design semantic models and datasets in Power BI and Tableau.
• Collaborate with data architects for BI performance and AI consumption.

Skills

Power BI

Tableau

SQL

Data storytelling

Cloud data platforms

Job description

Overview

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

About this role

This role centers on architecting modern, AIaugmented Business Intelligence solutions with Power BI and Tableau to deliver trusted, actionable insights and predictive signals to decisionmakers. You will sit at the intersection of business and data/ML platform teams, shaping semantic models, defining KPIs and features, and designing intuitive, highimpact analytics and decisionintelligence experiences.

As a BI Solution Architect within the Data & AI Solutions Team, you will lead clients from requirements and KPI definition through productionready dashboards, governed selfservice analytics, and integrated ML/GenAI insights. You will combine deep handson 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 decisionintelligence strategy and currentstate assessments, and define targetstate architecture for reporting, advanced analytics, and selfservice experiences.
• Design semantic models and datasets in Power BI and Tableau, including dimensional modeling, KPI and feature definitions, and rowlevel security to support ML and AIdriven 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 AIenhanced 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, modeltodashboard integration, and testing to ensure solutions meet usability and performance SLAs.
• Provide mentoring and bestpractice guidance to BI developers, analysts, and power users on advanced analytics, data storytelling, and responsible use of AIdriven 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, handson 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 nontechnical audiences.
• Consulting mindset with experience in scoping and estimation for BI and analytics engagements.

Additional information

Primary location is our Atlanta, GA office; expectation of 4 days per week in office and 1 day remote.

This is a clientfacing solutioning role with approximately 50% travel for technical workshops, stakeholder discussions, and onsite collaboration with customers.