Note: The job is a remote job and is open to candidates in USA. EDUCAUSE’s Membership Analytics Engineer supports enterprise data workflows from requirements gathering through development. The role develops analytics and reporting solutions, maintains data models and pipelines, and works with stakeholders to turn association needs into data products and insights.
Responsibilities
- 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
Skills
- 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
- 2-5 years experience with Microsoft Power BI, analyzing data, developing data models and designing business intelligence dashboards and reports
- 2-5 years experience with data collection, preparation, transformation, modeling, reporting and analysis
- 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
- Experience with Microsoft Azure data services
- Experience defining or applying engagement-related scoring systems to evaluate member engagement
- Experience identifying at-risk members for year-over-year activities that tie into potential revenue losses, such as at-risk renewals
- Experience performing market share analysis to surface insights from organizational and individual member demographics and engagement data
Benefits
- 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
- Remote work in the United States
Company Overview