Senior Data Engineer II

ABOUT US:

As a world leading provider of integrated solutions for the alternative investment industry, Alter Domus (meaning “The Other House” in Latin) is proud to be home to 90% of the top 30 asset managers in the private markets, and more than 6,000 professionals across 24 jurisdictions. 

With a deep understanding of what it takes to succeed in alternatives, we believe in being different - in what we do, in how we work and most importantly in how we enable and develop our people. Invest yourself in the alternative, and join an organization where you progress on merit, where you can speak openly with whoever you are speaking to, and where you will be supported along whichever path you choose to take. 

Find out more about life at Alter Domus at careers.alterdomus.com  

Join our Client & Investor Lifecycle Management team as a Data Engineer and make a direct impact on every client and investor relationship across our organization. In this mission-critical role, you'll be at the heart of our KYC (Know Your Customer) and AML (Anti-Money Laundering) operations, transforming complex data into actionable insights that drive critical business decisions.

You'll harness cutting-edge technologies—integrating Fenergo APIs, processing data through Databricks and Apache Spark, and crafting compelling Power BI dashboards that tell the story hidden in millions of data points. This is where technical excellence meets business impact: your data pipelines will ensure compliance, your analytics will inform leadership strategy, and your attention to detail will safeguard the integrity of our client onboarding and due diligence processes. As we continue our cloud transformation journey, you'll work across diverse scenarios and emerging technologies, constantly innovating in a fast-paced, dynamic environment where your creativity and problem-solving skills will shine.

Your responsibilities:

· Lead integration of Fenergo APIs to extract KYC and AML data, ensuring seamless connectivity between systems.

· Design, develop, and maintain scalable data pipelines and ETL processes for data ingestion from databases, APIs, and flat files.

· Implement data processing pipelines using Databricks, Apache Spark, DataFrames, and Medallion Architecture, leveraging AI tools for optimization.

· Conduct regular data quality assessments, audits, and root cause analysis to ensure data integrity and compliance with industry standards.

· Architect and develop interactive Power BI dashboards and reports, translating complex data into actionable insights for clients, leadership, and stakeholders.

· Create visual representations of KPIs and operational metrics for KYC/AML processes for regular reporting to clients and senior management.

· Maintain comprehensive documentation of data processes, API integrations, data flows, governance practices, and reporting solutions for compliance.

· Proactively resolve data-related issues, ensuring timely and accurate reporting.

· Implement data validation, quality control measures, and monitoring processes to ensure reliability throughout all pipelines.

Your profile:

Required Skills & Experience:

· Bachelor's degree in Data Science, Computer Science, Statistics, Engineering, or related field.

· 5+ years of experience as a Data Engineer, Data Analyst, or similar role with strong focus on data analysis, engineering, and reporting.

· Proficiency in Databricks and Apache Spark for data processing and pipeline development.

· Strong knowledge of Power BI with ability to create executive-level dashboards.

· Expert-level proficiency in SQL for data querying, manipulation, and complex analytical operations.

· Experience with Python for data analysis and automation.

· Strong understanding of data warehousing, ETL processes, data modeling, Medallion Architecture, and data lakehouse principles.

· Strong experience in API integration for data extraction and system connectivity.

· Experience with cloud platforms (Azure or AWS) and Databricks integration/mounting.

· Knowledge of Git connection to Databricks for version control.

· Understanding of data governance and data quality best practices.

· Good troubleshooting and problem-solving skills.

· An open mind willing and capable to learn in a fast-paced environment.

Additional Technical Skills (Nice to have):

· Databricks administration skills

· Experience in Financial Services industry, particularly with KYC/AML processes or regulatory compliance is highly desirable.

· Familiarity with machine learning concepts and their application in data analysis

· Experience with graph data models

WHAT WE OFFER

We are committed to supporting your development, advancing your career, and providing benefits that matter to you. 

Our industry-leading Alter Domus Academy offers six learning zones for every stage of your career, with resources tailored to your ambitions and resources from LinkedIn Learning. 

Our global benefits also include:

• Support for professional accreditations such as ACCA and study leave 
• Flexible arrangements, generous holidays, plus an additional day off for your birthday!
• Continuous mentoring along your career progression 
• Active sports, events and social committees across our offices 
• 24/7 support available from our Employee Assistance Program 
• The opportunity to invest in our growth and success through our Employee Share Plan 
• Plus additional local benefits depending on your location 

Equity in every sense of the word:

We are in the business of equity, in every sense of the word. For us, this means taking action to ensure every colleague has equal opportunity, valuing every voice and experience across our organisation, maintaining an inclusive culture where you can bring your whole self to work, and making Alter Domus a workplace where everyone feels they belong. 

We celebrate our differences, and understand that our success relies on diverse perspectives and experiences, working towards shared goals and a common purpose. We take pride in creating a workplace where all our people are empowered to be truly invested in the alternative and bring their whole selves to work.

We are committed to ensuring a welcoming recruiting and onboarding process for everyone. Please contact our hiring team if you require any accommodations to make our recruitment process more accessible for you. 

(Alter Domus Privacy notice can be reviewed via Alter Domus webpage: https://alterdomus.com/privacy-notice/)

#LI-HYBRID