Membership Analytics Engineer

Automatic Data Processing, Inc.; United States; Remote; USD 90,000 - 108,000; Full time

Job summary

EDUCAUSE is seeking an Analytics Engineer to support enterprise data workflows from requirements through development, ensuring reliable data access for stakeholders.

The role focuses on business analysis, data transformation in Microsoft Fabric, and presenting insights via Power BI. You will collaborate with the Enterprise Data Management team to expand data sources, improve pipelines, and deliver timely member engagement analytics.

Qualifications

• 3–5 years of professional SQL database experience with schema design and reporting.
• 2–5 years experience with Microsoft Power BI, data modeling, and BI dashboards.
• 2–5 years experience with data collection, preparation, transformation, modeling, reporting and analysis.
• Preferred: engagement-related scoring experience.
• Preferred: market share analysis from demographics and engagement data.

Responsibilities

• Develop Power BI reports and dashboards to identify trends and insights for membership and the association.
• Create, maintain, and modify data models and dashboards using Fabric and Power BI.
• Develop AI-assisted analytics for natural language exploration of data models and reports.
• Perform data analysis to inform planning and development of BI resources and reports.
• Create ad-hoc reports using SQL and Excel/SharePoint.
• Work with integrated data from other systems to support surveys and marketing lists.
• Assist with data pipelines and integrations in Microsoft Fabric.
• Design, develop, and maintain SQL schemas and artifacts for reporting.
• Design AI interfaces to aid analytics report development and SQL optimization.
• Monitor data pipelines in Fabric to ensure availability of engagement data.
• Support new data sources and ingestion pipelines for timely access to data.

Skills

SQL

Data analysis

Data modeling

Tools

Power BI

Azure data services

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

IT - General Full-time Regular Remote, US 2 Attachments

Salary Range: $90,000.00 To $108,000.00 Annually

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

SUMMARY

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.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Business Intelligence Analytics

• 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.

Business Analysis

• 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.

Association Service and Support

• 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

SUPERVISORY RESPONSIBILITIES

• This job has no supervisory responsibilities.

QUALIFICATIONS

Education and Experience

• 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.

Knowledge, Skills, and Abilities

• 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.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

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

Remote Work Requirements

• 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%.

EEO Statement

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