Core & Main logo

Solutions Architect

Core & Main

Full Time
Senior
13 days ago

Job Description

About the Role

Based in St. Louis, Core & Main is a leader in advancing reliable infrastructure™ with local service, nationwide®. As a specialty distributor focusing on water, wastewater, storm drainage, and fire protection products and related services, the company provides solutions to municipalities, private water companies, and professional contractors across municipal, non-residential, and residential end markets nationwide. With over 370 locations across the U.S., Core & Main offers local expertise backed by a national supply chain. The company’s 5,700 associates are committed to helping communities thrive with safe and reliable infrastructure. The Solutions Architect role involves partnering with business analysts and engineers to analyze, translate, and design technical architectures that support current and future business applications.

Key Responsibilities

  • Assist in defining and designing the systems and applications architecture for both current and future business applications.
  • Partner with infrastructure, application, and quality teams to ensure applications meet business requirements, are well documented, and have support and maintenance processes in place.
  • Drive standard and efficient applications and infrastructure design by aligning the infrastructure roadmap with the application technology strategy, hardware vendor roadmaps, and service capabilities.
  • Assist in identifying emerging technologies that could positively impact the organization and evaluate their strategic fit.
  • Contribute to technology strategy through consulting support, requirements gathering, collection of deployment plans, and synthesis of business goals and operating strategies.

Requirements

  • Typically requires a BS/BA in a related discipline.
  • Minimum of 6 years of deep technical experience.
  • 5+ years of experience in a related field.
  • Experience with design and implementation of high availability applications infrastructure on various computing platforms.
  • Experience implementing new technologies, converting technologies, and technology management.
  • Strong experience in design and deployment of solutions using architectural principles, standards, and frameworks.
  • 7+ years of hands-on development experience in SQL and/or Python for data warehouse management, data integration, and data lake management.
  • Deep knowledge of SQL development, including designing, implementing, and optimizing complex database objects.
  • Experience working with Azure data architecture, building data pipelines on cloud-based platforms, and familiarity with Delta Lakehouse Medallion architecture and data warehousing solutions.
  • Exposure to Spark-based data platforms like Databricks or Microsoft Fabric for data engineering, analytics, and machine learning workflows.
  • Understanding of ELT vs ETL and building efficient data pipelines with modern Change Data Capture processes.
  • Hands-on experience with CI/CD pipelines in Azure DevOps and familiarity with Agile methodologies.
  • Familiarity with data mapping and transformation techniques for Dynamics 365 Data Entities and Data Management Framework.
  • Knowledge of Power BI and its integration with Microsoft Fabric for analytics.
  • Proven ability to lead technical teams, mentor junior engineers, and collaborate with stakeholders.
  • Strong communication skills to translate complex technical concepts into business language.
  • Proficiency in managing the ML lifecycle using Azure ML and/or Databricks MLflow, including model training, tracking, deployment, and monitoring.

Nice to Have

  • Experience with design and implementation of high availability applications infrastructure on a wide variety of computing platforms.
  • Previous experience implementing and managing new technologies and converting existing technologies.

Qualifications

  • BS/BA in a related discipline.

Working at Core & Main

Core & Main is an Equal Employment Opportunity employer. Employment is based solely on merit and qualifications related to professional competence. The company does not discriminate based on race, creed, color, religion, national origin, age, disability, veteran status, gender identity, sexual orientation, marital status, or other protected characteristics. The organization values diversity and inclusion, emphasizing merit-based hiring and equal opportunity.

Apply Now

Job Details

Posted AtJul 11, 2025
SalaryCompetitive salary
Job TypeFull Time
ExperienceSenior

Job Skills

AI Insights

Key skills identified from this job posting

Sign upto access all insights for this job

About Core & Main

Website

coreandmain.com

Industry

Plumbing and Heating Equipment and Supplies (Hydronics) Merchant Wholesalers

Get job alerts

Set up personalized alerts for your job search and get tailored job digests for close matches