job summary:
Our client is looking for an IT Business Systems Analyst for a 6 month contract opportunity located in Sacramento, CA. This role has a high chance of extensions.
location: Sacramento,
job type: Contract
salary: $62 - 65 per hour
work hours: 8am to 5pm
education: No Degree Required
responsibilities:
Technical & Software 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.
h3. *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.
h3. *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.
----
h2. *2. 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.
----
h2. *3. Communication & Collaboration Skills*
* Work closely with multiple departments and external vendors.
* Ability to explain technical solutions in non-technical language to end-users.
* Coordinate with external consultants and vendors for system implementation.
----
h2. *4. Security & Compliance Awareness*
* Understanding of restricted or sensitive data handling (airport security, TSA data)
----
h2. *5. Additional Desirable Skills*
* *Scripting / Automation*: Python, PowerShell, or similar for automating data processes.
* *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.
qualifications:
Technical & Software 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.
h3. *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.
h3. *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.
----
h2. *2. 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.
----
h2. *3. Communication & Collaboration Skills*
* Work closely with multiple departments and external vendors.
* Ability to explain technical solutions in non-technical language to end-users.
* Coordinate with external consultants and vendors for system implementation.
----
h2. *4. Security & Compliance Awareness*
* Understanding of restricted or sensitive data handling (airport security, TSA data)
----
h2. *5. Additional Desirable Skills*
* *Scripting / Automation*: Python, PowerShell, or similar for automating data processes.
* *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.
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.
it business systems analyst.
- posted 3 days ago
share this job.
related jobs.
see all jobs- Warehouse Operations Specialist Are you a hands-on, detail-oriented individual looking for a dynamic role in a fast-paced warehouse? We are seeking a Warehouse Operations Specialist to join our team. This is a true warehouse position, offering a variety of tasks beyond just operating a forklift. What You'll Do: Handle a wide range of warehouse duties, including loading and unloading trucks, shipping products via UPS, and managing incoming deliveries.
- Are you a planning, communication, and customer service expert? If so, this may be a great opportuntiy for you! We are currently recruiting for a reputable company in the Natomas area who is in need of a Client Support Specialist. The ideal candidate would have excellent customer service, experienced with handling purchase orders, and be proficient with software platforms including Microsoft Office Suite and ERP systems. If you feel that you would be a gre
- Do you have experience in the legal field and have knowledge in HR? If so, this may be the perfect role for you! We are currently seeking an Office Administrator and HR Support for an organization located in Sacramento, CA. The Office Administrator and HR Support is responsible for managing day-to-day operations and support HR functions in the office. This role is essential to maintaining smooth office workflows, supporting legal case management, and ensu
