Prominence Advisors Logo

Prominence Advisors

Data Architect-Cloud Architect

Posted 3 Days Ago
Remote
Hiring Remotely in United States
Mid level
Remote
Hiring Remotely in United States
Mid level
The Data Architect will design scalable data models, transform raw data into actionable insights, and deploy analytics solutions for healthcare providers, with a strong emphasis on SQL proficiency and cloud technologies.
The summary above was generated by AI

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.

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.


Requirements

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.

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

Benefits

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.

Top Skills

Spark
Aws Redshift
Azure Synapse
Databricks
Microsoft Sql Server
Snowflake

Similar Jobs

9 Days Ago
Remote or Hybrid
United States
Senior level
Senior level
Fintech • Software
The Cloud Data Architect will design scalable data architectures for SaaS solutions, set data standards, collaborate with engineering, and ensure data governance and optimization. Requires advanced SQL and cloud platform proficiency.
Top Skills: Apache AirflowAzureAzure Data FactoryAzure SynapseDatabricksOciOraclePysparkPythonSnowflakeSpark SqlSQL
13 Days Ago
Remote
United States
Senior level
Senior level
Analytics • Business Intelligence • Consulting
The role involves architecting, building, and delivering data solutions on GCP, leading projects, and mentoring junior staff. Requires extensive cloud experience, particularly with GCP.
Top Skills: App EngineBigQueryBigtableCloud ComposerCloud Data FusionCloud FilestoreCloud StorageCompute EngineData AnalyticsData PipelinesDataflowDatalabDataprocDatastoreETLFirestoreGoogle Cloud PlatformMemorystorePersistent DiskVmware Engine
4 Days Ago
Remote
United States
87K-266K Annually
Senior level
87K-266K Annually
Senior level
Software
The Salesforce Data Cloud Solution Architect leads customer data strategy architecture, designs data solutions, ensures integrations, and collaborates with team members to drive AI-powered transformations.
Top Skills: AgentforceAmazon ConnectBigQueryDatabricksEinsteinLookerMulesoftPandasPower BIPythonRedshiftSalesforce Data CloudService CloudSnowflakeSparkSQLTableau

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account