Talent.com
IT Business Systems Analyst contractor

IT Business Systems Analyst contractor

California Creative Solutions Inc.Sacramento, CA, United States
4 days ago
Job type
  • Full-time
  • Quick Apply
Job description

Roles / Responsibilities :

  • Manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling backend data operations.
  • Understand and migrate legacy Microsoft Access databases, including front-end forms and back-end updates.
  • Handle large datasets for cleaning and transformation, removing duplicates, normalizing data, and integrating across systems.
  • Optionally work with Adobe Forms as a replacement for Wufoo.
  • Automate data flows from forms to databases or dashboards using Power Automate or equivalent.
  • Gather requirements, document workflows, and create functional specifications.
  • Identify inefficiencies in manual processes and design automated, streamlined solutions.
  • Translate operational needs into actionable KPIs, metrics, and visualizations.
  • Debug slow or failing systems and track down data issues across multiple sources.
  • Work closely with departments such as 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.
  • Understand and handle restricted or sensitive data (e.g., airport security, TSA data) in compliance with security protocols.

Mandatory 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.
  • 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, 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)
  • Desirable Skills :

  • 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.
  • Create a job alert for this search

    System Analyst • Sacramento, CA, United States

    Related jobs
    • Promoted
    Computer Systems Analyst

    Computer Systems Analyst

    TradeJobsWorkForce94291 Sacramento, CA, US
    Full-time
    Training users on how to appropriately utilize their computer systems Writing instruction manuals for systems Consulting with managers to determine what role the systems play in the business Testin...Show moreLast updated: 30+ days ago
    • Promoted
    Deliverables & Project Support Analyst I

    Deliverables & Project Support Analyst I

    West YostDavis, CA, United States
    Full-time
    We are a water-focused engineering consulting firm, certified as a Great Place to Work® based on feedback from our community of over 260 team members. We ranked top three in the AEC Advisors 2021 an...Show moreLast updated: 3 days ago
    • Promoted
    Data Security Risk & Compliance Analyst

    Data Security Risk & Compliance Analyst

    M4A FoundationEl Dorado Hills, CA, United States
    Full-time
    Min Qualifications required : Bachelors / Masters.Experience : Experience in information security, governance, IT audit, or risk management. Minimum Volunteer hours required : (in hrs per week) 15-20.R...Show moreLast updated: 3 days ago
    • Promoted
    IT Security Analyst

    IT Security Analyst

    Decision PointYuba City, CA, United States
    Full-time
    DecisionPoint Corporation is seeking an.US Air Force team supporting the defense of USAF infrastructure (AFIN) at the base level. The contractor shall provide Functional Mission Analysis-Cyber assis...Show moreLast updated: 3 days ago
    • Promoted
    Real Estate Quality Control Analyst

    Real Estate Quality Control Analyst

    Sierra Central Credit UnionYuba City, CA, US
    Full-time
    To perform department reviews of loan documents, system records, vendor reviews and internal controls as they relate to the Real Estate Department. Ensure all real estate documentation adheres to es...Show moreLast updated: 8 days ago
    • Promoted
    Business Analyst

    Business Analyst

    TradeJobsWorkforce95831 Sacramento, CA, US
    Full-time
    ESSENTIAL JOB FUNCTIONS Analyzes global markets for IT Services, servers, storage, backup, IT security, productivity software, remote monitoring services, hyperconvergence and IoT.Studies SMB and m...Show moreLast updated: 30+ days ago
    • Promoted
    Information Technology Professional

    Information Technology Professional

    U.S. NavyClarksburg, CA, United States
    Full-time +1
    To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.At any given moment, hundreds of complex networked computer systems are operating in tandem to keep ships and su...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Product Manager

    Senior Product Manager

    Keeper Security, Inc.El Dorado Hills, CA, US
    Full-time
    Keeper Security is hiring an experienced and execution-oriented Senior Product Manager to define and drive our product strategy. This is a 100% remote position with an opportunity to work a hybrid s...Show moreLast updated: 30+ days ago
    • Promoted
    Business Relationship Manager I

    Business Relationship Manager I

    Tri Counties BankYuba City, CA, United States
    Full-time
    Come join a company you can be proud to represent.The hiring range for this opportunity is $90,000 to $112,000 annual salary along with incentive opportunities, creating a competitive total compens...Show moreLast updated: 3 days ago
    IT Business Systems Analyst

    IT Business Systems Analyst

    DMV IT ServiceSacramento, CA, US
    Full-time
    Quick Apply
    DMV IT Service LLC, founded in 2020, is a trusted IT consulting firm specializing in IT infrastructure optimization, cybersecurity, networking, and staffing solutions. We partner with clients to ach...Show moreLast updated: 4 days ago
    IT Business Systems Analyst

    IT Business Systems Analyst

    GovServicesHubSacramento, CA, us
    Full-time
    Quick Apply
    Technical & Software Skills : .Database & Data Management.SQL Server • : Ability to manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling bac...Show moreLast updated: 2 days ago
    • Promoted
    Logistics Manager

    Logistics Manager

    U.S. NavyHood, CA, United States
    Full-time +1
    To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.In this field, your efforts are critical in delivering what the Navy needs for mission success.Youll always be t...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Operations Supervisor (Supply Chain / Logistics) - 1st Shift

    Senior Operations Supervisor (Supply Chain / Logistics) - 1st Shift

    Penske Truck Leasing Co., L.P.Dixon, CA, US
    Full-time
    Position Summary : Provide operational leadership to individual contributors and hourly workforce to ensure the execution of daily tasks and activities including driver deliveries, loading / unloading...Show moreLast updated: 1 day ago
    • Promoted
    QA Analyst, Mobile (KeeperChat)

    QA Analyst, Mobile (KeeperChat)

    Keeper SecurityEl Dorado Hills, CA, United States
    Permanent
    Keeper Security is hiring a highly motivated and experienced QA Analyst to join our KeeperChat team and ensure the quality, reliability, and security of our secure messaging applications.This is a ...Show moreLast updated: 3 days ago
    • Promoted
    Travel Licensed Social Worker (LSW) - $1,029 per week in Ione, CA

    Travel Licensed Social Worker (LSW) - $1,029 per week in Ione, CA

    AlliedTravelCareersIone, CA, US
    Full-time
    AlliedTravelCareers is working with Care Career to find a qualified LSW in Ione, California, 95640!.Duties / Responsibilities shall include, but are not limited to : Licensed Clinical Social Worker (L...Show moreLast updated: 1 day ago
    Business Solutions Analyst

    Business Solutions Analyst

    Sabot ConsultingSacramento, CA, US
    Full-time
    Quick Apply
    Business Solutions Analyst Location : .Remote Salary : $85-130k Sabot Consulting is seeking a Business Solutions Analyst to support a comprehensive IT feasibility study aimed at modernizing digital se...Show moreLast updated: 8 days ago
    • Promoted
    Fully Remote Survey Participant

    Fully Remote Survey Participant

    Prime InsightsDixon, CA, United States
    Remote
    Full-time
    Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...Show moreLast updated: 1 day ago
    • Promoted
    Senior Manager, Public Cloud Sales (RapidScale) - West

    Senior Manager, Public Cloud Sales (RapidScale) - West

    Cox CommunicationsClarksburg, CA, United States
    Full-time
    At RapidScale, exceptional technology is powered by exceptional people.As a growing leader in secure, reliable managed cloud solutions, we help mid-market through enterprise organizations simplify ...Show moreLast updated: 3 days ago