Senior Data & Cloud Architect — SQL & Analytics

Prominence Advisors, Inc

United States

Remote

USD 90,000 - 140,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

15 days PTO
Diverse healthcare offerings
401(k) offering
Annual Professional Development fund
Flexibility to manage your schedule

Job summary

A technology consultancy is seeking an experienced data architect to build and deploy analytics solutions in partnership with healthcare providers. The ideal candidate has strong SQL skills and familiarity with platforms like Microsoft SQL Server, Azure Synapse, and Databricks. This fully remote position requires strong communication skills and the ability to manage complex data responsibilities effectively. The company offers flexible scheduling and a comprehensive benefits package, including 15 days PTO and diverse healthcare options.

Qualifications

  • Strong experience in reading and writing SQL; ability to write, debug, and tune SQL queries.
  • Deep knowledge of relational data modeling; think at an architectural level to create scalable data models.
  • Experience with cloud technologies such as Azure Synapse and AWS Redshift.

Responsibilities

  • Transform raw data into meaningful, actionable information.
  • Design data models that scale in size and complexity.
  • Develop and deploy analytics solutions to meet customer needs.

Skills

SQL
Relational Data Modeling
Cloud Technologies
C#
Python

Tools

Microsoft SQL Server
Databricks
Snowflake
Azure Synapse
AWS Redshift
Power BI
Tableau

Job description

Prominence is seeking a Data Architect / Analytics Engineer (Databricks) with strong SQL expertise and hands-on experience with Databricks to design and deploy advanced analytics solutions for some of the nation’s leading healthcare providers. The ideal candidate brings deep familiarity with Databricks and complementary technologies such as Microsoft Fabric, Azure Synapse, AWS Redshift, Snowflake, Apache Spark, or similar platforms.

Who We Are

Prominence is an award-winning data enablement firm revolutionizing healthcare. We empower healthcare organizations to unlock the full potential of their data, driving improvements in patient care, operational efficiency, and financial outcomes. Celebrated with two Best in KLAS awards and honored with over 30 Best Places to Work accolades, we are proud of our innovative culture and exceptional team. If you’re passionate about making healthcare smarter and eager to tackle the industry’s most critical challenges, Prominence is where your talents will not only thrive but also shape the future of healthcare.

Your Role

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.

If this sounds like you, and you meet the requirements below, we encourage you to apply. If you know of someone else how would be a great fit, let us know.

Essential Functions

  • 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 and Python scripts.

Skills, Knowledge, and Abilities

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

Preferred Qualifications

  • Healthcare industry knowledge and experience.
  • Experience in C#, Python, or general programming.
  • Familiarity with SQL Server hardware and software configuration best practices.
  • Experience with reporting tools such as Power BI or Tableau.
  • Knowledge of cloud-based services (AWS, Azure).

Successful team members at Prominence display the following:

  • High degree of professionalism; treats others with respect, keeps commitments, builds trust within a team, works with integrity, and upholds organizational values.
  • Highly organized; able to manage multi-faceted work streams.
  • Self-motivated; able to mintage schedule, meet deadlines, and monitor your personal work product.
  • Highly adaptable; able to acclimate quickly to new project assignments and work environments.
  • Creative; not paralyzed by problems and able to work collaboratively to find novel solutions.
  • Clear communication skills; ability to clearly convey messaging that resonates with your audience, in clear and concise written and verbal communications.
  • Can smell smoke and anticipate issues before they arise, ability to escalate effectively.
  • Passion to mentor and guide others.

Successful team members at Prominence display the following:

  • High degree of professionalism; treats others with respect, keeps commitments, builds trust within a team, works with integrity, and upholds organizational values.

Physical and Medical Standards

  • Must be able to sit or stand at a computer and work independently.

Working Conditions and Environment

  • Must be able to work remotely and independently from a personal home office.
  • Willingness to flex across customer time zones and travel for onsite meetings and business reviews as needed.
  • Remote-first; must be based in the U.S.

Hours Worked

  • This is a full-time, 40-hour-per-week position.

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.
Employment Eligibility

Must be legally authorized to work in the United States without sponsorship.

Commitment to Equal Opportunity

The world’s most talented professionals come from every background. All applicants will be considered for employment without attention to age, race, color, religion, gender identity and/or expression, sexual orientation, national origin, marital status, veteran or disability status, or any other characteristic protected by law. In addition, Prominence will provide reasonable accommodations for qualified individuals with disabilities.

If you are smart and good at what you do, come as you are. All qualified candidates are encouraged to apply.

Partnership Eligibility

Our partnerships are extremely important to us. This online application is not intended for anyone who is currently under a non-compete agreement or has an arrangement that precludes employment at Prominence. We appreciate your help in respecting our partners.

Interested in learning more? Apply below to connect with our Talent team about immediate openings and future consulting projects.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Healthcare IT Talent Network — Join Our Pool
Healthcare IT Talent Network — Join Our Pool

Prominence Advisors, Inc • United States

Hybrid
USD 70,000 - 100,000
Competitive Salaried and Hybrid Compensation Plans
Health Care Plan
Retirement Plan (401k)
+4
Senior Healthcare Solutions Architect
Senior Healthcare Solutions Architect

Internetwork Expert, Inc. • United States

Remote
USD 110,000 - 170,000
Senior Data Scientist: AI for Healthcare, Remote
Senior Data Scientist: AI for Healthcare, Remote

Prominence Advisors, Inc • United States

Hybrid
USD 140,000 - 190,000
Health care plan
401k retirement plan
Paid time off
+2
Data Architect / Analytics Engineer (Databricks)
Data Architect / Analytics Engineer (Databricks)

Prominence Advisors, Inc • United States

Remote
USD 90,000 - 140,000
15 days PTO
Diverse healthcare offerings
401(k) offering
+2
Remote Data Engineer: Healthcare Analytics & Pipelines
Remote Data Engineer: Healthcare Analytics & Pipelines

Prominence Advisors, Inc • United States

Remote
USD 80,000 - 120,000
15 days PTO
16 paid holidays
Diverse healthcare plans
+2
Technical Project Manager
Technical Project Manager

Prominence Advisors • United States

Remote
USD 110,000 - 160,000
Health care plan
HSAs
Dental & Vision
+6
Senior Data Scientist
Senior Data Scientist

Prominence Advisors, Inc • United States

Hybrid
USD 140,000 - 190,000
Health care plan
401k retirement plan
Paid time off
+2
Senior Epic BI & Cloud Migration Lead (Remote)
Senior Epic BI & Cloud Migration Lead (Remote)

Internetwork Expert, Inc. • Chicago (IL)

Remote
USD 110,000 - 170,000
Health Care Plan
401k
Life Insurance
+4
Data Engineer
Data Engineer

Prominence Advisors, Inc • United States

Remote
USD 80,000 - 120,000
15 days PTO
16 paid holidays
Diverse healthcare plans
+2
Epic Prelude/RTE Analyst — Healthcare IT Leader
Epic Prelude/RTE Analyst — Healthcare IT Leader

Prominence Advisors, Inc • Chicago (IL)

Hybrid
USD 100,000 - 150,000
Health Care Plan (Medical)
Retirement Plan (401k)
Life Insurance
+4