• Business Intelligence Developer

    Location US-NY-New York
    Posted Date 11 months ago(4/19/2018 1:26 PM)
    Job ID
    Information Technology - All Openings
    Emp Status
    Regular Full-Time
    Hours per Week
  • Overview

    Business Intelligence & Analytics Developer


    At Hospital for Special Surgery our clinicians and scientists collaborate to deliver the most innovative care. Our specialized focus on orthopedics and rheumatology enables us to help patients get back to what they need and love to do reliably and efficiently. Our patients are overwhelmingly satisfied with the care they receive at our facilities. When you join us, you will become part of this legacy of commitment to the most cutting-edge research and coordinated care.


    The Business Intelligence Developer will primarily be responsible for the development and deployment of data warehousing solutions and Business Intelligence applications. The ideal candidate will be passionate about the field of analytics and well versed in all aspects of an enterprise-wide analytics architecture including data integration, data modeling, and master data management.



    • Design, build, and support all components of a data warehouse, such as ETL processes, databases and reporting environments
    • Develop and maintain business intelligence applications including operational reports, dashboards, scorecards, and ad hoc reporting requests
    • Develop and automate ETL processes that involve data cleansing, error, reconciliation handling and process monitoring utilizing Microsoft SQL Server Integration Services (SSIS)
    • Design dimensional models with conformed dimensions, following the business processes
    • Utilize SAP Business Objects in designing and building the reporting environment
    • Create processes for capturing and maintaining metadata
    • Create system documentation and ensure it is continually sustained.
    • Participate in the technical design and implementation of the Hospital’s enterprise wide analytics platform




    • BS/MS in Computer Science or related field
    • 5+ years of professional experience, health care industry experience (preferred not required)
    • 3+ years of Programing experience (C#/.Net, Java, Python, Scala etc.)
    • 3+ years working with RDBMS (i.e. SQL Server)
    • 2+ years of experience in data warehousing with designing multi-layered data warehouses and data marts using both relational and dimensional modeling techniques
    • 2+ years of experience in integrating data both at logical & physical levels
    • 2+ years of ETL (SSIS or other tools) experience
    • Expertise in query optimization techniques
    • Proven experience consolidating disparate data sets into usable data
    • Experience with visualization tools (e.g. Tableau)
    • Experience with SAP tools, WebI and Universe Designer
    • Experience with I2B2 or OMOP models or other healthcare data models an added plus
    • Experience with Big Data technologies (Hadoop, Spark, noSQL database) a big plus
    • Experience with a public cloud platform (AWS, Azure) and its data analytics services a big plus
    • Excellent oral and written communication skills
    • Strong interpersonal skills



    Elements of a Successful Candidate

    • Self-motivated, creative and innately curious about the world of technology and consistently introducing innovative solutions to problems.
    • Ability to monitor and synthesize data, identify trends and insights and make recommendations based on rational thinking.
    • Self-motivated people-oriented and energetic attitude; a positive team player who is analytical and focused on results.
    • Demonstrated cultural competence and ability to interface with a diverse, multi-cultural population; diplomatic and discreet; socially, culturally and politically astute.
    • Committed to improving quality and service and maintaining a spirit of cooperation and respect.

    Other Requirements



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