Senior Azure Data & Integration Engineer; ADF, SSIS, APIs, iPaaS CF

Job Details

Job Title: Senior Azure Data & Integration Engineer (ADF, SSIS, APIs, iPaaS) - (CF0011)

Location: Calabasas, CA 91302 (Hybrid)

Employment Type: Permanent

Business Unit: Corporate IT

Posting Date: 04/13/2026

Compensation Range: $140,000 - $156,000/year

Notes: Only qualified candidates need apply. Eligible for a hybrid work schedule split between home & office, with a minimum of 3 days in the office each week.

3 Key Consulting has been retained to identify a Senior Azure Data & Integration Engineer (ADF, SSIS, APIs, iPaaS) for a permanent opportunity with our direct client, a leading multi-brand hospitality company with enterprise-scale operations.

Important: Candidates must be authorized to work in the United States. This position is not open to new visa sponsorship. Candidates who require employer sponsorship now or in the future will not be considered. H-1B transfer candidates may be considered.

The Senior Data Engineer will be an integral part of the Integrations team within our Information Technology department. They will have the responsibility to design, develop, support, and optimize data pipelines and architectures using modern iPaaS solutions and other cloud-based data processing and storage solutions. They will collaborate with various stakeholders to identify data needs and utilize best practices to integrate with disparate systems for data sharing.

• Deadline Driven: you understand that deliverables are due by a specific date and time, and your time management and work ethic gets you there with ease.
• A Team Player: you’re a collaborative team player who shows respect for the views and contributions of others while building team spirit across the department.
• Highly Organized: in a dynamic work environment with many moving parts, you easily prioritize your responsibilities while maintaining deadlines.
• Adaptable: you’re at ease in a fast-paced environment and you’re able to change direction rapidly when priorities, deadlines, or personalities shift.
• Accountable/Responsible: you’re able and willing to take initiative and ownership for getting things done (within a supportive team environment).

• Azure Data Factory (ADF) + End-to-End Data Pipeline Development
• Data Integration (APIs, Messaging, System Connectivity)
• Advanced SQL (Performance Tuning + Data Modeling)
• Ownership & Accountability (Execution in a Complex Environment)
• Cross-Functional Communication (Translating Business ↔ Technical)

• Design, develop, and maintain scalable, fault-tolerant data pipelines using ETL/ELT frameworks to support ingestion, transformation, and integration of structured and unstructured data.
• Implement integration solutions with external systems via REST APIs, SOAP services, and message queues (e.g., RabbitMQ and Kafka) to enable real-time and batch data exchange.
• Partner cross-functionally with Business Analysts, BI teams, and stakeholders to translate business requirements into technical designs, data contracts, and production-ready solutions.
• Optimize and troubleshoot data systems (Azure SQL Database, Azure Data Factory, SSIS) for performance tuning, query optimization, and cost efficiency.
• Design and implement robust data models for analytical and transactional systems ensuring referential integrity and scalability.
• Implement best practices for data management, including data governance, security (RBAC, password-less auth), compliance, and auditing using Azure Purview or similar tools.
• Maintain comprehensive documentation of data workflows, architecture diagrams, and integration patterns.
• Mentor and support junior engineers through code reviews, design guidance, and troubleshooting, helping raise overall engineering quality and delivery consistency.
• Lead proofs of concept (POCs) and evaluate tools such as Snowflake, Databricks, and Airflow, providing recommendations to improve architecture, scalability, and operational maturity.
• Leverage CI/CD pipelines for Azure functions, data factory and SSIS using Git Hub Actions to ensure automated deployments and version control.
• Work with cloud-native storage and compute…