Focused on employment and labor law since 1958, Jackson Lewis P.C.’s 1,000+ attorneys located in major cities nationwide consistently identify and respond to new ways workplace law intersects business. We help employers develop proactive strategies, strong policies and business-oriented solutions to cultivate high-functioning workforces that are engaged and stable, and share our clients’ goals to emphasize belonging and respect for the contributions of every employee.

The Firm is ranked in the First Tier nationally in the category of Labor and Employment Litigation, as well as in both Employment Law and Labor Law on behalf of Management, in the U.S. News - Best Lawyers® “Best Law Firms”.

We seek a Senior Data Integration Engineer who will report directly to the Data Integration and Data Warehouse 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 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 Sr. Data Integration Engineer will lead 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 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.
Lead the end-to-end development of integration solutions using Boomi, support SDLC during the design process, gathering and documenting business requirements, technical requirements, data mapping, plan and execute regression, integration testing, cutover, go-live and post go-live activities.

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.

Collaborate with the data warehouse and analytics teams to ensure data governance policies are followed, with a focus on security and compliance.

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:

Collaborate with cross-functional teams to gather requirements, provide updates, and deliver high-quality integration solutions meeting business needs and any reporting requirements
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.

Required Skills & Experience:

7+ years of hands-on experience in data integration and ETL/ELT pipelines.

Deep experience with data integration platforms, particularly:

Boomi

Matillion

Fivetran

DBT (or similar tools)

Experience with Boomi connectors like SFTP, HTTP Client, DB V2, Azure, etc.
Strong understanding of API integration and building real-time data synchronization between systems.

Proven expertise in Change Data Capture (CDC), batch processing, delta processing, and incremental data loading strategies.

Experience with enterprise bus architecture for managing real-time data flow and event-driven integrations.

Hands-on experience with SQL databases and cloud-based data warehousing platforms (e.g., Snowflake).

Proficiency in building data pipelines for systems like Salesforce, Workday, Aderant, and other cloud-based or enterprise applications.

Strong problem-solving skills and the ability to troubleshoot complex data integration challenges.

Excellent written and verbal communication skills to work effectively with both technical and non-technical stakeholders.

Preferred Qualifications:

Experience with legal domain systems such as Aderant, Intapp Time, Workday, and Compulaw.

Familiarity with cloud platforms (AWS, Azure, or Google Cloud).

Understanding of data governance and data security practices within the legal industry.

Knowledge of data visualization tools (e.g., Tableau, Power BI) and how integrated data supports business reporting and analytics.

Experience working within a regulated industry or compliance-heavy environment.
Ability to understand and write any quick SQL and python scripts
In-depth understanding of API design and development, including RESTful and SOAP protocols.
Familiarity with different data formats, such as JSON, XML, and CSV, and experience with data transformation techniques.
Solid knowledge of authentication and authorization mechanisms, security protocols, and data privacy considerations in integration projects.

Why Join Us:

Play a key role in building and maintaining critical data integration pipelines that power the firm’s data-driven decision-making.

Collaborate with a talented team of data professionals and help shape the firm’s data integration and warehousing strategy.

Competitive salary, benefits, and opportunities for professional growth within a fast-paced and innovative legal services firm.

Be part of a team that embraces cutting-edge technologies and fosters a culture of innovation and collaboration.

#LI-LM1

#LI-Hybrid

For New York, the expected salary range for this position is between $ 151,400 and $ 177,000 per year. The actual compensation will be determined based on experience and other factors permitted by law.

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, national origin, gender, age, religion, disability, sexual orientation, veteran status, marital status or any other characteristics protected by law.

Jackson Lewis

Latest Jobs

Sr. Data Integration Engineer