Data Architect

Scentsy is looking for a Data Architect to lead, champion change, and drive technology vision for large-scale architectural systems as well as stand accountable for defining, maintaining, communicating, implementing, and executing the enterprise database architecture, standards, and strategy for operational usage across the business.

Location: Meridian, ID (On-site)

Schedule: Monday - Friday 8:00 am - 5:00 pm (40hs/wk Full-Time)

Benefits:

• Flexible work schedule (9/80 Schedule - every other Friday off)
• Casual dress code
• Free Wellness Center/Gym
• Intramural sports
• 401K and matching contributions
• Medical, dental, and vision
• Paid time off
• On-site Cafeteria w/ discounted rates
• AD&D, life, and disability benefits
• Cutting-edge technology
• Other Company and Community perks & discounts

At Scentsy, we’re all about being our authentic selves and embracing our differences, and we’d love to hear from you – even if you don’t fit every bullet point in this job description. So, if you’re excited about this opportunity and think you can bring something awesome to the team, don’t hold back – please apply, and let’s see what we can do together!

Scentsy will not sponsor for employment status at this time

What You Would Do:

• Manage logical and physical data models, enterprise data dictionary, and metadata layer
• Oversee technical design and implementation of database schemas, design for performance, database development, and technical review to meet Scentsy’s strategic objectives
• Ensure consistency across database implementations (data cleansing, integrity, and quality)
• Lead internal and external teams to influence and guide technology strategy and product delivery as well as stay current on new product feasibility and costs
• Create and execute large-scale enterprise designs that demonstrate the ability to scale, to support large numbers of concurrent users as well as large data volumes
• Responsible for hitting key metrics that include system: scalability, extensibility, maintainability, testability, and stability
• Lead proof of concept activities and conduct architectural performance validation strategies that confirm the effectiveness of one approach versus another, along with leading prototype efforts
• Work collaboratively with developers, business analysts, stakeholders, and management to define new (and enhance existing) features that are aligned with Scentsy’s overall long-term strategy
• Set the architectural vision, coding standards, and work effectively with development teams; acts as data/database Subject Matter Expert (SME)
• Support designing, building, and maintaining scalable data platforms that use emerging big data technologies
• Work with business and IT resources to create and enforce database development standards and processes, set ETL standards (tools, methods, and documentation), and define data archive/purge standards
• Participate in software development, creating designs for incremental database schemas changes, performance design recommendations, and analyze application and database issues
• Responsible for architect database, n-tier, components, and associated interactions
• Perform all other assigned tasks and requirements as needed

You Should Have:

• 10 years of development experience
• 3 years of architectural experience
• Bachelor's degree in Computer Science preferred equivalent experience
• Experience with cloud migrations and syncing data from cloud-based sources to legacy sources
• Experience in high-traffic, high-volume, and high-availability environments
• Experience in e-commerce web retail solutions
• Experience in 3-tiered applications and/or SOA design and development is highly desired
• Innovative and seasoned architect with proven leadership experience in guiding a team in architecture design, best practices, policies, procedures, etc.

Things You Should Know & Be Able to Do:

• Ability to multi-task and stay focused and organized in a dynamic work environment
• Ability to work in a fast-paced agile software development lifecycle, dedicated to a solid user experience
• Strong analytical and problem-solving skills
• Strong customer service skills
• Ability to effectively communicate technical information to both technical and non-technical personnel - both written and verbal
• Ability to plan, scope, budget, and document requirements for a feature or project
• Understanding of Object-Oriented Analysis and Design, UML, and web architecture
• Familiar with big data platforms including Snowflake and other Data-as-a-Service(DaaS) infrastructures
• Strong experience with cloud-based data solutions including AWS and Azure, Microsoft technologies including C#, LINQ, SQL Server, SQL Server Reporting and Integration Services, writing stored procedures and queries in SQL Server, BI, Data Warehouse, NoSQL database solutions
• Strong experience in SQL Server, database configuration, administration, security, clustering and replication, mirroring, backups, profiling, and maintenance