Integrations Analyst

Overview

You may know us for our huge menu of delicious food…and for being recognized by Fortune Magazine as one of the “100 Best Companies to Work For®” since 2014! What you may not know is that our IT team skillfully supports a global $3.6 billion public company with over 350 full-service restaurants and more than 47,000 total staff members.

As the Integrations Analyst you will be an integral part of the Integrations team within our Information Technology department. You 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. You will collaborate with various stakeholders to identify data needs and utilize best practices to integrate with disparate systems for data sharing.

You’ll thrive in this position if you are:

• 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., Rabbit
  
  MQ and Kafka) to enable real-time and batch data exchange.
• Collaborate with Business Analysts, BI engineers, and stakeholders to translate business requirements into technical specifications and deliver optimized data 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, compliance, and auditing using Azure Purview or similar tools.
• Maintain comprehensive documentation of data workflows, architecture diagrams, and integration patterns.
• Conduct POCs and evaluate technologies like Snowflake, Databricks, Airflow etc. to recommend improvements for data architecture and integration strategies.
• 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 services (Azure Blob Storage, Data Lake Gen2, Functions, Logic Apps, SSIS, ADF) for scalable data processing and integration.
• Develop automation scripts in Python and Power Shell for data processing, orchestration, and operational efficiency.

• 2+ years of hands-on experience with Azure Data Factory, Azure SQL offerings, and SSIS.
• Proficiency in SQL, Python, stored procedures and other data transformation techniques.
• Expertise in optimizing SQL queries using query optimization techniques and other performance tuning strategies.
• Scripting experience utilizing Python/Power Shell.
• Strong problem-solving and data debugging skills.
• Demonstrated ability to learn and adapt to new technologies and methodologies.
• Excellent communication skills and teamwork abilities.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field.

• Restaurant industry experience.
• Familiarity with other cloud-based technologies and services on Azure e.g. Logic Apps, Functions.
• System design and architecture experience.
• Familiarity with modern data warehouses and data processing tools like Databricks, Big Query, Synapse, Snowflake.
• Experience with iPaaS tools like TIBCO, Adeptia, Snap Logic, etc.
• Experience building frameworks and utilities that standardize data quality, logging, monitoring, etc.

• Vacation and sick time
• 401K with company match
• Tuition Reimbursement
• 25%-35% discount when dining as a guest
• Annual stipend for dining in our restaurants

Named to FORTUNE Magazine’s “100 Best Companies to Work For®” list every year since 2014, The Cheesecake Factory Incorporated is a leader in experiential dining. We are culinary-forward and relentlessly focused on hospitality. Delicious, memorable experiences created by passionate people—this defines who we are and where we are going.

We currently own and operate 353 restaurants…