We are the champions of childhood Hanna Andersson is a Portland, Oregon-based premier kids and baby clothing brand. Our clothes are made to play, made to last, and designed to let kids be kids. We have core commitments to design, quality, and sustainability, and we believe in helping families create meaningful everyday moments. These principles guide the Hanna Way, and lead to an experience authentically different from other children’s brands.We cultivate our unique brand by hiring team members who believe in these values, own a customer service mindset, and who are innovative, results-oriented, and comfortable working in a collaborative and growth-driven work environment. We all share in our brand’s success, and we actively encourage our team members to maintain a healthy balance in their daily lives.The Lead Data Engineer is a pivotal leader in the design, development, and management of data warehouses, ETL processes, data ingestion strategies, and data pipelines for large, complex data sets that drive Hanna’s reporting and business intelligence initiatives. This role will oversee and guide the data engineering team while collaborating with technical teams and business stakeholders to ensure seamless and efficient data flow across the organization. The Lead Data Engineer will be responsible for architecting scalable solutions, setting technical direction, and ensuring world-class standards of data integrity and system performance. Primary Duties (Identified Essential Functions*)Architecture and Optimization: Leads the design and implementation of advanced, highly available data architecture and processing solutions. Oversees optimization strategies for data fidelity, system performance, timeliness of data delivery, and resource utilization to ensure alignment with business reporting and data insight needs. Data Pipeline Design and Management: Guides the development, deployment, and maintenance of scalable ETL pipelines on Google Cloud Platform (GCP) using tools such as dbt and Fivetran. Ensures data integrity, consistency, and availability across BigQuery, SQL Server, and Power BI environments. Integration: Directs technical integrations and data ingestion with a variety of data sources and platforms including relational databases, cloud services, and third-party applications. Ensures seamless data flow and system compatibility. Leadership: Mentors, coaches, and develops data engineering team members. Serves as an escalation point and advanced resource as a subject matter expert regarding enterprise data infrastructure, data delivery pipelines, and reporting systems. Provides strategic guidance and technical expertise to the team and organization. Collaboration: Coordinates closely with cross-functional teams including e-commerce developers, data analysts, infrastructure admins, cybersecurity engineers, and business stakeholders. Leads efforts to gather requirements, understand data needs and usage, and implement effective technical solutions. Troubleshooting and Support: Oversees the monitoring and troubleshooting of data pipelines and ETL processes. Provides leadership in resolving issues, ensuring minimal system disruption, and aligning solutions with disaster recovery protocols. Provides after-hours/off-schedule support as needed and participates in a regular on-call support rotation. Documentation and Best Practices: Establishes and enforces comprehensive documentation standards for ETL processes, data pipelines, and data architecture. Promotes and implements standards and guidelines for data engineering, deployment, and analytics. Innovation: Champions the adoption of industry trends, technologies, and best practices. Proactively identifies, develops, tests, and implements cutting-edge technical solutions to enhance data engineering capabilities in support of operational goals including system security, stability, and scalability, data availability, and insight delivery. Supervisory Responsibilities: Leads and mentors the data engineering team, promoting best practices, facilitating technical skill development, and providing architectural guidance. Ensures effective team collaboration and professional growth.Required General Knowledge & SkillsGoogle Cloud Platform (GCP) Google BigQuery ETL tools (e.g. dbt and Fivetran) Microsoft SQL Server Microsoft Azure Power BI Database architecture and development (Relational, Data Lake, Data Warehouse)Data integration (Order Management, ERP, ESP, Marketing Platforms, GA4)Data modelingData pipeline optimizationRetail and e-commerce operational concepts Customer Data Platforms (CDPs) Database monitoring tools (e.g. Idera) SQL development best practices Data governance, quality, and security best practicesAnalytical Skills: Superior ability to analyze and resolve complex data issues, ensuring high data quality and optimal system efficiency. Problem-Solving: Advanced diagnostic and troubleshooting skills with a proven ability to devise effective solutions for data challenges. Communication: Exceptional communication skills, with the ability to convey technical concepts to non-technical stakeholders and lead team collaboration effectively. Organization: Strong organizational skills with the ability to prioritize tasks, manage multiple projects, and maintain high-quality outcomes.Education & QualificationsBachelor’s or Master’s (preferred) Degree in Computer Science, Data Science, or a related technical field. 7+ years of data engineering experience, with a demonstrated track record of leading the development of enterprise-level data platforms. 7+ years of experience building and optimizing data warehouses, pipelines, and ETL processes. 4+ years of experience supporting high-volume e-commerce/retail operations. 4+ years of experience supporting data partner integration$120,000 - $170,000 a yearHanna Talent Cultivation Standards:With a rise in cyber- criminal activity, please note Hanna will never: -Ask for any sensitive personal information via email, text, or other forms of instant messaging -Interview you via email and/or send you a list of questions in lieu of an interview -Extend an offer without speaking to you via phone or video call -Ask for bank account or financial information during the recruiting processLegitimate email communication will only be done to and from @hannaandersson.com email addresses. Please examine messages carefully to ensure this is the domain you are receiving messages from, as cybercriminals may also utilize domains that look similar but may have one letter off (such as @hannaander$son.com). Hanna Andersson provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. As an Equal Opportunity Employer, Hanna Andersson prohibits discrimination, harassment, and retaliation of any kind. Hanna Andersson encourages applicants of all ages.Apply for this job