Lead DWH/BI Consultant

SimCorp; Ciudad de México; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible hours

Hybrid model

Medicover healthcare

Descripción de la vacante

SimCorp in Mexico City is seeking a seasoned Data & BI Consultant to support client reporting deployments and data platform modernization. You will advise on data warehouse/BI solutions, run workshops with business and technical teams, and design ETL/ELT pipelines to deliver high-volume data processing in cloud environments.

You will contribute to project delivery, mentor junior consultants, and help establish implementation standards within an international, multicultural team.

Formación

• Minimum 7 years of professional IT experience.
• Hands-on experience with Oracle and Snowflake databases.
• Understanding of database concepts and data modeling for analytics and reporting solutions.
• Understanding of Data Warehouse and ETL/ELT concepts.
• Experience with processing/migrating high volumes of data.
• Familiarity with cloud environments (Azure data stack preferred).
• SQL and PL/SQL programming skills.
• Experience implementing Business Intelligence (QlikView/QlikSense or Power BI).
• Experience delivering project work (as a member of project teams organized in agile or waterfall methodologies).
• Comfortable with business requirements gathering and clarification, including direct work with business users.
• Ability to coordinate small projects, workstreams, or work groups as a lead consultant.
• Experience working as a consultant for external clients (prior experience in Consulting Services).
• Experience working in an international or multicultural environment.
• Nice to have Basic knowledge of financial instruments and markets, or experience working with financial data and business processes related to investment management.
• Familiarity with Ms Fabric Python development skills focused on automation and data pipeline processing, including data manipulation frameworks such as Pandas.
• Interest in developing your career as a consultant in the Data Warehouse and Business Intelligence field for a top brand in the fintech sector.

Responsabilidades

• Act as a trusted advisor, supporting our clients in the Data Warehouse/Business Intelligence area.
• Facilitate requirements gathering workshops in both business and technical areas.
• Participate in data platform modernization initiatives to offer clients the best cloud experience for data warehouse and Business Intelligence/reporting solutions.
• Design, implement, and test changes to the Data Warehouse model and ETL workflows.
• Work with data ingestion and extraction pipelines.
• Test and optimize processes and tools to meet performance and data quality requirements.
• Leverage project experience to estimate and plan delivery of a small team.
• Demonstrate growth as a subject matter expert (SME) for SimCorp products or technologies.
• Participate in the company knowledge-sharing culture, mentor junior consultants, and contribute to the improvement or creation of implementation standards.

Conocimientos

Oracle

Snowflake

Data Warehouse

ETL/ELT

SQL

Power BI

QlikView/QlikSense

Python (Pandas)

Herramientas

QlikView

QlikSense

Power BI

Azure data stack

Descripción del empleo

WHAT MAKES US, US

Join some of the most innovative thinkers in FinTech as we lead the evolution of financial technology. If you are an innovative, curious, collaborative person who embraces challenges and wants to grow, learn and pursue outcomes with our prestigious financial clients, say Hello to SimCorp! At its foundation, SimCorp is guided by our values – caring, customer success-driven, collaborative, curious, and courageous. Our people-centered organization focuses on skills development, relationship building, and client success. We take pride in cultivating an environment where all team members can grow, feel heard, valued, and empowered. If you like what we’re saying, keep reading!

WHY THIS ROLE IS IMPORTANT TO US

We are expanding the ADC Data & Communication team, which operates across Warsaw, Manila, and Mexico City. The DWH/BI Consultant is a highly skilled professional working within Consulting Services and based at the Advanced Delivery Center. The primary purpose of this role is to provide expert advice and functional delivery for the successful deployment of SimCorp Client Reporting products and services within a client's environment.

WHAT YOU WILL BE RESPONSIBLE FOR

