Business Intelligence Analyst
About The Position
CrossCountry Consulting is hiring a Business Intelligence Analyst to work with business stakeholders and support its modern enterprise data warehouse on Snowflake. The role combines dashboard development and data analysis with stakeholder relationships, requirements gathering, and user enablement. The analyst will partner with teams across finance, sales, and operations to turn reporting needs into clear KPIs and actionable insights, and will work with Data Engineering on data models, data quality, and performance. The position also supports the responsible use of AI in analytics by creating business definitions and synonyms, validating AI-generated reports and text-to-SQL results, and helping teams build self-service data skills. The analyst will create documentation, facilitate training, gather feedback, and improve reporting based on adoption and user needs.
Requirements
- At least 5 years of experience in business intelligence, analytics, FP&A, or a similar role.
- Strong dashboarding skills in Power BI, Tableau, or a comparable BI tool.
- Working SQL proficiency, including joins, aggregations, CTEs, and basic window functions.
- Ability to conduct requirements-gathering conversations and turn vague requests into scoped deliverables.
- Hands-on use of AI tools in analytical work and judgment to evaluate output quality and identify unsupported answers.
- Experience facilitating trainings, workshops, or demos for non-technical audiences.
- Excellent written and verbal communication skills, including the ability to explain data clearly.
- Strong attention to detail and a habit of validating numbers before sharing them.
Nice To Haves
- Experience with Snowflake or another cloud data warehouse.
- Familiarity with DAX and dimensional modeling concepts.
- Experience writing business definitions, synonyms, or test cases for AI-driven or natural-language analytics tools.
- Background in finance, FP&A, or sales operations.
- Exposure to dbt, Fivetran, or modern data stack tools.
- Experience building a data community or champions program.
- Bachelor’s degree in Finance, Business, IT, Analytics, or a related field, or equivalent experience.
Responsibilities
- Partner with stakeholders across finance, sales, and operations to understand goals and translate them into requirements and KPIs.
- Scope dashboard projects by defining success criteria, prioritizing requests, setting timelines, and managing expectations.
- Build, publish, and maintain accurate, intuitive, and actionable dashboards and reports in Power BI or Tableau.
- Write SQL against Snowflake to explore data, validate results, and support ad hoc analysis.
- Work with Data Engineering to shape the semantic layer and data models, define KPI and calculation logic, flag data quality issues, and improve report performance and Snowflake costs.
- Build business definitions and synonyms to help AI tools such as Snowflake Cortex Analyst or Power BI Copilot answer questions correctly.
- Test AI-generated reports and text-to-SQL results against known-correct answers before launch.
- Run training sessions, workshops, and office hours to build self-service skills across the business.
- Create user guides, metric definitions, and walkthroughs to help business users trust and navigate data.
- Gather feedback after launch, track adoption, and iterate on dashboards.
Benefits
- Comprehensive healthcare options, including medical, dental, and vision coverage.
- Flexible spending accounts.
- 401(k) with company matching.
- Generous parental and maternity leave policies.
- Technology stipends.
- Wellness reimbursement programs.
- Annual bonus.
