Data Engineer
RxSenseFull Time
Senior (5 to 8 years)
Candidates should possess 5-7 years of experience with cloud data warehouses, including at least 3 years of hands-on experience with Snowflake. A minimum of 4 years in data engineering, analytics engineering, or a similar data-focused role is required, along with a strong understanding of data warehousing concepts like Star/Snowflake schemas, slowly changing dimensions, and data marts. Proficiency in SQL, including advanced joins, CTEs, and window functions, is essential, as is experience with Python for data manipulation, ingestion, and API integrations. Familiarity with workflow orchestration tools such as Airflow and the ability to work independently and communicate effectively with technical and non-technical stakeholders are also necessary.
The Analytical Data Engineer will design and maintain scalable, business-friendly data models and curated datasets in Snowflake. They will build and optimize data pipelines and transformations using SQL and Python, and develop reusable data assets like views and table functions for self-service analytics. This role involves partnering with data architects, data scientists, business intelligence analysts, and stakeholders to capture business rules and requirements. Responsibilities also include developing and orchestrating workflows in Airflow to ensure reliable, automated data delivery, diagnosing and resolving data issues by tracing SQL lineage, and collaborating with teams to translate business requirements into effective data structures. Additionally, the engineer will implement proactive data validation, quality checks, and monitoring, document data models and lineage, automate data enrichment and integration workflows, and continuously evaluate and improve data infrastructure while staying current with emerging data tools and practices.
Provides investment advice and financial education
The Motley Fool offers financial services focused on helping individual investors make informed decisions about their money. It provides premium subscription services like Stock Advisor and Rule Breakers, which deliver stock recommendations and investment advice to assist clients in building and managing their investment portfolios. The company generates revenue through subscription fees, website advertising, and affiliate partnerships. Unlike many competitors, The Motley Fool emphasizes a long-term investment philosophy and prioritizes financial education, catering to both novice and experienced investors. Its goal is to enhance financial literacy and empower individuals to achieve smarter, happier, and wealthier lives.