• Act as a trusted advisor, supporting our clients in the Data Warehouse/Business Intelligence area.
• Facilitate requirements gathering workshops in both business and technical areas.
• Participate in data platform modernization initiatives to offer clients the best cloud experience for data warehouse and Business Intelligence/reporting solutions.
• Design, implement, and test changes to the Data Warehouse model and ETL workflows.
• Work with data ingestion and extraction pipelines.
• Test and optimize processes and tools to meet performance and data quality requirements.
• Leverage project experience to estimate and plan delivery of a small team.
• Demonstrate growth as a subject matter expert (SME) for SimCorp products or technologies.
• Participate in the company knowledge-sharing culture, mentor junior consultants, and contribute to the improvement or creation of implementation standards.

WHAT WE VALUE

• Minimum 7 years of professional IT experience.
• Hands-on experience with Oracle and Snowflake databases.
• Understanding of database concepts and data modeling for analytics and reporting solutions.
• Understanding of Data Warehouse and ETL/ELT concepts.
• Experience with processing/migrating high volumes of data.
• Familiarity with cloud environments (Azure data stack preferred).
• SQL and PL/SQL programming skills.
• Experience implementing Business Intelligence (QlikView/QlikSense or Power BI).
• Experience delivering project work (as a member of project teams organized in agile or waterfall methodologies).
• Comfortable with business requirements gathering and clarification, including direct work with business users.
• Ability to coordinate small projects, workstreams, or work groups as a lead consultant.
• Experience working as a consultant for external clients (prior experience in Consulting Services).
• Experience working in an international or multicultural environment.
• Nice to have Basic knowledge of financial instruments and markets, or experience working with financial data and business processes related to investment management.
• Familiarity with Ms Fabric Python development skills focused on automation and data pipeline processing, including data manipulation frameworks such as Pandas.
• Interest in developing your career as a consultant in the Data Warehouse and Business Intelligence field for a top brand in the fintech sector.

BENEFITS

• Flexible working hoursand hybrid model - 2 days in the office, 3 days remote
• Modern office (next to Wilanowska metro station) with quiet zones and ergonomic workstations
• Base salary with annual bonus structure
• Holiday allowance upon a 2-week vacation
• Occasional remote work across Poland and international options available (up to 24 days domestic, 20 days international per year - subject to internal policy)
• Employer-paid Medicover Platinum healthcare package (employee-paid family upgrade available)
• Multisport card with 75% employer contribution
• Unum group life insurance (employee-paid upgrade available)
• Medicover travel insurance for private trips and global business travel insurance
• Possibility to join Deutsche Börse Group Share Plan (eligible after 1 year)
• Copyrights program for certain roles
• Possibility to develop your career in an international environment
• Professional training and courses provided by SimCorp
• Polish language classes for foreign employees; German and English classes based on business needs
• Integration events, volunteering initiatives and employee-led clubs

Visit our career pages to learn more about working at SimCorp:www.simcorp.com/career

WHO WE ARE

For over 50 years, we have worked closely with investment and asset managers to become the world’s leading provider of integrated investment management solutions. We are 4,000+ colleagues with a broad range of nationalities, education, professional experiences, ages, and backgrounds in general.

SimCorp is an independent subsidiary of the Deutsche Börse Group. Following the recent merger with Axioma, we leverage the combined strength of our brands to provide an industry-leading, full, front-to-back offering for our clients.

SimCorp is an equal opportunity employer. We are committed to building a culture where diverse perspectives and expertise are integrated in our everyday work. We believe in the continual growth and development of our employees, so that we can provide best-in-class solutions to our clients.

#LI-Hybrid

SimCorp is a provider of industry-leading integrated investment management solutions for the global buy side. Founded in 1971, with more than 3,000 employees across five continents, SimCorp is a truly global technology leader that empowers more than half of the world’s top 100 financial companies through its integrated platform, services, and partner ecosystem. SimCorp is a subsidiary of Deutsche Börse Group. As of 2024, SimCorp includes Axioma, the leading provider of risk and management and portfolio optimization solutions for the global buy side.

---------------------------------------------------------------- Discover more about our culture, recruitment process, and commitment to promoting meaningful work