Mid-Level Analytical Data Engineer (Contract) (Remote)

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust. Job Summary: The Motley Fool is a purpose-driven financial services company seeking a Contract Analytical Data Engineer to build scalable and reliable data solutions. This role involves designing and implementing data models, optimizing data pipelines, and collaborating with various stakeholders to ensure business-ready data sets. 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 • 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 Qualifications: Required: • 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 Preferred: • 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 Company: The Motley Fool is a multimedia financial services company providing websites, books, newspaper columns, TV appearances, and newsletters. Founded in 1993, the company is headquartered in Alexandria, Virginia, USA, with a team of 201-500 employees. The company is currently Growth Stage.