Data Analyst

About the Position & Awana:

This position works to advance the ministry of Awana by analyzing data from a variety of sources to provide actionable insights to decision makers in the organization. Collaborating with staff and leaders across the organization, the aim of this role is a greater organizational understanding or “intelligence” around sales, customers, donors, church engagement, marketing efforts, and other ministry drivers or results.

At Awana, we believe true change happens in the communities when children and youth are transformed by the gospel and engaged in Biblical discipleship in the presence of a caring adult. We believe that kids can come to know, love and serve Jesus, following Him for a lifetime. This is why, for 70+ years, Awana has been working with leaders in local churches in the US and around the world, providing solutions that equip these women and men to make disciples in children and youth.

Today, God is using Awana to reach over 6.4 million kids in 135 countries around the world. With over 500,000 equipped leaders in 78,000 clubs/churches, Awana is able to play a vital role in global evangelism and discipleship of children and youth. If you are passionate about being integral to reaching kids with the gospel, join us, and become a part of our global cause.

Hiring Range for this position is: $75,000 to $85,000

What We Are Looking For:

• Exemplary team member and collaborator whose work exceeds the standards of operational and cultural excellence.
• Highly analytical and detail-oriented thinker with ability to analyze large amounts of data using a variety of analytical tools to identify patterns, trends and other insights that will ultimately help Awana equip more leaders to reach more kids with the gospel.
• A proactive, hands-on and motivated self-starter that is always actively curious about what is beneath each layer of data.

Data Analysis & Business Intelligence

• Analyze sales transactions and trends: membership renewals, member vs non-member sales, spend per customer, etc.
• Provide customer insights: individuals vs churches, customer additions and drops.
• Research church engagement: analyze the level of participation across various products and services: Awana Clubs, Brite, events, membership, AwanaGo, donations, etc.; provide insights around historic church engagement trends.
• Analyze donors and donations: giving patterns and trends; help the development team to create and maintain pipeline management tools, reports and dashboards; train team members in their understanding of data; analyze the effectiveness of giving campaigns.
• Assist sales & marketing efforts: provide sales and marketing team with analysis around the effectiveness of marketing campaigns and promotions; assist with dashboards and reports that facilitate good communication/understanding across the organization; equip team with information for customer followup pre/post renewal or add/drop; help the team identify cross-promotional opportunities.
• Provide product reporting and analysis: assist the supply chain team with product analysis - inventory, sales quantities, customer/product relationships and forecasting.
• Generate regular reports and dashboards that provide actionable insights for decision-making, helping the organization optimize both sales and donation strategies.
• Work with leadership to develop and implement key performance indicators to measure the health and success of the organization and strategic sales and donation campaigns.
• Develop data analysis processes that leverage predictive analytics in support of organizational growth.
• Support the monitoring and evaluation of the performance of fundraising activities and sales efforts, providing recommendations for leadership based on data-driven insights.
• Collaborate with the finance team to assist in budget and financial forecasting by providing data-driven projections related to sales and donation trends.
• Collaborate with various departments, including marketing, finance, and program management, to understand their data needs and provide analytical support.

Other Responsibilities

• Act as a primary liaison among technology teams/systems and end users of data; while the role reports directly to finance, there is a strong dotted line to the technology team.
• Drive consistency is the use of data - how it is defined, characterized and presented across the organization.
• Communicate complex data findings in a clear and understandable manner, fostering a data-driven culture within the organization to drive informed decision-making.
• Become the in-house subject matter expert on Awana’s diverse customer/donor/constituent data.

What You Need:

• Minimum 5 years experience as a Data Analyst or similar role.
• Expert skills & knowledge of spreadsheets - Excel and GoogleSheets: Power Pivot, advanced charts, data validation, macros, etc.
• Strong skills and proficiency with data visualization, reporting and developing dashboards.
• Experience and proficiency with Microsoft BI, Domo, Tableau and/or other data analysis, reporting and visualization tools.
• Experience and proficiency with Salesforce is highly desired.
• Experience teaching others how to create queries, reports and dashboards.
• Strong verbal and written communication skills - the ability to assimilate, summarize and communicate technical information in non-technical terms.
• Analytical and highly curious mindset – strong desire to understand how systems, transactions and processes work and willingness to help others gain the same understanding.
• Willingness to jump into projects that are not clearly defined to move them to a process outcome.
• Experience with Awana Club, curriculum, resources, & solutions is a plus.
• Experience with donor-driven organizations is a plus.
• Occasional local and out-of-town, overnight travel may be required.
• PHYSICAL DEMANDS/WORKING CONDITIONS: While performing the duties of this job, you are regularly required to communicate. You are also required to regularly utilize computer equipment (e.g., screens and keyboards) to perform work, and routinely required to move about the work environment (St. Charles office, home office, etc.). Specific vision abilities required by this job include close vision for extended periods of time. This position requires the ability to read, type and interpret numbers efficiently and accurately - and often in high volume.
• Eligibility to work in the United States is required; this position is not eligible for employment visa sponsorship.

What We Offer:

• As a global ministry that equips leaders to reach kids with the gospel and engage them in lifelong discipleship, we also consider how our workforce and employment culture impact the lives of our team members.
• Mission-driven work that changes the lives of children and youth around the world.
• Values of intentional connection, flexibility, family, and community engagement in our culture.
• Remote-first / hybrid work environment, allowing you to do the majority of your work from where it is you call “home”.
• Competitive benefits package, including a variety of programs you can choose from to meet you and your family’s needs. Some of these include medical, dental, & vision medical insurance, paid parental leave, HSA, 401(k) (pre-tax & Roth) retirement saving plans with an organizational match, life and disability insurance, paid vacation & holidays, an employee wellness program, and more!

This Job Description reflects the current assignment of essential functions and is not meant to be all-inclusive. Responsibilities may be assigned or reassigned to this job at any time based on the needs of the organization and may be modified to reasonably accommodate an individual with a disability or for other reasons.