• Business Intelligence Developer

    Job Locations US-OH-Hilliard
    Posted Date 1 week ago(4/11/2019 9:06 AM)
    Job ID
    Information Technology
    City Name(s)
    Columbus, OH or Hilliard, OH
  • Overview

    Headquartered in Hilliard Ohio, Advanced Drainage Systems, Inc (ADS) is the leading manufacturer of high performance thermoplastic corrugated pipe, providing a comprehensive suite of water management products and drainage solutions.  Our innovative products and superior drainage solutions are used across a broad range of end markets and applications, including residential, non-residential, agriculture and infrastructure applications.  We have established a leading position in many of these end markets by leveraging our national sales and distribution platform, overall product breadth and scale, and our manufacturing excellence.  Founded in 1966, we operate a global network of 3,700 employees, 63 manufacturing plants and 31 distribution centers.  In July, 2014 we became a public company traded on the NYSE®.  To enable our continued growth, we are looking to add top talent to our dynamic organization.


    The Business Intelligence Developer supports delivery of business intelligence solutions focused on the Microsoft BI stack in an agile team environment. The BI Developer should have good understanding of general and design principles and concepts as well as the toolsets in this space.


    Primary Job Responsibilities:


    • Utilize SQL Server, SSRS, SSAS, & SSIS to deliver high quality BI solutions in a mature enterprise data warehouse environment
    • Assist in the collection of user requirements and creation of functional specifications
    • Translate functional specifications into technical specifications, including tasks, timelines, and time estimates
    • Working from technical specifications, create or alter existing ETL processes
    • Create or modify existing reporting assets
    • Analyze relational and multidimensional data sets
    • Design or enhance relational and dimensional data models
    • Build data visualizations including dashboards and reports
    • Document data profiling and quality assurance results, ETL processes, data dictionaries and analytical findings
    • Comply with team development, IT, and company processes and policies
    • Assist/train users in the use of business reporting assets including Excel Pivot Tables connected to SSAS multidimensional model
    • Work with teammates to plan mid- and long-term product and technical strategies
    • Assist with crafting the development lifecycle process to fit tools and needs
    • Communicate clearly with business users and IT professionals about enhancements that are being made to the existing system
    • Participate in a rotating on-call schedule for production support


    Job Skills:

    • Experience with building ETL processes using SSIS and T-SQL
    • Experience authoring, diagnosing, and altering SQL Server objects and T-SQL queries
    • Experience creating and maintaining reporting assets in SSRS, PowerBI, Tableau, and/or QlikView (Qlik Sense)
    • Knowledge of and experience with Kimball/Inman schema data warehousing concepts
    • Knowledge of general data modeling concepts
    • Experience with SQL Server Analysis Services MD
    • Understanding of Big Data and IIoT
    • Understanding of process engineering concepts and measurements
    • Excellent written and verbal communication skills
    • Ability to work effectively with remote teammates and users
    • Ability to disagree with civility and respect


    Educational Requirements:

    Bachelor's Degree in Information Systems, Computer Science or relevant work experience


    Preferred Experience:

    • 5+ years of Business Intelligence Experience in a data warehouse environment
    • 4+ years of experience with SSRS
    • Experience with SQL Server version 2012+ and T-SQL is required
    • Experience with SQL Server Integration Services version 2012+ is required
    • Experience with SQL Server Analysis Services 2012+ and MDX is required
    • Experience with SQL Server Reporting Services 2012+ is preferred

    EEO Statement


    Advanced Drainage Systems is proud to be an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.



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