Business Systems Analyst & IT Support
Posted
Summary
Hybrid business systems analyst and IT support role at MDRT: gathers requirements, builds Power BI reports and low-code Power Platform workflows across Aptify and Dynamics 365, and oversees Tier 2 help desk, Microsoft 365 administration, and IT assets for ~150 staff. Needs SQL, Power BI, and M365/Entra ID/Intune admin experience.
Million Dollar Round Table (MDRT) is looking for an IT Support & Business Systems Analyst who will own the analysis, configuration, and continuous improvement of MDRT's business systems and staff technology experience. The role's primary focus is business systems analysis. The analyst works with departments to define requirements, recommend solutions, and deliver reporting and workflow improvements across Aptify, Dynamics 365, Power BI, Microsoft 365, and the Power Platform. The analyst also oversees MDRT's end-user support function for about 150 employees and uses insights from support trends to find root causes and drive lasting fixes.
Responsibilities:
Business Systems Analysis
Business Systems Analysis
- Serve as the lead analyst for core business systems, including Aptify, Dynamics 365, and Power BI.
- Partner with department leaders to understand goals, challenges, and needs for systems, reporting, and data.
- Analyze current business processes, find opportunities to improve them, and recommend solutions that help staff work faster and make better decisions.
- Define, prioritize, and document business and technical requirements, user stories, and acceptance criteria.
- Assess whether a business need is best met through configuration, automation, reporting, training, or a new tool, and make recommendations to IT leadership.
- Design and build Power BI reports and dashboards. Lead the move of staff reporting from Aptify to Power BI, including validating results with department users.
- Write SQL queries to extract, validate, and analyze data, including checking membership data for accuracy before importing it into Aptify.
- Design and build low-code workflow solutions using Power Automate, Power Apps, Dataverse, and Copilot Studio.
- Plan and run user acceptance testing (UAT) on system changes, reports, and workflow solutions, and approve them for release.
- Research and recommend new technologies and vendor solutions.
IT Support Oversight
- Assist with the HappyFox help desk system and support process.
- Analyze recurring support issues and fix their root causes
- Handle escalated (Tier 2) issues and decide on the best path for resolution.
- Oversee the onboarding and offboarding process for staff technology access, equipment, and software.
- Manage Microsoft 365 administration, including mailboxes, licenses, and email policies.
- Oversee the IT asset inventory and the lifecycle of PCs, mobile devices, printers, and phones.
- Develop and maintain the MDRT Knowledge Base and staff training on SharePoint, OneDrive, Teams, and Microsoft 365 Copilot.
- Monitor and remediate security vulnerabilities and support Microsoft 365 email security.
- Coordinate technical support at MDRT Annual Meetings.
- Support IT projects by helping with planning, tracking deliverables, and coordinating cross-functional teams.
- Complete special IT Leadership projects.
Knowledge, Skills and Abilities:
Required
- Bachelor's degree in Information Technology, Information Systems, Business Administration, or a related field, or equivalent experience.
- 4+ years of experience in business systems analysis, with a background in IT support.
- Experience gathering requirements, documenting business processes, and running user acceptance testing.
- Skill in building Power BI reports and dashboards.
- Working knowledge of SQL for querying and validating data.
- Ability to turn business needs into technical solutions and to communicate with staff at all levels.
- Experience administering Microsoft 365 (Teams, SharePoint, OneDrive), Active Directory/Entra ID, and Intune.
- Strong analytical, diagnostic, and problem-solving skills, and sound independent judgment.
- Strong organizational skills, and the ability to manage multiple priorities in a fast-paced environment.
- Travel to MDRT Annual Meetings, and occasional extra hours during membership season.
- Ability to lift and move IT equipment up to 30 lbs.
Preferred
- Experience with Aptify or a CRM such as Dynamics 365.
- Experience with the Power Platform (Power Automate, Power Apps, Dataverse, Copilot Studio) or Python.
- Familiarity with project management methods such as Agile and Waterfall.
- Working knowledge of Windows 11, Mac, network infrastructure, and VoIP (RingCentral).
- Certifications such as PL-300, IIBA (ECBA/CCBA), Microsoft 365, or CompTIA A+.
Skills
Sign in to read and join the discussion.