Professional Services Senior Consultant
Pendo.io
Business Integration Consultant
Guidehouse
full-time
Posted on:
Location Type: Office
Location: San Francisco • California • 🇺🇸 United States
Visit company websiteSalary
💰 $113,000 - $188,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AWSAzureETLInformaticaSQL
About the role
- Support system modernization efforts across state and local government clients, focusing on data migration, integration, and conversion
- Plan and execute end-to-end data conversion and migration efforts, from legacy system extraction to modern platform ingestion
- Design and manage system interfaces using APIs, middleware, or data integration tools
- Translate business rules and legacy logic into modern data mapping and transformation approaches
- Collaborate with client and internal technical teams to ensure integration points are well defined, documented, and implemented
- Lead data profiling and data quality assessments to inform migration planning and remediation
- Contribute to the development of conversion strategies, sequencing plans, and cutover timelines
- Coordinate across delivery and testing teams to validate migrated data and support UAT/readiness
- Provide technical oversight on data architecture decisions within the broader program delivery framework
Requirements
- Bachelor's degree from an accredited University
- 5+ years of overall work experience
- Experience in IT or consulting, including data migration, data integration, or system interface projects
- Experience with public sector data modernization efforts (e.g., UI, tax, case management, benefits)
- Strong knowledge of ETL processes, data mapping, and conversion tools
- Familiarity with modern API design, data pipelines, and integration frameworks
- Ability to understand and troubleshoot data lineage across systems
- Strong interpersonal and communication skills, especially in a cross-functional delivery environment
- Experience with tools such as Talend, Informatica, MuleSoft, Boomi, Azure Data Factory, or similar (nice to have)
- Familiarity with legacy technologies (e.g., COBOL, VSAM, mainframe datasets) (nice to have)
- Experience with AWS tools (e.g., AWS Glue), Modern Databases (e.g., Snowflake) and SQL (nice to have)
- Understanding of data architecture principles including data modeling, metadata management, and information governance (nice to have)
- Background in developing test data sets and validating conversions with QA/UAT teams (nice to have)
- Prior experience working within state or local government transformation programs (nice to have)
Benefits
- Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package
- Medical, Rx, Dental & Vision Insurance
- Personal and Family Sick Time & Company Paid Holidays
- Position may be eligible for a discretionary variable incentive bonus
- Parental Leave and Adoption Assistance
- 401(k) Retirement Plan
- Basic Life & Supplemental Life
- Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
- Short-Term & Long-Term Disability
- Student Loan PayDown
- Tuition Reimbursement, Personal Development & Learning Opportunities
- Skills Development & Certifications
- Employee Referral Program
- Corporate Sponsored Events & Community Outreach
- Emergency Back-Up Childcare Program
- Mobility Stipend
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data migrationdata integrationdata conversionETL processesdata mappingAPI designdata pipelinesdata architecturemetadata managementinformation governance
Soft skills
interpersonal skillscommunication skillscollaborationleadershiporganizational skills
Certifications
Bachelor's degree