Senior Data Engineer

Position: Senior Data Engineer (Contractor or Full Time)

Location: Currently Remote / Port Chester, NY

Position Reports to: SVP, Development

ABOUT THE SHADE STORE

At The Shade Store, we have handcrafted the finest Shades, Blinds and Drapery for 75 years. We believe designing beautiful custom window treatments should be an effortless experience, so we offer outstanding services to help our customers every step of the way, from inspiration to installation.

WHY WORK AT THE SHADE STORE

We set out to create a company culture that is enjoyable, rewarding, and where there is continuous upward mobility and growth opportunity. If you work hard, give the company your all, use good judgment, and have a positive attitude then the sky’s the limit. In return, there are numerous perks and benefits including:

• Full time highly competitive salary
• Medical Benefits
• 401k Available and we match up to 4% of your contributions
• Life Insurance & Short Term Disability Coverage provided at no charge

THE POSITION: Senior Data Engineer

As The Shade Store continues our aggressive growth, it has become ever more apparent that we need to continue to grow and scale this very important team. We’re committed to building an excellent team of collaborators and innovators. Our team is ambitious and passionate; the environment is close-knit, fast paced and fun. We are a company that values doers over talkers and mentors over managers. If you work well with people and most importantly have the technical skill set to help support the business in the functions described above - then we would love to hear from you.

The position will report directly to the SVP, Development and will be part of the Development team responsible for building and scaling our existing data and reporting operational functions that support and inform strategic decision making for The Shade Store. The role requires hands-on technical data skills, and good communication skills for collaboration with the rest of the development team and business stakeholders in other departments.

RESPONSIBILITIES:

• Design, build, develop, deploy and maintain applications using the Looker and Snowflake business intelligence platforms.
• Develop and optimize large-scale batch and real-time data pipelines that ingest structured and unstructured data from a variety of sources.
• Experience loading and unloading data with different file types (such as CSV, JSON, XML, etc)
• Hands-on experience with LookML and SnowSQL (writing procedures)
• Strong experience with SQL language and data warehousing architecture
• Develop and maintain pipelines using DBT
• Experience with ETL technologies and integrations
• Experience using code versioning and build processes (GIT)
• Able to perform data quality checks and validation rules and various stages of processing.
• Develop reporting solutions to challenging complex business problems.
• Work closely with the business stakeholder team and shared development resources across all phases of projects
• Lead and/or participate in project efforts using an Agile development methodology.
• Collaborate with QA to develop comprehensive and appropriate test strategies for each release

POSITION REQUIREMENTS:

• Bachelor’s degree in computer science, Engineering or a related subject, or equivalent experience
• 5+ years in a Data Engineer or SQL-heavy data analyst role
• Track record of success in building new Data Engineering processes with a wide range of data sets from various sources.
• Demonstrated ability to work across disparate teams to achieve consensus on key business decisions.
• Expert-level SQL skills.
• Advanced knowledge with Looker, DBT, Snowflake and/or equivalent tools.
• Willingness to roll up your sleeves and fix problems in a hands-on manner.
• Intellectual curiosity and research abilities.
• Demonstrated knowledge of modern SDLC, Agile/Scrum, Kanban etc.
• Ability to organize and manage multiple tasks and priorities
• Strong communication skills with the ability to cross collaborate amongst internal departments
• Self-motivated and willing to "do what it takes" to get the job done

NICE TO HAVES:

• Experience building on AWS
• Expert level with basic tools like Excel
• MySQL tuning and database optimization

THE SHADE STORE offer is contingent upon:

• Proof of legal authorization to work in the United States for The Shade Store, which will be confirmed by E-Verify within three business days of your hire date

The base salary range for this position is $150-$170k, commensurate with experience.

The Shade Store provides equal employment opportunities to all employees and applicants 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.