Data Warehouse Architect

Job Locations US-NC-Raleigh
Requisition ID
Posted Date
1 month ago(1/23/2018 3:30 PM)
Software Development




Welcome to Allscripts! Our Mission is to be the most trusted provider of innovative solutions that empower all stakeholders across the healthcare continuum to deliver world-class outcomes. Our Vision is a Connected Community of Health that spans continents and borders. With the largest community of clients in healthcare, Allscripts is able to deliver an integrated platform of clinical, financial, connectivity and information solutions to facilitate enhanced collaboration and exchange of critical patient information.


The primary purpose of this role is to Provide input into the use of technology and definition of architectural approaches applied within Allscripts software solutions to meet the company and customer's long-term requirements.


  • Assist development teams in the appropriate selection and use of technical frameworks, platforms and design patterns
  • Development and technology planning
  • Provide guidance in best practice and tool use in the design and build of technical frameworks and the applications built on them
  • Architecture and design
  • Implement technical solutions or components of complex solutions and ensure their integrity
  • Technical design authority
  • Internally recognized as highly competent in technical areas, will review and participate in benchmarking, installation, upgrade, configuration, deployment and testing activity
  • Improve quality
  • Investigate and prototype innovative approaches to improve software quality
  • Industry knowledge
  • Familiarity with industry changes in technology standards, information management, development standards, methods and emerging 3rd party software in order to advise on technology and leverage industry best practice in the design and construction of Allscripts software products
  • Able to support day to day technical control of development projects by assisting Project Management in planning technical aspects of projects
  • Provide regular updates on project status
  • Support and mentor individual junior developers
  • Perform detailed technical reviews to ensure design components are being correctly implemented Provide input into the best application of technology to create the next generation of Allscripts solutions
  • In concert with other architects within Allscripts create a center of expertise and forum for common component design, reuse and exploitation
  • Participate in the definition and documentation of development standards and best practices
  • Provide input in the drive for constantly improving the scalability, extensibility, interoperability, reliability, availability and performance of Allscripts software products


Academic and professional qualifications:

  • Bachelor's Degree with a major in Computer Science, Mathematics, MIS or any related courses



  • Upwards of 4 years relevant experience in the IT industry
  • Demonstrable understanding of architecture principles and methods, technology and standards
  • 6 years working with large SQL Server data warehouse applications
  • 6 years data warehouse architecture including data analysis, ETL processing and general system architecture.
  • 4 years aligning efficient technical designs with business roadmap requirements in a high volume data environment
  • 4 years in a technical leadership role
  • 1 year of experiene of Azure platform as a Service 
  • 4 years data modeling
  • 2 year working in an agile development environment
  • 4 years working with data base tuning and performance improvement
  • 2 years web site/web services development in .Net environment
  • 2 years using SSIS or similar ETL tool


Travel requirements:

  • Up to 25% (Able and willing to travel for occasional short assignments)


Working arrangements

  • Core hours based on local time zone, but willing to be flexible in work schedule to accommodate various time zones of a global organization


At Allscripts, our greatest strength comes from bringing together talented people with diverse perspectives to support the technology needs of 180,000 physicians, 1,500 hospitals and 10,000 post-acute organizations across the globe. Allscripts offers a comprehensive compensation and benefits package, including holidays, vacation, medical, dental, and vision insurance, company paid life insurance and retirement savings.


Allscripts policy is to provide equal employment opportunity and affirmative action in all of its employment practices without regard to race, color, religion, sex, national origin, ancestry, marital status, protected veteran status, age, individuals with disabilities, sexual orientation or gender identity or expression or any other legally protected category. Applicants for North American based positions with Allscripts must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required as a condition of hire.


From a "VEVRAA Federal Contractor" We request Priority Referral of Protected Veterans


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with Allscripts for future communications and career opportunities.