Lead Power BI Engineer

SOLTECH; Alpharetta (GA); On-site; USD 130,000 - 190,000; Full time

Job summary

SOLTECH seeks a Lead BI Engineer to own ongoing Power BI semantic models and drive data analytics strategy. The role emphasizes AI-assisted development with Claude Code and governance across BI workspaces, while contributing to Snowflake GOLD-layer enhancements.

You will mentor teammates, optimize DAX/Power Query, and ensure data quality from Snowflake to semantic models for enterprise reporting.

Qualifications

• 7+ years of BI experience with enterprise models.
• 3+ years building and maintaining Power BI semantic models.
• Expertise in DAX, Power Query, and dimensional modeling (Kimball).
• Experience with Snowflake data warehouse and cloud data modeling.
• Hands-on AI-powered coding environments (Claude Code) in daily workflows.
• Knowledge of RLS, workspace governance, and BI governance best practices.
• Ability to mentor teammates and communicate with technical and non-technical stakeholders.

Responsibilities

• Maintain and optimize enterprise Power BI semantic models (TMDL/Model.bim).
• Develop DAX measures, calculated columns, Power Query transformations, and optimize model performance.
• Design and manage Row-Level Security and BI workspace governance.
• Administer BI workspaces with governance, permissions, and lifecycle management.
• Align semantic models with Snowflake GOLD-layer changes and downstream reporting.
• Provide guidance, documentation, troubleshooting, and support to report developers.
• Mentor teammates on BI practices and AI-assisted development workflows.

Skills

Analytical thinking

Mentoring

AI-assisted development

Communication

Tools

Power BI

DAX

Power Query (M)

TMDL/Model.bim

Tabular Editor

Claude Code

Snowflake

Jira

Job description

3rd Party Candidates will NOT BE CONSIDERED!

Must live in the Atlanta Metro area!

Our client is seeking an experienced Lead Business Intelligence (BI) Engineer to join their Data & Analytics team in a full-time capacity. This role combines two key responsibilities:

• Primary: Own the ongoing maintenance and optimization of enterprise Power BI semantic models, including TMDL/Model.bim, DAX development, relationships, row-level security (RLS), and workspace governance.
• Secondary: Contribute to the continued development of a Snowflake data warehouse by extending GOLD-layer dimensional models (facts and dimensions) that support enterprise analytics and reporting initiatives.

This is an AI-first engineering role where modern AI-assisted development practices are central to the team's workflow. The successful candidate will use Claude Code as the primary development environment, leveraging an established multi-repository framework that includes project-specific context, reusable development skills, AI-assisted code orchestration, and integrated tools for Snowflake, SQL Server, and Jira. Candidates should be comfortable working within AI-assisted development environments and taking full ownership of the quality, accuracy, and maintainability of AI-generated solutions.

Key Responsibilities

• Maintain and enhance enterprise Power BI semantic models using TMDL/Model.bim and Tabular Editor.
• Develop and optimize DAX measures, calculated columns, Power Query (M) transformations, and semantic model performance.
• Design, implement, and manage Row-Level Security (RLS).
• Administer Power BI workspaces, including governance, permissions, lifecycle management, and naming standards.
• Ensure semantic models remain aligned with upstream Snowflake GOLD-layer changes.
• Provide guidance, documentation, troubleshooting, and support to report developers and business users.
• Optimize semantic models for Power BI Copilot, including metadata, naming conventions, relationships, descriptions, synonyms, and Q&A capabilities to improve natural language interactions.

Snowflake Data Warehouse Development

• Extend and maintain GOLD-layer dimensional models, including fact and dimension tables, to support evolving business requirements.
• Apply Kimball dimensional modeling best practices throughout the analytics ecosystem.
• Collaborate closely with the data engineering team to implement well-defined warehouse enhancements.
• Validate end-to-end data quality from Snowflake through semantic models and downstream reporting solutions.

AI-Assisted Development

• Utilize Claude Code as the primary development environment for Power BI, DAX, semantic modeling, and Snowflake development.
• Leverage existing AI workflows, reusable skills, validation scripts, and multi-repository orchestration to improve development efficiency.
• Expand and maintain the team's reusable AI skill library and development standards as best practices evolve.
• Utilize integrated tools for Snowflake, SQL Server, and Jira within the AI development environment.
• Review, validate, and take full ownership of AI-assisted code before deployment.
• Collaborate with cross-functional teams on multi-repository changes and technical impact assessments.
• Mentor team members on Business Intelligence best practices as well as AI-assisted development workflows.

Required Qualifications

• 7+ years of Business Intelligence experience.
• 3+ years of hands-on experience developing and maintaining Power BI semantic models.
• Advanced expertise with:
• Power BI
• DAX
• Power Query (M)
• TMDL/Model.bim
• Tabular Editor
• Experience designing and maintaining dimensional data models within a cloud data warehouse, preferably Snowflake.
• Deep understanding of Kimball dimensional modeling methodologies.
• Hands-on experience using Claude Code or comparable AI-powered coding platforms (such as Codex CLI or GitHub Copilot CLI) in daily software development workflows.
• Ability to evaluate, explain, and take ownership of AI-assisted development output.
• Experience implementing Row-Level Security (RLS) and administering Power BI workspaces.
• Experience preparing semantic models for Power BI Copilot through optimized metadata, relationships, and natural language capabilities.
• Experience collaborating with data engineering teams on enterprise data warehouse development.

Preferred Qualifications

• Experience building or extending AI development tooling, including reusable skills, MCP servers, or AI agent configurations.
• Experience with GitHub Actions, CI/CD pipelines, and GitHub-based code review processes.
• Exposure to SSRS or migrations from legacy SSAS environments.
• Experience with Azure Data Factory or comparable ELT/orchestration platforms.
• Background supporting financial services, nonprofit, foundation, or philanthropic organizations.

Desired Skills & Attributes

• Strong analytical and problem-solving abilities.
• Demonstrated commitment to validating and testing AI-assisted work before deployment.
• Comfortable working in rapidly evolving technical environments and continuously improving engineering practices.
• Passion for documenting standards, reusable workflows, and development best practices.
• Self-motivated with excellent judgment and decision-making skills.
• Strong written and verbal communication skills with both technical and non-technical stakeholders.
• Collaborative mindset with experience mentoring teammates and promoting engineering excellence.