Sign upLog in
IT Management Jobs

Technical Implementation Lead/Integration Lead (Ref: 5734)

Estrada Consulting Incorporated

Sacramento, California(remote)

Apply
JOB DETAILS
SKILLS
Acceptance Testing, Agile Programming Methodologies, Application Programming Interface (API), Authentication, Behavioral Health, Bug Tracking/Defect Management, Business Intelligence, Case Management, Child Protection/Welfare, Cloud Computing, Communication Skills, Community and Social Services, Consulting, Customer Relationship Management (CRM), Customer Relationship Management (CRM) Systems, Data Analysis, Data Mapping, Data Migration, Data Quality, Data Structures, Data Warehousing Applications, Database Extract Transform and Load (ETL), Department of Health and Human Services, Documentation, Documentation Plan, Government, Grant Administration/Management, Homeless Services, ITIL (IT Infrastructure Library), Informatica, Integration Testing, JSON, Leadership, Medicaid, Meeting Minutes, Microsoft Product Family, Microsoft Windows Azure, Middleware, Nonprofit, OAuth, Operational Support, Organizational Skills, Power BI, Privacy Controls, Problem Solving Skills, Product Requirements Document (PRD), Production Support, Project Management Professional (PMP), Project/Program Management, Public Health, REST (Representational State Transfer), Reconciliation, Relational Databases (RDBMS), Reporting Dashboards, Risk Analysis, Risk Management, SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ScrumMaster, Social Work, Software Development, Software Testing, Software as a Service (SaaS), State Government, System Integration (SI), System Test, Tableau, Team Player, Technical Delivery, Technical Leadership, Technical Support, Technical Writing, Test Data, Testing, United States Department of Energy (DOE), Validation Testing, Waterfall Model of Software Development, XML (EXtensible Markup Language)
LOCATION
Sacramento, California(remote)
POSTED
9 days ago
Job Title: Apricot Technical Implementation Lead / Integration Lead (Ref: 5734)
Location: Remote
Rate: DOE

Position Summary
Estrada Consulting, Inc. is seeking an experienced Technical Implementation Lead / Integration Lead to support a Bonterra Apricot implementation for a State government program. This role will serve as the technical coordination lead between Bonterra, State stakeholders, business users, data teams, integration teams, and project leadership.
The ideal consultant will have experience supporting SaaS platform implementations, case management systems, CRM systems, human services platforms, data migration, system integrations, APIs, reporting, testing, and go-live activities. Direct Bonterra Apricot experience is preferred; however, experience with similar configurable SaaS, case management, health and human services, or CRM platforms may be considered.

Key Responsibilities:
  • Serve as the technical implementation lead for assigned Bonterra Apricot implementation activities.
  • Coordinate technical activities between Bonterra, State staff, business users, technical teams, data teams, and third-party vendors.
  • Support implementation planning, technical workstream tracking, issue resolution, risk management, and status reporting.
  • Review business and technical requirements related to Apricot configuration, data structures, integrations, reporting, user roles, workflows, and security.
  • Support planning and coordination for Apricot forms, fields, workflows, user permissions, dashboards, reports, and program-specific configuration needs.
  • Lead or support integration planning between Apricot and external State systems, including API-based integrations, secure file transfers, data feeds, batch uploads, and interface testing.
  • Define and document data exchange requirements, field mappings, source-to-target mappings, interface specifications, validation rules, and integration dependencies.
  • Support data migration activities, including legacy data analysis, data mapping, cleansing coordination, import planning, test loads, validation, reconciliation, and issue resolution.
  • Work with reporting teams and business users to support operational reports, compliance reports, program outcome reporting, dashboards, and executive reporting needs.
  • Support technical testing, system integration testing, data validation testing, user acceptance testing, defect tracking, retesting, and implementation readiness.
  • Coordinate technical cutover planning, go-live support, production deployment activities, post-go-live stabilization, and transition to operations.
  • Prepare and maintain technical documentation, decision logs, interface trackers, data mapping documents, issue logs, meeting notes, and implementation status updates.
  • Ensure technical activities align with State security, privacy, accessibility, data governance, and project delivery requirements.

