Data Architect-Cloud Architect

Prominence Advisors

Job Overview

Location

Remote

Employment Type

Full-time

Work Arrangement

Remote

Sector

Information Technology & Software

Experience Level

Senior (5-8 years)

Application Deadline

May 2, 2026

About the Company

Prominence Advisors is a leading healthcare and life sciences technology and consulting firm dedicated to empowering organizations to maximize their data's potential. With extensive expertise across providers, payers, and life sciences, they transform complex data into actionable insights.

Their comprehensive service offerings include advisory, analytics, optimization, and IT staffing, all aimed at enhancing operational efficiency, improving patient outcomes, and driving measurable financial impact. Prominence has earned prestigious recognition, including two Best in KLAS awards, and has been honored with over 30 Best Places to Work accolades, reflecting their commitment to innovation and their exceptional team.

The company fosters a people-first, values-driven culture, emphasizing strong teams and trusted partnerships to advance healthcare and life sciences. They operate with two core business nodes: Analytics and Epic Services, providing diversified career paths and stability in a dynamic market. Prominence is a fully remote company, offering flexibility in work location within the US and schedule management.

Job Description

Prominence Advisors is seeking a skilled Data Architect with extensive experience in SQL to spearhead the development and deployment of advanced analytics solutions. You will collaborate closely with leading healthcare providers, leveraging your deep understanding of platforms like Microsoft SQL Server, Azure Synapse, AWS Redshift, Snowflake, Databricks, and Apache Spark.

In this role, you will be instrumental in transforming raw data into meaningful, actionable insights. You will design and maintain scalable data models, guide clients through complex technological challenges, and develop tactical action plans to ensure project success. Our ideal candidates are humble, intelligent, and driven individuals committed to client success and knowledge sharing.

You will be responsible for writing, debugging, and optimizing SQL queries, ensuring the integrity and efficiency of data processes. This position offers a unique opportunity to shape the future of healthcare data analytics within a highly respected and award-winning organization.

To apply for this role, click the Apply button on this page and follow the instructions.

Required Skills

SQLData ModelingMicrosoft SQL ServerDatabricksSnowflakeMicrosoft FabricAzure SynapseAWS RedshiftApache SparkCloud TechnologiesProfessionalismOrganizationSelf-MotivationAdaptabilityCreativityCommunicationProactivenessTeamwork

Key Responsibilities

Work with raw data to transform it into meaningful, actionable information.
Design data models that scale in size and complexity.
Develop and deploy analytics solutions to meet customer needs.
Guide customers through complex, new or unfamiliar technology requirements and compile ambiguous information into actionable plans.
Write, debug, and optimize SQL queries.

Qualifications

Strong experience in reading and writing SQL. Ability to write, debug and tune SQL queries.
Deep knowledge of relational data modeling. Ability to think at an architectural level in creating, growing, maintaining, and documenting scalable data models.
Experience with one or more of the following technologies: Microsoft SQL Server, Databricks, Snowflake, Microsoft Fabric, Azure Synapse, AWS Redshift, or similar cloud or big data platforms.
High degree of professionalism, treats others with respect, builds trust within the team, works with integrity, and upholds organizational values.
Organized: Manages multi-faceted work streams efficiently, ensuring smooth project execution.
Self-Motivated: Manages personal schedule, meets deadlines, and monitors work quality independently.
Highly Adaptable: Quickly acclimates to new projects and diverse work environments.
Creative: Finds novel solutions to problems and works collaboratively with team members.
Communication: Conveys clear and concise messages that resonate with the intended audience in both written and verbal forms.
Proactive: Anticipates potential issues, addresses concerns before they escalate, and escalates effectively when necessary.
Team-Oriented: Passionate about mentoring and guiding others, thrives in a team-based environment.
Healthcare industry knowledge and experience (Preferred).
Experience in C#, Python, or general programming (Preferred).
Familiarity with SQL Server hardware and software configuration best practices (Preferred).
Experience with reporting tools such as Power BI or Tableau (Preferred).
Knowledge of cloud-based services (AWS, Azure) (Preferred).
Must be legally authorized to work in the United States without sponsorship.

Benefits & Perks

2 nodes of business: Analytics and Epic Services - offer a diversified career path, stability in a rapidly changing market, and opportunities for growth within Prominence.
Fully remote company, with no requirements on where you live or work within the US and flexibility to manage your schedule.
15 days PTO and up to 16 paid Holidays each year for full-time staff.
Diverse healthcare offering, including low and high deductible health plans, HSAs, LTD/STD Insurance, Health and Dependent Savings Accounts, Vision, Dental, 401k offering, an annual Professional Development fund, and Signing Bonuses.

How to Apply

To apply for this role, click the Apply button on this page and follow the instructions.

Join Our Communities

Join WhatsApp Channel Join Telegram Group

The healthcare industry is experiencing a significant digital transformation, driven by the need for advanced data analytics to improve patient outcomes and operational efficiency. This role is crucial for architecting scalable data solutions, leveraging expertise in SQL, Azure Synapse, AWS Redshift, Snowflake, Databricks, and Apache Spark. Your impact will be measured by your ability to translate complex data into actionable insights, directly influencing business ROI and guiding strategic data initiatives for leading healthcare providers. This position demands a forward-thinking approach to data architecture, ensuring solutions are robust, efficient, and future-proof.