Business Systems Analyst - Grant Management & Systems Integration

Job Description

Job Description

Booth Management Consulting, LLC (BMC) is a diverse CPA firm that provides accounting, auditing, and management consulting services to public and private clients nationwide. Our employee-friendly company environment emphasizes quality of life, initiative, creativity, strong work ethic, and loyalty. We seek a qualified, motivated, and progressive individual to join our team as a Business Systems Analyst for a Grant Management and Systems Integration project .

Position Summary

In this role, you will support the configuration, integration, testing, and implementation of an integrated grant management and reporting solution for government-funded programs. Working under the guidance of BMC’s Technical Lead, this individual will translate approved system designs and business requirements into functional low-code/no-code solutions using platforms such as Microsoft Power Platform, Power BI, and JotForm Enterprise. The Technical Lead will establish the overall architecture and develop initial proofs of concept; the analyst will expand these into complete, tested prototypes and help prepare the solution for deployment.

Key Responsibilities

Business Applications & Workflow Configuration

• Configure grant intake forms, project tracking, approval processes, notifications, and document-management workflows.
• Expand initial proofs of concept into end-to-end working prototypes using approved low-code/no-code platforms.
• Translate documented process requirements into practical forms, workflows, business rules, and user-facing functionality.

Data Management & Integration

• Organize and maintain structured grant, project, funding, milestone, and location data with appropriate validation and quality controls.
• Configure data imports, exports, transformations, and integrations between approved systems.
• Coordinate with OSIT GIS and data personnel to support geographic identifiers, mapping inputs, and data exchanges; troubleshoot integration issues.

Dashboards & Reporting

• Build and maintain Power BI dashboards and reports for funding, project status, milestones, and program performance.
• Prepare data models, report filters, refresh processes, and clear visual summaries for management and stakeholders.

Testing, Documentation & Implementation

• Perform functional, integration, and regression testing; document issues and resolve defects.
• Support user acceptance testing, deployment preparation, user training, and post-launch troubleshooting.
• Document configurations, workflows, data definitions, and operating procedures.
• Implement approved security, access, and data-handling requirements under Technical Lead oversight.

Experience & Qualifications

• Bachelor’s degree in Information Systems, Information Technology, Computer Science, Data Analytics, Business Analytics, or a related field, or equivalent relevant experience.
• Strong analytical, organizational, troubleshooting, communication, and problem-solving skills.
• Proficiency in Microsoft Excel, including structured datasets, formulas, and data manipulation.
• Understanding of data structures, relational database concepts, validation, and reporting fundamentals.
• Familiarity with business information systems, process workflows, or application configuration.
• Ability to learn new platforms independently, translate specifications into working solutions, and document work clearly.
• Two or more years of relevant hands-on experience preferred, not required. Recent graduates with demonstrated technical aptitude, internships, or substantial academic projects are encouraged to apply.

Preferred Experience :

• Experience with Microsoft Power BI, Power Apps, Power Automate, Dataverse, or comparable low-code/no-code platforms.
• Familiarity with Jotform Enterprise, SharePoint, document management, and approval workflows.
• Basic knowledge of SQL, REST APIs, JSON, and data integration concepts.
• Experience configuring dashboards, workflow automation, or business applications.
• Exposure to GIS/geographic identifiers, government reporting, grants management, or infrastructure programs.
• Familiarity with role-based access, auditability, testing, and controlled deployment processes.
  

Onboarding & Development

BMC anticipates an initial onboarding and learning period of approximately one month before project implementation. The selected candidate will be supported in building hands-on proficiency with Power BI, Power Platform, Jotform Enterprise, and the project’s integration workflows. Prior experience with every platform is not expected; initiative, practical learning ability, and demonstrated follow-through are highly valued.

BMC is an equal employment opportunity (EEO)/affirmative action (AA) employer that is committed to providing a workplace that is free from discrimination based on race, color, ethnicity, religion, sex, national origin, age, marital status, sexual orientation, gender identity and expression, disability, veteran status, pregnancy, genetic information or any other status protected by applicable federal, state, local or international law. These protections also extend to applicants.