Description
Job Title: Senior Data Engineer / Analytics Engineer
Experience
8+ Years
Location
Adaptable / Hybrid / Remote
Job Summary
We are seeking an experienced Senior Data Engineer / Analytics Engineer with 8+ years of hands-on experience in designing, building, and optimizing scalable data platforms and analytics solutions. The ideal candidate should possess strong expertise in SQL, dbt, AWS, and Python, along with excellent communication and stakeholder management skills. The role involves working closely with business teams, data analysts, architects, and engineering teams to deliver reliable and scalable data solutions.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL/ELT workflows.
- Build and manage data transformation frameworks using dbt.
- Develop high-performance data models and optimize complex SQL queries.
- Implement data ingestion and integration processes from multiple data sources.
- Leverage AWS services to build cloud-native data solutions.
- Ensure data quality, governance, security,
and compliance across data platforms.
- Collaborate with business stakeholders to understand requirements and convert them into technical solutions.
- Create reusable data models, documentation, and best practices.
- Monitor and troubleshoot production data pipelines to ensure reliability and performance.
- Mentor junior team members and participate in code reviews and architectural discussions.
- Support BI and reporting initiatives by providing curated and trusted datasets.
Required Skills
SQL
- Advanced SQL development and performance tuning.
- Expertise in data modeling, query optimization, and database design.
- Experience working with large-scale relational and analytical databases.
dbt
- Strong experience in developing and maintaining dbt projects.
- Creating incremental models, snapshots, tests, macros, and documentation.
- Understanding of CI/CD integration and deployment practices for dbt.
AWS
Hands-on exper
📌 Data Engineer (Pune)
🏢 EXL
📍 Pune