Senior Data Engineer

The Motley Fool

Senior Data Engineer designing, building, and owning data infrastructure at The Motley Fool. Responsible for data lifecycle, ETL pipelines, snowflake data warehousing, and driving AI initiatives.

Posted 6/8/2026contractRemote • 🇺🇸 United StatesSenior💰 $160,000 - $180,000 per yearWebsite

Tech Stack

Tools & technologies

AirflowApacheAWSCloudETLNumpyPandasPythonSQLTerraform

About the role

Key responsibilities & impact

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

What you’ll need

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.

Benefits

Comp & perks

🌐 Worldwide ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs ✉️ Email Alerts 👤 Account The Motley Fool Website LinkedIn All 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. Senior Data Engineer Job not on LinkedIn 🔥 10 minutes ago 🇺🇸 United States – Remote 💵 $160k - $180k / year ⏳ Contract/Temporary 🟠 Senior 🚰 Data Engineer Airflow Apache AWS Cloud ETL Numpy Pandas Python SQL Terraform Apply Now Find Hiring Managers Customize resume + cover letter Report problem ☆ Save ☑️ Mark as applied ❌ Hide 📋 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. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score Similar Jobs Manager, IT Systems – Data Architecture 🕒 3 days ago Coursedog 51 - 200 📚 Education ☁️ SaaS 🤝 B2B Website LinkedIn All Job Openings Manager, IT Systems & Data Architecture at Coursedog leading operational infrastructure and AI tooling support for business operations. Managing tier-1 IT support, system integrations, and collaborating with various departments. 🇺🇸 United States – Remote 💵 $9k - $11k / month 💰 $90M Private Equity Round - Coursedog on 2023-03 ⏳ Contract/Temporary 🟡 Mid-level 🟠 Senior 🚰 Data Engineer 🦅 H1B Visa Sponsor Amazon Redshift BigQuery Cloud ERP ETL SQL Data Engineer 🕒 3 days ago BiOptimizers 11 - 50 🧘 Wellness 🛍️ eCommerce 🧬 Biotechnology Website LinkedIn All Job Openings Data Engineer focused on managing AI-native development workflows at BiOptimizers. Candidate should have strong Python skills and 3+ years experience in data engineering for remote work. 🇺🇸 United States – Remote ⏳ Contract/Temporary 🟡 Mid-level 🟠 Senior 🚰 Data Engineer ETL Python Senior Data Engineer 🕒 3 days ago Omm IT Solutions 11 - 50 🔒 Cybersecurity Website LinkedIn All Job Openings Senior Data Engineer supporting the design, development, and implementation of capital markets data solutions. Building data pipelines and onboarding complex financial data sources with cloud technologies. 🇺🇸 United States – Remote ⏳ Contract/Temporary 🟠 Senior 🚰 Data Engineer AWS Cloud Docker ETL Kafka Kubernetes RabbitMQ SQL .NET Enterprise Data Architect 🕒 4 days ago A.C.Coy Company 51 - 200 🎯 Recruiter 🤝 B2B Website LinkedIn All Job Openings Enterprise Data Architect managing and implementing data models for enterprise applications. Leading security and compliance strategies while overseeing development teams. 🇺🇸 United States – Remote ⏳ Contract/Temporary 🟠 Senior 🔴 Lead 🚰 Data Engineer Data Engineer 🕒 5 days ago Kaizen Analytix 51 - 200 🤝 B2B ☁️ SaaS 🤖 Artificial Intelligence Website LinkedIn All Job Openings Data Engineer supporting data conversion and migration initiatives for a leading legal services client. Responsibilities include data cleansing, validation, and automation of processes for improved data quality. 🇺🇸 United States – Remote ⏳ Contract/Temporary 🟡 Mid-level 🟠 Senior 🚰 Data Engineer 🦅 H1B Visa Sponsor ETL SQL View More Data Engineer Jobs 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonETLELTApache AirflowAWS LambdaSnowflakeSQLTerraformAWS CDKdata manipulation

Soft Skills

leadershipownershipanalytical thinkingproblem-solvingcommunication