Business Intelligence Developer
About The Position
Imagine yourself… Growing your expertise and expanding your skillset with every project. Thriving in a supportive team environment that inspires you to strive for excellence. Joining a company with a proven track record of success and an exciting future. It’s possible with a role at ChemTreat. ChemTreat, a Veralto company, is the nation’s largest and fastest-growing specialty chemical company dedicated solely to industrial water treatment. 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- helping them grow their businesses while protecting people and the environment. When you join the ChemTreat team and the broader Veralto network, you’ll have the chance to shape the future of our planet and the future of your career. You’ll have opportunities to build new skills and invest in your development, all while doing meaningful work that makes an everyday impact on the world’s vital water resources. Learn more about how our team is maximizing the power of water: https://wi.st/3vH5OUK Reporting to the Data Warehousing and Business Intelligence Manager, The Business Intelligence (BI) Developer plays a critical role in designing, developing, and implementing business intelligence solutions that enable ChemTreat to make data-driven decisions. This position is responsible for delivering timely, accurate, and actionable insights to key stakeholders across the organization, empowering them to identify business trends, optimize performance, and drive strategic initiatives.
Requirements
- Understand Data Warehousing concepts and best practices
- Ability to translate business needs into technical specifications
- Ability to explain technical concepts to non-technical stakeholders
- Experience with Power Platform (e.g., Power BI, Power Automate, Power App), DAX and API-based connectors in BI tools
- Ability to transform data using Power Query (M language)
- Ability to write and troubleshoot complex queries, optimize performance, and work with relational databases (e.g., Snowflake, SQL Server, Oracle, MySQL)
- Understanding of data modeling concepts (e.g., ERD)
- Experience with data extraction, transformation, and loading using tools like SSIS, Azure Data Factory, or similar
- API knowledge (e.g. RESTful APIs, JSON data retrieval, API call best practices)
- Understanding of cloud-based data solutions (e.g., Azure, AWS, Snowflake)
- Familiarity with languages such as Python or R for data manipulation and advanced analytics
- General understanding of AI/ML concepts (e.g., supervised vs. unsupervised learning, model evaluation, and generative AI fundamentals) and how they can support analytics and decision-making
- Experience with Power BI RBAC (static and dynamic RLS to restrict data visibility based on user roles) and Object level security (OLS)
- Strong analytical and problem-solving skills
- Effective business communication and presentation skills
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Statistics or a related certification
- 2+ years of Information Technology experience
- 2+ years of experience in a Data Warehousing environment
- 2+ years of Power BI experience
Nice To Haves
- 1+ years of SSIS and Snowflake experience, preferred
- 1+ years of experience with Python or R for data manipulation and advanced analytics, preferred
Responsibilities
- Partner with business stakeholders to understand reporting needs
- Translating business requirements into technical specifications
- Build and maintain dashboards, reports, and data visualizations using BI tools (e.g., Power BI), inclusive of prototypes
- Create and optimize data models to support reporting and analytics
- Ensure data integrity, accuracy, and consistency across systems
- Write and optimize SQL queries for data extraction and transformation
- Work with relational and cloud-based databases (e.g., SQL Server, Snowflake, Azure)
- Monitor and improve BI solution performance
- Implement best practices for query optimization and data processing
- Ensure compliance with data security and privacy standards
- Implement role-based access and permissions for BI tools
- Conduct unit and integration testing for BI solutions
- Maintain documentation for dashboards, data models, and processes
- Support Extract, Transform, Load (ETL) processes for data integration from multiple sources
- Stay updated on BI trends and emerging technologies
- Recommend enhancements to improve analytics capabilities
- Support self-service BI initiatives for business users
Benefits
- We offer a comprehensive package of benefits including paid time off, medical/dental/vision insurance and 401(k) to eligible employees.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
501-1,000 employees
