Analytics Architect

The Analytics Architect will work as member of the Commercial Digital Solutions Analytics team. This position with work with the latest cloud-based and on-premises Microsoft BI/DW solutions. This position is hands-on (does development) and provides technical leadership that will enhance the capabilities of the data warehouse environments used by our customers, field organization and back-office associates. This position works closely with the business and the rest of the commercial digital solutions team to deliver value through Business Intelligence and analytics.

This position is based in St. Paul, MN as a hybrid work schedule

What You Will Do:

• Architect, design, build, implement, and maintain solutions to meet global business needs for the data warehouse and data mart environments using the primarily Microsoft BI/DW stack

• Works with the Principal architect, BI director, data scientists, and the business to define the architecture and strategy for BI/DW across the analytics environment

• Provides technical direction to ETL developers, BI developers, and application developers to architect, design, and implement solutions

• Stays current on the technology, tools, and approaches in the BI/DW/Analytics/cloud space

• Solves complex problems and develops proofs of concept to validate ideas or technologies

• Works on multiple initiatives simultaneously

• Creates and owns best practice standards and templates

• Helps support the system and troubleshoots system related issues

Minimum Qualifications:

• Bachelor's and/or Master's degree in Information Technology

• 8 years of experience in Information Technology

• 5 years of experience architecting, designing, and developing BI/Data Warehouse solutions using the Microsoft BI/DW stack (e.g. Power BI, SSRS/Paginated reports, Fabric, SQL Server 2016+ , ADF, SSAS tabular, Azure)

• 3 years of experience Familiar with modern large data platforms, like Snowflake, MS Fabric etc.

• 5 years of experience working with SQL, SQL stored procedures, Change data capture, data extracts, APIs, and relational/multidimensional databases

• 5 years of experience with data architecture/design in data warehouse and transactional environments

• 5 years of experience working with BI tool architectures, functions, and features

• 3 years of experience with Azure cloud development

• Visa sponsorship is not provided for this opportunity

Preferred Qualifications:

• Proven ability to quickly learn new technologies

• Knowledge of service data and service-based businesses

• Experience with agile methodologies

• Strong problem-solving orientation

• Can manage multiple competing tasks/projects at the same time

• Strong team and customer service focus

A trusted partner at nearly three million customer locations, Ecolab (ECL) is the global leader in water, hygiene and energy technologies and services that protect people and vital resources. With annual sales of $15 billion and 49,000 associates, Ecolab delivers comprehensive solutions, data-driven insights and on-site service to promote safe food, maintain clean environments, optimize water and energy use, and improve operational efficiencies for customers in the food, healthcare, energy, hospitality and industrial markets in more than 170 countries around the world. For more Ecolab news and information, visit www.ecolab.com.

Follow us on Twitter @ecolab, Facebook at facebook.com/ecolab, LinkedIn at Ecolab or Instagram at Ecolab Inc.

Benefits

Ecolab strives to provide comprehensive and market-competitive benefits to meet the needs of our associates and their families. Click here to see our benefits.

If you are viewing this posting on a site other than our Ecolab Career website, view our benefits at jobs.ecolab.com/working-here.

Covid-19 Vaccine Notice

Due to local mandates and customer requirements, applicants for certain customer-facing positions must be fully vaccinated (which in some situations requires a booster if eligible), unless a religious or medical accommodation is requested by the applicant and approved by Ecolab.

Americans with Disabilities Act (ADA)

Ecolab will provide reasonable accommodation (such as a qualified sign language interpreter or other personal assistance) with our application process upon request as required to comply with applicable laws. If you have a disability and require accommodation assistance in this application process, please visit the Recruiting Support link in the footer of each page of our career website.