Senior BI & Insights Consultant

Executive-Facing Analytics & Visualization Leader

Founded in 2002, Source Allies is an agile, team-based technical consultancy focused on building industry-defining data and cloud-native solutions. We partner closely with enterprise clients to design, build, and evolve modern data ecosystems that drive measurable business outcomes.

We are seeking a Senior BI & Insights Consultant who thrives at the intersection of data, design, and executive communication. This is not a pipeline engineering role. This is a storytelling and insight leadership role.

You will work with teams consuming curated, enterprise-scale data products and transform them into clear, compelling, executive-ready dashboards and narratives that shape decision-making across digital and operational domains.

You will work downstream of multiple enterprise data product teams, owning visualization quality, executive reporting, and stakeholder communication across digital applications and operational metrics.

You will not own the upstream data pipelines or core enterprise data models. Instead, you will partner closely with data engineers and stakeholders to ensure curated data is translated into trusted insight.

• Build and maintain scalable, trusted dashboards (primarily in Power BI)
• Create executive- and user-ready reporting artifacts
• Translate complex datasets into intuitive, actionable narratives
• Help leaders understand not what the data says, but what it means

Own Visualization Quality & Storytelling

• Apply strong visual storytelling and report design best practices
• Continuously improve clarity, usability, and adoption of reporting assets

Shape Data for BI Consumption

• Perform final aggregation, shaping, validation, and tuning of large datasets
• Use SQL to transform and wrangle data (often tens of millions of rows)
• Ensure reporting datasets are reliable, performant, and fit-for-purpose
• Apply light data engineering practices focused on downstream optimization

Partner with Stakeholders

• Collaborate closely with product, operations, and analytics leaders
• Explain joins, DAX logic, assumptions, and limitations in business language
• Proactively communicate timelines, tradeoffs, blockers, and data nuances
• Serve as a trusted advisor in discussions about performance and adoption metrics

• 3+ years building interactive Power BI dashboards for business stakeholders
• Demonstrated expertise in data visualization best practices, storytelling, and modern UI/UX design
• 3+ years of SQL experience transforming, validating, and shaping large datasets
• Experience preparing datasets specifically for BI and executive consumption
• Proven ability to communicate complex data concepts clearly to non-technical audiences
• Comfort presenting to senior leaders and facilitating insight-driven conversations

• Tableau experience (particularly in transition environments)
• Experience working with curated enterprise data products

• Not a heavy data engineering or pipeline ownership role
• Not an API development position
• Not isolated from stakeholders

This role is insight-forward, communication-heavy, and focused on clarity and usability.

• Operators rely on your reporting for decision-making
• Data assumptions are transparent and well-understood
• Complex digital and operational metrics become intuitive
• Reporting assets are scalable, maintainable, and widely adopted
• The pay range for this position is $90-$110/hr dependent on experience
• Expected collaboration with cross-functional enterprise teams
• Hybrid / onsite expectations may apply depending on client needs