Business Intelligence Developer

Shelby American, Inc.; Lawrence (KS); On-site; USD 82,000 - 95,000; Full time

Job summary

An established nonprofit organization is seeking a talented Business Intelligence Developer to join their innovative team. This role offers the opportunity to architect solutions and transform raw data into compelling stories that drive strategic decisions. As a key player in a data-driven environment, you will collaborate with various departments to enhance data quality and governance while also contributing to the overall analytic maturity of the organization. If you are a creative thinker with a passion for data and analytics, this position is perfect for you!

Benefits

100% employer-paid pension plan

Health, dental, and vision insurance

401(k) matching program

Generous paid leave

KU education assistance

Free parking

Qualifications

• 1+ year experience in data analytics or business intelligence role.
• Experience building reliable ETL workflows and data pipelines.

Responsibilities

• Design, build, and maintain dashboards and Tableau Prep flows.
• Work cross-functionally to develop actionable insights.

Skills

Tableau

Data Modeling

ETL Workflows

SQL

Collaboration

Creativity

Education

Bachelor's Degree

Analytics or Computer Science

Tools

Salesforce CRM

Tableau Prep

JIRA

Job description

Description

Department: Development Analytics

Reports to: Assistant Vice President, Advancement Services

FLSA Status: Exempt

The anticipated salary for this position starts at $82,500. The final pay will be determined based on several factors, including qualifications, experience, education, and years within the job or industry, with a strong emphasis on maintaining internal equity.

Who we are and what we’re about:

KU Endowment is an independent, nonprofit organization and the official fundraising foundation for the University of Kansas. We partner with donors in providing philanthropic support to build a greater KU.

As an employee of KU Endowment, you’ll witness firsthand the power of our donors’ generosity. You will join a talented and fun group of people who are inspired to help KU through the support of loyal alumni and friends. This support fuels excellence, enabling students and faculty to develop innovative programs and research that distinguish the university. We connect the philanthropic passions of donors with the needs of students, faculty and programs – and everyone benefits.

People are engaged. Purpose is ignited. Lives are changed.

What we are looking for:

Are you a data artist with a technical edge? A Tableau wizard who sees patterns where others see chaos? KU Endowment is embarking on a data-driven future and we’re calling on technically inclined, curious, creative minds to help us design, build, and launch the tools needed to turn our team into an industry leading data shop.

We’re seeking a highly skilled Business Intelligence Developer to join our Business Intelligence team. This is more than a dashboard role, it's your chance to architect solutions, wrangle data, and power strategic decisions across our organization. You’ll dive deep into Tableau and Tableau Prep, optimize performance, build seamless workflows, and turn raw data into stories that move our mission forward.

If you’ve got a handle on data modeling, and light up during brainstorming sessions to unravel complex questions—especially within Salesforce CRM environments like Ascend/Affinaquest—we’re already intrigued. Bonus points if you dabble in SQL/SOQL, ETL, tinker with AI tools, or know a thing or two about Python, R, or data warehouse architecture.

But here’s the thing: While technical chops are essential, we’re really looking for that spark! We want creative dreamers and data enthusiasts, the one who brings a little weirdness to their work in the best way possible. If you can jazz up your technical projects with a creative touch, see data not just as numbers but as living stories, and secretly dream about becoming a data scientist then you might be the ace up our sleeve.

This role isn’t for someone who wants to follow the script. We’re building this department from the ground up, and we’re looking for enthusiastic partners who get excited about starting with nothing and shaping something meaningful.

The individual in this position is expected to embrace KU Endowment’s stated core values – collaboration, curiosity, empowerment, and excellence – and demonstrate support for them through professional interactions and activities.

What’s a typical day look like?

• (50%) Be one of KU Endowment’s go-to Tableau minds designing, building, and maintaining dashboards and Tableau Prep flows that are not only accurate and informative, but useful and beautiful.
• (20%) Work cross-functionally to help departments develop actionable insights that drive efficiency and strategic thinking, automate routine tasks, and dream.
• (20%) Support broader BI initiatives: data exploration, ETL development, campaign insights, donor segmentation, documentation, governance, and overall advancement of KU Endowment’s analytic maturity.
• (10%) Brainstorm, learn, and experiment alongside a team that’s genuinely excited about finding new tools, learning new things, testing provocative ideas, and unlocking hidden value through creative tech.
• Partner directly with fundraisers, researchers, and senior leaders to define data needs and co-create solutions that solve real-world challenges in smart, creative ways.
• Bring giving data, donor segmentation, and marketing personas to life through thoughtful reporting that empowers action and sparks strategy.
• Uphold high standards of data quality and stewardship, with a strong sense of accountability and an eye for clean documentation.
• Help shape a collaborative, curiosity-driven culture—share knowledge, celebrate creativity, and lift up your teammates.
• Regular and reliable attendance is essential for this position.
• Performs other duties as may be assigned.

