Membership Analytics Engineer

Educause• Remote, US,

12d•$90,000 - $108,000•Remote

About The Position

The Membership Analytics Engineer supports enterprise data workflows across the data ecosystem, from gathering requirements through development, so internal and external EDUCAUSE stakeholders can access reliable, accurate, and relevant data. The role performs business analysis and gathers stakeholder requirements for analytics development to help the association understand and serve its members. It also supports collection of web analytics and member engagement data, data transformation in Microsoft Fabric, and presentation of data in Microsoft Power BI for analysis and reporting. The role works with the Enterprise Data Management team to recommend and implement technologies and workflows as EDUCAUSE's needs evolve. It also responds to relevant ad hoc data requests and provides backup for teammates to support business continuity. The position has no supervisory responsibilities. Scheduled working hours are either in the employee's time zone or EDUCAUSE core working hours, as determined with the supervisor. Travel is less than 10%.

Requirements

3–5 years of professional experience with SQL databases, schema design, dynamic data views, data definitions, and query development for reporting and analysis, demonstrating expert-level SQL knowledge.
2–5 years of experience with Microsoft Power BI, data analysis, data modeling, and designing business intelligence dashboards and reports.
2–5 years of experience with data collection, preparation, transformation, modeling, reporting, and analysis.
Demonstrated communication skills to bridge business stakeholders and technical teams.
Demonstrated understanding of association business processes and operations, including Membership, Marketing, and Finance data.
Ability and desire to identify problems, propose solutions, and actively participate in problem solving.
Demonstrated ability to learn new technologies and technical skills quickly.
Proficiency with SQL, Excel, and other software languages and platforms for analyzing, interpreting, and securely sharing data.
Ability to meet scheduled working hours in the employee's time zone or EDUCAUSE core working hours, as arranged with the supervisor, and to be available and responsive during those hours.
Prolonged periods of sitting at a desk and working on a computer.

Nice To Haves

Experience with Microsoft Azure data services.
Experience defining or applying engagement-related scoring systems to evaluate member engagement.
Experience identifying at-risk members in year-over-year activities tied to potential revenue losses, such as at-risk renewals.
Experience performing market share analysis using organizational and individual member demographics and engagement data.

Responsibilities

Develop Microsoft Power BI reports and dashboards that identify trends, patterns, and insights for data-driven decision-making in Membership and across the association.
Create, maintain, and modify data models and dashboards using Microsoft Fabric and Power BI, and assist with analysis and reporting in adjacent systems as required.
Develop AI-assisted analytics capabilities that enable natural-language exploration of enterprise data models and reports.
Analyze data to inform the planning and development of business intelligence resources and reports, improving awareness of member engagement and related revenue.
Create ad hoc stakeholder reports using SQL and Microsoft Office products, including Excel and SharePoint.
Work with integrated data from other systems to support survey analysis, email marketing lists, and data quality efforts.
Assist with research and validation of data pipelines and integrations, surfacing data through the medallion architecture established in Microsoft Fabric.
Assist in designing, developing, and maintaining data models and SQL schema artifacts for reporting requirements.
Design agentic AI interfaces to facilitate analytics report development, application code review, and SQL performance optimization.
Monitor and maintain Microsoft Fabric data pipelines with the Enterprise Data Management team to support highly available and accurate membership engagement data.
Support development of new data sources and ingestion pipelines to ensure accurate and timely availability of member engagement data.
Collaborate with association stakeholders to maintain business knowledge, identify and translate business needs into requirements, and ensure data products meet association needs.
Negotiate and document project scope, risks, and assumptions for stakeholders and team members.
Communicate expected project scope and delivery timelines, proactively sharing updates and changes to expectations with internal and external stakeholders.
Identify opportunities and recommend actions based on data-driven insights from member data and work with EDUCAUSE staff and related stakeholders.
Support process improvement and ensure data collection and analysis remain aligned with current and upcoming association goals.
Respond to assigned data support tickets within 24 hours, as assigned by the Senior Director of Enterprise Data Management.
Represent EDUCAUSE professionally, engage respectfully with coworkers, and advance the organization's mission and vision.
Participate in EDUCAUSE events and activities as needed.
Perform other duties and activities that may be assigned or changed.

Benefits

Medical, dental, and vision coverage.
2-for-1 employer match to the 403(b) retirement plan, up to 10% of base salary.
Employer-paid life and AD&D insurance, 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 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.