Job
Description
What You'll 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 You’ll Need To Be Successful Bachelor's 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. How We’ll 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. Inclusive culture and diversity 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.
