Senior Data Engineer

🕒 June 8

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

The Motley Fool

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 1993

💸 Finance

📱 Media

📚 Education

💰 $25M Private Equity Round on 2009-11

Finance • Media • Education

The Motley Fool is a financial services company founded in 1993 by brothers Tom and David Gardner. It aims to make the world smarter, happier, and richer by helping millions of people attain financial freedom. The Motley Fool offers premium investing solutions, free market analysis on its website Fool. com, personal finance education, podcasts, and manages the non-profit Motley Fool Foundation. The company provides guidance on stock market news, investing strategies, retirement planning, and personal finance products, striving to empower investors through refreshing, engaging, and fun financial content.

📋 Description

• Design, build, and take full ownership of the data infrastructure powering our investment operations. • Own the complete data lifecycle, spanning ingestion, transformation, warehousing, analytics, and machine learning. • Architect ETL/ELT pipelines orchestrated by Apache Airflow (AWS MWAA). • Build and tune a Snowflake data warehouse fed by S3 data lakes. • Develop analytical models and dashboards that turn raw data into actionable intelligence. • Lead the transformation of our data infrastructure from manual processes to scalable, governed, automated data systems. • Replace manual file drops with event-driven Airflow DAGs and AWS Lambda functions. • Define all cloud infrastructure with Terraform or AWS CDK. • Establish clean, governed, and accessible datasets that feed AI agents and intelligent automation.

🎯 Requirements

• 5+ years of professional Python development. Comfortable with object-oriented design, data manipulation libraries (pandas, NumPy). • Familiarity with financial research data vendors and feed/API products such as CapIQ Xpressfeed, FactSet, Bloomberg, Thomson Reuters/Refinitiv/LSEG, Russell or MSCI. • Familiarity with financial business data and feed/API products from Broadridge, Morningstar and custodian banks and fund administrators. • Proven experience designing and operating ETL/ELT pipelines. Apache Airflow and Lambda experience is a plus. • Deep expertise in Snowflake architecture (clustering keys, micro-partitions, Snowpipe, Stages). Able to write complex analytical SQL, window functions, CTEs, recursive queries, and optimize them for cost and performance. • Hands-on experience with AWS CDK or Terraform. You define infrastructure in code, not in the AWS Console. • Exposure to LLM integration patterns: markdown files and prompt engineering. Experience with RAG, knowledge bases, and embeddings is a plus.