About the company
Ardmore Home Design (AHD), founded in 2008, is a privately owned, fast-paced, founder-led entrepreneurial company where we value people with strong skills to make our products and processes better every day. We design, sell, and distribute luxury home dcor globally to interior designers and boutique / luxury retailers. The AHD family of wholesale brands includes Made Goods (flagship furniture made from unique materials), Pigeon & Poodle (home and bath accessories), Blue Pheasant (handcrafted tabletop products) and Burton James (seating home furnishing).
About the Role :
We are seeking a Sr. Data Engineer with extensive experience in designing and implementing data architectures in Snowflake and MS SQL Server, as well as working with multiple database platforms for varied business use cases. This role focuses on building robust data pipelines, optimizing data structures, and ensuring high-performance data solutions that meet the needs of a data-driven organization. This individual embraces and supports our in-person / on-site work culture and embodies our company values of Ownership, Collaboration and Respect .
What You'll Do :
Data Architecture & Design :
- Design and implement scalable data architectures in Snowflake and other platforms to support analytics, reporting, and operational systems.
- Optimize database schemas and data models for performance, scalability, and maintainability.
Data Engineering :
Develop, test, and maintain efficient ETL / ELT pipelines to process and load structured and unstructured data from diverse sources.Build data pipelines that support real-time and batch processing.Database Expertise :
Work extensively with MS SQL Server and other database platforms for data storage, query optimization, and performance tuning.Leverage experience with NoSQL, columnar, and relational database systems to meet varied data use cases.Collaboration & Cross-Functional Support :
Partner with data scientists, analysts, and software engineers to understand data requirements and deliver tailored solutions.Collaborate with business stakeholders to align data structures with organizational needs.Data Quality & Governance :
Implement and enforce data quality, security, and governance standards to ensure accuracy, integrity, and compliance.Monitor data systems for consistency and reliability.Performance Optimization :
Continuously optimize query performance, storage costs, and processing speeds across platforms.Collaborate Across Teams :
Work with data scientists, analysts, and business stakeholders to understand data needs and provide high-quality, efficient data solutions.Mentor & Lead :
Provide technical guidance and mentorship to junior data analysts, fostering their development and ensuring best practices are followed.Ensure Data Integrity :
Maintain high standards of data integrity by developing data quality checks, validation rules, and ensuring proper data governance practices are in place.
Problem Solving & Troubleshooting : Resolve complex data issues through detailed analysis, identifying root causes, and implementing long-term solutions to prevent recurrence.Requirements
Education : Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent experience.Experience : 6 years of experience in data engineering, including hands-on experience with Snowflake and MS SQL databases.Snowflake : Strong experience in designing data architectures, optimizing Snowflake warehouses, and leveraging its advanced features (e.g., time travel, zero-copy cloning).MS SQL Server : Extensive knowledge of database design, query optimization, normalization, and performance improvements.Data Pipeline Development : Proven experience in designing, implementing, and maintaining data pipelines using modern ETL / ELT tools and technologies in tools like Apache Airflow, Talend, DBT, Fivetran or custom Python / Scala pipelines.Data Warehousing : Expertise in data warehousing design and management, particularly with Snowflake .Programming & Scripting : Proficiency in programming languages such as Python , SQL , and experience working with data processing frameworks.Cloud Platforms : Experience with cloud technologies like AWS , Azure , or Google Cloud and their respective data services.Data Quality : Strong experience in ensuring data integrity and quality through validation, testing, and transformation.Mentorship : Ability to mentor and provide guidance to junior team members, fostering a culture of learning and development.Performance Tuning : Expertise in query optimization , database tuning, and enhancing performance in large-scale data environments.Analytical & Problem-Solving Skills : Excellent analytical skills with a strong focus on troubleshooting and resolving data issues.Communication Skills : Strong verbal and written communication skills, with the ability to articulate technical concepts to both technical and non-technical stakeholders.Physical Requirements : The physical demands described here are representative of those that are required by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to sit; stand; walk; use hands to finger, handle or feel; as well as reach with hands and arms.The employee must frequently lift and / or move up to 15 pounds and occasionally lift and / or move up to 35 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception and ability to adjust focus.Ability to work in open environment with fluctuating temperatures and standard lighting.Ability to work on computer and mobile phone for multiple hours; with frequent interruptions.Required to use stairwells to attend meetings and engage with employees on multiple floors throughout building.Other Considerations : Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. Reasonable accommodations may be made to qualified individuals with disabilities to enable them to perform the essential functions of the role.
Compensation Starting annual salary : $120,000-$130,000. Exact compensation may vary based on skills, experience, and location.
Salary : $120,000 - $130,000
