Data & Cloud Data Architect

Socket.dev; United States; Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical, Dental, and Vision benefits

Employer-paid Life and LTD

401k w/ matching

Remote work options

Flexible working hours

Paid Volunteer Program

Generous FTO

On site in HQ Free daily lunches

Job summary

ELLKAY is seeking a senior Database & Cloud Data Architect to define and govern its database, data-modeling, and cloud data architecture. You will ensure scalable, secure, and governed data platforms across Snowflake, AWS, and product data stores, working with cross-functional teams in a hybrid work environment.

The role involves defining standards, designing data layers, and guiding migrations from legacy systems to cloud-native platforms.

Qualifications

• Deep experience in database and enterprise data architecture.
• Strong logical and physical data-modeling capabilities.
• Experience with AWS, Snowflake, and cloud database modernization.
• Knowledge of performance, security, resilience, backup and cost optimization.
• Experience designing governed data platforms and enterprise data models.
• Ability to influence multiple engineering teams through architecture standards.

Responsibilities

• Define the enterprise database and cloud data architecture for the shared Data Platform.
• Develop logical, conceptual, and physical data models for core domains.
• Establish standards for relational, analytical, operational, and cloud-native data stores.
• Define usage patterns for Snowflake, AWS RDS/Aurora, object storage, and NoSQL.
• Design raw, standardized, curated, semantic, and product-serving data layers.
• Define database design, naming, schema-management, indexing, partitioning, and performance standards.
• Establish data lifecycle, retention, archival, backup, and disaster-recovery patterns.
• Define data security standards including encryption, access controls, masking, and PHI protection.
• Develop canonical data models and reusable domain patterns.
• Guide migration from legacy databases to AWS/cloud platforms.
• Define modernization and migration patterns, including validation and cutover controls.
• Review and approve critical designs.
• Partner with Product Architecture, Data Engineering, Cloud Engineering, Security, Governance, Migration, and apps teams.
• Identify risks and define remediation plans.
• Create reference architectures, decision records, modeling standards, and checklists.
• Maintain hands-on depth to support teams with complex issues.

Job description

ELLKAY started out providing connectivity solutions to laboratories and within a few years, grew to also provide data management solutions to ambulatory organizations. ELLKAY is now a trusted data management partner in five healthcare segments. ELLKAY’s solutions continue to serve laboratories and ambulatory practices and have expanded to empower hospitals and health systems, healthcare IT vendors, ambulatory practices, health plans, and other healthcare organizations with cutting‑edge technologies and solutions that drive their growth and interoperability strategies.

Today, ELLKAY remains true to our core values, building strong partner relationships and offering unparalleled service and support while providing innovative, scalable solutions to the challenges our customers face in today’s data‑rich world.

ELLKAY's experience, customer‑focused approach, and reputation for innovation, speed, and accuracy differentiate ELLKAY as a premier partner for your interoperability needs and data management strategy.

Job Description:

The Database & Cloud Data Architect will define and govern ELLKAY’s database, data‑modeling, cloud data architecture, and data‑management standards. This role will ensure that the shared Data Platform, Data Lake, migration solutions, and product data stores are scalable, secure, performant, governed, and aligned with ELLKAY’s target cloud architecture.

The Architect will work across AWS, Snowflake, relational databases, analytical platforms, and product‑specific data stores. This is a senior hands‑on architecture role responsible for defining standards while helping engineering teams implement them successfully.

Essential Duties & Responsibilities:

• Define the enterprise database and cloud data architecture for the shared Data Platform.
• Develop logical, conceptual, and physical data models for core healthcare and platform domains.
• Establish standards for relational, analytical, operational, and cloud‑native data stores.
• Define appropriate usage patterns for Snowflake, Amazon RDS or Aurora, object storage, caching, search, NoSQL, and other approved data technologies.
• Design raw, standardized, curated, semantic, and product‑serving data layers.
• Define database design, naming, schema‑management, indexing, partitioning, clustering, and performance standards.
• Establish data lifecycle, retention, archival, deletion, backup, recovery, and disaster‑recovery patterns.
• Define data security standards, including encryption, access controls, masking, tokenization, auditability, and PHI protection.
• Develop canonical data models and reusable domain patterns that reduce incompatible product‑specific schemas.
• Guide migration from legacy and on‑premises databases to approved AWS and cloud data platforms.
• Define database modernization and migration patterns, including validation, reconciliation, rollback, and cutover controls.
• Review and approve critical database and data‑platform designs.
• Partner with Product Architecture, Data Engineering, Cloud Engineering, Security, Governance, Migration, and application teams.
• Identify database performance, reliability, data‑integrity, and cost risks and define remediation plans.
• Create reference architectures, decision records, modeling standards, and architecture review checklists.
• Maintain sufficient hands‑on depth to build proofs of concept and support teams with complex database or data‑modeling issues.

Qualifications:

• Deep experience in database and enterprise data architecture.
• Strong logical and physical data‑modeling capabilities.
• Experience with AWS, Snowflake, and cloud database modernization.
• Strong knowledge of database performance, security, resilience, backup, recovery, and cost optimization.
• Experience designing governed data platforms and enterprise data models.
• Ability to influence multiple engineering teams through architecture standards and technical leadership.
• Healthcare data, interoperability, or regulated‑data experience is preferred.

Benefits:

ELLKAY offers a comprehensive and competitive benefit package that starts day one!

Including:

• Medical, Dental, and Vision benefits
• Employer‑paid Life and LTD
• 401k w/ matching – once eligibility is met
• Work/life balance
• Paid Volunteer Program
• Flexible working hours
• Generous FTO
• Remote work options
• Employee Discounts
• Parental Leave
• Gym membership / Exercise class stipends

Our awesome culture includes:

• Working with talented, collaborative, and friendly people who love what they do
• Professional growth within
• Innovation environment
• On site in HQ Free daily lunches

Awards:

• 2025 Top Workplaces Employee Appreciation
• 2025 Top Workplaces Employee Well‑Being
• 2025 Top Workplaces Professional Development
• 2025 Top Workplaces Leadership
• 2026 USA Today Top Workplaces
• 2026 NJ Top Workplaces

Additional information

At ELLKAY, we are committed to operating as a hybrid workplace, offering employees flexibility in how they structure their time between in‑office and remote work. We recognize the significance of fostering connections, collaboration, and creativity within our office culture and its positive impact on our business. Our philosophy of operating as a hybrid workplace underscores our dedication to enabling employees to tailor work‑life balance to their individual preferences. For those who do not live within 40 miles of one of our offices, we are open to considering remote work for candidates whose skills and experience strongly align with the role. While we prioritize a hybrid work environment for most roles, we understand the importance of flexibility and are open to remote work for specific positions and specialized skill sets.

For more information on our company, visit www.ELLKAY.com.

ELLKAY LLC is a Smoke‑Free Workplace.

ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.