Business Intelligence Systems Administrator

At ChemTreat ( we understand and respect the awe-inspiring power of water to impact industries, and to sustain and enhance lives. Our 2,000 associates across North and South America maximize this power for our customers-from power producers to food and beverage companies to the automotive industry. When you join the nation's largest and fastest growing specialty chemical company dedicated solely to industrial water treatment, you'll work side-by-side with those customers, helping them save millions of dollars and grow their businesses, all while protecting people and the environment. Our "whatever-it-takes" mindset allows us to turn our 50 years of experience and innovative thinking into meaningful outcomes for our customers-and rewarding careers for our people. Motivated by the highest possible stakes of climate change and global health, we're working together within a rapidly digitizing industry to find innovative technologies that guarantee the safety of our water and our environment. ChemTreat is proud to be a Water Quality company in Veralto (NYSE: VLTO). Imagine a world where everyone has access to clean water, safe food and medicine, and trusted essential goods. That is the tomorrow Veralto is creating today. Veralto is a $5B global leader in essential technology solutions made up of over 16,000 associates across our Water Quality and Product Identification segments all united by a powerful purpose: Safeguarding the World's Most Vital Resources. About the Role The Business Intelligence (BI) Systems Administrator will play a critical role in ensuring the smooth operation and optimization of BI solutions within the organization. Your expertise lies in managing the technical aspects of BI systems, data integration, maintaining security, leading unit, system, and user acceptance testing efforts, and supporting end-users ESSENTIAL FUNCTIONS & RESPONSIBILITIES Lead the configuration and maintenance of the OneStream platform, including workflows, data sources, transformation rules, business rules, calculations, dashboards, data management sequences, and cube/master data. Collaborate with cross-functional teams to integrate OneStream with other financial systems (such as Hyperion Financial Management (HFM)) and ensure seamless data flow. Intimately knowledgeable about the IT infrastructure and data architecture where solution reside. Ensure that the BI layer operates smoothly on the underlying IT infrastructure. Connect solution to data sources and establish security protocols. Maintain and monitor systems to ensure seamless performance. Lead Unit Testing, System Testing and User Acceptance Testing (UAT) for system enhancements, patches, and upgrades. Collaborate with end-users to validate system functionality, identify, and resolve system issues. Collaborate with data engineers to design and maintain data pipelines, ETL processes, and data transformation workflows. Create and build OneStream applications, cubes, dimensions, and calculation scripts using or C# and SQL. Understand cumulative translation adjustment (CTA) calculations and their impact on financial statements EDUCATION & EXPERIENCE Bachelor's degree in computer science, engineering, mathematics, or related field of study. Master's degree preferred. 3 years of experience as an OneStream administrator or HFM integration 3 years of architectural design and implementation experience in a Data Warehousing & Business Analytics environment (e.g., Data Lakes, Data Marts, BI, including development and implementation, data analysis, and report writing) 3 years of experience with specific technology domain areas (e.g., software development, systems engineering, infrastructure, security, networking, data & analytics) Deep knowledge of DAMA-DMBOK Functional Framework (e.g., data architecture management, etc.) Hands-on experience with SSAS and SSIS is desired Understanding CTA calculations and their impact on financial statements SOX Compliance experience Hands-on experience with HFM integration Advanced knowledge of SQL and programing languages (e.g., Python, Java, PHP) US ONLY: The below range reflects the range of possible compensation for this role at the time of this posting. We may ultimately pay more or less than the posted range. This range may be modified in the future. An associate's position within the salary range will be based on several factors, including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, shift, travel requirements, sales or revenue-based metrics, any collective bargaining agreements, and business or organizational needs. The compensation range for this role is $100,000.00 - $130,000 USD per year. This job is also eligible for Bonus Pay. We offer a comprehensive package of benefits including paid time off, medical/dental/vision insurance and 401(k) to eligible employees. Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company's sole discretion, consistent with the law. US residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information. Veralto Corporation and all Veralto Companies are committed to equal opportunity regardless of race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity, or other characteristics protected by law. We value diversity and the existence of similarities and differences, both visible and not, found in our workforce, workplace and throughout the markets we serve. Our associates, customers and shareholders contribute unique and different perspectives as a result of these diverse attributes. The EEO posters are available here . We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform crucial job functions, and to receive other benefits and privileges of employment. Please contact us at to request accommodation. Unsolicited Assistance We do not accept unsolicited assistance from any headhunters or recruitment firms for any of our job openings. All resumes or profiles submitted by search firms to any employee at any of the Veralto companies, in any form without a valid, signed search agreement in place for the specific position, approved by Talent Acquisition, will be deemed the sole property of Veralto and its companies. No fee will be paid in the event the candidate is hired by Veralto and its companies because of the unsolicited referral.

Created: 2024-10-19