IT Data Architect

ABOUT US:

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.

JOB SUMMARY:

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.

KEY RESPONSIBILITIES:

• Data Architecture & Modernization Lead transition from Microsoft SQL Server to AWS Aurora (PostgreSQL-compatible) and drive overall data strategy.
• Cloud & Database Management Architect and manage AWS database services specifically Aurora (additionally RDS and DMS).
• AI & Data Innovation Implement vectorized data storage solutions to support machine learning and generative AI use cases.
• Data Modeling & Integration Develop and maintain logical and physical data models aligned with business needs.
• Performance Optimization Monitor tune and ensure high-performing database environments.
• Data Governance & Security Establish frameworks for compliance security and data integrity.
• Cross-Functional Collaboration Partner with engineering analytics and business teams.
• Technical Leadership Mentor team members and contribute to strategic architecture decisions.
• Documentation & Standards Maintain architecture documentation standards and best practices.

QUALIFICATIONS:

Education: A Bachelors degree in Computer Science Information Technology or a related field is preferred. Relevant experience may be a substitute for formal education.

Experience:

• 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).
• 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).

Certifications:

• AWS Certified Database Specialty or AWS Solutions Architect (preferred).

Skills:

• 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.

WORKING CONDITIONS:

This is a primarily remote position working in a home office environment with a preference for candidates able to work within Eastern or Central Time Zone business hours. The role requires prolonged periods of sitting or standing while operating a computer and other office equipment. Occasional travel may be required including overnight stays. Frequent communication with team members clients and stakeholders is expected.

Ethos Risk Services is an equal opportunity employer that does not discriminate on the basis of religious creed sex national origin race veteran status disability age marital status color or sexual orientation or any other characteristic.

Required Experience:

Staff IC