Lead DWH/BI Consultant

Location: Mexico City

Time Type: Full time

Job Description

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 hours  

• Medical & Dental insurance 

• Private life insurance  

• Christmas Bonus and Vacation Premium  

• Vacation days as per labor law  

• Ten days of paid “Sick Time” per year for employee or child illness  

• Two paid personal days per calendar year  

• Savings Fund  

• Grocery vouchers  

• Hybrid working model: 2 days per week in the office + 3 days remote 

• Office location: Spaces SkyTown Insurgentes, Colonia Tabacalera, Cuauhtémoc, Mexico City 

• Professional training and courses (starting from a 3-week SimCorp Dimension® Academy)  

• Possibility to develop your career in an international environment   

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

NEXT STEPS  

Please send us your application in English via our career site. 
Please note that only applications sent through our system will be processed.  

At SimCorp, we recognize that bias can unintentionally occur in the recruitment process. To uphold fairness and equal opportunities for all applicants, we kindly ask you to exclude personal data such as photo, age, or any non-professional information from your application. Thank you for aiding us in our endeavor to mitigate biases in our recruitment process.   

For any questions you are welcome to contact Hanna Brzózka, Lead Talent Acquisition Partner, at "[email protected]". If you are interested in being a part of SimCorp but are not sure this role is suitable, submit your CV anyway. SimCorp is on an exciting growth journey, and our Talent Acquisition Team is ready to assist you discover the right role for you. The approximate time to consider your CV is three weeks.      

We are eager to continually improve our talent acquisition process and make everyone’s experience positive and valuable. Therefore, during the process we will ask you to provide your feedback, which is highly appreciated.  

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 3,000+ colleagues with a broad range of nationalities, educations, 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