Business Intelligence Analyst

Job Description

Job Description

At Xceleration, we design employee recognition and reward programs that truly connect people to their work. Our RewardStation® platform is used worldwide for everything from peer-to-peer recognition to service milestones, allowing companies to create experiences that reflect their values and reward employees in meaningful ways. We’re proud to work across more than 90 countries, delivering solutions that adapt to different cultures and work environments. Joining Xceleration means working with cutting-edge technology while being part of a team that values input and collaboration. Our environment is designed to help you grow, contribute, and see your efforts directly impact how companies engage and motivate their employees. If you’re looking for a space where your ideas can shape the future of workplace recognition, Xceleration is the place.

The Business Intelligence Analyst will own the analytics layer behind our client recognition and incentive programs on RewardStation. This role will model program data, build and maintain the dashboards clients and account teams run on, and use AI tooling as a core part of how you work — to move faster on SQL, QA, documentation, and insight, while staying accountable for what the numbers say. This is a hands-on build role, not a reporting-request queue.

What you'll do

• Model the data. Design and maintain data models and semantic layers (star schemas, metric definitions) that make program data reliable and reusable across reports.
• Build the pipelines. Build, version, and document SQL transformations; implement automated data-quality checks and own fixes when something breaks.
• Ship the dashboards. Develop and maintain client-facing and internal dashboards in our BI platform; standardize KPIs for participation, engagement, redemption, and program ROI.
• Work AI-first. Use LLM tools and AI-connected data agents to draft and review SQL, generate first-pass analyses and narrative summaries, and automate recurring reporting. Validate every AI output before it reaches a client.
• Deliver insight. Investigate client and program questions, surface trends, and turn findings into clear recommendations for account, product, and leadership teams.
• Modernize the stack. Contribute to our BI platform migration and modernization: migrate reports, retire legacy artifacts, and improve performance.
• Keep it governed. Maintain the data dictionary and metric documentation; handle client data in line with privacy and security requirements.

What you bring

• Proactive ownership. You find the question before it's asked, turn a vague business need into a spec and a shipped result, and drive the work to done. Clear written and verbal communication with non-technical stakeholders is a given. We're hiring a builder, not an order-taker.
• 3–5 years in business intelligence, analytics engineering, or data analysis, ideally in a SaaS or B2B platform environment.
• Advanced SQL (T-SQL required; columnar engines such as DuckDB or Snowflake a plus) and solid data-modeling fundamentals.
• Production experience in at least one modern BI tool — Sisense, Power BI, Tableau, or Looker — including semantic-layer design.
• Working Python for analysis and automation (pandas or similar) and comfort with Git-based workflows.
• Daily, hands-on use of AI assistants (Claude, ChatGPT, Copilot, or similar) in analytics work, with the judgment to catch when they're wrong.

Nice to have

• dbt or similar transformation frameworks; ELT patterns on cloud storage (S3) or a cloud warehouse.
• DuckDB / MotherDuck, and exposure to MCP-based or agentic data tooling.
• SSIS or legacy ETL experience, useful for migration work.
• Jira / Confluence; experience in employee recognition, incentives, or HR tech.

Tools you'll use

Claude, DuckDB / MotherDuck, Python, Git, MCP-connected data tools, Jira / Confluence, SQL Server.

How we measure success

• Dashboards and models are trusted: metric definitions are documented and defect rates fall quarter over quarter.
• Turnaround on client and internal data questions shrinks as AI-assisted workflows and reusable models take hold.
• Migration milestones are delivered on schedule with no loss of client-facing 

How we work

We are a small team. We directly communicate with one another, no layers to route around. Decisions get made in the room. We’re aggressive about AI leverage — not as a talking point, but because a team this size can’t ship what we’re shipping otherwise. We’re a team of bright, driven professionals, each of whom brings unique perspectives, experience, ideas, and skills to our roles. Our company culture means everything to us – we call it CARE (Collaborative. Adaptable. Respectful. Efficient.) Every member of our team works hard to exemplify these qualities in every aspect of the work we do each day.

Xceleration is an Equal Opportunity Employer and we do not discriminate on the basis of actual or perceived race, color, national origin, ancestry, sex (which includes pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), gender, gender identity, and gender expression, religious creed, disability (mental and physical) including HIV and AIDS, medical condition (cancer and genetic characteristics), genetic information, age, marital status, sexual orientation, military and veteran status, denial of family and medical care leave, or any other characteristic protected by federal, state or local law.