Data Analyst

This position is critical to the ministry of Sky Ranch and contributes directly to our mission of leading youth and families to know and follow Christ. The Data Analyst reports to the Director of Information Services and Analysis and is globally responsible for managing, maintaining, and supporting the company’s information. This includes supporting the creation, protection, maintenance, and broad-based use of the datasets that make-up the information. Sky Ranch values data that is accurate, timely, easily maintained, and actually used. To ensure this, the role will be the strategic owner of key systems, champion controls and processes, manage integration projects, create, and maintain data libraries, discover and recommend key metrics, create reports, monitor user data creation and maintenance, and support the reporting needs across all departments and functions.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Data & Systems Management

Consolidate and maintain historical data

Create and enforce company-wide process and controls to ensure clean data

Create and maintain automation between systems utilizing APIs or automation tools such as Power Automate, Zapier, etc.

Implement new platforms and functionality

Reporting

Maintain a global reporting strategy

Identify key reports, KPIs, metrics by department, function, user, etc.

Consolidate and maintain reporting dissemination (duplicates, DNUs, user access, etc.)

Align data to support reporting strategy

Train users on how to use, create, and run reporting

Sample Areas of Focus

Guests (counts, retention, surveys, etc.)

Donors (restrictions, appeals, lists, etc.)

Operations (calendaring, assets, occupancy, etc.)

Employees (recruiting, retention, training, performance, surveys, etc.)

Sales & Marketing (impressions, market share, comparisons, etc.)

Note : Financial areas will be shared (trends, procurement, budgets, etc.)

Systems Ownership

Research, recommend, implement, and maintain core data platforms

Maintain users and permissions

Implementation, automation and integration advancements

Ensure each platform has an operational owner, back-up plans, and documentation

Drive licensing renewals

Sample systems

CircuiTree

Salesforce

Learning Management System

Performance Management

Ops Calendaring

Maintenance / Assets

Blackbaud - Raiser’s Edge

TalkDesk

ArcGIS

Intacct / Cube

Financial Reporting (shared)

Identify data points and needs to support reporting, metrics, KPIs, etc.

Analyze and provide variances and trend analysis as needed (e.g. revenue, purchasing, guest counts)

Create and maintain KPIs, reports, metrics, and benchmarks across entities, departments, and programs

Implementation automation and integration to centralize data

Perform checks and audits to ensure accuracy

Ongoing / As Needed

Support staff with proactive and requested data / reports

Create and lead training on data, reports, and related systems

Create and distribute documentation for training and processes

Build and maintain custom reports and data requests

Develop and maintain positive, respectful and supportive relationships with all Sky Ranch employees and departments with open and proactive communication

OTHER DUTIES AND RESPONSIBILITIES

Maintain compliance with Sky Ranch’s employee policies and procedures.

Maintain compliance with all state and federal laws and regulatory requirements.

Perform other duties as required.

QUALIFICATIONS : EDUCATION

College degree in relevant field

EXPERIENCE

Experience in camp or similar industry

Experience in data and database management

Experience in systems and software technology

Preference for experience with tools such as Power BI or Tableau

Preference for experience with APIs

KNOWLEDGE

Expert in MS Excel (formulas, pivot tables, etc.)

Proficiency with Power BI

Proficiency with Power Automate

Preference for working knowledge of Crystal Reports and Visual Basic

SKILLS AND ABILITIES

Professionalism in the workplace to include professional and accurate communication with others.

Excellent leadership skills necessary to appropriately influence people to achieve a desired outcome.

Excellent interpersonal skills and relationship building skills.

Encouraging and building mutual trust, respect, and cooperation among team members.

Ability to relate positively, influentially, and sensitively to a broad spectrum of persons in a variety of multi-tiered relationships and settings to include co-workers, peers, and board members.

Ability to plan, manage, and report budgets proficiently.

Ability to provide strategic and logistical planning and facilitate meetings, conferences, workshops, and / or retreats as required.

Ability to investigate and analyze information and draw conclusions.

Ability to prepare moderately complex reports.

Ability to exercise independent thinking and initiative.

Excellent, professional written communication skills.

Ability to deal with complex situations or issues and make effective, timely and appropriate decisions.

Excellent organizational skills : ability to multi-task and manage a variety of tasks.

Ability to maintain confidentiality.

Ability to communicate the vision of Sky Ranch to both internal and external customers.

EXTERNAL CONTACTS

Board, auditors, tax accountants, outside vendors, financial institutions, and foundational executives. |

PHYSICAL DEMANDS

Little to no physical effort required. Ability to use up to 20 pounds of force occasionally, and / or up to 10 pounds of force frequently to move objects.

Ability to grasp, push, pull, carry or otherwise manipulate objects; ability to perform tasks requiring action of muscles or groups of muscles and foot and / or hand-eye coordination.

Requires some physical agility, including but not limited to : bending for items below or reaching for items above the individual; crawling under desks; stooping, and climbing step stools or ladder.

WORK ENVIRONMENT

Works indoors in normal office environment majority of the time.

OTHER

Commitment to Christian principles and teachings both professionally and personally. Must be able to fully support Sky Ranch’s Doctrinal Statement. An active membership in a church whose spiritual beliefs are aligned with Sky Ranch’s Doctrinal Statement.

Commitment to Sky Ranch’s Vision, Mission, Values (Who We A.R.E.) and Principles (WOW, Stewardship, and Excellence) demonstrated in daily behavior.

Must demonstrate annually a clear background check and review of child safety practices as required for camp accreditation by the American Camping Association.

Possess personal spiritual discipline that models a proactive approach toward personal, spiritual, and relational health.