IT Data Architect

Ethos Risk Services • Raleigh, NC

2d • Remote

About The Position

Ethos Risk Services is a leading insurance claims investigation and medical management company committed to providing better data that translates into better decision-making for our clients. We are at the forefront of innovation in our space, and our success is driven by a dynamic team passionate about delivering exceptional services to our customers. 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. They bring deep technical expertise, strong collaboration skills, and a proactive, solutions-oriented mindset to drive data strategy and innovation.

Requirements

• Minimum of 10+ years of SQL database design, development, and administration (required).
• Hands-on experience with Amazon Aurora database technologies, specifically Aurora PostgreSQL and Aurora MySQL (required).
• 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

• A Bachelor's degree in Computer Science, Information Technology, or a related field is preferred. Relevant experience may be a substitute for formal education.
• Background supporting AI/ML workflows in enterprise environments (preferred).
• Experience in insurance, claims, or investigative services (preferred).
• Experience working with sensitive data environments (e.g., HIPAA).
• 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, specifically Aurora (additionally RDS and 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