Data Warehouse & Business Intelligence Developer in Nationwide Colombia at ChemTreat

Date Posted: 7/12/2018

Job Snapshot

Job Description

Job ID: CHE001617

About Us

ChemTreat operates as a subsidiary of Danaher Corporation, one of the best performing Fortune 500 companies. Our proprietary solutions allow our customers to reduce water, chemical, and energy costs, extend asset life, improve process operations, and reduce downtime. We have expertise in a variety of industries, including automotive, beverage, chemical, food, fuel processing, metals, mining, power, pulp and paper, and textile. We also serve commercial and institutional customers, including data centers, district energy providers, universities, government buildings, and hospitals. Our company has developed a robust product portfolio for the prevention of corrosion; scale and biofouling in critical heat transfer systems and advanced polymers for industrial wastewater.


In this role, the Data Warehouse & Business Intelligence Developer (DW&BI) Developer is responsible for the development, implementation, and administration of reporting and analytics solutions for the company by documenting requirements, identifying and understanding appropriate data sources, developing and implementing data warehouse schemas (star schemas), developing BI reports and dashboards, data cubes, and security mechanisms.  

DW&BI Developer will design and implement software and systems that provide timely, accurate, and meaningful enterprise data to key users and decision makers in the company so they can effectively analyze business patterns and trends and make informed decisions.

High-level of technical competence around Data Warehousing, Business Intelligence, and Visualization.

Versed on traditional BI development lifecycle from requirements gathering, data modeling, reporting, dashboard design, KPI and scorecards development, through testing, validation, and production implementation. They should have demonstrated experience with one or more BI applications synthesizing meaningful information from large varied data sets.

Excellent analytic skills.

Ability to capture relevant information from conversations with stakeholders or identify gaps independently; and ability to break down complex problems into discrete steps and/or the concrete tasks necessary to solve them.

Business acumen.

Ability to obtain essential information about a situation, focus on the key objectives, recognize the feasible options, recommend an appropriate course of action and set in motion an agreed upon implementation plan to execute the solution that includes buy-in from stakeholders.

Candidate must take initiative.

They seek innovative solutions to business problems and consults proactively and with urgency to address them. When faced with a challenge or opportunity, they take ownership and do what it takes to deliver what is needed for the business while following corporate policies and codes of conduct.

Customer focused.

They take a personal interest in, and have a passion for meeting the internal customers’ business needs. This means being fully available to the customer and becoming the advocate of customer issues within the organization.

Strong communication and interpersonal skills.

They initiate and maintain partnerships within the business as well as their peer group within IT, building trust and cooperating to get to solutions efficiently and effectively. When interacting, they practice effective listening, speaking, and writing skills, clearly articulating the needs of the business and defined solutions.

Ability to thrive in an environment of continuous change, always identifying opportunities and selling their ideas.

Able to have constructive and sometimes difficult discussions with internal customers and vendors. Accepts constructive criticism freely without becoming discouraged.

Must have project management skills.

They understand how to effectively setup and manage projects and assignments.  Develop detailed project requests including detailed project objectives, success criteria, and requirements. Present project requests to supervisor and represent business partners in the project portfolio prioritization process.

Candidate must be a teacher and evangelist for advanced uses of information, and a continuous learner.


Applies data warehousing and BI leading industry practices to successfully design, build and implement solutions to meet the needs of the business.

Develops data warehouse structures (e.g. star schemas, OLAP cubes, etc.), ETL processes, and performs DBA operations.

Develop and implement BI solutions (e.g. Interactive reports, visualizations, dashboards, scorecards, standard and ad-hoc reports, etc.) that support a variety of business operations.

Assist in the design of databases and data warehouses to ensure interoperability with BI solutions and integration with other analytical and transactional systems.

Review database architectures and designs to ensure compliance with corporate objectives for data integrity, quality, performance, management, scalability, reliability, and security.

Develop quality control measures, testing measures, and the accuracy of data standards and consistency to support deployment of solutions for the businesses and IT.

Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.

Other duties and responsibilities as assigned by supervisor

Job Requirements


Knowledge, Skills and Experience:

Four-year degree in Information Science, Computer Science or equivalent. Master’s degree preferred.
Effective business communication and presentation skills.
Strong analytical, problem-solving and metadata skills.
Five years of Data Warehousing, Data Marts, and Business Intelligence (BI), including DW/BI development and implementation, data analysis, report writing, software development experience.
Experience in Microsoft environments (e.g. D365, Power BI, SQL, SSRS, SSAS, SSIS, etc.)
Work history of successful software design and utilization of latest technologies in Microsoft Azure, Visual Studio, SQL Server Business Intelligence Studio; Microsoft’s SQL server and Windows Server environment.
Advance knowledge of SQL and scripting languages like Python, R, etc.
Experience with Erwin.
Experience with JDEdwards
Experience with Master Data Management, Data Governance, and Data Integration.
Experience with Business Intelligence tools ideally within the Microsoft stack (Power BI), Tableau, and Jet Reports.
Extensive experience of OLTP and OLAP development and implementation.
Experience with data integration platforms (e.g. Talend or Dell Boomi), and Java are a plus.
Experience or exposure to IIoT and big data implementations a plus.
EPICS or ITIL certification is a plus.
Bilingual in English and Spanish. Portuguese a plus
Up to 10% travel.

Danaher Corporation Overview

Danaher is a global science & technology innovator committed to helping our customers solve complex challenges and improve quality of life worldwide. Our world class brands are leaders in some of the most demanding and attractive industries, including life sciences, medical diagnostics, dental, environmental and applied solutions. Our globally diverse team of 62,000 associates is united by a common culture and operating system, the Danaher Business System, which serves as our competitive advantage. We generated $16.9B in revenue last year. We are ranked #133 on the Fortune 500 and our stock has outperformed the S&P 500 by more than 1,300% over 20 years.
At Danaher, you can build a career in a way no other company can duplicate. Our brands allow us to offer dynamic careers across multiple industries. We’re innovative, fast-paced, results-oriented, and we win. We need talented people to keep winning. Here you’ll learn how DBS is used to shape strategy, focus execution, align our people, and create value for customers and shareholders. Come join our winning team.


  1. Business Analyst Jobs
  2. Data Analyst Jobs