SQL Report Developer

Job Locations US-NY-New Hyde Park
Requisition ID
Posted Date
3 months ago(7/20/2020 11:46 AM)
Information Technology




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 Report Developer will be coding stored procedures, functions and reports that meet project and customer requirements for the Sunrise application. This individual will be responsible for evaluating data for reporting and analyzing technical specs for reports and data extracts.


  • Responsible for developing stored procedures and reports that meet customer requirements
  • Suggesting and implementing procedural enhancements and code optimizations
  • Responsible for documentation configuration management
  • Demonstrating knowledge of Project Life cycle
  • Implementing code and reports in line with established plans and standards for the product
  • Liaising with architects, business analysts, developers and testing teams for content input and document reviews to ensure that product functionality is well documented.
  • Pro-actively understanding changes to project scope and making relevant changes to stored procedures and report code
  • Work with clinical analysts, clinicians, and other end-users to understand and document business requirements for reports
  • Understanding of relational databases and data analysis, extracts, and reporting is required
  • Make prompt, technically sound decisions and recommendations that add value to business priorities and needs
  • Assist Quality Assurance team with validating reports
  • Escalating issues in a timely manner and suggesting improvements
  • Providing peer review support to work produced by others, confirming use of relevant coding standards; approving work produced by others
  • Provide on-call support on rotating basis for Production report related issues
  • Provide on-site support during activations



  • Microsoft SQL experience required
  • Experience with report writing tools (MS Visual Studio, MS SQL Server, MS SQL Reporting Services, SQL Server Integration Services, etc.)
  • Understanding of relational databases concepts
  • Strong analytical and documentation skills
  • Ability to ask probing questions to determine the desired outcomes for report requests
  • Strong communication skills
  • Team player
  • Healthcare background a plus
  • Knowledge of Allscripts Sunrise Clinical Manager application a plus
  • Microsoft Office experience
  • Successful completion of a Bachelor’s Degree in a relevant Program of study is mandatory



Academic and Professional Qualifications:

  •  BA or BS degree preferred and/or other relevant combination of training and experience.



  •  0-2 years Industry experience preferred
  •  2-5  years experience; preferred for the healthcare setting


Travel Requirements:

  •  May require local travel
  •  May require other travel for business needs


Working Arrangements:

  • May require after hours on call support
  • Work is performed in a standard office environment with minimal exposure to health or safety hazards


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 competitive total rewards package, including holidays, vacation, and medical, disability and life insurance.


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

This is an official Allscripts Job posting.  To avoid identity theft, please only consider applying to jobs posted on our official corporate site.


Visa Sponsorship is not offered for this position


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.