Technical Services Consultant- Data Migration

FreeBalance; San Jose (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

FreeBalance seeks a Technical Services Consultant (Data Migration) to implement ERP solutions and enable PFM reform initiatives. You'll design, develop, test, and deploy the FreeBalance GRP while integrating data exchange with external systems and providing expert support to governments.

You will work with banks, government agencies, and financial institutions, leveraging your data migration and integration skills, and supporting BI reporting and performance tuning across environments.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of professional IT experience including technical consulting, implementation, or ERP support.
• Experience in ERP implementation and system integration using SOAP/REST APIs.

Responsibilities

• Configure and customize web services based on project requirements.
• Perform web service integration using SOAP and REST standards.
• Develop and optimize BI reports and dashboards (BIRT/Jasper/Power BI).
• Design ANSI SQL queries for multiple databases.
• Support deployment and performance of Apache Tomcat.
• Provide technical guidance and knowledge transfer to in‑country teams.
• Collaborate with Sales/Pre‑Sales for technical insights on projects.

Skills

ERP implementation

System integration

SOAP/REST APIs

BI reporting tools

SQL

Data modeling

Tomcat administration

Linux/Windows

Travel internationally

Cross‑cultural collaboration

Education

Bachelor's degree in CS/IT

Tools

BIRT

Jasper Reports

Power BI

Pentaho

Job description

As a Technical Services Consultant (Data Migration), you will have the opportunity to contribute to our ongoing success by delivering high-quality and timely technical implementation support and services that enable Public Financial Management (PFM) reform initiatives for governments around the world.

During the implementation of the FreeBalance Accountability Suite, you will leverage your technical expertise in ERP implementation to design, develop, implement, test, and deploy the FreeBalance Government Resource Planning (GRP) solution. You will collaborate with multiple stakeholders across banks, government agencies, and financial institutions to design and implement data exchange mechanisms and system integration. Leveraging your expertise in data migration, systems integration, and technical analysis, you will serve as a subject matter expert, ensuring smooth and successful project outcomes for our customers.

In this role, you will also serve as a Technical Solution Consultant to the in‑country project teams, ensuring effective knowledge transfer and adherence to best practices. Additionally, you will work closely with the Sales and Pre‑Sales Teams to provide technical insights for existing and prospective customer projects, assist in preparing responses to RFPs, and act as a subject matter expert during technical analysis and specification phases.

Main responsibilities:

• Configure and customize web services based on project and system requirements.
• Perform web service integration using SOAP and REST standards between FreeBalance GRP and external systems.
• Develop, maintain, and optimize BI reports and dashboards using BIRT, and support similar tools such as Jasper Reports, Crystal Reports, Power BI, Pentaho, or Apache BI Suite.
• Design and tune ANSI SQL queries to ensure optimal performance and data accuracy across multiple database platforms.
• Understand and work with data structures, including data cubes, dimensions, and fact tables, to ensure accurate and efficient reporting.
• Support deployment, configuration, and performance optimization of application servers such as Apache Tomcat.
• Monitor system performance, troubleshoot technical issues, and implement corrective actions.
• Provide technical guidance, training, and post‑implementation support to in‑country teams and client stakeholders.
• Collaborate with internal teams and client representatives to ensure successful delivery of technical solutions aligned with project timelines and quality standards.
• English proficiency is required, and knowledge of other languages in addition to the native language (Spanish) is considered an asset.

Required Skills and Experience:

• Proven experience in ERP implementation and system integration using SOAP/REST APIs.
• Hands‑on experience with BI and dashboard tools, primarily BIRT, and familiarity with JasperReports, Crystal Reports, Power BI, Pentaho, or Apache BI Suite.
• Strong knowledge of ANSI SQL, query optimization, and report performance tuning.
• Solid understanding of data modeling concepts, including data cubes, dimensions, and fact tables.
• Practical experience with web servers such as Apache Tomcat, including deployment and environment configuration.
• Good working knowledge of Linux and Windows operating systems.
• Experience in ERP environments and public sector or government projects is a plus.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Minimum 5 years of professional IT experience, including technical consulting, implementation, or ERP support.
• Strong analytical, troubleshooting, and communication skills.
• Ability to work effectively with multicultural teams and government clients.
• Willingness to travel internationally for project delivery and customer support.

We thank all applicants for their interest; however, only those selected for an interview will be contacted. FreeBalance is an inclusive employer dedicated to building a diverse workforce to increase the representation of the designated groups based on each country’s legislation. We encourage applications from all qualified candidates and will accommodate applicants’ needs under the respective labour law throughout all stages of the recruitment process.