Integrations Analyst

Compensation Range

$48.00 – $52.50 / Hour

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 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.

• 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.
• 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.
• 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.
• 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, you eagerly embrace new tools and technologies. Through POCs, you drive innovations that revolutionize our data integration, keeping us ahead of the curve.

• 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 (RBAC, password‑less auth), 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.