Lead Data Engineer
- Avalara
- 6 - 11 years
- Pune
- 1 month ago
- Email to a friend
- Report this job
Job Description
What Youll Do
We are seeking an experienced Lead Data Engineer with experience in the Data Engineering. We are looking for a background in ETL processes, data warehousing, data modeling, and hands-on expertise in SQL and Python. The ideal candidate will have exposure to cloud technologies and will play a key role in designing and managing scalable, high-performance data systems that support marketing and sales insights.
You will report to Manager- Data engineering
What Your Responsibilities Will Be
- You will Design, develop, and maintain efficient ETL pipelines using DBT,Airflow to move and transform data from multiple sources into a data warehouse.
- You will Lead the development and optimization of data models (e.g., star, snowflake schemas) and data structures to support reporting.
- You will Leverage cloud platforms (e.g., AWS, Azure, Google Cloud) to manage and scale data storage, processing, and transformation processes.
- You will Work with business teams, marketing, and sales departments to understand data requirements and translate them into actionable insights and efficient data structures.
- You will Use advanced SQL and Python skills to query, manipulate, and transform data for multiple use cases and reporting needs.
- You will Implement data quality checks and ensure that the data adheres to governance best practices, maintaining consistency and integrity across datasets.
- You will Experience using Git for version control and collaborating on data engineering projects.
What Youll Need to be Successful
- Bachelors degree with 6+ years of experience in Data Engineering.
- ETL/ELT Expertise : experience in building, improving ETL/ELT processes.
- Data Modeling : experience with designing and implementing data models such as star and snowflake schemas, and working with denormalized tables to optimize reporting performance.
- Experience with cloud-based data platforms (AWS, Azure, Google Cloud)
- SQL and Python Proficiency : Advanced SQL skills for querying large datasets and Python for automation, data processing, and integration tasks.
- DBT Experience : Hands-on experience with DBT (Data Build Tool) for transforming and managing data models.
Good to have Skills:
- Familiarity with AI concepts such as machine learning (ML), (NLP), and generative AI. Work with AI-driven tools and models for data analysis, reporting, and automation.
- Oversee and implement DBT models to improve the data transformation process.
- Experience in the marketing and sales domain, with lead management, marketing analytics, and sales data integration.
- Familiarity with business intelligence reporting tools, Power BI, for building data models and generating insights.
#LI-Onsite
How Well Take Care of You
Total Rewards
In addition to a great compensation package, paid time off, and paid parental leave, many Avalara employees are eligible for bonuses.
Health & Wellness
Benefits vary by location but generally include private medical, life, and disability insurance.
Benefits vary by location but generally include private medical, life, and disability insurance.
Inclusive culture and diversit y
Avalara strongly supports diversity, equity, and inclusion, and is committed to integrating them into our business practices and our organizational culture. We also have a total of 8 employee-run resource groups, each with senior leadership and exec sponsorship.
Avalara strongly supports diversity, equity, and inclusion, and is committed to integrating them into our business practices and our organizational culture. We also have a total of 8 employee-run resource groups, each with senior leadership and exec sponsorship.
Learn more about our benefits by region here: Avalara North America
What You Need To Know About Avalara
We re Avalara. We re defining the relationship between tax and tech.
We ve already built an industry-leading cloud compliance platform, processing nearly 40 billion customer API calls and over 5 million tax returns a year, and this year we became a billion-dollar business
.
Our growth is real, and we re not slowing down until we ve achieved our mission - to be part of every transaction in the world. We re bright, innovative, and disruptive, like the orange we love to wear. It captures our quirky spirit and optimistic mindset. It shows off the culture we ve designed, that empowers our people to win. Ownership and achievement go hand in hand here. We instill passion in our people through the trust we place in them.
We ve been different from day one. Join us, and your career will be too.
We re An Equal Opportunity Employer
Supporting diversity and inclusion is a cornerstone of our company we don t want people to fit into our culture, but to enrich it. All qualified candidates will receive consideration for employment without regard to race, color, creed, religion, age, gender, national orientation, disability, sexual orientation, US Veteran status, or any other factor protected by law. If you require any reasonable adjustments during the recruitment process, please let us know.
- Bachelors degree with 6+ years of experience in Data Engineering.
- ETL/ELT Expertise : experience in building, improving ETL/ELT processes.
- Data Modeling : experience with designing and implementing data models such as star and snowflake schemas, and working with denormalized tables to optimize reporting performance.
- Experience with cloud-based data platforms (AWS, Azure, Google Cloud)
- SQL and Python Proficiency : Advanced SQL skills for querying large datasets and Python for automation, data processing, and integration tasks.
- DBT Experience : Hands-on experience with DBT (Data Build Tool) for transforming and managing data models.
Good to have Skills:
- Familiarity with AI concepts such as machine learning (ML), (NLP), and generative AI. Work with AI-driven tools and models for data analysis, reporting, and automation.
- Oversee and implement DBT models to improve the data transformation process.
- Experience in the marketing and sales domain, with lead management, marketing analytics, and sales data integration.
- Familiarity with business intelligence reporting tools, Power BI, for building data models and generating insights.
#LI-Onsite
- You will Design, develop, and maintain efficient ETL pipelines using DBT,Airflow to move and transform data from multiple sources into a data warehouse.
- You will Lead the development and optimization of data models (e.g., star, snowflake schemas) and data structures to support reporting.
- You will Leverage cloud platforms (e.g., AWS, Azure, Google Cloud) to manage and scale data storage, processing, and transformation processes.
- You will Work with business teams, marketing, and sales departments to understand data requirements and translate them into actionable insights and efficient data structures.
- You will Use advanced SQL and Python skills to query, manipulate, and transform data for multiple use cases and reporting needs.
- You will Implement data quality checks and ensure that the data adheres to governance best practices, maintaining consistency and integrity across datasets.
- You will Experience using Git for version control and collaborating on data engineering projects.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Data EngineerEmployement Type: Full timeContact Details:
Company: AvalaraLocation(s): Pune+ View Contact
Keyskills: Automation Data analysis Version control GIT Data modeling Machine learning Data structures Data quality SQL Python
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Avalara
We are Quest Global. We€™re in the business of engineering, but what we€™re really building is a brighter future. It€™s not just what we do, but why we do it that makes us different. We believe engineering has the unique opportunity to solve the problems of today ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in