Overview
On Site
Hybrid
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
Data Management
Microsoft SQL Server
Microsoft Access
Data Integration
Data Cleansing
Business Intelligence
Toad
Microsoft Excel
Pivot Table
Macros
VBA
Reporting
Data Collection
Microsoft
SQL
Microsoft Power BI
Adobe Experience Manager
Process Automation
Data Flow
Forms
Database
Analytical Skill
Requirements Elicitation
Documentation
Workflow
Process Improvement
KPI
Conflict Resolution
Problem Solving
Debugging
Communication
Collaboration
Accounting
CMMS
System Implementation
Regulatory Compliance
Scripting
Python
Windows PowerShell
Project Management
JIRA
Change Management
Training
Gmail
Attention To Detail
Management
Dashboard
Job Details
Job Description
We are seeking an experienced Business Intelligence Analyst to support its operations, data management, and business intelligence initiatives. This role combines technical expertise, analytical skills, and communication abilities to bridge the gap between technical teams and business stakeholders.
Technical & Software Skills
Database & Data Management
- SQL Server: Manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling backend data operations.
- Microsoft Access: Understand and update legacy Access databases (front-end forms and back-end tables); migrate Access data to SQL or modern platforms.
- Data Integration / APIs: Connect multiple systems via APIs and automated data feeds.
- Data Cleaning & Transformation: Handle large datasets, remove duplicates, normalize data, and integrate data across multiple systems.
Business Intelligence & Reporting
- Power BI: Build dashboards, KPIs, automated reports, filtering/slicers, drill-through, and use service accounts/gateways.
- TIC (Toad Intelligence Central): Build scheduled and parameterized reports.
- Excel / Advanced Excel: PivotTables, formulas, macros/VBA, and connecting to external databases for reporting.
Forms & Data Collection Tools
- Microsoft Forms & Power Apps / Canvas: Design interactive forms, collect data from multiple users, handle attachments, and integrate with SQL/Power BI.
- Adobe Forms (Optional): Experience replacing Wufoo forms.
- Process Automation: Use Power Automate or equivalent to automate data flows from forms to databases or dashboards.
Analytical & Project Skills
- Requirements Gathering & Documentation: Understand user needs, document workflows, and 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: Debug slow or failing systems and track data issues across multiple sources.
Communication & Collaboration Skills
- Collaborate with multiple departments including Operations, Accounting, Properties, TSA, Concessions, CMMS, Airside, IT, and external vendors.
- Explain technical solutions in non-technical language to end-users.
- Coordinate with external consultants and vendors for system implementation.
Security & Compliance Awareness
- Understand restricted or sensitive data handling, including airport security and TSA-related information.
Additional Desirable Skills
- Scripting / Automation: Python, PowerShell, or similar for automating data processes.
- Project Management Experience: Experience with Jira or other ticketing systems for tracking implementation tasks.
- Change Management / Training: Ability to train staff on new systems and ensure adoption.
- Attention to Detail: Manage multiple reports, dashboards, and manual processes accurately and efficiently.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.