Data Engineer Manager

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll find an environment that inspires and empowers you to thrive both personally and professionally. There’s no one like you and that’s why there’s nowhere like RSM.

Overview

The Data Engineer will be responsible for designing, building, and maintaining scalable data solutions that support Catamaran’s digital outsourcing platform. This individual will focus on enabling data-driven insights, automation, and operational excellence through the implementation of modern data engineering practices. The role requires expertise in Microsoft Azure data services, enterprise-level data integration, and DevOps methodologies.

Key Responsibilities

• Design, build, and optimize data pipelines and workflows within Azure Data Factory, ensuring reliable data ingestion, transformation, and delivery across multiple systems.
• Develop and maintain ETL/ELT processes to support the medallion data architecture (bronze, silver, gold layers) using Azure Data Lake, SQL, and related services.
• Work closely with solution and data architects to implement best practices for data modeling, data quality, and metadata management.
• Create and manage data integrations using APIs and JSON, enabling secure and scalable data exchange across internal and external platforms.
• Collaborate with cross-functional teams—including analytics, applications, and DevOps—to ensure data solutions align with enterprise architecture and performance standards.
• Implement CI/CD pipelines and leverage source control tools (e.g., Git, Azure DevOps) for deployment and version control of data assets.
• Monitor and troubleshoot production data workflows to ensure reliability, data accuracy, and compliance with RSM’s information security standards.
• Contribute to the continuous improvement of Catamaran’s data platform by identifying opportunities for automation, optimization, and innovation.

Required Skills & Qualifications

Technical Expertise:

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field; equivalent experience may be considered.
• 3+ years of experience in data engineering, with proven delivery in an enterprise or managed services environment.
• Strong proficiency in Microsoft Azure services, including Azure Data Factory, Azure Data Lake, Azure SQL Database, Synapse, or Databricks.
• Advanced knowledge of SQL for query optimization, data modeling, and performance tuning.
• Experience working with REST APIs, JSON, and data ingestion frameworks for structured and semi-structured data.
• Understanding of medallion architecture and modern data design principles for scalable, reusable, and governed data products.
• Demonstrated experience with DevOps practices, including CI/CD pipelines, infrastructure as code (IaC) concepts, and source control.
• Familiarity with data governance, data security, and privacy standards, ideally within a regulated or client-service organization.
• Strong analytical, problem-solving, and communication skills with the ability to work effectively in a collaborative and dynamic team environment.
• Experience working with data platforms that support AI and machine learning projects
• Ability to prepare data to be ready and usable for AI models.
• Familiarity with using smart automation tools to improve data performance and reliability.

At RSM, we offer a competitive benefits and compensation package for all our people.  We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients.  Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits   https://rsmus.com/careers/el-salvador.html. 

RSM does not tolerate discrimination and/or harassment based on race; colour; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender (including gender identity and/or gender expression); sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the Salvadoran Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable provincial employment legislation.  

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership. RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please send us an email at careers@rsmus.com.