Data Warehouse Architect – REMOTE Jobs in Buffalo, NY at Hach
Title: Data Warehouse Architect – REMOTE
Location: Buffalo, NY
This is a remote position that can be located anywhere in the US or Canada. Several locations have been listed for marketing purposes only – there is only one position available.Our work at Hach ensures water quality for people around the world. Our customer partnerships, passionate experts, and reliable, easy-to-use solutions make water analysis better—faster, simpler, greener, and more informative. As a member of our team, you’ll get to make an immediate, measurable impact on a global scale, within industries from aviation to manufacturing to mining. You’ll also be part of an environment that fosters career growth and professional development, with kindness at its core. And you’ll be part of our mission, which drives us to develop water quality solutions that protect the health and safety of all living things.
Hach is proud to be one of Danaher’s Water Quality companies. 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.
You will report into the Senior Manager for Data Architecture & Warehouse, and serve as a key member of the senior technical staff defining and executing the corporate strategy around leveraging data as an asset.
Job Summary:We are growing and opening a NEW role for a Data Warehouse Architect (DWA) to serve Hach’s current and future data needs with focus on designing, implementing, and continuously improving Data Warehouse architecture, models, and data pipelines.
Our current data warehouse is implemented in an Azure environment in SQL server databases. It follows best practices from Inmon, Kimball, and Linstedt methodologies. We also plan to implement a Gen 2 Azure data lake to store non-structured and IoT data, a Knowledge Graph, and sophisticated analytics pipelines. We implement forward and reverse ELT processes, and fine-grained access control for delivery of data to multiple applications in multi-mode formats and channels. Data sets are exposed to consuming applications through subject focused data marts.
Define, design, and implement Data Warehouse (DW) architecture, logic, and physical implementation. DW has architecture and infrastructure to ingest, curate, and deliver structured and non-structured data at scale in relational and non-relational databases.
Facilitate VOC sessions with stakeholders of diverse professional backgrounds, reviewing source system layouts and schemas, analyzing, and discussing business and technical requirements, creating roadmaps, and delivering solutions that meet customer’s information needs.
Instrumental in the definition, documentation, and development of mapping rules for movement of data from disparate data sources and into the various components and subject areas
Create data models including robust metadata, entity-relationship-attribute models, as well as relational, dimensional, and graph models.
Work closely with DBAs to transition logical models to physical implementation of data structures in SQL and No-SQL data bases.
Master’s degree in Information Systems, Computer Science, or equivalent education and/or experience.
Five or more years of experience in designing and delivering enterprise Data Warehousing solutions/ Lakehouse initiatives
Five or more years of experience with Relational and Dimensional Modeling as well as structurin…