The Motley Fool is hiring a
Freelance Analytical Data Engineer

Summary

Join our team as a Freelance Analytical Data Engineer to expand and optimize data pipelines in Snowflake. This mid to senior level position requires 4-5+ years of relevant experience.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

• 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

Benefits

100% remote work