IT Business Systems AnalystDMV IT Service • Sacramento, CA, US
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]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. 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
[job_alerts.create_a_job]
System Analyst • Sacramento, CA, US
[internal_linking.similar_jobs]
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]
We understand some people are really looking for a stable company where you can grow professionally.For others it’s more important to be where you can feel you’re helping the environmen...[show_more]
This individual is a technical leader, collaborating closely with project managers, application developers, and clients to deliver best-in-class solutions that meet business objectives and technica...[show_more]
The Interoperability Analyst serves a vital role in supporting the development, execution, and optimization of CalMHSA Connex, CalMHSA’s statewide interoperability platform serving County Beh...[show_more]
First point of contact within the Enterprise Help Desk (EHD) for information systems user problems.Responds to routine hardware / software problems and / or questions related to Point of Sale (POS) and...[show_more]
Commercial Real Estate Companies in Sacramento, CA.MM square feet, over 175 properties, and over 250 buildings, valued at over $2.
ECP has had an Annual Growth of over 20% for the past 13 years and ...[show_more]
Oakland, Sacramento, San Francisco, San Jose .[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 ...[show_more]
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]
Keish Environmental Is Hiring : Business Analyst.Are you an experienced professional with a passion for navigating the complexities of construction compliance and environmental regulations? The Busi...[show_more]
At E Tech Group, joining our team means joining a group of passionate and forward-thinking experts.We're one of the largest engineering and system integration firms in the United States ...[show_more]
ESSENTIAL DUTIES AND RESPONSIBILITIES : .Provide general customer service support to both internal and external customers.
Recommends policies and procedures governing operations and make.Performs cir...[show_more]
JBW Federal is a subsidiary company of the Kanaka Foundation - An NHO who's mission is to support Native Hawaiians.You will receive a comprehensive benefits package that includes : .Annual member...[show_more]
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]
Speridian Technologies is recruiting for a Senior Product Manager for our State of California Client, the Department of Healthcare Services, Behavioral Health.
This person will be part of a long-ter...[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 ...[show_more]
Forgen is dedicated to building a better future - for generations.The Information Technology (IT) Manager provides oversight and management of the company's IT Service and Infrastructure value ...[show_more]
GoodLeap is a technology company delivering best-in-class financing and software products for sustainable solutions, from solar panels and batteries to energy-efficient HVAC, heat pumps, roofing, w...[show_more]
Business Systems Analyst II - Core Banking
First Technology Federal Credit Union • Rocklin, CA, US
[job_card.full_time]
[last_updated.last_updated_30]
Network & Systems Engineer
Tesco Controls Inc • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
GIS Systems Architect
Timmons Group • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Interoperability Analyst
California Mental Health Services Authority • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Technical Support Analyst
TEKsystems • Rocklin, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Lease Analyst
Ethan Conrad Properties Inc • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
SLED Client Executive, IT Solutions - Sales
Xerox Corporation • Sacramento, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Business System Analyst
Estrada Consulting Incorporated • Sacramento, California, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Business Analyst
TradeJobsWorkforce • 95829 Vineyard, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Business Analyst
Keish Environmental • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Control Systems Services Manager
E Tech Group • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Administrative Assistant
AppleOne • Lincoln, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Systems Server Administration and Support - TSSCI
JBW Federal • Beale Air Force Base, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Computer Systems Analyst
TradeJobsWorkForce • 94230 Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Principal Product Manager, Financial Systems
Speridian Technologies • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Business Systems Analyst II - Core Banking
First Tech Federal Credit Union • Rocklin, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
IT Manager
Forgen • Rocklin, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Salesforce Solution Analyst
GoodLeap • Roseville, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]