Lead BI Engineer

SOLTECH; Alpharetta (GA); On-site; USD 120,000 - 170,000; Full time

Job summary

SOLTECH in Alpharetta, GA seeks a Lead BI Engineer to own the enterprise Power BI semantic models, DAX development, RLS, and governance. This AI-first role uses Claude Code and an established multi-repository framework to deliver scalable BI solutions and Snowflake extensions for enterprise analytics.

The candidate will mentor teammates, collaborate with data engineering, and ensure high-quality AI-assisted code before deployment, driving reporting capabilities for business users.

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.
• Experience implementing Row-Level Security (RLS) and administering Power BI workspaces.
• Experience preparing semantic models for Power BI Copilot through optimized metadata and relationships.

Responsibilities

• Maintain and optimize Power BI semantic models (TMDL/Model.bim, DAX, M) and govern workspaces.
• Develop and optimize DAX measures and Power Query transformations; improve model performance.
• Design, implement, and manage Row-Level Security (RLS).
• Administer Power BI workspaces with governance, permissions, and lifecycle management.
• Keep models aligned with upstream Snowflake GOLD-layer changes and BI needs.
• Provide guidance and support to report developers and business users.
• Enhance models for Power BI Copilot through metadata and naming conventions.

Skills

Power BI

DAX

Power Query (M)

RLS

Tabular Editor

Tools

Snowflake

Claude Code

GitHub Actions

Jira

Job description

3rd Party Candidates will NOT BE CONSIDERED!

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‑
• 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.