• Business Intelligence Developer

    Job Locations US-PA-New Castle
    Posted Date 2 months ago(2 months ago)
    Job ID
    # of Openings
    Information Technology
  • Overview

    The primary function of the Business Intelligence Developer is to fulfill a key role in planning, designing, coding, testing, debugging, configuring and documenting business intelligence solutions, including data warehouse development and reporting. Experience with SQL Server and the Microsoft BI stack is required.


      • Responsible for design, coding, testing and maintenance for ETL and reports within our PMS, data warehouse, and business intelligence platforms
      • Writes and/or reviews functional and technical specification documents
      • Writes and/or reviews business requirements documents in conjunction with business users
      • Responsible for maintaining integrity of database information
      • Provides off hours support of critical production applications when necessary
      • Manages middleware interface programs and or applications that move data between systems using ETL functions
      • Adopts and follows change management procedures related to implementation of application changes within core systems
      • Design, develop, and support data marts utilized by mission critical data warehouse applications
      • Develop and maintain data architecture, data management standards/conventions, data dictionaries, data element naming standards & data dictionary metadata standards
      • Assists cross-functional team members to recommend technical solutions to business issues and/or system issues
      • Acts as peer reviewer for other application developers’ output to enforce accepted programming standards and techniques
      • Provides assistance and routine consultation to internal business users of BI content
      • Ability to effectively present information in one-on-one and large group situations to senior management and other employees
      • Enforces Software Development Lifecycle (SDLC) and other company IT standards
      • Expected to work all scheduled work days, during scheduled hours and report to work on time.
      • Other special projects or responsibilities as assigned.

    Technology Competencies:

    Technical expert in the following areas:

    • BI Systems/Applications
    • Microsoft SQL Server 2012/2014/2016
    • Microsoft BI Stack (SSIS/SSRS/SSAS/PowerBI)
    • MySQL
    • Practice Management Systems
    • Primary Languages
    • SQL
    • Primary Operating System
    • Microsoft Windows
    • Primary Database
    • Microsoft SQL Server 2012/2014/2016






    • 4+ years’ experience architecting and building data warehouses
    • 4+ years using ETL tools (SSIS)
    • 6+ years SQL programming with Microsoft SQL 2008/2012/2014/2016
    • 4+ years developing reports using Microsoft BI Stack (SSRS, Power View, Power BI, Power Pivot)
    • 4+ years of BI development experience in the medical vertical preferred
    • Strong knowledge of dimensional data modeling and star schema design
    • Strong experience in current software engineering and solution delivery methodologies
    • SharePoint experience preferred
    • Some off hours support will be required
    • Proficient in Excel and MS Office Suite



    • Competitive Salary
    • Health, Dental, and Vision coverage
    • Full Time Associates Enjoy Up to 3 weeks Paid Time Off
    • 7 Paid Holidays
    • Short and Long Term Disability
    • Life Insurance
    • 401(k)


    North American Dental Group is an Equal Opportunity Employer

    #ZR #CB #GD


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