Companies Hiring Now — Impact of COVID-19: There are companies out there that are experiencing an immediate need for new employees including delivery networks, shippers and warehouse operators, and grocery and restaurant delivery services. Click here for more information.

Advanced Drainage Systems

Business Intelligence Developer

Click Here to Apply

Job Location

Hilliard, OH, United States

Job Description


We are looking for Business Intelligence Developer to join our team!


Primary Job Responsibilities:

The responsibilities of this position include, but are not limited to:

    • Utilize Power BI 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 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, 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
    • 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 writing Power Query, DAX, MDX for complex data projects
    • Experience authoring, diagnosing, and altering SQL Server objects and T-SQL queries
    • Experience creating and maintaining reporting assets in Power BI
    • Knowledge of general data modeling concepts
    • 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
    • Designing beautifully organized analytics dashboards for upper management
    • Experience using Agile/SCRUM techniques
    • Understanding of Power BI Premium

Educational Requirements:

    • 5+ years of Business Intelligence experience in a data warehouse environment
    • 3+ years of experience with Power BI
    • Experience with T-SQL is required
    • 2+ years' experience with DAX, Power Query, and MDX is required
    • Experience with Oracle EBS is preferred but not required
    • Experience with SalesForce is preferred but not required
    • Experience with Microsoft Flows
    • Experience with Azure Data Lake fundamentals
    • A 4 year degree is preferred
    • 2+ years' experience in DW multidimensional modeling
    • 2+ years' experience with ETL specifications/process/documentation
    • Experience with Oracle or equivalent RDBMS
    • Proficient in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW


Location: Hilliard, Ohio, US

Posted Date: 9/28/2021
Click Here to Apply
View More Advanced Drainage Systems Jobs

Contact Information

Contact Human Resources
Advanced Drainage Systems


September 28, 2021
UID: 147425789 does not guarantee the validity or accuracy of the job information posted in this database. It is the job seeker's responsibility to independently review all posting companies, contracts and job offers.