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, 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  

Your role

We are seeking a skilled Data Engineer to design, build, and maintain robust data pipelines that power our analytics and business intelligence capabilities. You will work with modern data stack technologies to create scalable data solutions, ensure data quality, and enable data-driven decision-making across the organization.

Your responsibilities

Data Pipeline Development

• Design, build, and maintain scalable ETL/ELT pipelines to support analytics and reporting needs
• Develop automated data ingestion processes from various sources into the data warehouse
• Implement data transformation workflows that ensure data consistency and reliability
• Monitor and troubleshoot pipeline issues to maintain data availability and accuracy
• Build reusable pipeline components and frameworks for efficient development

Data Transformation and Modeling

• Implement modular transformations and testing frameworks using DBT (Data Build Tool)
• Design efficient database schemas optimized for analytical workloads
• Create and maintain data models that support business requirements
• Write complex SQL queries and optimize them for performance
• Work with Amazon Athena or similar query services for large-scale data analysis

Workflow Orchestration and Automation

• Build and schedule data workflows using Apache Airflow
• Create dependencies and manage task execution across complex data pipelines
• Implement error handling, retry logic, and alerting mechanisms
• Automate routine data operations and maintenance tasks
• Use Python for data processing, automation, and custom integrations

Data Quality and Governance

• Implement data validation rules and quality checks throughout pipelines
• Establish data lineage tracking and documentation practices
• Build data observability solutions to monitor pipeline health and data integrity
• Collaborate with stakeholders to define and enforce data governance standards
• Create and maintain documentation for data models, pipelines, and processes

Performance Optimization

• Tune data pipelines and queries for scale, performance, and reliability
• Identify and resolve bottlenecks in data processing workflows
• Optimize data storage and partitioning strategies
• Monitor resource utilization and implement cost optimization measures
• Conduct performance testing and implement improvements

Your profile

Required Qualifications

• Experience designing, building, and maintaining ETL/ELT data pipelines
• Hands-on experience with DBT for implementing modular transformations and testing
• Practical knowledge of Apache Airflow for workflow orchestration and scheduling
• Strong SQL skills including complex queries, data modeling, and optimization
• Experience with Amazon Athena or similar query services for analytical workloads
• Proficiency in Python for data processing and automation
• Understanding of data quality practices, validation, and governance principles
• Experience with performance tuning of data pipelines and queries
• Strong problem-solving skills and attention to detail
• Excellent communication and collaboration abilities

Desirable Skills

• Experience configuring and managing Airbyte connectors for data ingestion and integration workflows (Nice to have)
• Experience creating and supporting Power BI dashboards and business intelligence solutions Nice to have)
• Familiarity with cloud data platforms (AWS, Azure, or GCP)
• Knowledge of data warehousing concepts and modern data architectures
• Experience with version control systems (Git) and CI/CD practices
• Understanding of data security and compliance requirements
• Familiarity with streaming data technologies (Kafka, Kinesis)
• Experience with containerization (Docker) and infrastructure as code
• Knowledge of data catalog and metadata management tools
• Exposure to machine learning workflows and MLOps practices

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 
• 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 recognise that our success relies on diverse perspectives and experiences, as we work 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 welcomling 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 is an Equal Opportunity Employer: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status. 

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

#LI-HYBRID