Business Intelligence Analyst

Xceleration Partners LLC • Charlotte, NC

12d

About The Position

The Business Intelligence Analyst owns the analytics layer behind client recognition and incentive programs on Xceleration’s RewardStation platform. This is a hands-on build role focused on modeling program data, creating and maintaining client-facing and internal dashboards, and using AI tools to accelerate analytics work while validating outputs and remaining accountable for the results.

The role designs reusable data models and semantic layers, develops documented SQL transformations and automated data-quality checks, and investigates questions to turn findings into clear recommendations. It also contributes to BI platform migration and modernization, maintains metric and data documentation, and handles client data in accordance with privacy and security requirements.

Xceleration describes itself as a small, collaborative team with direct communication and an emphasis on using AI to increase leverage. Its company culture is called CARE: Collaborative, Adaptable, Respectful, and Efficient.

Requirements

• 3–5 years of experience in business intelligence, analytics engineering, or data analysis; SaaS or B2B platform experience is preferred.
• Advanced SQL, with T-SQL required, and solid data-modeling fundamentals.
• Production experience with at least one modern BI tool: Sisense, Power BI, Tableau, or Looker, including semantic-layer design.
• Working knowledge of Python for analysis and automation, such as pandas or similar, and comfort with Git-based workflows.
• Daily, hands-on use of AI assistants such as Claude, ChatGPT, or Copilot in analytics work, with the judgment to identify incorrect outputs.
• Proactive ownership, including the ability to translate vague business needs into specifications and completed work.
• Clear written and verbal communication with non-technical stakeholders.

Nice To Haves

• Columnar-engine experience such as DuckDB or Snowflake.
• dbt or similar transformation-framework experience.
• Experience with ELT patterns on cloud storage such as S3 or on a cloud warehouse.
• DuckDB or MotherDuck experience and exposure to MCP-based or agentic data tooling.
• SSIS or legacy ETL experience, particularly for migration work.
• Jira or Confluence experience.
• Experience in employee recognition, incentives, or HR technology.

Responsibilities

• Design and maintain data models and semantic layers, including star schemas and metric definitions, to make program data reliable and reusable across reports.
• Build, version, and document SQL transformations; implement automated data-quality checks and resolve issues when they occur.
• Develop and maintain client-facing and internal dashboards in the BI platform.
• Standardize KPIs for participation, engagement, redemption, and program ROI.
• Use LLM tools and AI-connected data agents to draft and review SQL, produce first-pass analyses and narrative summaries, and automate recurring reporting; validate AI output before client delivery.
• Investigate client and program questions, identify trends, and communicate recommendations to account, product, and leadership teams.
• Contribute to BI platform migration and modernization by migrating reports, retiring legacy artifacts, and improving performance.
• Maintain the data dictionary and metric documentation, and handle client data in line with privacy and security requirements.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed