Senior Data Engineer

The Motley Fool is a purpose-driven financial services company on a mission to make the world smarter, happier, and richer. For 30 years, we’ve been helping people make better investment decisions through transparency, education, and a healthy dose of Foolish fun. We’re a fast-moving, collaborative team that values high-quality work, curiosity, and initiative. We care deeply about what we do, and we’re driven by the impact our work has on real people’s financial futures.

We are seeking a Senior Data Engineer to design, build, and take full ownership of the data infrastructure powering our investment operations. You will own the complete data lifecycle, spanning ingestion, transformation, warehousing, analytics, and machine learning, serving as the connective tissue between raw data and the decisions that depend on it. If something breaks, you fix it. If a stakeholder needs data, you find it or build it. The Investment Committee and business partners rely on you to ensure they always have trustworthy, timely data in hand.

You will architect ETL/ELT pipelines orchestrated by Apache Airflow (AWS MWAA), build and tune a Snowflake data warehouse fed by S3 data lakes, and develop the analytical models and dashboards that turn raw data into actionable intelligence. You will also play a key role in introducing machine learning capabilities to enhance forecasting, anomaly detection, and portfolio analytics.

You will help lead the transformation of our data infrastructure, moving the team from manual processes and spreadsheet-based workflows into scalable, governed, automated data systems. This role sits at the center of investment operations, analytics, reporting, and emerging AI initiatives.

• The “Golden Source” Transformation: Migrating data reliance from spreadsheets and manual processes into a governed Snowflake warehouse with documented lineage, quality checks, and self-service analytics.
• Automated Ingestion Pipelines: Replacing manual file drops with event-driven Airflow DAGs and AWS Lambda functions that ingest, validate, and transform data from external vendors and internal systems in near real-time.
• Infrastructure as Code: Defining all cloud infrastructure with Terraform or AWS CDK so that development, staging, and production environments are reproducible, version-controlled, and auditable.
• Data-Powered AI Initiatives: Establishing the data foundations that enable AI across the business: clean, governed, and accessible datasets that feed AI agents, natural-language interfaces, and intelligent automation. Machine learning techniques such as anomaly detection, classification, and forecasting will augment these initiatives where appropriate.
• Automate how we tell our story with data: Build reusable templates and automation frameworks to close the loop between our database and the materials our team uses to win and retain business. That means pulling live data into branded one-pagers, generating narrative-driven slide decks, websites, populating email campaigns, and producing social-ready content.

• Pipeline Design & Orchestration: Design, build, and maintain robust ETL/ELT pipelines using Apache Airflow (MWAA). Author DAGs that handle complex dependencies across external data vendors, internal models, and downstream consumers.
• Data Integration: Ingest data from diverse sources including SFTP feeds, REST APIs, flat files, and third-party financial data providers. Normalize and conform data into a consistent analytical model.
• Data Quality & Monitoring: Build “circuit breakers” into pipelines: automated data quality checks that halt downstream processing and alert the team via CloudWatch and Slack when anomalies are detected.
• Serverless Processing: Implement AWS Lambda functions for lightweight, event-driven tasks such as triggering ingestion when files land in S3 or validating data payloads before loading.
• Documentation: Maintain and document the data catalog so institutional knowledge lives in the system, not in your head.

• Warehouse Architecture: Serve as the subject-matter expert for Snowflake. Design schemas, manage data loading via Stages and Snowpipe, and implement role-based access controls.
• Complex SQL Development: Write advanced analytical SQL: window functions, CTEs, recursive queries, pivots; to support investment reporting, performance attribution, and ad-hoc analysis.
• Query Tuning & Optimization: Profile and optimize slow-running queries. Leverage clustering keys, micro-partition pruning, materialized views, and result caching to minimize compute cost and maximize performance.

• Infrastructure as Code: Define and deploy cloud resources using Terraform or AWS CDK. Treat infrastructure as software with version control, peer review, and automated testing.
• CI/CD Pipelines: Help design and maintain CI/CD workflows with GitHub Actions for automated testing, linting, and deployment of data pipelines, infrastructure, and application code.

• Analytical Modeling: Partner with investment and business teams to translate questions into data models, dashboards, and reports that drive strategic decisions using Tableau.
• Analytics Presentation: Design and build automated pipelines that pull data from source systems and render it into production-ready marketing outputs: one-pagers, pitch decks, email campaigns, and social content.
• AI Integration: Be a resource for software engineers to build an AI layer on top of existing data infrastructure, enabling LLMs to securely query fund performance data via APIs and answer natural-language questions for internal stakeholders.

• Python Mastery: 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.
• ETL & Orchestration: Proven experience designing and operating ETL/ELT pipelines. Apache Airflow and Lambda experience is a plus.
• Snowflake & Advanced SQL: 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.
• Infrastructure as Code: 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.

• Cloud Fluency (AWS): Working knowledge of the AWS ecosystem: Lambda, ECS Fargate, Step Functions, S3, EventBridge, CloudWatch, and RDS.
• Experience with data visualization tools (Tableau, Streamlit, or similar) for self-service analytics.
• Background in data governance, data cataloging, or data lineage tooling.
• CI/CD Experience: Demonstrated experience maintaining CI/CD pipelines for automated testing and deployment of data engineering and application code using Github actions and Terraform.
• SQL & Database Tuning: Experience profiling and optimizing queries across both OLAP (Snowflake) and OLTP (PostgreSQL/Aurora) systems. Familiarity with EXPLAIN plans, indexing strategies, and database-level performance tuning.
• Machine Learning Fundamentals: Practical experience building, evaluating, and deploying ML models. Familiarity with common frameworks (scikit-learn, XGBoost) and an understanding of when and how to apply ML to business problems.