Job Description

• Design, develop, and maintain scalable data transformation and analytics pipelines using Snowflake, SQL, Python, and dbt.
• Perform data extraction, cleansing, preprocessing, validation, and transformation from multiple data sources.
• Develop complex and optimized SQL queries, stored procedures, views, and data models in Snowflake.
• Build and maintain dbt models, macros, tests, snapshots, and documentation following analytics engineering best practices.
• Use Python for data preprocessing, automation, data validation, and analytical workflows.
• Develop and maintain Tableau dashboards, reports, visualizations, and KPI reporting for business stakeholders.
• Translate business requirements into effective data models, metrics, dashboards, and analytical solutions
• Perform data profiling and quality checks to ensure accuracy, completeness, consistency, and reliability of reporting data.
• Optimize SQL queries, Snowflake workloads, dbt models, and Tableau dashboards for performance.
• Collaborate with Business Analysts, Data Engineers, Data Scientists, and business stakeholders to understand reporting and analytics requirements.
• Troubleshoot data and reporting issues and provide root-cause analysis.
• Establish reusable data transformation and reporting frameworks to improve scalability and maintainability.
• Ensure proper documentation of data sources, transformations, business rules, and reporting logic.

Requirements

• 6+ years of overall experience in Analytics Engineering, Data Engineering, BI, or a related role.
• Strong hands-on experience with Snowflake and advanced SQL
• Strong Python experience for data preprocessing, transformation, automation, and validation.
• Hands-on experience with dbt for data transformation and analytics engineering.
• Strong experience in Tableau dashboard and report development.
• Experience working across data preprocessing → transformation → data modeling → BI reporting
• Strong understanding of ETL/ELT concepts, dimensional modeling, and data warehousing
• Good understanding of data quality, governance, and performance optimization.
• Strong analytical and problem-solving skills with the ability to work directly with business stakeholders.