Paula’s Choice is Your Right Choice!  

Paula’s Choice Skincare is a multinational brand that is 25 years strong! Our vision is to empower and enable people around the world with highly effective products and in-depth knowledge to achieve their own definition of beautiful. We question ingredients, follow the facts and stand up for the customer, because we’re in this journey together.   

How you’ll have an impact at Paula’s Choice:  The Enterprise Database Developer and Administrator will be the principal data steward in our enterprise.  As such, you’ll be at the core of managing key decisionable data for the business.  The primary function of this role is to develop database solutions that enable better business intelligence as we support our customers with world class customer relations.  This is a deeply technical role that supports Product Owners, Business Analysts and Technical Program Managers and translates business requirements / stories into execution.  It is very detail-oriented and requires personal ownership to keep us safe, secure, and efficient.

This is an incredible opportunity to “do it right” as we build a new Data Warehouse and standardize KPI’s globally.

As an Enterprise Database Developer & Administrator, a typical day might include a mix of the following:

• Provide technical leadership in design, architecture, development and support of the entire data sourcing platform (on premise and in Azure) with a focus on high availability, performance, scalability and maintenance
• Analyze, understand and make sense of complex source data, create data models, and determine the best methods for data staging ETL/ELTL into the data warehouse
• Design and develop data warehouse tables (star schemas, dimension tables, etc.) for fast data analytics
• Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, database backups and performance tuning
• Develop, contribute, and adhere to the development of standards and sound procedural practices in compliance with PC’s Data Regulatory Council’s rules.
• Create or update technical documentation
• ·Develop automated data audit and validation processes
• Develop and deploy workflows with reliable error/exception handling and rollback
• Proactively communicate innovative ideas, solutions, and capabilities over and above specific task requests
• Strong analytical and troubleshooting skills.
• Highly motivated self-starter, detail and quality oriented and ability to handle multiple competing priorities.
• Must be a strong team player with a positive attitude and enthusiasm to get things done.
• Presentation skills to various levels of the organization including executive management.
• Excellent communication (both written and verbal), interpersonal skills and experience.
• Other responsibilities as assigned by your manager

The details:

Location:  Seattle, WA (Temporarily remote)

Hours:  Typical business hours (45 hours/week).  Times flexible.  24/7 Support rotation (one week on, several weeks off, etc.)

Travel requirements:  None

What you’ll bring to the table:

• 5+ years ETL/ELTL development experience preferably using Microsoft SQL Server Data Tools with deep and thorough hands-on use of SSIS
• 5+ years of intense experience in relational and data warehouse database design, optimization and performance; preferably with MS SQL Server
• Proven understanding of business requirements and the ability to interpret DW architectures and execution.
• 3+ years development using C#, .Net Framework
• Experience with Web services development (SOAP, REST)
• Strong in Object Oriented Programming, Design patterns, and SOLID principles

What can help you really stand out:

• Have experience building out a data warehouse solution from scratch
• Have advanced SQL skills with a focus in supporting Microsoft SQL Server and Azure services
• Experience with data visualization tools such as Power BI
• Geek out over big data, data lakes, Python, and R
• Experience with ServiceStack framework, Azure App Services

What we offer you:   

• A robust benefits package including health, vision, dental, retirement and more   
• Transportation stipend, gym membership and more   
• Product samples and discounts   
• Generous PTO   
• Great location – we’re in the heart of Seattle’s beautiful International District   
• Exceptional environment – we work hard and celebrate our accomplishments. You might catch our teams riding the Seattle Ducks, at Mariner’s games or connecting at happy hours   
• Did we mention we’re a dog-friendly office?    

Paula’s Choice is committed to diversity! Our customers come from all walks of life and so do we. We hire great people from a wide variety of backgrounds, not just because it’s the right thing to do, but because it makes our company stronger. We hope you agree. If you share our values and our enthusiasm for empowering people to achieve their own definition of beautiful, Paula’s Choice could be a wonderful fit for you.  

Note: At any time, with or without notice, Paula’s Choice reserves the right to add/delete/change the position’s requirements.