Data Architect

About Us Data Analysis Incorporated (DAI) is the controlling entity of the O’Neil family of businesses. DAI and its subsidiaries operate in diverse industries worldwide, including global equity markets, health care, financial services, digital news, and insurance. Our global footprint allows our teams to be responsive to customer needs in a timely and efficient manner. We are dedicated to using technology and innovation to bring change and growth to our businesses. We believe in a dynamic workplace, creating engaging, informative products and services that help our customers succeed. Integrity is an essential characteristic for our firms and our associates  Summary The Data Architect is responsible for leading the design, review, and optimization of enterprise data solutions. This role establishes data architecture standards, promotes database design best practices, and provides technical leadership for high-performance relational database environments. The position partners with Engineering and Database Administration teams to deliver scalable, maintainable, and secure data platforms that support business growth. Duties and Responsibilities Design and review high-performance relational database architectures for enterprise applications. Define and promote data modeling standards, architectural patterns, and database design best practices. Evaluate and recommend appropriate data platforms and architectural patterns based on workload, scalability, performance, and operational requirements, and remain engaged through implementation to ensure successful adoption. Collaborate with engineering teams to ensure scalability, maintainability, and performance of solutions. Partner with Database Administrators to optimize database structures, indexing strategies, and query performance. Conduct architectural reviews and identify inefficiencies, anti-patterns, and technical debt. Provide guidance on transaction processing, concurrency, locking, and data integrity within OLTP environments. Establish standards and governance practices for database development and deployment. Support performance troubleshooting, root cause analysis, and remediation of database-related issues. Contribute to strategic initiatives involving data integration, reporting, and data warehousing. Document architectural decisions, standards, and recommended practices. Qualifications & Requirements Required Education, Experience, Certification/Licensure Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field. 10+ years of experience designing and implementing relational database solutions. Expert-level knowledge of relational databases such as: Microsoft SQL Server, PostgreSQL, and/or Oracle. Strong understanding of OLTP database design principles and performance optimization techniques. Experience with data modeling, schema design, query tuning, indexing strategies, and transaction management. …