Required Qualifications:
  • Five or more years of experience supporting technical implementation of SaaS, CRM, case management, health and human services, grants management, or similar enterprise platforms.
  • Experience coordinating system integrations between SaaS platforms and external systems.
  • Experience with REST APIs, JSON, XML, authentication concepts, secure file transfer, ETL processes, or middleware/data exchange tools.
  • Experience with data migration, data mapping, data cleansing, data validation, and reconciliation.
  • Experience working with SQL, relational databases, reporting databases, or data extracts.
  • Experience supporting technical requirements, interface documentation, test planning, defect resolution, and go-live readiness.
  • Experience coordinating with software vendors, client technical teams, business users, and executive stakeholders.
  • Experience supporting public-sector, government, health and human services, social services, behavioral health, workforce, or similar regulated environments.
  • Strong documentation, communication, facilitation, and problem-solving skills.

Preferred Qualifications:
  • Direct experience with Bonterra Apricot, Social Solutions Apricot, Bonterra Case Management, or similar human-services case management platforms.
  • Experience with State government implementations.
  • Experience with Medicaid, public health, social services, child welfare, behavioral health, homelessness services, workforce programs, grants management, or nonprofit program reporting.
  • Experience with integration tools such as MuleSoft, Boomi, Workato, Azure Logic Apps, Power Automate, SSIS, Azure Data Factory, Informatica, Talend, or similar tools.
  • Experience with reporting tools such as Power BI, Tableau, SQL Server Reporting Services, or built-in SaaS reporting tools.
  • Experience with Agile, hybrid, or waterfall project delivery environments.
  • PMP, Scrum Master, ITIL, Microsoft, data, cloud, or integration-related certifications are a plus.

Technical Skills:
  • Bonterra Apricot or comparable case management / CRM / SaaS platforms.
  • REST APIs, JSON, XML, OAuth/authentication concepts.
  • Secure file transfer, data feeds, batch imports, and interface testing.
  • SQL, data extracts, data mapping, ETL, and data validation.
  • Reporting and dashboard support.
  • Data migration and legacy system conversion.
  • Requirements documentation and technical specifications.
  • UAT, system integration testing, defect tracking, and go-live support.
  • Microsoft Office 365, Teams, SharePoint, Excel, Visio, Project, Jira, Azure DevOps, Smartsheet, or similar tools.

Desired Consultant Profile
The ideal consultant is a hands-on technical implementation lead who can understand the details of integrations, data migration, reporting, testing, and SaaS configuration while also communicating clearly with non-technical business users and executive stakeholders. This person should be able to keep technical workstreams organized, identify risks early, coordinate across vendors and State teams, and help ensure a smooth Bonterra Apricot implementation.


About Estrada Consulting Incorporated:

Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit http://www.estradaci.com/ to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.

About the Company

E

Estrada Consulting Incorporated

Estrada Consulting, Inc. is a delivering technology-enabled services and solutions to clients throughout the USA. We provide system integration, custom application development, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters in Sacramento, California, was established in year 2000. ECI also holds an active  CMAS and MSA for State of CA. ECI is continually searching for highly skilled consultants with public sector project experiences in Project Management / PMP, Solutions and Enterprise Architecture, IT Systems Analysts, Business Analysts and Agile Scrum. Please reach out to jacquelinep@estradaci.com

COMPANY SIZE
20 to 49 employees
INDUSTRY
Computer/IT Services
FOUNDED
2000
WEBSITE
http://www.estradaci.com

Resume Resources

Free Resume TemplatesFree Resume Builder

Similar Job Searches

Chief Information Officer Jobs in Sacramento, CAInformation Systems Manager Jobs in Sacramento, CATechnical Lead Jobs in West Sacramento, CARemote IT JobsEntry Level IT Jobs