IT Data Architect

Ethos Risk Services • Irving, TX

6d • Remote

About The Position

Our synergetic Ethos IT Team is growing and seeking a full-time Data Architect (REMOTE) to lead the modernization of our enterprise data environment. This role will be responsible for designing and implementing scalable, cloud-based data architecture, transitioning from on-prem systems to AWS, and enabling advanced analytics and AI capabilities across the organization. Our ideal candidate is a forward-thinking Data Architect who thrives on modernizing data environments and building scalable, cloud-based solutions that support advanced analytics and AI. They bring deep technical expertise, strong collaboration skills, and a proactive, solutions-oriented mindset to drive data strategy and innovation.

Requirements

• A Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant experience may be a substitute for formal education.
• Minimum of 10+ years of SQL database design, development, and administration (required).
• Experience with AWS database services (Aurora, RDS, DMS) (required).
• Background supporting AI/ML workflows in enterprise environments (required).
• Experience working with sensitive data environments (e.g., HIPAA).
• Advanced expertise in Microsoft SQL Server (T-SQL, SSIS, SSRS) and PostgreSQL.
• Strong knowledge of data modeling, ETL processes, and data warehousing.
• Experience with vector databases (e.g., OpenSearch, pgvector, Pinecone).
• Understanding of data security, privacy, and disaster recovery.
• Strong communication and cross-functional collaboration skills.

Nice To Haves

• Experience in insurance, claims, or investigative services (preferred).
• AWS Certified Database Specialty or AWS Solutions Architect (preferred).

Responsibilities

• Lead transition from Microsoft SQL Server to AWS Aurora (PostgreSQL-compatible) and drive overall data strategy.
• Architect and manage AWS database services (Aurora, RDS, DMS).
• Implement vectorized data storage solutions to support machine learning and generative AI use cases.
• Develop and maintain logical and physical data models aligned with business needs.
• Monitor, tune, and ensure high-performing database environments.
• Establish frameworks for compliance, security, and data integrity.
• Partner with engineering, analytics, and business teams.
• Mentor team members and contribute to strategic architecture decisions.
• Maintain architecture documentation, standards, and best practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 101-250 employees