Calabasas Hills, California, USA
26 days ago
Integrations Analyst
Position Overview: Compensation Range $95,000 - $110,000 / Year 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®” 11 years in a row! What you may not know is that our IT team skillfully supports a global $3.4 billion public company with over 300 full-service restaurants and more than 47,500 total staff members. As the Integrations Analyst you will be an integral part of the Integrations team within our Information Technology department. You'll 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: Builder of Bridges: By joining forces with diverse experts, you craft dynamic data pipelines and integration solutions that fuel our business's rocket ship to success. Data systems detective: Whether it's diving deep into Azure SQL mysteries or untangling Data Factory knots, you thrive on optimizing and troubleshooting to keep the data highways flowing smoothly. Precision architect of data realms: With meticulous care, you craft sturdy data models and safeguard their integrity—keeping governance, security, and auditing standards top-notch. Tech chameleon: Flexing with the times, eagerly embrace new tools and technologies. Through POCs, drive innovations that revolutionize our data integration, keeping us ahead of the curve. Master of the art of communication: From brainstorming with Business Analysts and BI engineers to decoding stakeholder needs, you ensure the data solutions speak volumes—clear, concise, and always on point. Here’s more of what you’ll get to do: Design, develop and maintain scalable data pipelines to support data integration and processing. Implement integration solutions with external systems to facilitate data exchange and synchronization. Collaborate with Business Analysts, BI engineers, and other stakeholders to gather requirements and deliver data solutions. Optimize and troubleshoot data systems (Azure SQL, Data Factory, SSIS) for performance and reliability. Provide production support for data pipelines to ensure continuous and reliable operation. Design and implement robust data models to ensure data quality and consistency. Implement best practices for data management, including data governance, security, and auditing. Maintain documentation of data workflows, architectures, and processes to ensure clarity and continuity. Assess new tools or technologies by conducting POCs and presenting recommendations. What we require: 1+ years of hands-on experience with Azure Data Factory, Azure SQL offerings, and SSIS. Proficiency in SQL, stored procedures, triggers, and other data transformation techniques. Expertise in optimizing SQL queries using query optimization techniques and other performance tuning strategies. Scripting experience utilizing Python/C#/JavaScript. 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. What we prefer: 3+ years of hands-on experience with Azure Data Factory, Azure SQL offerings, and SSIS. Restaurant industry experience. Experience with iPaaS tools like TIBCO, Adeptia, SnapLogic, etc. Familiarity with other cloud-based technologies and services on Azure e.g. Logic Apps, Functions. System design and architecture experience. Familiarity with any of the modern data warehouses and data processing tools like Databricks, BigQuery, Synapse, Snowflake etc. Experience building frameworks and utilities that standardize implementation of data quality, logging, monitoring etc. Azure certifications e.g. Azure Fundamentals, Azure Data Fundamentals, Azure Data Engineer About the Company: Recognized as a Fortune 100 Best Companies to Work For® since 2014, The Cheesecake Factory Incorporated is a global $3.4 billion public company with 47,500 staff members across more than 300 casual dining restaurants, including The Cheesecake Factory, North Italia, Grand Lux Cafe and Fox Restaurant Concepts. Internationally, 30 The Cheesecake Factory restaurants operate under licensing agreements. Our Bakery division creates over 35,000 delicious cheesecakes per day and other baked products for our restaurants, international licensees, and third-party bakery customers. We offer a people-centered culture and are committed to creating an inclusive workplace for all. We welcome applicants from a wide variety of identities, ideas, perspectives, and experiences, and encourage individuals from underrepresented backgrounds to apply. #SoCheesecake #LifeAtCheesecake The Cheesecake Factory Incorporated is an Equal Opportunity Employer and offers reasonable accommodations to job applicants with disabilities.
Confirm your E-mail: Send Email