Sr. Data Engineer

Addepar; City of Edinburgh; On-site; GBP 45,000 - 85,000; Full time

Job summary

A leading technology company is seeking a Senior Data Engineer to join their Data Engineering team in Edinburgh. This role involves building and maintaining ETL pipelines to automate data cleaning and transformation processes, essential for serving their extensive client base efficiently. Candidates should possess a degree in a technical field and experience with programming and data technologies, as well as a keen interest in data modeling and visualization.

Qualifications

• Experience with object-oriented programming preferred.
• Knowledge of financial concepts encouraged but not necessary.

Responsibilities

• Write code and design pipeline architecture.
• Build pipelines that support the ingestion, analysis, and enrichment of financial data.
• Improve existing pipelines to increase throughput and data accuracy.

Skills

Object-oriented programming

Data modeling

Data visualization

ETL pipelines

SQL

Python

Apache Spark / PySpark

Java/Spring

Amazon Web Services

Data structures and algorithms

Education

Degree in computer science, engineering, mathematics, or related field

Job description

Social network you want to login/join with:

Sr. Data Engineer

Who We Are

Addepar is a global technology and data company that helps investment professionals provide the most informed, precise guidance for their clients. Hundreds of thousands of users have entrusted Addepar to empower smarter investment decisions and better advice over the last decade. With client presence in more than 50 countries, Addepar's platform aggregates portfolio, market, and client data for over $7 trillion in assets. Addepar's open platform integrates with more than 100 software, data, and services partners to deliver a complete solution for a wide range of firms and use cases. Addepar embraces a global, flexible workforce model with offices in New York City, Salt Lake City, Chicago, London, Edinburgh, Pune, and Dubai.

The Role

We're looking for a Senior Portfolio Data Engineer to join our Data Engineering team in Edinburgh.

A core part of Addepar's business relies on us being able to quickly and correctly ingest data from various sources, including third-party data providers, custodial banks, data APIs, and direct user input. The data engineers on the Portfolio Data Engineering team help build and maintain the transformation and cleaning steps of our ETL (Extract, Transform, Load) pipeline before it can be stored and accessed by our customers in a standardized fashion. As a data engineer on this team, you'll build components within the ETL pipeline that automate these cleaning and transformation steps. As you gain more experience, you'll contribute to increasingly challenging engineering projects within our broader data infrastructure.

This is a crucial, highly visible role within the company. Your team is a key component of growing and serving Addepar's client base with minimal manual data cleaning effort required from our clients or our internal data operations team.

What You'll Do

• Write code and design pipeline architecture.
• Build pipelines that support the ingestion, analysis, and enrichment of financial data.
• Improve existing pipelines to increase throughput and data accuracy.
• Work with data analysts to map financial concepts to our internal data models in a repeatable and precise manner.
• Understand data models and schemas, and collaborate with engineering staff to recommend extensions and changes.
• Use investigative tools and database queries to automatically flag irreconcilable data within production datasets.

Who You Are

• A degree in computer science, engineering, mathematics, or a related technical field.
• Experience with object-oriented programming preferred.
• Familiarity with technologies such as:
• Python, Apache Spark / PySpark, Java/Spring
• Amazon Web Services
• SQL, relational databases
• Understanding of data structures and algorithms
• Interest in data modeling, visualization, and ETL pipelines
• Knowledge of financial concepts (stocks, bonds, etc.) is encouraged but not necessary.

Our Values

• Act Like an Owner: Think and operate with intention, purpose, and care. Own your work.
• Build Together: Collaborate to unlock the best solutions. Deliver lasting value.
• Champion Our Clients: Exceed client expectations. Our clients' success is our success.
• Drive Innovation: Be bold and unconstrained in problem solving. Transform the industry.
• Embrace Learning: Engage our community to broaden our perspective. Bring a growth mindset.

In addition to our core values, Addepar is proud to be an equal opportunity employer. We seek to bring together diverse ideas, experiences, skill sets, perspectives, backgrounds, and identities to drive innovative solutions. We are committed to promoting a welcoming environment where inclusion and belonging are held as a shared responsibility.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the application or interview process, perform essential job functions, and receive other employment benefits. Please contact us to request accommodation.

PHISHING SCAM WARNING: Addepar has been made aware of phishing scams involving imposters posing as hiring managers via email, text, and social media. These scammers create misleading email accounts, conduct remote "interviews," and make fake job offers to collect personal and financial information. Please note that no job offers will be made without a formal interview process, and we will not ask you to purchase equipment or supplies as part of onboarding. If you have questions, contact TAinfo@addepar.