IT Business Systems Analyst

7 days ago

Sacramento, CA, United States DMV IT Service Full time

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.

  • Business Systems Analyst

    2 weeks ago

    Sacramento, CA, United States Veracity Full time

    Job Title: Business Systems Analyst - Need only local Location: Sacramento, CA or Walnut Creek, CA Duration: (3 to 6 Months CTH Role) Over All 12+ years Job Description • Experience: Minimum of 3 years of experience as a Business Systems Analyst or similar role. • Experience with low code platforms and experience with SQL and data visualization tools...

  • IT Business Systems Analyst II

    3 days ago

    Sacramento, CA, United States Kaav Inc. Full time

    The Application Development team is looking for a Business Analyst to work on several projects for xref creation, Animal Care, Asset Management. This position will work on documenting the business requirements, creating proposals and collaborating with partner departments on various projects. This position will also work closely with the IT Supervisor and...

  • Business Systems Analyst III

    2 weeks ago

    Sacramento, CA, United States E-Solutions Full time

    * Provide professional customer support for system-related software and/or hardware issues, needs, or requirements in the fulfillment of our client's mission. * Evaluate customer technical needs, elicit, and determine requirements, and recommends solutions; plan, design, develop, test, and implement a variety of hardware and/or software systems. * Develop,...

  • Business Systems Analyst III

    2 weeks ago

    Sacramento, CA, United States E-Solutions Full time

    * Provide professional customer support for system-related software and/or hardware issues, needs, or requirements in the fulfillment of our client's mission. * Evaluate customer technical needs, elicit, and determine requirements, and recommends solutions; plan, design, develop, test, and implement a variety of hardware and/or software systems. * Develop,...

  • Business Systems Analyst

    2 weeks ago

    Sacramento, CA, United States h3 Technologies Full time

    Sacramento County is seeking a journey level Business Analyst to work closely with the Community Development Agency to re-engineer their process workflows to create efficiencies and better serve the public. This position will work with various subject matter experts to create requirements and project documentation to support developing these features in the...

  • Business Systems Analyst

    1 day ago

    Sacramento, CA, United States InterSources Full time

    RT | Business Systems Analyst - RTH-1146 2526.7610.02 | Accepting Candidates | P1 | Data, Functional | _Job #1103243 | Open Location: Sacramento, CA ***LOCAL CANDIDATES ONLY*** Job Title: Business Analyst - RTH-1146 2526.7610.02 Job Location (and/or specific WFH schedule): This position will be 3 days in office with up to 2 days remote. Interview Process:...

  • Business Systems Analyst

    3 days ago

    Sacramento, CA, United States InterSources Full time

    RT | Business Systems Analyst - RTH-1146 2526.7610.02 | Accepting Candidates | P1 | Data, Functional | _Job #1103243 | Open Location: Sacramento, CA ***LOCAL CANDIDATES ONLY*** Job Title: Business Analyst - RTH-1146 2526.7610.02 Job Location (and/or specific WFH schedule): This position will be 3 days in office with up to 2 days remote. Interview Process:...

  • Business Systems Analyst

    3 days ago

    Sacramento, CA, United States InterSources Full time

    RT | Business Systems Analyst - RTH-1146 2526.7610.02 | Accepting Candidates | P1 | Data, Functional | _Job #1103243 | Open Location: Sacramento, CA ***LOCAL CANDIDATES ONLY*** Job Title: Business Analyst - RTH-1146 2526.7610.02 Job Location (and/or specific WFH schedule): This position will be 3 days in office with up to 2 days remote. Interview Process:...

  • Business Systems Analyst

    2 weeks ago

    Sacramento, CA, United States InterSources Full time

    RT | Business Systems Analyst - RTH-1146 2526.7610.02 | Accepting Candidates | P1 | Data, Functional | _Job #1103243 | Open Location: Sacramento, CA ***LOCAL CANDIDATES ONLY*** Job Title: Business Analyst - RTH-1146 2526.7610.02 Job Location (and/or specific WFH schedule): This position will be 3 days in office with up to 2 days remote. Interview Process:...

  • Business Systems Analyst

    2 weeks ago

    Sacramento, CA, United States InterSources Full time

    RT | Business Systems Analyst - RTH-1146 2526.7610.02 | Accepting Candidates | P1 | Data, Functional | _Job #1103243 | Open Location: Sacramento, CA ***LOCAL CANDIDATES ONLY*** Job Title: Business Analyst - RTH-1146 2526.7610.02 Job Location (and/or specific WFH schedule): This position will be 3 days in office with up to 2 days remote. Interview Process:...