Senior Analytics Engineer

Description

Job Summary: As a Senior Analytics Engineer, you will build a reliable and scalable data foundation to drive strategic decisions, directly impacting organizational efficiency and growth. Key Highlights: 1. Build a reliable and scalable data foundation for strategic decision-making 2. Develop and maintain robust data pipelines 3. Collaborate with business areas to deliver efficient technical solutions As a Senior Analytics Engineer, you will play a pivotal role in building a reliable and scalable data foundation that powers strategic decision-making. Your work will enable business teams, analysts, and data scientists to access well-organized, high-quality, and insight-ready information—directly influencing the organization’s efficiency and growth. **Team Mission:** Ensure company data is structured, accessible, and trustworthy, enabling consistent analytics and supporting data-driven decision-making across all business areas. **Your responsibilities will include:** * Developing and maintaining robust data pipelines, ensuring data integrity, scalability, and performance * Processing large volumes of batch and streaming data using techniques such as partitioning, load balancing, and indexing * Implementing validations and tests to ensure data quality (quantitative and qualitative) * Automating data processes and routines using tools such as Airflow * Documenting pipelines, data models, and transformation processes clearly and in detail * Collaborating with various business areas to understand requirements and translate them into efficient technical solutions **Required Qualifications:** * Minimum 5 years of experience building scalable and reliable data pipelines * Strong knowledge of data modeling (Star Schema, OBT, Snowflake, EAVT, SCD2, historical data, data closing, indexes, and partitions) * Advanced proficiency in SQL, including query optimization and use of complex functions * Experience with Data Warehousing (Amazon Redshift) * Experience with Python and/or PySpark for large-scale data manipulation and transformation * Experience automating processes via scripts (Python, Bash) * Knowledge of data monitoring and alert creation **Preferred Skills:** * Experience with tools and services such as EMR (Spark SQL), Airflow, S3, Delta, and Athena * Hands-on experience with version control and collaboration using Git * Experience with data documentation and governance (e.g., Confluence, Datahub) * Knowledge of modern data engineering best practices and data architecture principles **WHY JOIN HOTMART?** * National health and dental insurance coverage at no cost to the employee; co-payment applies for spouse and dependents; * Meal/food allowance (Flash – Visa brand); * Flexible benefit (Flash Multibenefícios – Visa brand), usable for food, meals, mobility (ride-hailing apps, fuel, public transportation in São Paulo), culture, health, and education; * Private pension plan; * Transportation voucher; * Life insurance; * Wellhub; * Daycare assistance for children up to five years old; * Education budget: a dedicated amount for investments in your education, helping you develop and enhance your competencies; * Language learning incentive through an online platform; * Baby On Board: benefit offered to individuals preparing for parenthood; * Extended maternity leave (180 days); * Extended paternity leave (30 days); * Conexa Saúde: free online access to health professionals—including nutritionists and psychologists; * Annual profit and results sharing (PLR); * Hotmart Recharge: a bonus equal to 30% of your gross monthly salary, paid after completing a 30-day vacation accrual period. **JOIN HOTMART** Being part of our team means knowing your work transforms lives on a global scale. Join Hotmart and be part of this transformation!