Membership Analytics Engineer

RESUME AND COVER LETTER REQUIRED TO BE CONSIDERED FOR THIS POSITION

Salary: $90,000 - $108,000 annually. Salary is dependent on experience and qualifications.

The Membership Analytics Engineer supports enterprise data workflows throughout the entire data ecosystem, from requirement gathering through development, ensuring that stakeholders internal and external to EDUCAUSE have access to reliable, accurate, and relevant data.

This role is responsible for performing business analysis, gathering stakeholder requirements for analytics development to support association efforts to best understand and serve our members. This role includes assisting the Enterprise Data Management team with the collection of data around web analytics and member engagement. The role assists with data transformation in Microsoft Fabric and data presentation in Microsoft Power BI for analysis and reporting.

In addition, this role will work with the Enterprise Data Management team to recommend and implement new technologies and/or workflows in support of EDUCAUSE’s evolving needs, ensuring we adapt as we gain new insights and understanding through our work. Finally, this role also supports relevant, ad hoc data requests and acts as a backup for other teammates, providing business continuity for the Enterprise Data Management team in support of EDUCAUSE.

• Develop Microsoft Power BI reports and dashboards that identify trends, patterns, and insights that empower data-driven decision making for Membership and the greater association.
• Create, maintain, and modify data models and dashboards using Microsoft Fabric and Power BI, assisting with analysis and reporting in adjacent systems when required.
• Develop AI‑assisted analytics capabilities that enable natural language exploration of enterprise data models and reports.
• Perform data analysis to inform planning and development of business intelligence resources and reports, improving data awareness around member engagement and related revenue.
• Create ad-hoc data reports for stakeholders using SQL and Microsoft Office suite products, including Excel and SharePoint.
• Work with integrated data from other systems to assist EDUCAUSE staff with survey analysis, email marketing lists, data quality efforts, etc.

• Assist with research and validation of data pipelines and integrations, surfacing data through a medallion architecture established in Microsoft Fabric.
• Assist with design, development, and maintenance of data models and SQL schema artifacts to support reporting requirements.
• Design agentic AI interfaces that facilitate analytics report development, application code review, and SQL performance optimizations.
• Work with the Enterprise Data Management team to monitor and maintain data pipelines in the Microsoft Fabric environment, ensuring critical membership engagement data is highly available and accurate for reporting.
• Support the Enterprise Data Management team with development of new data sources and ingestion pipelines to ensure accurate and timely availability of member engagement data.

• Collaborate directly with stakeholders across the association to maintain business knowledge, identify and translate business needs into requirements, and ensure we design data products that satisfy association needs.
• Negotiate and document project scope, risks, and assumptions for use with business stakeholders and team members.
• Actively communicate with stakeholders, internal and external to the team, about expected project scope and delivery timelines, being proactive when communicating updates and changes around expectations.
• Identify opportunities and propose recommendations based on data-driven insights gained while working with member data, EDUCAUSE staff, and related stakeholders.
• Support process improvement, ensuring data collection and analysis efforts stay aligned strategically with current and upcoming association goals.

• Respond to data support tickets within 24 hours, as assigned by the Senior Director of Enterprise Data Management.
• Represent EDUCAUSE in a professional manner at all times; engage with co-workers in a civil, caring, respectful way; and advance the mission and vision of EDUCAUSE
• Participate in EDUCAUSE events and activities as needed.
• Duties, responsibilities, and activities may change or new ones may be assigned at any time with or without notice

• This job has no supervisory responsibilities.

• Required- 3-5 years of professional experience with SQL databases, designing schemas, dynamic data views, data definitions, and developing queries for reporting and analysis, demonstrating an expert-level knowledge of SQL. Experience with Microsoft Azure data services is preferred.
• Required- 2-5 years experience with Microsoft Power BI, analyzing data, developing data models and designing business intelligence dashboards and reports.
• Required-2-5 years experience with data collection, preparation, transformation, modeling, reporting and analysis.
• Preferred-Experience defining or applying engagement-related scoring systems to evaluate member engagement.
• Preferred-Experience identifying at-risk members for year-over-year activities that tie into potential revenue losses, such as at-risk renewals.
• Preferred-Experience performing market share analysis to surface insights from organizational and individual member demographics and engagement data.

• Demonstrated communication skills to bridge business stakeholders with technical teams to achieve meaningful outcomes.
• Demonstrated understanding of association-related business processes and operations, including Membership, Marketing, and Finance data.
• Ability and desire to identify problems, propose solutions, and be an active partner in problem solving.
• Demonstrated ability to learn new technologies and technical skills quickly
• Proficient with SQL, Excel, and other software languages and platforms to analyze, interpret, and securely share data.

• Analytical- Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs work flows and procedures.
• Judgement- Displays willingness to make decisions; Exhibits sound and accurate judgment; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
• Planning/Organizing- Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks; Develops realistic action plans.
• Interpersonal Skills- Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things.
• Innovation- Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others' attention.

• Prolonged periods of sitting at a desk and working on a computer.

• Scheduled working hours either in the employees time zone or EDUCAUSE core working hours or core working hours to be determined with the supervisor.
• Be available and responsive during scheduled work hours.
• Any time off or change in working hours must be pre-arranged according to department guidelines and consistent with the rules applicable to employment (e.g., vacation, sick, personal, leave of absence).

TRAVEL REQUIREMENTS

• Less than 10%.

EDUCAUSE not only offers meaningful work and dedicated colleagues; we also have a robust benefit package that includes:

• Medical, Dental, and Vision
• 2-for-1 employer match to your 403(b) retirement plan; up to 10% of your base salary
• Employer-paid Life and AD&D, Short‐Term Disability, and Long‐Term Disability
• 15 days of vacation and 6 days of personal time annually
• 9 paid holidays
• One week of paid time off when offices are closed between Christmas and New Year’s Day
• 36-hour work week (without any reduction in pay) amounting to 26 additional days of paid time off each year
• Employee Assistance Program (EAP)
• Emergency Travel Assistance
• Professional development assistance
• Monthly connectivity reimbursement

EDUCAUSE is committed to an equal opportunity workplace and is proud to be an equal opportunity employer. EDUCAUSE provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, or any other characteristic protected by federal, state, or local laws.

EDUCAUSE recognizes that the unique backgrounds, talents, skills, and contributions of every individual improve and enhance the quality of the association. Creating an environment of equal opportunity is an EDUCAUSE organizational goal, which includes, but is not limited to:

• Treating everyone with dignity, respect, and fairness
• Creating a welcoming, supportive, and knowledgeable community that thrives on diverse voices and perspectives
• Providing insights and input as a work contributor
• Listening to and acknowledging others' contributions
• Contributing to an open and welcoming environment across demographic categories and physical locations
• Meeting others at their point of need to advance organizational achievement
• For supervisors, ensuring everyone's input is heard and considered

Originally posted on Himalayas