Principal Data Integration Engineer

Principal Data Integration Engineer

As a Principal Data Integration Engineer, you will play a critical role in designing and supporting existing data integrations that power Cambium's finance, sales, and human capital management systems. Our team's mission is to seamlessly connect our internal and external platforms to streamline daily operations. By leveraging high-performance solutions, you will accelerate strategic planning and provide executive visibility while maintaining the highest standards of data integrity and corporate security.

Job Responsibilities:

• Accountable for any piece or the entirety of the software delivery lifecycle, including requirements, design, implementation, testing, release, and hypercare.
• Delivering robust enterprise-grade ERP solutions, primarily through SQL-driven pipelines with selective use of middleware.
• Providing architectural design oversight and alignment to team implementation efforts.
• Maintaining the business perspective in understanding and affecting how systems are implemented to satisfy user goals.
• Developing systems that adhere to a high standard of quality where our team's successful delivery is a direct result of our own testing diligence.
• Keeping informed of ecosystem technical advances, and capable of proposing changes based on alternative technology.
• Participating on multiple projects at the same time, stabilizing needs, and deadlines.
• Providing technical guidance and mentorship to other team members.

Job Requirements:

• Possesses 10+ years of software engineering experience, with a specific focus on MS SQL Server.
• Writes, optimizes, and debugs complex T-SQL queries, views, stored procedures, user-defined functions, and triggers to support ETL processes across multiple systems and databases.
• Implements robust automated error-handling, transaction management, and audit logging mechanisms within database processes.
• Orchestrates data workflows across middleware tools, enterprise platforms, and database layers - including proprietary in-house applications - using API-based, file-based, and replication approaches to optimize for performance, scalability, and fault tolerance.
• Develops reusable ETL/ELT frameworks and patterns to standardize integration logic, reduce duplication, and improve maintainability.
• Analyzes unfamiliar source system schemas and accurately maps data elements to target destinations while maintaining strict business logic.
• Troubleshoots and resolves data mismatches, connectivity drops, or pipeline failures quickly within production environments.
• Executes regression testing to ensure database modifications do not negatively impact shared objects, integration processes, or dependent upstream/downstream systems.
• Documents test results, defects, and resolution steps in a structured format to support audit readiness and pre-production validation.
• Collaborates with business stakeholders and end users to facilitate UAT, ensuring integration outputs meet functional expectations before production signoff.
• Follows change management and control standards when modifying production database objects or integration processes.
• Exhibits excellent interpersonal and communication (written and verbal) skills.
• Works with equal effectiveness both independently and alongside multiple cross-functional teams.
• Holds a Bachelor's Degree in Computer Science, Information Systems, or possesses equivalent professional work experience.

Preferred Skills & Abilities:

• Possesses 12+ years of software engineering experience, including 8+ years of dedicated MS SQL Server experience.
• Demonstrates functional knowledge of core financial accounting areas, including Accounts Receivable (banking, settlement, customer accounts, contracts), Accounts Payable (suppliers, procurement), and the General Ledger.
• Proficiency with middleware and integration platforms such as DBAmp, MuleSoft, CData Sync, CData Arc, and Python.
• Background integrating with enterprise platforms such as JDE, Workday, and Salesforce.
• Experience designing and supporting data warehouse or data lake architectures, including dimensional modeling and data staging strategies.
• Possesses a working knowledge of database administrator tasks such as SQL replication and mirroring.
• Maintains a solid understanding of data encoding standards, specifically UTF-8 and Base64.
• Familiarity with cloud-native data services (e.g., Azure Data Factory, Azure SQL, Snowflake pipelines) and their role in modern data architectures.
• Processes and stages data ingested into SQL Server via REST/SOAP APIs and web services.
• Experience developing and consuming web services, including REST, SOAP, and Graph APIs, for data integration across enterprise systems.
• Familiarity with designing scalable service integration patterns, including synchronous and asynchronous API interactions.
• Holds a Master's Degree or possesses equivalent professional work experience.

Remote First Work Environment

Our Remote First approach gives employees the flexibility and trust they need to effectively balance work with life. It creates a culture in which all employees are valued and where success is measured in results. It allows us to work collaboratively, inclusively and for greater positive impact, regardless of our individual locations.

If you will be working remotely, either occasionally or on a permanent basis, you must have a reliable internet connection through a cable or fiber-optic broadband service with minimum speeds of 10 Mbps download and 5 Mbps upload.

The successful candidate will be expected to actively participate in video-based interviews during the recruiting process and ongoing virtual meetings with their camera on, as part of their role. To maintain confidentiality and ensure a fair evaluation process, the use of note-taking tools, reference materials, or AI-powered tools (including generative AI, language models, or similar technologies) during interviews or other selection activities is prohibited unless prior written approval has been obtained from the People Experience team. If you require an exception for medical, accessibility, or other reasons, please contact your Talent Acquisition team member to discuss accommodations in advance.

As part of our Remote-First benefits, Cambium offers reimbursement to help cover the cost of setting up your home or remote office.

An Equal Opportunity Employer

We are dedicated to fostering a culture that celebrates unique backgrounds, ideas, and experiences. All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, age, religion, sex (including pregnancy, gender, gender identity/expression, or sexual orientation), national origin, protected veteran status, disability, or genetic information (including family medical history).

We will provide reasonable accommodations for qualified individuals with disabilities. You may request an accommodation during the recruiting process with your Talent Acquisition team member.