Data Integration Architect II

Sodexo; Bethesda (MD); Remote; USD 100,000 - 130,000; Full time

Job summary

A leading global provider of integrated food services and facilities management seeks a Data Integration Architect II. The role involves designing and maintaining comprehensive data integration solutions to support enterprise-wide initiatives, ensuring seamless data flow across various applications and platforms. Ideal candidates should have extensive experience with ETL processes and strong proficiency in modern data integration technologies.

Benefits

Medical, Dental, Vision Care

401(k) Plan with Matching Contributions

Paid Time Off and Company Holidays

Career Growth Opportunities and Tuition Reimbursement

Qualifications

• 3+ years of experience in data integration, ETL, or data architecture.
• Hands-on experience with Informatica IDMC, Azure Data Factory, and Databricks.
• Strong knowledge of SQL Server and Oracle DB.

Responsibilities

• Design, develop, and maintain data integration solutions.
• Build and optimize reusable data pipelines.
• Monitor, troubleshoot, and resolve data integration workflows.

Skills

Data integration

ETL

Problem-solving

Communication

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Informatica IDMC

Microsoft Azure Data Factory

Azure Databricks

Microsoft SQL Server

Oracle DB

Job description

Role Overview

Sodexo is seeking a Data integration Architect II

This is aremoterole with the selected candidate able to work Eastern Standard Time Zone Hours

The Data Integration Architect II is responsible for designing, developing, and maintaining data integration solutions to support enterprise-wide data initiatives. This role ensures efficient data flow across applications, platforms, and business units using modern data integration technologies and best practices. The Data Integration Architect II collaborates with business and IT teams to deliver robust, scalable, and secure data pipelines and integration architectures.

What You'll Do

• Design, develop, and maintain data integration solutions across multiple systems and platforms.

• Build and optimize reusable and scalable data pipelines using Informatica IDMC (CDI and CAI), Microsoft Azure Data Factory, and Microsoft Azure Databricks.

• Manage structured and unstructured data integrations utilizing Microsoft SQL Server, Oracle DB, and Azure Data Lakes.

• Develop and maintain ETL processes using Informatica PowerCenter and other integration tools.

• Ensure integration solutions adhere to architectural standards, best practices, and security policies.

• Monitor and troubleshoot data integration workflows, identifying and resolving issues proactively.

• Work with internal customers to understand data needs and translate them into technical integration requirements.

• Document data flows, system integrations, and technical specifications.

• Support integration testing, system testing, and user acceptance testing.

• Collaborate with cross-functional teams, including data engineers, business analysts, and software developers, to enhance integration capabilities.

What We Offer

Compensation is fair and equitable, partially determined by a candidate's education level or years of relevant experience. Salary offers are based on a candidate's specific criteria, like experience, skills, education, and training. Sodexo offers a comprehensive benefits package that may include:

• Medical, Dental, Vision Care and Wellness Programs
• 401(k) Plan with Matching Contributions
• Paid Time Off and Company Holidays
• Career Growth Opportunities and Tuition Reimbursement

More extensive information is provided to new employees upon hire.

What You Bring

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience)

• 3+ years of experience in data integration, ETL, or data architecture.

• Hands-on experience with Informatica IDMC (CDI and CAI), Microsoft Azure Data Factory, and Azure Databricks.

• Strong knowledge of Microsoft SQL Server and Oracle DB.· Experience in developing and maintaining ETL workflows with Informatica PowerCenter.

• Familiarity with data lake architectures and cloud-based integration solutions.

• Solid understanding of API-based data integration, RESTful services, and event-driven architectures.

• Strong analytical and problem-solving skills.

• Excellent communication and interpersonal skills, with the ability to work in a customer-facing role.

• Experience working with cloud-based data platforms, especially in Microsoft Azure a plus

• Knowledge of data security and governance best practices a plus

• Understanding of Agile methodologies and DevOps practices a plus

• Certifications in Azure or Informatica technologies are a plus.

Who We Are

At Sodexo, our purpose is to create a better everyday for everyone and build a better life for all. We believe in improving the quality of life for those we serve and contributing to the economic, social, and environmental progress in the communities where we operate. Sodexo partners with clients to provide a truly memorable experience for both customers and employees alike. We do this by providing food service, catering, facilities management, and other integrated solutions worldwide.

Our company values you for you; you will be treated fairly and with respect, and you can be yourself. You will have your ideas count and your opinions heard because we can be a stronger team when you’re happy at work. This is why we embrace diversity and inclusion as core values, fostering an environment where all employees are valued and respected. We are committed to providing equal employment opportunities to individuals regardless of race, color, religion, national origin, age, sex, gender identity, pregnancy, disability, sexual orientation, military status, protected veteran status, or any other characteristic protected by applicable federal, state, or local law. If you need assistance with the application process, please complete this form.

Qualifications & Requirements

Minimum Education Requirement - Bachelor’s Degree or equivalent experienceMinimum Functional Experience - 3 years