The Motley Fool is looking for a Contract Analytical Data Engineer to help build scalable, reliable, and business-ready data solutions to power analysis and decision-making across the company.
Requirements
- 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
- Experience working with financial, subscription, e-commerce, and/or time-series data
Responsibilities
- 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
- 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
- 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
Other
- This is an independent contract role at 40 hours per week for at least 6 to 12 months
- mid-to-senior level engineer with 4-5+ years of relevant experience
- Ability to work independently and communicate effectively with both technical and non-technical stakeholders
- Personal or professional experience using The Motley Fool’s services
