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.related_jobs]
    Integration Analyst IV - Workday Integrations

    Integration Analyst IV - Workday Integrations

    Kavaliro • Sacramento, CA, US
    [job_card.full_time]
    Our client is seeking a Integration Analyst IV – Workday Integrations for a long-term project.The Integration Analyst IV serves as a senior technical leader and design architect responsible f...[show_more]
    [last_updated.last_updated_variable_days] • [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]
    Zillow Flex Real Estate Agent

    Zillow Flex Real Estate Agent

    Culbertson and Gray Group • Lincoln, CA, US
    [job_card.full_time]
    Are you a licensed real estate agent seeking unparalleled support and significant growth opportunities?.Join The Culbertson Gray Group, where we provide genuine tools, structured guidance, and lead...[show_more]
    [last_updated.last_updated_30] • [promoted]
    1099 Board Certified Behavioral Analyst (BCBA) - Herald CCH 356

    1099 Board Certified Behavioral Analyst (BCBA) - Herald CCH 356

    Telecare Corporation • Herald, CA, United States
    [job_card.part_time]
    Telecare's mission is to deliver excellent and effective behavioral health services that engage individuals in recovering their health, hopes, and dreams. Telecare continues to advance cultural dive...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Manager Application Systems JDEdwards Eone

    Manager Application Systems JDEdwards Eone

    Tri-S Recruiters, Inc • Sacramento, CA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Remote, must be based in the United States prefer NorthWest U.Yes (Internal team and external consultants).I am seeking a strategic and hands-on. Application Manager ERP - JDEdwards.You will need to...[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]
    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_1_day]
    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]
    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]
    Computer Systems Analyst

    Computer Systems Analyst

    TradeJobsWorkForce • 94230 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]
    Senior Analyst, IT Business Solutions

    Senior Analyst, IT Business Solutions

    Cardinal Health • Sacramento, CA, United States
    [job_card.full_time]
    What Application Development & Maintenance contributes to Cardinal Health.Information Technology oversees the effective development, delivery, and operation of computing and information services.Th...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]