Lead Analytics Engineer

About Us:
Atomic is the venture studio that co-founds companies by pairing founders with the best ideas, teams, and resources, and funding those with the most potential. When entrepreneurs co-found with Atomic, they team up with an experienced group of operators who have started dozens of companies and created billions of dollars in enterprise value. Industry disruptors like Bungalow, Found, Hims and Hers, Homebound, OpenStore, and Replicant all started at Atomic along with dozens more. Atomic was founded in 2012 by serial entrepreneur Jack Abraham and has offices in NYC, Miami, and San Francisco with a distributed team across North America.
Overview:
Housing is a vibrant field, and Bungalow's team is dedicated to enhancing the living experiences of our communities. Our mission is to deliver top-notch homes that blend quality with affordability, ensuring that finding the perfect place is a hassle-free experience. 
As the Lead Analytics Engineer, you will be the technical and strategic driving force behind our domain-driven analytical datasets and data pipelines. Your mission is to design, build, and optimize data architectures that empower functional leaders across Marketing, Sales, Operations, Product, and Executive teams.
In this role, you will combine deep technical expertise in AWS, Airflow, Python, SQL, and DBT with strong business acumen to manage stakeholder requests and drive data-driven decision-making.
You will lead cross-functional teams, mentor junior engineers, and collaborate with key stakeholders to transform complex business requirements into scalable, high-quality data solutions.

What You'll Do:

• Data Architecture & Modeling: Translate business requirements into intuitive, domain-specific data models and set standards for data architecture.
• ETL/ELT Pipeline Management: Architect, build, and optimize scalable pipelines using AWS, Airflow, and dbt to ensure high-quality data delivery.
• Team Leadership & Collaboration: Work closely with cross-functional stakeholders to align technical solutions with business needs.
• Reporting & Analytics: Utilize advanced SQL and Python skills to develop efficient reports and analytical insights that drive decision-making.
• Continuous Improvement: Implement best practices, and emerging technologies to maintain scalable, cost-efficient data processes.

Who We're looking For:

• Professional Experience: 7+ years in analytics engineering, data consultancy, data engineering, or a related field, with significant experience in leading technical projects and managing stakeholder requirements.
• AWS Expertise: Proven experience with AWS services relevant to data warehousing, ETL/ELT processes, and scalable data architectures.
• Airflow Proficiency: Strong hands-on experience with Apache Airflow for orchestrating and managing complex data pipelines.
• Programming & SQL: Advanced proficiency in Python and SQL for data manipulation, reporting, and analytics. Demonstrated expertise with DBT for transforming and modeling data.
• Data Modeling: Deep understanding of data modeling concepts, including star schema, snowflake schema, and dimensional modeling.
• BI Tools: Familiarity with business intelligence tools (e.g., Tableau, Looker, Metabase) for visualization and data exploration.
• Version Control & CI/CD: Experience with Git and CI/CD practices to streamline and secure data deployments.
• Leadership & Mentorship: Proven leadership abilities with experience in managing teams and mentoring junior
• Strategic Thinking: Ability to balance technical depth with strategic business insight, ensuring that data initiatives drive measurable business value.
• Communication: Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Problem Solving: Strong analytical and problem-solving skills, with meticulous attention to detail.
• Educational Background: Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or a related field.