Consultant - Data Integration Engineer (BOOMI)

Who We Are

HIKE2 is a leading provider of technology advisory and implementation services that specializes in empowering a distinct set of industries to define their future and accelerate their path forward. With expertise for law firms, financial services, insurance, business service providers, and high-tech SaaS companies, our team addresses complex and evolving challenges by providing advisory services and tailoring cutting-edge cloud solutions, AI initiatives, and data & analytics programs.

We are a collaborative, diverse, and action-oriented group of consultants who work iteratively to capture client mindsets and solve the most complex business problems. For our teams, there’s no such thing as “cookie-cutter” advice or solutions. We thrive in change and love going from blank slate to truly innovative ideas and creative breakthroughs, developing solutions from our deep, cross-discipline expertise shaped by senior advisors and practical experience.

We care deeply about our clients, building strong and positive relationships with their partners and fellow guides, and the impact of their work.

At HIKE2:

• We work in teams

• We are committed to our customer success and each other’s success

• We set the bar high and challenge one another

• We are passionate about emerging technologies and love the thrill of venturing to the edge of technology

• We get out from behind our desks and go to the drawing board

• We gather information and get to know our clients face to face

Are you ready to make a change? Join our growing team and excel in your career!

How We’ll Align

We are looking for a Data Integration Consultant who will report directly to the Data Practice Manager and play a critical role in building and optimizing the firm’s data integration pipelines. The ideal candidate will have deep hands-on expertise in designing, building, and managing complex data integration workflows, with a strong focus on tools like Dell Boomi, Matillion, and other modern data integration platforms. The role requires expertise in API integration, Change Data Capture (CDC), batch processing, delta processing, and experience working within enterprise bus architectures to ensure seamless data flow across systems.

The Data Integration Consultant will manage the end-to-end integration process, ensuring data is accurately and efficiently moved between source systems, data warehouses, and business intelligence platforms while maintaining data quality, consistency, and timeliness.

Key Responsibilities:

• Data Integration Pipeline Development - Design, build, and manage scalable and reliable data integration pipelines using tools like Dell Boomi, Matillion, and Fivetran.

• Implement and optimize ETL/ELT workflows to ensure efficient data movement between internal and external systems.

• Develop real-time and batch integration processes that meet business requirements while ensuring data accuracy and timeliness.

• API and Enterprise System Integration- Implement and maintain API-based integrations between various data sources and systems, including Salesforce, Workday, and Aderant.  Ensure seamless two-way data synchronization between SQL databases and external APIs. Work closely with cross-functional teams to integrate API services into the firm’s data architecture.

• Change Data Capture (CDC) & Delta Processing - Implement and manage Change Data Capture (CDC) mechanisms across various databases (e.g., SQL, cloud databases) to track and propagate changes in real-time. Develop and implement batch and delta processing strategies to optimize data flow, minimize latency, and ensure timely updates.  Ensure accurate and consistent data capture for historical data tracking and auditing purposes.

• Data Quality and Governance - Ensure high data quality across all integration processes, performing regular checks and validations to detect and correct any inconsistencies.

• Enterprise Bus Architecture - Contribute to designing and implementing the firm’s Enterprise Bus Architecture, ensuring smooth data exchange between various internal and external systems.  Build and manage processes to propagate real-time changes from SQL tables and other systems to the enterprise bus.  Ensure the enterprise bus efficiently handles data flows and event-driven processing across the firm’s data ecosystem.

• Performance Optimization - Continuously monitor and improve the performance of data integration pipelines to ensure optimal throughput and latency.  Identify bottlenecks and inefficiencies in existing processes and propose solutions to improve data flow and processing time.

• Collaboration and Communication - Work closely with the data warehouse and analytics teams to ensure the data integration pipelines meet business needs and reporting requirements.  Collaborate with external vendors and stakeholders to maintain integrations with third-party tools and systems (e.g., Aderant, Intapp, Workday).  Provide technical documentation and training to other team members to ensure data integration systems' successful operation and maintenance.