Prominence Advisors

Data Architect – Cloud Architect

Prominence Advisors

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

About the role

  • 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

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