Solutions Architect

Based in St. Louis, Core & Main is a leader in advancing reliable infrastructure with local service, nationwide. As a specialty distributor with a focus on water, wastewater, storm drainage and fire protection products and related services, Core & Main 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., the company provides its customers local expertise backed by a national supply chain. Core & Main's 5,700 associates are committed to helping their communities thrive with safe and reliable infrastructure. Visit coreandmain.com to learn more.

Job Summary

Technical expert who partners with business analysts and engineers in requirements gathering and reviews. Responsible for analyzing and translating business information and technical requirements into an architectural blueprint.

Major Tasks, Responsibilities and Key Accountabilities

• Assists in defining and designing the systems and applications architecture for both current and future business applications.
• Partners with infrastructure, application, and quality teams to ensure that applications meet business requirements, are well documented, and have processes in place for ongoing support and maintenance.
• Drives standard and efficient applications and infrastructure design by aligning the infrastructure roadmap with the application technology strategy, hardware vendor roadmaps, and service capabilities.
• Assists in identification of emerging technologies that could have a positive impact on the organization; helps evaluate strategic fit.
• Contributes to technology strategy through consulting support: driving requirements gathering, collection of existing deployment plans, synthesis of business goals, and operating strategies.

Typical Training/Experience

• Typically requires BS/BA in a related discipline.
• Minimum of 6 years of deep technical experience.
• 5+ years of experience in a related field.

Preferred Qualifications

• Experience with design and implementation of high availability applications infrastructure on a wide variety of computing platforms.
• Previous experience implementing new technologies, converting technologies, and technology management.
• Strong experience and demonstrated success in design and deployment of solutions required.
• Apply architectural principles, guidelines, standards, reference architecture, patterns, and frameworks to deliver consistent views in support of technology strategy and portfolios.
• 7+ years of hands-on development experience in SQL and/or Python for data warehouse management, data integration, and data lake management.
• Deep working knowledge in SQL development using T-SQL code to design, implement, and optimize complex database objects, such as tables, views, stored procedures, indexes, and functions.
• Experience working with Azure data architecture, including a solid understanding of tools for building data pipelines on cloud-based data platforms, such as Delta Lakehouse Medallion architecture and data warehousing solutions.
• Exposure to modern Spark based data platforms like Databricks or Microsoft Fabric for data engineering tasks, including leveraging their capabilities for scalable data processing, analytics, and machine learning workflows in a cloud-based environment.
• Understanding of ELT vs ETL and how to build efficient data pipelines with modern Change Data Capture processes.
• Hands-on experience with CI/CD pipelines in Azure DevOps and understanding of Agile development methodologies.
• Familiarity with common data mapping and transformation techniques for Dynamics 365 Data Entities and Data Management Framework for the Finance and Operations modules.
• Familiarity with Power BI and its integration with Microsoft Fabric for end-to-end analytics.
• Proven ability to lead technical teams, mentor junior engineers, and collaborate with cross-functional stakeholders.
• Strong communication skills with the ability to translate complex technical concepts into business-friendly language.
• Proficiency in managing the ML lifecycle using Azure ML and/or Databricks MLflow, including model training, tracking, deployment, and monitoring.

Core & Main is an Equal Employment Opportunity employer. Employment at Core & Main is based solely on a person's merit and qualifications directly related to professional competence. Core & Main does not discriminate against any employee or applicant on the basis of race, creed, color, religion, national origin, nationality, ancestry, age, disability, veteran status, pregnancy or related condition (including breastfeeding), affectional or sexual orientation, gender identity or expression, marital status, status with regard to public assistance, citizenship, or any other basis protected by law.

None of the questions in this application are intended to elicit information regarding any protected characteristics, nor imply any limitation, illegal preferences or discrimination based upon non-job-related information or protected characteristics.

For more information, please click here or visit https://www.eeoc.gov