IT Business Systems Analyst

Overview:

*Technical & Software Skills*

*Database & Data Management*

* *SQL Server* : Ability to manage, migrate, and update SQL databases, including creating

relationships, indexes, keys, and handling backend data operations.

* *Microsoft Access*: Understand legacy Access databases, front-end forms, and back-end updates;

ability to migrate Access data to SQL/modern platforms.

* *Data Integration / APIs*: Experience connecting multiple systems via APIs, automated data feeds

* *Data Cleaning & Transformation*: Handling large datasets, removing duplicates, normalizing data,

integrating data across multiple systems.

*Business Intelligence & Reporting*

* *Power BI*: Strong skills in building dashboards, KPIs, automated reports, filtering, slicers, drill-

through, and using service accounts/gateways.

* *TIC (Toad Intelligence Central)*: Experience building scheduled and parameterized reports.

* *Excel / Advanced Excel*: PivotTables, formulas, macros/VBA, connecting to external databases for

reporting.

*Forms & Data Collection Tools*

* *Microsoft Forms & Canvas / Power Apps*: Ability to design interactive forms, collect data from

multiple users, handle attachments, and integrate with SQL/Power BI.

* *Adobe Forms*: Optional experience, as replacement for Wufoo.

* *Process Automation*: Experience using Power Automate or equivalent to automate data flows

from forms to databases or dashboards.

*2. Analytical & Project Skills*

* *Requirements Gathering & Documentation*: Ability to understand user needs, document

workflows, create functional specifications.

* *Business Process Improvement*: Identify inefficiencies in manual processes and design automated,

streamlined solutions.

* *Dashboard & Metrics Design*: Translate operational needs into actionable KPIs, metrics, and

visualizations.

* *Problem-Solving / Troubleshooting*: Debugging slow or failing systems, tracking down data issues

across multiple sources.

---- *3. Communication & Collaboration Skills*

* Work closely with multiple departments: Operations, Accounting, Properties, TSA, Concessions,

CMMS, Airside, IT, and external vendors.

* Ability to explain technical solutions in non-technical language to end-users.

* Coordinate with external consultants and vendors for system implementation.

4. Security & Compliance Awareness*

* Understanding of restricted or sensitive data handling (airport security, TSA data)

5. Additional Desirable Skills*

* *Scripting / Automation*: Python, PowerShell, or similar for automating data processes.

* *Project Management Experience*: Experience with Jira/other ticketing systems for tracking

implementation tasks.

* *Change Management / Training*: Ability to train staff on new systems and ensure adoption.

* *Attention to Detail*: Managing multiple reports, dashboards, and manual processes without errors.