Offer summary

Qualifications:

4-5+ years of experience in data engineering and data warehousing, specifically with Snowflake., Proficiency in SQL and experience with data debugging and Python for data ingestion., Familiarity with AWS services and experience in developing data pipelines using Airflow., Strong communication skills and ability to work independently in a remote environment..

Key responsibilities:

Build and optimize data warehouses and pipelines in Snowflake.

Collect and integrate raw data from various vendors, transforming it into structured datasets.

Monitor cloud-based systems for performance and reliability, and create necessary cloud resources.

Collaborate with stakeholders to ensure data models meet business needs and support future growth.

Job description

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?

We are The Motley Fool, a purpose-driven financial information and services firm with nearly 30 years of experience focused on making the world smarter, happier, and richer. But what does that even mean?! It means we’re helping Fools (always with a capital “F”) demystify the world of finance, beat the stock market, and achieve personal wealth and happiness through our products and services.

The Motley Fool is firmly committed to diversity, inclusion, and equity. We are a motley group of overachievers that have built a culture of trust founded on Foolishness, fun, and a commitment to making the world smarter, happier and richer. However you identify or whatever winding road has led you to us, please don't hesitate to apply if the description above leaves you thinking, "Hey! I could do that!"

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—$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.

Required profile