Senior Analytics Engineer
Metropolis16 days ago
Bengaluru, IndiaSenior
Responsibilities
- Lead the design, implementation, and monitoring of large-scale data warehouses and data marts.
- Build data transformation pipelines and ELT processes that prepare and clean data for analysis.
- Optimize SQL queries, tables, and database performance using window functions, STRUCT/ARRAY manipulation, partitions, sort keys, distribution keys, clustering, and incremental modeling.
- Design data flows with testing, data-quality checks, and alerts to identify bad or anomalous data.
- Own large-scale data projects that create significant impact across the company.
- Partner with engineering, data analysts, data scientists, product managers, and other business stakeholders.
- Mentor stakeholders on data best practices.
- Use AI tools to transform static workflows into responsive, high-output processes.
Requirements
- At least 5 years of experience in data or analytics engineering.
- At least 5 years of experience with Python and SQL, preferably Snowflake.
- At least 3 years of experience with dbt; dbt certification is a plus.
- Demonstrated ownership of large-scale data projects and effective cross-functional partnership.
- Expertise in SQL, window functions, STRUCT/ARRAY manipulation, and query optimization.
- Experience designing data warehouses, data marts, transformation pipelines, and ELT processes.
- Experience with data-quality testing, monitoring, and alerting.
- Familiarity with database performance practices including partitions, sort keys, distribution keys, clustering, and incremental modeling.
- Experience mentoring stakeholders in Data Science/Analytics, product management, and Engineering.
Benefits
- Metropolis uses an office-first model; the posting references three days in office and states that corporate team members must be on-site at least four days per week.
- The role offers collaboration with product leaders and engineers working at the intersection of parking, mobility, and real estate.
- Metropolis states that it is an equal opportunity employer and provides reasonable accommodations during the hiring process.