What’s required to be considered:

• Bachelor’s degree (flexible on field, but extra credit for Analytics, Computer Science, or Liberal Arts)
• At least one year of hands-on experience in a data analytics or business intelligence role
• Proven ability to build reliable ETL workflows and data pipelines—especially with Tableau Prep or similar tools
• A fast learner who can start producing in Tableau and Tableau Prep ASAP
• A great collaborator with a positive attitude who enjoys partnering across teams, contributing ideas, and bringing a little bit of joy to complex work
• Preferred qualifications:
  • At least five years of experience working with data analytics or business intelligence tools
  • Experience with Salesforce CRM, particularly Ascend or Affinaquest. Other CRM experience is valuable
  • Experience with Salesforce CRM-A/Standard Reporting
  • Experience with ETL processes, data modeling, and maintaining data hygiene and governance. You won’t be doing this forever, but right now it is important.
  • Ability to talk intelligently about data warehouse architecture, Tableau flows, and CRM Analytics.
  • Experience supporting fundraising or sales environments
  • Demonstrated creativity in analytics delivery, storytelling, or dashboard design
  • Certifications in Tableau or analytics-related tools
  • Proficiency in SQL, with additional experience in SOQL, Python, or R a plus
  • Past dashboard or reporting portfolio (encouraged, not required)

What separates the best from the rest?

• Light up in team settings, build trust effortlessly, and love making others look good
• Get curious, go deep, and ask “what if?” more than most
• Bring something really cool that we didn’t see coming and can show us why it matters
• Have experience with JIRA, and know how to keep a project moving without getting bogged down
• Understand the ins and outs of data governance, quality assurance, and how to keep things clean behind the scenes
• Are comfortable working with APIs, connectors, and third-party integrations to pull together data from across platforms
• Thrive in environments where the blueprint is still being sketched (and you’re alongside us holding a pen)
• Ability to establish and maintain professional and effective working relationships inside and outside KU Endowment.
• Ability to adapt to new procedures and technology.
• Deep expertise in Tableau—not just as a visualization tool, but as a platform for modeling, analysis, and insight delivery
• High degree of creativity and abstract thinking, with the ability to ask the right questions and design novel solutions
• Strong visual and verbal communication skills for presenting data in a compelling, accessible way
• Comfort working both independently and collaboratively in a fast-paced, mission-driven environment

Physical Requirements:

• A valid driver’s license.
• Must have access to reliable transportation to travel between multiple locations for training, donor meetings, networking, events and/or work-related activities.
• Must be able to respond quickly and effectively to directions and safety hazards.
• This job operates in a professional office environment. This role routinely uses standard office productivity machinery such as computers, keyboards and a mouse, laptops, phones, photocopiers, filing cabinets and fax machines.
• This is largely a sedentary role; however, some filing is required. This would require the ability to move files, open filing cabinets and bend or stand as necessary.
• The ability to observe details at close range (within a few feet of the observer).
• The person in this position frequently communicates with donors, colleagues, students, and general public. Must be able to communicate with others effectively.
• Physical effort/lifting: sedentary- up to 10 pounds
• Rare travel requirements can include the following, evenings, weekends, and out of town overnights as a regular part of the job.

We’ve got you covered:

KU Endowment offers a competitive salary with an excellent benefit package including:

• 100% employer-paid pension plan
• Health, dental, and vision insurance
• 401(k) and Roth 401(k) matching program
• Section 125 flexible benefits
• Generous paid leave including holidays, personal and sick leave
• Volunteer and community engagement opportunities
• Paid Parental Leave
• Life, AD&D, short- and long-term disability insurance
• Legal & ID Theft protection
• Critical Illness
• Accident and Hospital Indemnity insurance
• KU education assistance
• Free parking

Sounds good, right? What’s next?

Please include your resume and cover letter when applying for this position on our website at https://www.kuendowment.org/careers.

Questions regarding this vacancy may be addressed to:

Emily Garcia

Sr. Human Resources Associate
KU Endowment
PO Box 928
Lawrence, KS 66044-0928
Email: [e-mail]

Review of applications begins immediately and continues until the position is filled. Because of the sensitive nature of KU Endowment business and the importance of our reputation with donors, KU Endowment conducts a comprehensive review of applicants. By submitting your application, you authorize us to conduct reference checks and a review of available public information. Employment is contingent upon background and reference checks that KU Endowment finds acceptable.