Data Architect, Stord

• Bachelor's Degree in Computer Science, Engineering, Information Technology, or a related STEM field
• 20+ years of full-time experience in database design, architecture, and engineering
• Experience with OLTP and OLAP databases
• Experience with cloud architecture
• Working knowledge of ETL, both with custom builds and pre-built tools
• Experience with and working knowledge of event streaming
• Extensive experience with owning and building data pipelines
• Experience with both batch updates and real-time data, with ability to recommend strategic approaches to both
• Experience working with a data team and an in-depth understanding of data needs for MLOps/AI
• Communication skills and critical thinking skills to identify areas for improvement and lead change

Desirable

• STORD is looking for a Data Architect to join the Site Reliability Engineering team
• This role will focus on standardizing and implementing best practices across our software teams and databases
• This person will build and own data pipelines, identify and implement database best practices, and work closely with our data and engineering teams to optimize and scale our data
• Standardize software development database architecture across multiple enterprise systems by setting and maintaining a standard
• Drive and own schema design, code review, SQL query tuning
• Develop and implement a data strategy aligned with business objectives
• Collaborate with stakeholders to understand business requirements and define data architecture principles and standards
• Create a roadmap for the evolution of the data architecture over time
• Design and oversee the implementation of data warehouses
• Work with business intelligence teams to ensure data availability for reporting and analytics
• Optimize data structures to support efficient querying and reporting
• Ability to identify risks and dependencies to database decisions and how it empowers data and analytics
• Design and develop conceptual, logical, and physical data models
• Define data entities, relationships, and attributes to represent business concepts accurately
• Ensure data models adhere to industry best practices and standards
• Influence the selection of appropriate database technologies based on project requirements and ensure high availability
• Define database structures, tables, and indexes to optimize data storage and retrieval
• Oversee database performance tuning and optimization
• Identify areas of improvement, and implement optimization of databases to ensure optimal performance and cost efficiency
• Recommend and coordinate upgrades for existing database systems and ensure disaster recovery
• Design and implement data integration solutions to facilitate the flow of data across systems
• Define data mapping, transformation, and cleansing processes
• Ensure data consistency and integrity during integration
• Build and own data pipelines of enterprise software
• Establish and enforce data security policies and access controls
• Implement encryption, authentication, and authorization mechanisms to safeguard sensitive data
• Ensure compliance with security policies, own obfuscation protocols and protect database infrastructure and assets
• Define and implement data governance policies, procedures, and standards
• Establish data quality frameworks and monitoring processes
• Facilitate data stewardship and ownership initiatives
• Improve data architecture by tracking emerging technologies and evaluating their applicability to business goals and operational requirements
• Evaluate and recommend new tools and technologies that align with organizational needs
• Drive the adoption of modern data management practices
• Collaborate with cross-functional teams, including developers, analysts, and business stakeholders
• Communicate data architecture decisions and recommendations to technical and non-technical audiences
• Facilitate discussions to resolve data-related issues and align on solutions
• Be available for on-call support as needed