Analytics Developer

At ADS, no idea is off limits, and we celebrate creativity and bold moves. For more than 50 years ADS has been manufacturing a variety of innovative and environmentally friendly alternatives to traditional materials. Headquartered in Hilliard, Ohio, we are a multi-billion dollar stormwater management company, manufacturing pipe and ancillary products. What does that mean? When it storms, we capture rain with our drain basins, convey it with pipe, store it using chambers and finally treat it with our water quality products, before safely returning water back to the environment. We handle, what we call, the entire lifecycle of a raindrop. Our products help prevent flooding, which increases quality of life for people living in large cities, suburbs, and rural towns. We also believe in creating a circular economy and are the largest plastic recycling company in North America. We use plastic shampoo and detergent bottles to create pipe, diverting over 500 million pounds of plastic from landfills every year. ADS operates a global network of over 60 manufacturing plants and 30 distribution centers.We have amazing stories to tell, and we need your help getting our story out there. To learn more about ADS, please visit our website at www.adspipe.com.Responsibilities Primary Job Responsibilities: The responsibilities of this position include, but are not limited to: Utilize Power BI and Tableau to deliver high quality BI solutions in a mature enterprise data warehouse environment Assist in the collection of requirements, functional and technical specifications including tasks, timelines and estimates Create or modify existing reporting assets Design, analyze, and enhance relational and multidimensional data sets/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 Participate in production support Job Skills Experience authoring, diagnosing, and altering SQL Server objects and T-SQL queries Experience creating and maintaining reporting assets in Power BI and Tableau Excellent written and verbal communication skills Ability to work effectively with remote teammates and users Designing beautifully organized analytics dashboards Experience using Agile/SCRUM techniques Understanding of Microsoft BI tooling, including Azure, Power BI Premium/Pro Understanding of Salesforce Tableau tooling Requirements 3+ years of Business Intelligence experience in an enterprise environment 2+ years of experience with Power BI and/or Tableau, multidimensional modeling, and ETL processing Experience with DAX, Power Query, and MDX Experience with Microsoft Data Sets and Dataflows Experience with Azure Data Lake and SaaS BI components A 4-year technical degree is preferred Manufacturing experience is recommended EEO Statement ADS supports an inclusive workplace that values diversity of thought, experience, and background. We celebrate the power of our differences to create better solutions for our customers by ensuring employees can be their authentic selves each day. ADS is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, ancestry, age, physical or mental disability, sex, sexual orientation, gender identity/expression, pregnancy, veteran status, marital status, creed, status with regard to public assistance, genetic status or any other status protected by federal, state or local law.