The Motley Fool is looking for a Contract Analytical Data Engineer to help us build scalable, reliable, and business‑ready data solutions. This is an independent contract role at 40 hours per week for at least 6 to 12 months, and is best suited for a mid‑to‑senior level engineer with 4-5+ years of relevant experience.
Who are we?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 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.
The Data Team at The Motley Fool provides the trusted data foundation for the entire business. Our Analytical Engineering function bridges the gap between data engineering and analytics, ensuring that data is not only collected and processed but also modeled, documented, and made accessible for analysis, experimentation, and decision‑making.
What would you do in this role?This role focuses on building and optimizing the data layer that powers analysis and decision‑making across the Fool. You’ll design and implement scalable data models, ensure quality and governance, and work closely with analysts and stakeholders to deliver business‑ready data sets. You’ll take a proactive approach to making data more usable, reliable, and efficient across the company.
But What Would You Actually Do in this Role?
- Design and maintain scalable, business‑friendly data models and curated datasets in Snowflake
- Build and optimize data pipelines and transformations using SQL and Python
- Build reusable data assets, including views and table functions for self-service analytics
- Partner with data architects, data scientists, business intelligence analysts, and stakeholders to capture business rules and requirements
- Develop and orchestrate workflows in Airflow (or similar tools) to ensure reliable, automated data delivery
- Diagnose data issues by tracing SQL lineage end-to-end and resolving them at the source, ensuring downstream consistency
- Collaborate with analysts, data scientists, and product teams to translate business requirements into effective data structures
- Implement proactive data validation, quality checks, and monitoring to ensure accuracy and reliability
- Document data models, lineage, and definitions to promote self‑service and trust in data
- Automate data enrichment and integration workflows to reduce manual work
- Continuously evaluate and improve data infrastructure, anticipating future business needs
- Stay up‑to‑date on emerging data tools and analytical engineering practices, and recommend improvements
- 5-7 years of experience with cloud data warehouses, with at least 3 years hands-on experience in Snowflake
- 4+ years of experience in data engineering, analytics engineering, or similar data-focused role
- Knowledge of data warehousing concepts including Star/Snowflake schemas, slowly changing dimensions, and data marts
- Proficiency in SQL, including advanced joins, CTEs, and window functions
- Experience with Python for data manipulation, ingestion, and API integrations
- Familiarity with workflow orchestration tools such as Airflow
- Ability to work independently and communicate effectively with both technical and non‑technical stakeholders
- Experience working with financial, subscription, e-commerce, and/or time‑series data
- Experience with business intelligence tools (Tableau, Looker, Thoughtspot, Power BI) and their integration with Snowflake
- Experience integrating customer data platforms like Segment, including configuring event tracking, managing data destinations, and building pipelines to process behavioral and product analytics data
- Familiarity with data quality and observability tools such as Great Expectations or Soda
- Experience with DevOps/IaC tools like Terraform or Serverless
- Exposure to modern analytics workflows
- Knowledge of data contracts and governance frameworks
- Personal or professional experience using The Motley Fool’s services
Compensation:
Below is our target compensation range. While we are budget conscious, we’re also eager to find the right person for this role, so if your target is outside of this range, please don’t hesitate to apply and we’d be happy to have a conversation.
By applying on this site, you acknowledge that The Motley Fool will be collecting the personal data you provide for our recruiting purposes. Please see our Applicant Privacy Notice for additional information about how we process, transfer, and store your data, including where that data is stored, and about any additional privacy rights you may have based on your jurisdiction.
Similar Jobs
What We Do
The Motley Fool’s purpose is to make the world smarter, happier, and richer.
While other companies may make you smarter, happier, or richer, we aim to do all three by providing outstanding business and investing advice — with a decidedly Foolish bent.
Our name is in homage to the one character in Shakespearean literature — the court jester — who could speak the truth to the king and queen without having his or her head lopped off. The Fools of yore entertained the court with humor that instructed as it amused. More importantly, the Fool was never afraid to question conventional wisdom.
We believe in treating every dollar as an investment in the future you want to create. We believe that investing in great businesses, for the long term, is the most effective path to wealth. We believe in the power of a community to learn and grow together. We believe in keeping score and being transparent in our investment performance. We strive to fulfill our purpose by truly serving every Fool, from our employees to our members to our community.
We provide a variety of solutions to improve many areas of your financial life, including your investment portfolio, personal finances, real estate holdings, company, and career.
The Motley Fool is headquartered in Alexandria, Va., with offices in Denver and Sydney, Australia, and serves investors and businesses in the UK, Australia, Hong Kong, Canada, Singapore, and Germany.
