The Motley Fool is looking for a highly skilled Freelance Analytical Data Engineer with a strong focus in data warehousing to join our team on an independent contract basis, 40 hours per week for at least 12 months. This is a mid to senior level position and requires 4-5+ years of relevant experience. This role is flexible and 100% remote, but candidates MUST reside in the United States to be eligible for consideration. 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. What does this team do? The Data Engineering team at The Motley Fool creates data pipelines to wrangle data from around the Fool. We collaborate with everyone - from third party vendors to stakeholders to build easily consumable data structures for reporting and business insights. While working closely with our business analysts and machine learning specialists, we serve the data needs of all The Motley Fool Teams! What would you do in this role? As a Freelance Data Engineer, you will be responsible for expanding and optimizing data, the data pipeline architecture, the data flow, and collection for cross-functional teams. You are an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. This role will involve collecting and integrating raw data from various vendors, transforming it into clean, structured data sets, and building a scalable, maintainable data mart. The ideal candidate will be responsible for ensuring the integrity and usability of the data across downstream processes, working closely with stakeholders to ensure data models align with business needs and support future growth. Strong technical skills and experience in data architecture are essential. But What Would You Actually Do in this role? • Build data warehouses and data pipelines in Snowflake • Query and analyze large datasets in Snowflake using SQL • Debug and resolve data issues • Develop serverless data processing workflows using custom operators within Airflow. • Leverage data assets to meet mission needs, ensuring consistent data quality, establishing data standards and governance • Work in an agile, collaborative environment, partnering with client stakeholders, to develop and improve mission-based solutions • Monitor cloud-based systems and components for availability, performance, reliability, security and efficiency • Create and configure appropriate cloud resources to meet the needs of the end users. • As needed, document topology, processes, and solution architecture. • Assist with the training and enablement of data consumers. • Share your passion for staying on top of tech trends, experimenting with and learning new technologies Required Experience: • Enterprise-level data warehousing experience - specifically within Snowflake. • Proficiency in SQL, including multi-table joins, window functions, indexing strategies. • Data Debugging Experience • Experience developing using Python in context of data ingestion via REST APIs, manipulation with native data types, and database connection • Experience with AWS Services, including Lambda functions, EC2/ECS instances, S3, SQS, DynamoDB Tables; familiarity with IAM Roles and Policies. • Experience with development and deployment of data pipelines using Airflow; proficiency in base and third-party operators for complex DAGs. • Experience with Snowflake setting up storage integrations, external stages, data shares, snowpipes, RBAC; setting up tasks using Snowpark API. • Ability to work independently, and deliver results and drive projects with minimal supervision • Strong ability to communicate blockers and issues to management for escalation and timely resolution • Strong team player, with desire to learn new skills and broaden experience • Experience working with complex data sets Nice to Have: • Experience with event tracking configuration in Google GA4 and analysis using BigQuery • Experience with data migration project refactoring and optimizing complex SQL logic • Experience working with financial data • Experience investing and/or using The Motley Fool’s service offerings • Experience leveraging data quality tools to proactively address data discrepancies • Experience with DevOps, developing infrastructure-as-code via Terraform and/or CloudFormation 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. Hourly Pay Range: $85 USD - $100 USD 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.