Talent.com
IT Business Systems Analyst

IT Business Systems Analyst

GovServicesHubSacramento, CA, us
3 days ago
Job type
  • Full-time
  • Quick Apply
Job description

Job Description

Title : IT Business Systems Analyst

Location :  Sacramento, CA, 95837

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, 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.

    • 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.

    • Communication & Collaboration Skills

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

    Requirements

  • 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.
  • 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.
  • Security & Compliance Awareness
  • Understanding of restricted or sensitive data handling (airport security, TSA data)

    • 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.

    • Regards,

    Requirements

  • 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.
  • 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.
  • Security & Compliance Awareness
  • Understanding of restricted or sensitive data handling (airport security, TSA data) 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. Regards,
    • Create a job alert for this search

    System Analyst • Sacramento, CA, us