Note: The job is a remote job and is open to candidates in USA. Core & Main is a leader in advancing reliable infrastructure with local service nationwide. They are seeking a Data Engineer II to design, build, test, and maintain integration solutions, APIs, and data flows that connect enterprise applications and external partners, working independently on moderately complex tasks.
Responsibilities
- Design, develop, and maintain production-ready APIs and integration flows across cloud, on-premises, and third-party platforms
- Implement scalable integration patterns, including synchronous, asynchronous, batch, and event-driven processing
- Collaborate with business and technical stakeholders to understand integration and data requirements and translate them into effective technical solutions
- Build reusable integration components and services aligned with enterprise architecture, security, and development standards
- Perform unit testing and support QA, regression, and user acceptance testing for integration solutions
- Troubleshoot, debug, and resolve integration failures, data flow issues, performance bottlenecks, and production defects
- Contribute to technical documentation, including solution designs, interface specifications, data mappings, and operational runbooks
- Participate in peer code reviews and apply feedback to improve code quality, reliability, and maintainability
- Support enhancements, patches, upgrades, and operational administration activities across integration and related data platforms
Skills
- Design, build, test, and maintain reliable integration solutions, APIs, and data flows that connect enterprise applications, data platforms, and external partners
- Own end-to-end integration components and work independently on moderately complex integration and engineering tasks
- Partner with senior engineers, architects, product teams, and business stakeholders to deliver high-quality, scalable, and well-documented solutions
- Design, develop, and maintain production-ready APIs and integration flows across cloud, on-premises, and third-party platforms
- Implement scalable integration patterns, including synchronous, asynchronous, batch, and event-driven processing
- Collaborate with business and technical stakeholders to understand integration and data requirements and translate them into effective technical solutions
- Build reusable integration components and services aligned with enterprise architecture, security, and development standards
- Perform unit testing and support QA, regression, and user acceptance testing for integration solutions
- Troubleshoot, debug, and resolve integration failures, data flow issues, performance bottlenecks, and production defects
- Contribute to technical documentation, including solution designs, interface specifications, data mappings, and operational runbooks
- Participate in peer code reviews and apply feedback to improve code quality, reliability, and maintainability
- Support enhancements, patches, upgrades, and operational administration activities across integration and related data platforms
- Bachelor's degree in Computer Science, Information Technology, or related field
- Typically requires BS/BA in a related discipline
- Generally, 3-5 years of experience in a related field; certification is required in some areas OR MS/MA and generally 2+ years of experience in a related field
- Applies established problem-solving skills to moderately complex situations
- Identifies root causes for common and recurring data issues and escalates more complex or ambiguous problems appropriately
- Troubleshoots and resolves issues within defined data pipelines, systems, or domains, using documented patterns and guidance from senior team members
- Performs assignments with moderate independence, operating within established practices and architectural standards
- Determines appropriate approaches to solutions for well-defined problems
- Receives regular technical guidance on complex problems, design decisions, or unfamiliar technologies
- Works closely with other engineers, analysts, and business partners to deliver reliable, high-quality data solutions
- Actively participates in knowledge sharing, documentation, and peer reviews
- May provide informal guidance to less experienced engineers but does not have formal leadership or people management responsibilities
- 3-5 years of hands-on experience in integration development or API engineering
- Experience developing and supporting integrations using MuleSoft or comparable middleware/iPaaS platforms
- Strong understanding of REST, SOAP, JSON, XML, and common API and integration design patterns
- Experience building event-driven integrations (Kafka, RabbitMQ, Azure Service Bus, etc.)
- Proficiency in SQL and experience working with relational databases
- Experience with Java, JavaScript, Python, or similar programming and scripting languages
- Familiarity with API testing and troubleshooting tools such as Postman, JMeter, or similar technologies
- Hands-on experience with version control and CI/CD practices using Git and platforms such as Azure DevOps, GitHub, or GitLab
- Understanding of integration security concepts and protocols, including OAuth2, JWT, SSL/TLS, and SAML
- Familiarity with enterprise applications and data domains, including ERP platforms and/or master data, is a plus
- Excellent problem-solving skills and ability to learn new integration platforms quickly
- Strong communication skills with the ability to translate complex technical concepts into business-friendly language
Company Overview
Core & Main is a specialized distributor that provides water, storm drainage, and fire protection products and solutions. It is a sub-organization of Putnam Pipe. It was founded in 2017, and is headquartered in St Louis, Missouri, USA, with a workforce of 1001-5000 employees. Its website is https://coreandmain.com/.