California Creative Solutions Inc.Sacramento, CA, United States
4 days ago
Job type
Full-time
Quick Apply
Job description
Roles / Responsibilities :
Manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling backend data operations.
Understand and migrate legacy Microsoft Access databases, including front-end forms and back-end updates.
Handle large datasets for cleaning and transformation, removing duplicates, normalizing data, and integrating across systems.
Optionally work with Adobe Forms as a replacement for Wufoo.
Automate data flows from forms to databases or dashboards using Power Automate or equivalent.
Gather requirements, document workflows, and create functional specifications.
Identify inefficiencies in manual processes and design automated, streamlined solutions.
Translate operational needs into actionable KPIs, metrics, and visualizations.
Debug slow or failing systems and track down data issues across multiple sources.
Work closely with departments such as Operations, Accounting, Properties, TSA, Concessions, CMMS, Airside, IT, and external vendors.
Explain technical solutions in non-technical language to end-users.
Coordinate with external consultants and vendors for system implementation.
Understand and handle restricted or sensitive data (e.g., airport security, TSA data) in compliance with security protocols.
Mandatory Skills :
Database & Data Management
SQL Server : Ability to manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling backend data operations.
Microsoft Access : Understand legacy Access databases, front-end forms, and back-end updates; ability to migrate Access data to SQL / modern platforms.
Data Integration / APIs : Experience connecting multiple systems via APIs, automated data feeds.
Data Cleaning & Transformation : Handling large datasets, removing duplicates, normalizing data, integrating data across multiple systems.
Business Intelligence & Reporting
Power BI : Strong skills in building dashboards, KPIs, automated reports, filtering, slicers, drill-through, and using service accounts / gateways.
TIC (Toad Intelligence Central) : Experience building scheduled and parameterized reports.
Excel / Advanced Excel : PivotTables, formulas, macros / VBA, connecting to external databases for reporting.
Forms & Data Collection Tools
Microsoft Forms & Canvas / Power Apps : Ability to design interactive forms, collect data from multiple users, handle attachments, and integrate with SQL / Power BI.
Adobe Forms : Optional experience, as replacement for Wufoo.
Process Automation : Experience using Power Automate or equivalent to automate data flows from forms to databases or dashboards.
Analytical & Project Skills
Requirements Gathering & Documentation : Ability to understand user needs, document workflows, create functional specifications.
Business Process Improvement : Identify inefficiencies in manual processes and design automated, streamlined solutions.
Dashboard & Metrics Design : Translate operational needs into actionable KPIs, metrics, and visualizations.
Problem-Solving / Troubleshooting : Debugging slow or failing systems, tracking down data issues across multiple sources.
Communication & Collaboration Skills
Work closely with multiple departments : Operations, Accounting, Properties, TSA, Concessions, CMMS, Airside, IT, and external vendors.
Ability to explain technical solutions in non-technical language to end-users.
Coordinate with external consultants and vendors for system implementation.
Security & Compliance Awareness
Understanding of restricted or sensitive data handling (airport security, TSA data)
Desirable Skills :
Project Management Experience : Experience with Jira / other ticketing systems for tracking
implementation tasks.
Change Management / Training : Ability to train staff on new systems and ensure adoption.
Attention to Detail : Managing multiple reports, dashboards, and manual processes without errors.
Create a job alert for this search
System Analyst • Sacramento, CA, United States
Related jobs
Promoted
Computer Systems Analyst
TradeJobsWorkForce94291 Sacramento, CA, US
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 moreLast updated: 30+ days ago
Promoted
Deliverables & Project Support Analyst I
West YostDavis, CA, United States
Full-time
We are a water-focused engineering consulting firm, certified as a Great Place to Work® based on feedback from our community of over 260 team members.
We ranked top three in the AEC Advisors 2021 an...Show moreLast updated: 3 days ago
Promoted
Data Security Risk & Compliance Analyst
M4A FoundationEl Dorado Hills, CA, United States
Full-time
Min Qualifications required : Bachelors / Masters.Experience : Experience in information security, governance, IT audit, or risk management.
Minimum Volunteer hours required : (in hrs per week) 15-20.R...Show moreLast updated: 3 days ago
Promoted
IT Security Analyst
Decision PointYuba City, CA, United States
Full-time
DecisionPoint Corporation is seeking an.US Air Force team supporting the defense of USAF infrastructure (AFIN) at the base level.
The contractor shall provide Functional Mission Analysis-Cyber assis...Show moreLast updated: 3 days ago
Promoted
Real Estate Quality Control Analyst
Sierra Central Credit UnionYuba City, CA, US
Full-time
To perform department reviews of loan documents, system records, vendor reviews and internal controls as they relate to the Real Estate Department.
Ensure all real estate documentation adheres to es...Show moreLast updated: 8 days ago
Promoted
Business Analyst
TradeJobsWorkforce95831 Sacramento, CA, US
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 moreLast updated: 30+ days ago
Promoted
Information Technology Professional
U.S. NavyClarksburg, CA, United States
Full-time +1
To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.At any given moment, hundreds of complex networked computer systems are operating in tandem to keep ships and su...Show moreLast updated: 30+ days ago
Promoted
Senior Product Manager
Keeper Security, Inc.El Dorado Hills, CA, US
Full-time
Keeper Security is hiring an experienced and execution-oriented Senior Product Manager to define and drive our product strategy.
This is a 100% remote position with an opportunity to work a hybrid s...Show moreLast updated: 30+ days ago
Promoted
Business Relationship Manager I
Tri Counties BankYuba City, CA, United States
Full-time
Come join a company you can be proud to represent.The hiring range for this opportunity is $90,000 to $112,000 annual salary along with incentive opportunities, creating a competitive total compens...Show moreLast updated: 3 days ago
IT Business Systems Analyst
DMV IT ServiceSacramento, CA, US
Full-time
Quick Apply
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 ach...Show moreLast updated: 4 days ago
IT Business Systems Analyst
GovServicesHubSacramento, CA, us
Full-time
Quick Apply
Technical & Software Skills : .Database & Data Management.SQL Server • : Ability to manage, migrate, and update SQL databases, including creating relationships, indexes, keys, and handling bac...Show moreLast updated: 2 days ago
Promoted
Logistics Manager
U.S. NavyHood, CA, United States
Full-time +1
To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.In this field, your efforts are critical in delivering what the Navy needs for mission success.Youll always be t...Show moreLast updated: 30+ days ago
Position Summary : Provide operational leadership to individual contributors and hourly workforce to ensure the execution of daily tasks and activities including driver deliveries, loading / unloading...Show moreLast updated: 1 day ago
Promoted
QA Analyst, Mobile (KeeperChat)
Keeper SecurityEl Dorado Hills, CA, United States
Permanent
Keeper Security is hiring a highly motivated and experienced QA Analyst to join our KeeperChat team and ensure the quality, reliability, and security of our secure messaging applications.This is a ...Show moreLast updated: 3 days ago
Promoted
Travel Licensed Social Worker (LSW) - $1,029 per week in Ione, CA
AlliedTravelCareersIone, CA, US
Full-time
AlliedTravelCareers is working with Care Career to find a qualified LSW in Ione, California, 95640!.Duties / Responsibilities shall include, but are not limited to : Licensed Clinical Social Worker (L...Show moreLast updated: 1 day ago
Business Solutions Analyst
Sabot ConsultingSacramento, CA, US
Full-time
Quick Apply
Business Solutions Analyst Location : .Remote Salary : $85-130k Sabot Consulting is seeking a Business Solutions Analyst to support a comprehensive IT feasibility study aimed at modernizing digital se...Show moreLast updated: 8 days ago
Promoted
Fully Remote Survey Participant
Prime InsightsDixon, CA, United States
Remote
Full-time
Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...Show moreLast updated: 1 day ago
Promoted
Senior Manager, Public Cloud Sales (RapidScale) - West
Cox CommunicationsClarksburg, CA, United States
Full-time
At RapidScale, exceptional technology is powered by exceptional people.As a growing leader in secure, reliable managed cloud solutions, we help mid-market through enterprise organizations simplify ...Show moreLast updated: 3 days ago