Business Systems Analyst
Position Summary: The Business Systems Analyst position is a newly created role designed to support the organization’s ability to validate, reconcile, and interpret data across multiple systems, including Salesforce, D365, APIs, and other data sources. This role is responsible for analyzing raw data, identifying irregularities, and ensuring the accuracy of key performance indicators (KPIs) and operational reports. The Business Systems Analyst will actively test new data drops, investigate discrepancies, and verify that backend data structures are functioning as intended.
Success in this position requires someone who is naturally curious, detail-oriented, and able to approach data challenges like solving a puzzle—using logical thinking to determine when information “doesn’t look right” and digging deeper to understand why. The role involves building dashboards, validating system outputs, and cross-matching data across platforms, including CSV files, relational databases and table structures, to ensure the end-user experience is reliable and accurate.
The ideal candidate brings experience in IT, financial systems, or systems implementation, along with applied knowledge of data analysis tools and processes. This individual should be comfortable communicating with non-technical end users and collaborating with leadership. Flexibility, clear communication, and humility are important traits for success. While there is no defined upward career ladder, the role offers opportunities to work closely with regional leadership and gain broader organizational exposure.
Essential Job Duties and Responsibilities:
- Analyze raw data across multiple systems (Salesforce, D365, APIs, Databases, CSVs) to identify irregularities and ensure accuracy of KPIs and operational outputs
- Pull, review, and reconcile reports by comparing data tables, identifying mismatches, and validating whether information has been mapped correctly.
- Support the monitoring of automation performance, assist with implementing error-handling solutions, and contribute to the optimization of existing workflows to improve scalability, security, and speed.
- Monitor backend system changes and detects when alterations to tables or structures impact
data accuracy or system outputs.
- Test and validate new data drops, ensuring information flows correctly to end-user dashboards and reporting tools.
- Support the development and maintenance of dashboards, assist with mapping data from storage systems, and help verify the accuracy of calculated values and displayed outputs.
- Perform cross-matching of data (e.g., city/state codes, CSV fields) to verify accuracy and completeness of mapped information.
- Support stakeholder engagement efforts by assisting in the identification of automation opportunities, gathering business requirements, and documenting current-state processes.
- Assist project teams with the implementation of enterprise and other technology solutions by supporting end-user requirements, testing, training, and adoption efforts.
- Assist with the development and maintenance of technical documentation and support user training activities, as well as ongoing post-production support efforts.
- Identify trends, inconsistencies, or performance gaps by reviewing multiple reports and determining when results do not align with expected patterns.
Minimum Qualifications (Experience, Skills, and Education):
- Post-secondary education or verified continuing education/training beyond high school is required.
- Experience in IT, financial systems, systems implementation, or dashboard/reporting environments.
- Proficiency in Microsoft Power Platform, including Power Apps and Dataverse. Familiarity with standard RESTful APIs, SQL database queries, JSON, and low-code/no-code scripting.
- Connect Power Automate with enterprise applications—such as SharePoint, Teams, Outlook, and CRM/ERP systems—using standard and custom API connectors.
- Understand cloud flows, desktop flows (RPA), and business process flows to handle approvals, data synchronization, and multi-step tasks.
- Ability to analyze raw data, interpret trends, detect irregularities, and validate accuracy of mapped information.
- Proficiency working with CSV files, pulling reports, reconciling mismatches and data types, and reviewing backend tables for accuracy and completeness.
- Strong problem-solving skills with the ability to think logically and identify when data outputs are incorrect or inconsistent.
- Strong verbal and written communication skills.
- Excellent cross-functional communication for gathering requirements and training non-technical end users.
- Strong understanding of business process management, data structures, and conditional logic.
- Maintaining strict confidentiality is essential, requiring the Associate to exercise complete discretion with all sensitive materials they encounter.
- Ability to communicate clearly and effectively with end users and internal stakeholders.
- High attention to detail and ability to manage confidential information appropriately.
- Expertise with Microsoft Office Suite, especially Excel and PowerPoint.
- Exceptional analytical and problem-solving abilities, with careful attention to detail. Must be able to deconstruct manual processes and convert them into efficient, rule-based automated sequences.
- Ability to manage multiple projects under tight deadlines and maintain a positive, team-oriented attitude.
Physical Requirements and Working Conditions:
The Business Systems Analyst role will perform work at a home office environment. Will frequently use a computer, keyboard / mouse, cellular or telephone, and regular business office equipment. Extended periods of sitting for long durations. Occasional walking over uneven terrain, accessing outdoor areas or performing work in non-temperature-controlled environments may be necessary. Infrequent lifting and/or moving objects of up to 10 lbs.
Additional Requirements:
Work with a Top-of-Mind Awareness for the safety of yourself and everyone at the job site. Must be able to work in a high functioning team environment. Display the highest levels of honesty, integrity, and professionalism. Take pride in your work and in the company. Communicate openly and strive for peak performance in daily tasks. Know and deliver the quality service MEI’s customers have come to expect.
Disclaimer: This job description is intended to summarize the type and level of work and is not an exhaustive list of all duties, responsibilities, and/or requirements. MEI reserves the right to change or modify this job description or the essential duties of the job, as necessary.
MEI is an Equal Opportunity, M/F/Disabled/Vet Preferred Employer.
