Talent.com
IT Business Systems Analyst

IT Business Systems Analyst

DMV IT ServiceSacramento, CA, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Job Title : IT Business Systems Analyst

Location : Sacramento, CA

Employment Type : Full-time

About Us

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 achieve technology goals through expert guidance, workforce support, and innovative solutions. With a client-focused approach, we also provide online training and job placements, ensuring long-term IT success.

Job Purpose

As an IT Business Systems Analyst , you will play a key role in managing databases, integrating data sources, building business intelligence dashboards, and automating workflows. You will work closely with cross-functional teams to translate operational needs into actionable insights while ensuring data integrity, security, and compliance.

Requirements

Key Responsibilities

  • Manage, migrate, and optimize SQL Server databases, including relationships, indexes, and back-end operations.
  • Support and modernize legacy Microsoft Access databases, migrating data to SQL or other platforms as needed.
  • Develop and maintain data integrations using APIs and automated feeds.
  • Clean, transform, and normalize large datasets across multiple systems.
  • Build and enhance business intelligence dashboards, KPIs, and automated reports using Power BI and Toad Intelligence Central (TIC).
  • Design interactive data collection tools using Microsoft Forms, Power Apps, or equivalent platforms.
  • Automate data flows with Power Automate or similar tools, ensuring seamless integration into databases and dashboards.
  • Document requirements, workflows, and functional specifications for data projects.
  • Identify process inefficiencies and implement automation to improve efficiency.
  • Provide troubleshooting and problem-solving support for data inconsistencies and system performance.
  • Collaborate with multiple departments (Operations, Accounting, IT, Vendors, etc.) to align technical solutions with business needs.
  • Communicate technical concepts to non-technical users in a clear, user-friendly manner.
  • Ensure compliance with security standards when handling sensitive or restricted data.

Required Skills & Experience

  • Strong hands-on experience with SQL Server (data management, relationships, indexes, migration).
  • Experience with Microsoft Access (front-end forms, back-end updates, data migration).
  • Proficiency in data integration and API connections across systems.
  • Data cleaning and transformation skills for large datasets.
  • Expertise in Power BI (dashboards, KPIs, drill-through, slicers, service accounts).
  • Familiarity with Toad Intelligence Central (TIC) for scheduled and parameterized reporting.
  • Advanced Excel skills, including PivotTables, formulas, VBA / macros, and database connections.
  • Experience with Microsoft Forms, Power Apps, or similar tools for data collection.
  • Proficiency with Power Automate (or equivalent) for process automation.
  • Strong skills in requirements gathering, documentation, and business process analysis.
  • Proven problem-solving abilities in debugging systems and data issues.
  • Ability to collaborate across multiple departments and external vendors.
  • Understanding of security and compliance requirements for sensitive / restricted data.
  • Nice to Have

  • Experience with scripting / automation (Python, PowerShell, etc.).
  • Familiarity with project management tools (e.g., Jira).
  • Change management and training experience to support new system adoption.
  • Strong attention to detail in managing multiple reports and dashboards.
  • serp_jobs.job_alerts.create_a_job

    System Analyst • Sacramento, CA, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.new
    Business Solutions Analysts

    Business Solutions Analysts

    GovServicesHubSacramento, CA, us
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Job Title : Business Solutions Analysts.Location : Sacramento, CA – onsite.Look for some with strong background of CalHEERS, CalSAWS, CALWIN, State Welfare Medi-Cal projects, Statewide Automated Welf...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Information Systems Technician

    Information Systems Technician

    NavyAuburn, CA, United States
    serp_jobs.job_card.full_time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    IT Manager

    IT Manager

    TradeJobsWorkForce95831 Sacramento, CA, US
    serp_jobs.job_card.full_time
    Running regular checks on network and data security Identifying and acting on opportunities to improve and update software and systems Developing and implementing IT policy and best practice guides...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Remote Financial Planner - AI Trainer

    Remote Financial Planner - AI Trainer

    Data AnnotationLincoln, California
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Tax Expert - Local

    Tax Expert - Local

    IntuitNewcastle, CA, United States
    serp_jobs.job_card.full_time
    Intuit is seeking highly motivated individuals to join our dynamic team as dedicated TurboTax Live Seasonal Local Service Experts in one of our new TurboTax locations across the United States on a ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    $250 / 60min Paid Market Research Study for Dir. of IT Infrastructure in the Government Sector

    $250 / 60min Paid Market Research Study for Dir. of IT Infrastructure in the Government Sector

    Ivy ExecSacramento, CA, United States
    serp_jobs.job_card.full_time
    Market research studies are paid engagements Ivy Exec conducts with clients to get feedback on certain topics.For this study, we are looking for IT proffesionals in Education and State & Local gove...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Remote Senior Financial Analyst - AI Trainer

    Remote Senior Financial Analyst - AI Trainer

    Data AnnotationDavis, California
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Commercial Banking Analyst - AI Trainer

    Remote Commercial Banking Analyst - AI Trainer

    Data AnnotationWest Sacramento, California
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Sales Representative

    Sales Representative

    BVMYuba City, CA, US
    serp_jobs.job_card.full_time
    Be the exclusive Publisher for your neighborhood, enjoying complete autonomy and schedule flexibility.Be in business for yourself, but not by yourself!. Sell print and digital ad products & solu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Business Analyst

    Business Analyst

    TradeJobsWorkForce95833 Sacramento, CA, US
    serp_jobs.job_card.full_time
    Business Analyst Job Duties : Elicits, analyzes, specifies, and validates the business needs of ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    IT Applications Analyst III

    IT Applications Analyst III

    California Creative Solutions Inc.Sacramento, CA, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Roles / Responsibilities : • Design, develop, and maintain web applications using C#, Web API, and Angular Support and maintain legacy syst...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Remote Finance Advisor - AI Trainer

    Remote Finance Advisor - AI Trainer

    Data AnnotationLincoln, California
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Logistics Manager

    Logistics Manager

    U.S. NavyHood, CA, United States
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    IT Applications Analyst III

    IT Applications Analyst III

    DMV IT ServiceSacramento, CA, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Information Technology Professional

    Information Technology Professional

    U.S. NavyElk Grove, CA, United States
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Information Systems Analyst 2 - Davis, CA, Job ID 80476

    Information Systems Analyst 2 - Davis, CA, Job ID 80476

    University of California Agriculture and Natural ResourcesDavis, CA, United States
    serp_jobs.job_card.full_time
    Information Systems Analyst 2 - Davis, CA, Job ID 80476.University of California Agriculture and Natural Resources.This position provides front-line technical support across a range of IT services,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Computer Systems Analyst

    Computer Systems Analyst

    TradeJobsWorkForce95812 Sacramento, CA, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Business Analyst

    Business Analyst

    TradeJobsWorkforce95840 Sacramento, CA, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Analyst

    Analyst

    TradeJobsWorkforce94257 Sacramento, CA, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Remote Financial Analyst - AI Trainer

    Remote Financial Analyst - AI Trainer

    Data AnnotationElk Grove, California
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days