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
    Remote Financial Analyst - AI Trainer

    Remote 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 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
    PeopleSoft Business Systems Analyst III

    PeopleSoft Business Systems Analyst III

    TrinusSacramento, CA, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    MsoNoSpacing"> Job Description : We are seeking a skilled and proactive PeopleSoft Business Systems Analyst to...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • 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
    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
    OSP Project Management Team Supervisor

    OSP Project Management Team Supervisor

    Race Telecommunications LLCYuba City, CA, US
    serp_jobs.job_card.full_time
    OSP Project Management Team Supervisor.Work will be primarily performed onsite in our office.Occasional travel to and work from other Race offices or other off-site locations will be required.Bewar...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    IT Business Systems Analyst

    IT Business Systems Analyst

    GovServicesHubSacramento, CA, us
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Computer Systems Analyst

    Computer Systems Analyst

    TradeJobsWorkForce95831 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
    Remote Finance Director - AI Trainer

    Remote Finance Director - 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
    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
    Business System Analyst

    Business System Analyst

    Synergyassure IncSacramento, California., TX, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Title : Business System Analyst Duration : 6 Months C2H Location : Sacramento, California.Must be a US Citizen or a Green Card The IT Busine...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Business Analyst

    Business Analyst

    TradeJobsWorkforce94236 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
    Financial Services Analyst 3 Davis, CA, Job ID 80501

    Financial Services Analyst 3 Davis, CA, Job ID 80501

    University of California Agriculture and Natural ResourcesDavis, CA, United States
    serp_jobs.job_card.full_time
    Financial Services Analyst 3 Davis, CA, Job ID 80501.University of California Agriculture and Natural Resources.Serve as Lead Business Partner managing a large volume of accounts.Overseeing the bu...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • 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
    IT Business Analyst (1756)

    IT Business Analyst (1756)

    Kooner Fleet Management SolutionsSacramento, CA, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Are you an experienced and highly organized IT Business Analyst looking to advance your career? If so, Kooner Fleet Management Solutions wants you to join our growing team!.The IT Business Analyst ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day