Data Architect – Cloud Architect

Prominence Advisors

Data Architect with expertise in SQL and cloud technologies for analytics solutions in healthcare. Collaborating with provider clients to transform raw data into actionable insights.

Posted 4/16/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

Amazon RedshiftApacheAWSAzureCloudMS SQL ServerSparkSQL

About the role

Key responsibilities & impact

Prominence is seeking a data architect with strong experience in SQL to help build and deploy analytics solutions in partnership with some of the nation’s leading healthcare providers.
The ideal candidate has deep familiarity with Microsoft SQL Server and/or cloud technologies such as Azure Synapse, AWS Redshift, Snowflake, Databricks, Apache Spark, or similar tools.
Our consultants guide our customers through complex technology requirements to summit the challenge at hand.
You will need to be able to create order out of chaos, and compile ambiguous information into tactical action plans.
Our ideal team members are humble, smart, and driven to ensure our customer’s success. This includes a passion to deliver high-quality results, while teaching our counterparts how to fish and grow the skills needed to support and expand upon the deliverables of our projects.

Requirements

What you’ll need

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.
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
- Similar cloud or big data platforms
Professional: 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.

Benefits

Comp & perks

Prominence is dedicated to hiring the best and brightest minds in healthcare, and maintaining a culture that rewards our employees for following their passion.
You’ll join a team of highly motivated and passionate people who do great work for the nation’s leading healthcare organizations, including 7 of the top 10 academic medical centers.
In the past 5 years, we’ve received 20+ Best Places to Work Awards and are highly rated in KLAS, reflecting the quality work from our team of A-players who move mountains daily for our customers.
We strive to create the best working environment with the best team, so that we can continue to drive innovation in healthcare faster.
Our 2 nodes of business: Analytics and Epic Services - offer you a diversified career path, stability in a rapidly changing market, and opportunities for growth within Prominence.
Prominence is a fully remote company, with no requirements on where you live or work within the US and flexibility to manage your schedule.
We offer 15 days PTO and up to 16 paid Holidays each year for full-time staff.
We offer a 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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata modelinganalytics solutionsdebugging SQL queriesoptimizing SQL queriesrelational data modelingcloud technologiesbig data platformsdata transformationtactical action plans

Soft Skills

professionalismorganizationself-motivationadaptabilitycreativitycommunicationproactivityteam-orientedmentoringcollaboration