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 .
Follow us on Twitter , Facebook at , LinkedIn at or Instagram at .
Benefits
Ecolab strives to provide comprehensive and market-competitive benefits to meet the needs of our associates and their families. 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.
Our Commitment to Diversity and Inclusion
At Ecolab, we believe the best teams are diverse and inclusive, and we are on a journey to create a workplace where every associate can grow and achieve their best. We are committed to fair and equal treatment of associates and applicants. We recruit, hire, promote, transfer and provide opportunities for advancement on the basis of individual qualifications and job performance. In all matters affecting employment, compensation, benefits, working conditions, and opportunities for advancement, we will not discriminate against any associate or applicant for employment because of race, religion, color, creed, national origin, citizenship status, sex, sexual orientation, gender identity and expressions, genetic information, marital status, age, disability, or status as a covered veteran.

In addition, we are committed to furthering the principles of Equal Employment Opportunity (EEO) through Affirmative Action (AA). Our goal is to fully utilize minority, female, disabled and covered veteran individuals at all levels of the workforce. Ecolab is a place where you can grow your career, own your future and impact what matters.

We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance and the San Francisco Fair Chance Ordinance.