Senior Consultant (SAS)

Mirai Advisory SL; Ciudad de México; Presencial; MXN 895.897 - 1.254.255; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible hours

Career growth opportunities

Comprehensive benefits package

Descripción de la vacante

A technology firm specializing in financial solutions is seeking a highly skilled Consultant to join their Consulting team. This position involves extracting and transforming data from client Data Warehouses using advanced SQL and requires significant experience with large data environments. Ideal candidates will have a Bachelor’s degree and proven problem-solving skills. The role offers a remote work model with occasional on-site meetings in Mexico City, providing a flexible work-life balance and a robust benefits package.

Formación

• 3+ years of experience working with large databases in data analysis or financial systems integration.
• Extensive experience working with enterprise-level Data Warehouses or large-scale data ecosystems.
• English proficiency at B2 or higher.

Responsabilidades

• Collaborate with client stakeholders to understand data requirements and business logic.
• Extract and transform data from the client’s Data Warehouse using SQL.
• Analyze and adapt existing SAS code to align with project needs.

Conocimientos

Advanced SQL

SAS programming

Data analysis

Data management

Problem-solving

Educación

Bachelor’s degree in Mathematics, Actuary, Engineering or related field

Herramientas

SQL

Python

SAS

Descripción del empleo

Your mission

About Mirai RiskTech

Mirai RiskTech is the global technology leader in Balance Sheet Management, Financial Risk and Regulation. With pioneering SaaS Solutions and consulting services, we empower banks to shorten the path to success in risk management and regulatory compliance.

Mirai RiskTech operates with fully remote operations and main employee hubs in Madrid, Mexico City, and Boston. Our team comprises 150 professionals from over 20 countries, fostering a collaborative international culture at the intersection of technology, data, consulting, and finance.

About the Role

Mirai RiskTech is seeking a highly skilled and analytical Consultant to join our Consulting team. This role is ideal for a professional with strong experience in enterprise data environments, advanced SQL expertise, and the ability to interpret and translate complex data logic into efficient, high‑quality outputs.

As a Senior Consultant, you will play a key role in supporting the integration of our proprietary financial software platform by guiding clients through the preparation, structuring, and validation of data sourced input from their enterprise Data Warehouse. You will collaborate closely with client stakeholders, technical teams, and internal specialists to ensure data is accurately analyzed, transformed, and aligned with platform requirements.

Key Responsibilities

• Collaborate with client stakeholders to understand data requirements and business logic
• Extract and transform data from the client’s Data Warehouse using SQL
• Analyze and adapt existing SAS code to align with project needs
• Support the configuration and testing of data inputs for the internal financial software platform
• Document processes and provide feedback to improve data integration workflows
• Ensure high-quality deliverables and maintain strong client communication
• Identify data quality issues, propose remediation steps, and support the client in implementing corrective actions
• Produce clear and well‑structured documentation, including data transformation rules, validation procedures, and workflow guidance

Your profile

We are looking for a detail‑oriented and highly analytical professional with strong problem‑solving abilities and a deep interest in data integration and enterprise‑level information systems. The ideal candidate is someone who:

• Demonstrates advanced proficiency in SQL and is comfortable working with large, complex Data Warehouse environments.
• Has experience interpreting, optimizing, and translating SAS‑based data logic into efficient SQL transformations.
• Possesses a solid understanding of data flows, data quality frameworks, and end‑to‑end data preparation processes to support accurate and reliable software integration.

Qualifications

• Bachelor’s degree in Mathematics, Actuary, Engineering or a related field.
• English proficiency at B2 or higher (required)
• Extensive experience working with enterprise‑level Data Warehouses or large‑scale data ecosystems
• 3+ years of experience working with large databases in data analysis, or financial systems integration
• Proficiency in SQL and familiarity with SAS programming
• Strong analytical and problem-solving skills
• Strong knowledge in programming languages - SQL, Python, SAS
• Solid domain of SQL extraction and data management

Location

This position is based in Mexico and primarily follows a remote work model, with occasional on‑site meetings as needed for business purposes.

Why us?

At Mirai Risk Tech, our people are our greatest asset. We offer flexibility, work‑life balance, and a comprehensive benefits package designed to support your professional and personal growth.

• Work From Anywhere: Remoteworkondemandofeachposition
• Events: on‑site and on‑line events to foster team bonding
• Flexible Hours: Enjoy shorter workdays on Fridays
• Career Growth: We offer multiple fast‑paced career paths with annual performance reviews
• Attractive benefit package

Mirai offers equal opportunities and accepts applications from all the sectors of the society, the company does not discriminate for race, religion, ethnical origin, incapacity, age, nationality, marital status, sexual orientation, gender identity, or any other motive protected by the current law. Personal data will be processed by Mirai as responsible to evaluate the authenticity of the application for this position or other ones. You can see the policy in this link https://www.mirairisktech.com/privacy-policy