Membership Systems and Data Analyst

MICHIGAN ASSOCIATION OF SCHOOL BOARDS (MASB) JOB DESCRIPTION

JOB TITLE: Membership Systems and Data Analyst

DATE: May 2024

DEPARTMENT: Information Services and Technology

REPORTS TO: Director of Information Services and Technology

SUPERVISES: Not Applicable

Job Summary: The Membership Systems and Data Analyst is directly responsible for managing MASB's Microsoft Dynamics 365-based membership and customer relationship management systems. This position provides advanced reports and dashboards to senior leadership and staff, analytical support for business operations, and continuous monitoring of the software's performance and the data's quality. This position works collaboratively with MASB’s four-member IT team to provide solutions regarding data retention, database management, and ongoing IT support for MASB and several external client organizations. This person will also work closely with the IT team to provide solution consultation for data retention, database management, ongoing support, and strategies for various technology solutions.

Essential Duties:

• Managing the Dynamics365-based Association Management system, ensuring it performs optimally, maintains data integrity, and successfully integrates with various applications.

• Administering the Customer Relationship Management system based on Dynamics365, making sure it works well, keeps data accurate, and connects with other applications.

• Assess the kind and level of support MASB's Dynamics365 users require and organize their training, process documentation, and technical support needs.

• Finding, examining, and explaining trends and patterns in complex data sets for key stakeholders and staff members.

• Creating, updating, and sustaining customized database reports using SSRS, Power BI, FetchXML, SQL, and comparable applications.

• Training staff on creating, managing, and updating system reporting and dashboards.

• Writing and updating internal technical documentation about the configuration and upkeep of MASB’s supported databases. This includes documenting how the databases and reporting procedures relate to the organization's systems, services, and business processes.

• Supports the Director of Information Services and Technology in maintaining great relationships with vendors and customers inside and outside the organization.

• Represents the department in various staff committees within the organization.

Qualifications:

• Education or experience minimum
  • 4-year degree in computer science, information management, statistics, or a similar field OR
  • 5+ years of documented technology-related on-the-job experience
• 2+ years’ experience managing a Customer Relationship Management system
• 2+ years’ experience in the field of data/reporting management

Required Competencies/Abilities:

• Technical expertise in data models, data mining, and segmentation techniques.
• Extensive experience with reporting services such as SSRS and Microsoft Fabric/Power BI
• Extensive experience with the support and maintenance of databases and database reporting
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Adept at queries, report writing, and presenting findings to end-users
• Ability to understand business and systems architecture and systems integration
• Ability to communicate with and train all levels of staff
• Highly organized and works well in a team setting

Preferred Education and Competencies/Abilities:

• Computer-related certifications in association with database administration and reporting
• Innovation skills and vision
• Focus on excellent internal and external customer service
• Ability to manage multiple projects in multiple functional areas simultaneously
• Flexibility and adaptability to adjust to changing project needs in evolving situations
• Experience working with:
  • Dynamics 365: Sales, Customer Insights, Customer Voice, Dataverse
  • Microsoft Power Platform: Fabric/PowerBI, Power Apps, Power Automate, Power Pages
  • Microsoft SharePoint and Teams
  • Statistics and experience using statistical packages for analyzing large datasets
  • Email marketing systems such as MailChimp, Constant Contact, Customer Insights

Working Conditions and Physical Demands:

Work will be conducted primarily in an office setting and may include extended hours on the phone and computer keyboard. Some in-state and limited out-of-state travel is required to attend conferences, serve at district functions, and teach classes. Some weekend and after-hours work is required.

The work environment characteristics described here represent those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Salary/Benefits:

This is a full-time salaried position, with compensation commensurate with experience; the preliminary salary range is $75,000-85,000. MASB offers a complete benefits package that includes full family health, dental, vision, life, and long-term disability insurance, along with employer contributions into a 401(k) plan. Regular workdays are Monday through Friday, 8 a.m. to 5 p.m. with some night and weekend work required. Work location is 50% in the office and 50% work-from-home, or as needed by MASB. Paid time off includes sick, vacation, holiday, and personal days. MASB is not part of Michigan’s Public School Employees Retirement System.

Application Procedure:

Interested candidates should submit their resumes and cover letter to HR@MASB.ORG. MASB intends to conduct interviews as qualified applicants are received, with our first candidate screening on May 22nd, then conducting rolling interviews until filled. MASB is committed to improving diversity, equity, and inclusion in our workplace, and we are currently seeking to attract, recruit, and retain people from diverse backgrounds.

ADA and EOE Employer:

The information in this job description is for compliance with the American with Disabilities Act (A.D.A.) and is not an exhaustive list of the duties performed for this position. Additional duties are performed by the individuals currently holding this position, and additional duties may be assigned.

Equal Opportunity Employer: The Michigan Association of School Boards ensures equal employment opportunities regardless of race, creed, gender, color, national origin, religion, age, sexual orientation, or disability.

Values Statement:

We, the MASB staff, are committed to a workplace that:

• Focuses on members’ success;
• Builds trust, respect, and understanding;
• Values inclusion and diversity;
• Supports each other; and
• Embraces and drives purposeful change that promotes growth