Direct Hire Description: Our Client 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.
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
Experience:
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.
Skills:
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