Business Intelligence (BI) Analyst

It's fun to work in a company where people truly BELIEVE in what they are doing! We're committed to bringing passion and customer focus to the business. As our company has continued to grow, we are investing in the capabilities of our FP&A organization. The BI Analyst role is a newly created position, reporting to the Global FP&A Manager, that will be responsible for utilizing data and analytical tools to provide insights and support decision-making processes across the company. This individual will work on-site at our Corporate Headquarters in Sharonville, OH. Candidates should be legally approved to work in the United States. DuBois Chemicals doe not offer sponsorship. We are looking to build out a centralized data warehouse based on our primary strategic ERP and have cleansed a dataset for our non-strategic ERPs that will eventually be sunset. This will enable management across the company to gain visibility to a standardized set of KPIs and dashboards as we continue to grow through additional M&A activity. The BI Analyst will utilize Alteryx & PowerBI to extract, transform, and analyze data from various sources to create insightful and actionable reports and dashboards. DUTIES & RESPONSIBILITIES Partner with the IT organization to develop & publish curated datasets from our primary, strategic ERP Define processes to extract, transform, and ingest data from various non-strategic data sources into a centralized data warehouse. Collaborate with IT, Commercial & Supply Chain teams to ensure data integrity and accuracy. Analyze data and create reports and dashboards that provide insights and support decision-making processes. Partner with FP&A leader & CFO to develop standardized KPIs & dashboards Continuously monitor and improve the performance of BI systems and processes. QUALIFICATIONS 2 years of relevant experience Strong understanding of data warehousing and ETL concepts. Experience with SQL and programming languages such as Python, R or similar Experience utilizing BI software for dashboard development (e.g. Spotfire, Tableau, PowerBi, Qlik) with preference towards PowerBI Strong analytical and problem-solving skills. Strong communication and presentation skills. Ability to work independently and collaboratively in a team environment Prior experience utilizing Alteryx a plus but not required Candidates should currently live-in the Greater Cincinnati region EDUCATION REQUREMENTS Bachelor's degree in Computer Science, Information Systems, Mathematics, Finance or a related field DuBois provides equal employment opportunities to all employees and applicants for employment without regard to race, color, ancestry, national origin, gender, sexual orientation, marital status, religion, age, disability, gender identity, gender expression, genetic information, service in the military, veteran status, or any other protected status in accordance with applicable federal, state, and/or local law and/or regulation. Values and Culture Working at DuBois is dynamic, flexible and fun. Our customer centric focus gives you the opportunity to leverage your creative and innovative talents to help deliver specialty chemical solutions safely while protecting the environment. DuBois values: Honest and Ethical Behavior Collaborative Communication Safety at Work and Home Environmental Stewardship Perks and Benefits You will enjoy building your career with DuBois. DuBois offers the stability and comprehensive benefits of a larger organization with the feel of a smaller, more personable company. The diversity of our roles, customers served and large number of manufacturing, distribution and technical centers provide many routes for your career advancement. If you value learning, improving processes and want to make an immediate impact, DuBois is where you want to be. DuBois excellent benefit package includes health insurance, dental insurance, vision insurance, life insurance, 401k with company match, paid holidays, vacation time and income protection plans.