IT Business Systems AnalystDMV IT Service • Sacramento, CA, US
IT Business Systems Analyst
DMV IT Service • Sacramento, CA, US
job_description.job_card.30_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_descriptionStrong 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. 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 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
serp_jobs.job_alerts.create_a_job
System Analyst • Sacramento, CA, US
Job_description.internal_linking.related_jobs
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.Th...serp_jobs.internal_linking.show_more
Role- Business Process Reengineering Analyst.Sacramento California , United States.Business Process Reengineering Analyst.
Three (3) years' experience analyzing business processes and procedures to ...serp_jobs.internal_linking.show_more
Elicit, develop, and document project requirements and technical specifications; analyze and.Create meeting minutes, action items, next steps.
Collaborate with developers to clarify requirements thr...serp_jobs.internal_linking.show_more
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.Th...serp_jobs.internal_linking.show_more
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 ...serp_jobs.internal_linking.show_more
Hybrid onsite 1 day per week on Tuesdays Sacramento CA (local candidates only please).Enterprise SAP Systems Analyst.Must have at least three (3) current years of.
Must have at least one year (1) of...serp_jobs.internal_linking.show_more
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...serp_jobs.internal_linking.show_more
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 ...serp_jobs.internal_linking.show_more
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 ...serp_jobs.internal_linking.show_more
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...serp_jobs.internal_linking.show_more
Position Title : KloudGin Systems Analyst.Sacramento, CA (Mostly Remote and Some onsite).CLIENT is seeking one (1) Leased Employee with experience as a Systems Analyst for implementing the KloudGin ...serp_jobs.internal_linking.show_more
Berkshire Hathaway Homestate Companies, Workers Compensation Division, has a need for an.IT and business units, analyzing business needs and translating them into actionable technical solutions.Thi...serp_jobs.internal_linking.show_more
The Environmental Management Department (EMD) and the Water Resources Department (WR) are.Microsoft 365 (M365) tools-specifically SharePoint.
Online, Microsoft Teams, OneDrive and Copilot-as part of...serp_jobs.internal_linking.show_more
Job Title : Business Systems Analyst.The Business Systems Analyst (BSA) will provide comprehensive project technical and functional management support for large-scale IT initiatives aligned with Hea...serp_jobs.internal_linking.show_more
What Application Development & Maintenance contributes to Cardinal Health.Information Technology oversees the effective development, delivery, and operation of computing and information services.Th...serp_jobs.internal_linking.show_more
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...serp_jobs.internal_linking.show_more
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...serp_jobs.internal_linking.show_more
Job Title : Business Systems Analyst - Need only local.Location : Sacramento, CA or Walnut Creek, CA.Duration : (3 to 6 Months CTH Role).
Experience : Minimum of 3 years of experience as a Business Syst...serp_jobs.internal_linking.show_more
Business Systems Analyst
Tekfortune Inc • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business System Analyst
United Software Group • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst
Diverse Lynx • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst
h3 Technologies • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst II - Core Banking
First Technology Federal Credit Union • Rocklin, CA, US
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_30
Enterprise SAP Systems Analyst
Akaasa Technologies • Sacramento, California, USA
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
KloudGin Systems Analyst
Triune Infomatics Inc • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business System Analyst
Estrada Consulting Incorporated • Sacramento, California, United States
serp_jobs.job_card.full_time
serp_jobs.filters_job_card.quick_apply
serp_jobs.last_updated.last_updated_30
Business Systems Analyst II - Core Banking
First Tech Federal Credit Union • Rocklin, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
KLOUDGIN Systems Analyst
Softworld Inc • Rancho Cordova, CA, US
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
KloudGin Systems Analyst
BayInfotech • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst 2
Berkshire Hathaway Homestate Companies • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
M365 Implementation Specialist / IT Business Systems Analyst
Kaav Inc. • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst
SolutionIT • Sacramento, California, USA
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Senior Analyst, IT Business Solutions
Cardinal Health • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business System Analyst - UC Davis
Another Source • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst III
E-Solutions • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
Business Systems Analyst
Veracity • Sacramento, CA, United States
serp_jobs.job_card.full_time
serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted