DWH/CLOUD Consultant

Location: Mexico City, MX

In SimCorp, we assist some of the biggest financial institutions in the world to be fruitful by simplifying their investments, accounting, and operations. 

Our flagship product, SimCorp Dimension®, is a fully integrated front-to-back investment management solution, used by more than 200 clients located all over the world. It includes front office, middle office, back office data, and reporting solutions. 

SimCorp continuously enhances the portfolio of offerings to remain at the forefront of industry technology and trends. On top of this, over the last few years, we have been honing our service delivery and support model to implement SimCorp solutions to our clients and take ownership of running installations in the best possible way. 

This is why our Advanced Delivery Center (ADC) has been forged. First established in 2016 in Warsaw, extended to Manila in 2021 and kicked off the third location in Mexico City in 2023. Being spread over three locations, we can efficiently cater to our clients located in three regions: EMEA, APAC and NA.

Business Consultants in the ADC work in close collaboration with our market units on business functionality and solution workflows to tailor and deploy configuration of SimCorp Dimension to our customers. 

Why this role is important to us 

We're now expanding the ADC Data & Communication team within ADC Mexico, looking for a DWH/CLOUD Consultant.

The main purpose of the role is to provide expert advice and functional delivery in the successful deployment of SimCorp products and services in the data engineering and reporting areas.

What you will be responsible for 

  • Act as a trusted advisor supporting our Clients in the data engineering / reporting areas / cloud journey.
  • Design, implement and test changes to the Data Warehouse model and ETL workflows.
  • Work with data ingestion and extraction pipelines.
  • Test and optimize the process and tools to meet performance and data quality requirements. 
  • Facilitate requirements gathering workshops in business and technical-related areas.
  • Participate in data platform modernization initiatives to offer Clients best cloud experience for data warehouse and reporting solutions.
  • Use Python skills to implement tools for automation of processes.
  • Demonstrate growth as a SME for the SC products or technologies.
  • Participate in company knowledge sharing culture, mentor junior consultants, contribute to content creation.

What we value

  • Min. 5 years of IT professional experience.
  • Hands on experience with relational databases (Oracle / MS SQL) and cloud databases (Snowflake preferred).
  • Expertise within Data Warehouse and ETL/ELT concepts.
  • Advanced SQL and PL/SQL programming skills.
  • Great understanding of database concepts, data modeling for analytics and reporting solutions.
  • Familiarity with cloud environments (preferred Azure data stack).
  • Experience with migrating/processing high volumes of data.
  • Good Python development skills focused on automation and data pipelines processing.                
  • Data manipulation frameworks, like Pandas.      
  • Familiarity with BI reporting tools (Power BI / Qlik / Crystal Reports)
  • Experience with project work delivery (member of project teams organized as an agile or waterfall).
  • Experience working as a consultant for external client.
  • Feeling comfortable with business requirements gathering and clarification including direct work with business users.
  • Experience working in international/multicultural environment.

Nice to have

  • Basic knowledge of financial instruments and markets or experience working with financial data/business processes related to investment management.

Benefits  

  • Flexible working hours and working model (on-site/hybrid)  
  • Paid sick-leave, health/life insurance
  • Gym allowance, food/restaurant voucher, home office allowance
  • Annual performance bonus  
  • Professional training and courses (starting from a 3-week SimCorp Dimension® Academy   
  • Possibility to develop your career in an international environment  
  • Integration events and charity projects  
  • New office located in Zona Rosa (C. Varsovia 36)

    In addition, we provide a good work and life balance and opportunities for professional development in an international environment: there is never just only one route - we offer an individual approach to professional development to support the direction you want to take. Visit our career pages to learn more about working at SimCorp:  www.simcorp.com/career 

    Next steps  

    Please click below to apply. 

    Get in touch with Hanna Brzózka on hanna.brzozka@simcorp.com to learn more about the vacancy and what SimCorp has to offer regarding salary, benefits, and perks.  

    Recruitment stages

    Online meeting with Senior Recruiter -> On-line Tech check -> Online meeting with Senior Manager -> Feedback and final offer

    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 2,500+ colleagues with a broad range of nationalities, educations, professional experiences, ages, and backgrounds in general. 

    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. While seeking to deliver client value, we believe it is vital to consider our people and our planet in every business decision we make. Acting responsibly is not optional. It is essential. 

     
    #LI-Hybrid