IT Business Systems Analyst

Overview

On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - To 2026-05-01
100% Travel

Skills

Business Systems
Microsoft SQL Server
Microsoft Access
Legacy Systems
Data Cleansing
Reporting
Business Intelligence
KPI
Microsoft Excel
Pivot Table
VBA
Database
Microsoft
Data Collection
SQL
Microsoft Power BI
Adobe Experience Manager
Data Flow
Forms
Analytical Skill
Workflow
Business Process
Dashboard
Communication
Collaboration
Accounting
Security Awareness
Scripting
Python
Windows PowerShell
Project Management
JIRA
Attention To Detail
Management

Job Details

Job Title: IT Business Systems Analyst
Location: Sacramento, CA - Onsite
Duration: 6+ months
Description:
1. Technical & Software Skills
  • Databases:
    • SQL Server: Manage, migrate, and update databases (keys, indexes, relationships).
    • Microsoft Access: Understand legacy systems, forms, and migrate data to modern platforms.
  • Data Handling:
    • APIs & Integration: Connect systems and automate data flows.
    • Data Cleaning: Normalize, de-duplicate, and merge large datasets.
  • Reporting & BI:
    • Power BI: Build dashboards, KPIs, automated reports with filters and drill-through.
    • TIC: Create scheduled and customized reports.
    • Excel: Use PivotTables, formulas, VBA/macros, and connect to databases.
  • Forms & Automation:
    • Power Apps / Microsoft Forms: Design data collection forms with file uploads and integrate with SQL/Power BI.
    • Adobe Forms: Bonus.
    • Power Automate: Automate data flows from forms to dashboards.
2. Analytical & Project Skills
  • Gather requirements and document workflows.
  • Improve business processes through automation.
  • Design dashboards and metrics based on operations.
  • Troubleshoot data and system issues.
3. Communication & Collaboration
  • Work with departments (Ops, Accounting, IT, etc.) and external vendors.
  • Translate technical concepts into user-friendly language.
  • Coordinate implementations with consultants.
4. Security Awareness
  • Handle sensitive data (e.g., airport/TSA data) responsibly.
5. Bonus Skills
  • Scripting (Python, PowerShell) for automation.
  • Project management using Jira or similar.
  • Train users and support change adoption.
  • High attention to detail for managing multiple systems and reports.
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.

About AspireIT Solutions