
Data Architect – Cloud Architect
Prominence Advisors
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
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