IT Business Systems Analyst

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

Nice to Have