Talent.com
IT Business Systems Analyst
IT Business Systems AnalystDMV IT Service • Sacramento, CA, US
IT Business Systems Analyst

IT Business Systems Analyst

DMV IT Service • Sacramento, CA, US
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
  • [filters_job_card.quick_apply]
[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.
  • [job_alerts.create_a_job]

    System Analyst • Sacramento, CA, US

    [internal_linking.similar_jobs]
    Remote FinTech Product Analyst - AI Trainer ($50-$60 / hour)

    Remote FinTech Product Analyst - AI Trainer ($50-$60 / hour)

    Data Annotation • Lincoln, California
    [filters.remote]
    [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 quality of ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Business Systems Analyst II - Core Banking

    Business Systems Analyst II - Core Banking

    First Technology Federal Credit Union • Rocklin, CA, US
    [job_card.full_time]
    The Business Analyst II performs business process related activities that are focused on measuring and improving quality, cost effectiveness, efficiency, member and customer satisfaction and other ...[show_more]
    [last_updated.last_updated_30]
    KloudGin Systems Analyst

    KloudGin Systems Analyst

    Triune Infomatics Inc • Sacramento, CA, United States
    [job_card.full_time]
    Role : KloudGin Systems Analyst.Location : Sacramento, CA (Hybrid).The Client is seeking candidates with experience as a Systems Analyst for implementing the KloudGin Work Management (Field Service M...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    KLOUDGIN Systems Analyst

    KLOUDGIN Systems Analyst

    Softworld Inc • Rancho Cordova, California, United States
    [job_card.full_time]
    Job Title : KLOUDGIN Systems Analyst Job Location : Sacramento California 95826 Onsite Requirements : Configuration of KloudGin Work Management solution. Systems Analyst or similar role, preferably wit...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Business System Analyst - UC Davis

    Business System Analyst - UC Davis

    Another Source • Sacramento, CA, United States
    [job_card.full_time]
    Business System Analyst - UC Davis.University of California, Davis.US-CA-Davis | US-CA-Sacramento.Another Source's client, UC Davis Continuing and Professional Education, is hiring a Business Syste...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Information Systems Analyst 4

    Information Systems Analyst 4

    University of California- Davis Health • Sacramento, CA, United States
    [job_card.full_time] +1
    This position serves as a technical lead for the architecture, implementation, and support of complex IT Facilities technologies, including hardware, software, and distributed systems.Responsibilit...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Enterprise Imaging IT Analyst

    Enterprise Imaging IT Analyst

    University of California- Davis Health • Sacramento, CA, United States
    [job_card.full_time] +1
    This position provides technical support of assigned clinical and / or financial applications aligned with UC Davis Health goals. This position is responsible for life cycle management of clinical and...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Technical Business Analyst (fully on-site)

    Technical Business Analyst (fully on-site)

    Life-Assist, Inc. • Rancho Cordova, CA, US
    [job_card.full_time]
    At Life Assist we show up every day, so we can “Help Heroes Save Lives.Together through a culture of caring and genuine connections, every decision we make and every action we take ensures th...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Business System Analyst

    Business System Analyst

    Estrada Consulting Incorporated • Sacramento, California, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Estrada Consulting, Inc is looking for : .Candidates will have at least 12-15 years working in Information Technology and preferred to have public sector and healthcare project experience.Candidates ...[show_more]
    [last_updated.last_updated_30]
    Business Systems Product Manager

    Business Systems Product Manager

    The Judge Group • Elk Grove, CA, United States
    [job_card.full_time]
    We’re seeking a Business Systems Product Manager to join our client’s Business Systems team.This role is responsible for leading the strategy, development, and optimization of internal business sys...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Kloudgin Systems Analyst

    Kloudgin Systems Analyst

    Estrada Consulting Incorporated • Sacramento, California, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Is Looking For – KloudGin Systems Analyst – Hybrid (Sacramento, CA).Mandatory Requirements (Pass / Fail) : .Proposed resource must have these qualifications and experiences. Must have experience with co...[show_more]
    [last_updated.last_updated_variable_days]
    Business Analyst

    Business Analyst

    TradeJobsWorkforce • 95829 Vineyard, CA, US
    [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...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Business Systems Analyst II - Core Banking

    Business Systems Analyst II - Core Banking

    First Tech Federal Credit Union • Rocklin, California, United States
    [job_card.full_time]
    The Business Analyst II performs business process related activities that are focused on measuring and improving quality, cost effectiveness, efficiency, member and customer satisfaction and other ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    KloudGin Systems Analyst

    KloudGin Systems Analyst

    MethodHub • Sacramento, CA, United States
    [job_card.full_time]
    Sacramento, CA – Hybrid 2-3 days per week.Systems Analyst – KloudGin Work Management.Our client is seeking a Systems Analyst – KloudGin Work Management to support the implementation, configuration,...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Business Analyst

    Business Analyst

    Aditi Consulting • Sacramento, CA, US
    [job_card.full_time]
    Responsibilities : Support Strategic Resilience Initiatives : Assist in the execution of cross-discipline projects that enhance resilience, including crisis management, business continuity, and emplo...[show_more]
    [last_updated.last_updated_30] • [promoted]
    KloudGin Systems Analyst

    KloudGin Systems Analyst

    Anvaya Solutions • Sacramento, CA, US
    [job_card.full_time]
    HYBRID POSITION, WHICH INCLUDES ONSITE WORK IN SACRAMENTO, CA AREA.Must have experience with configuration of KloudGin Work management solution. Must have at least 3 years’ experience as a Sys...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Computer Systems Analyst

    Computer Systems Analyst

    TradeJobsWorkForce • 95823 Sacramento, CA, US
    [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...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Data Annotation • Lincoln, California
    [filters.remote]
    [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 quality of ...[show_more]
    [last_updated.last_updated_30] • [promoted]