Senior Application Integration Developer

The Sherwin-Williams Company; Cleveland (OH); On-site; USD 110,000 - 140,000; Full time

Job summary

The Sherwin-Williams Company in Cleveland is seeking a skilled Data Engineer to collaborate with analysts, users, and external integrators on designing and delivering complex technical objects within Enterprise applications and integrations.

You will develop end-to-end data integration solutions, evaluate requirements, implement robust web services, and support release updates while adhering to IS standards and best practices in a fast-paced environment near downtown Cleveland.

Qualifications

• Bachelor's degree in CS/CE/IT and 5+ years in software development or data engineering.
• 5 years IT experience.
• 5 years building applications and system integrations.
• 5 years delivering distributed cloud solutions on Azure, AWS, GCP, Snowflake, etc.
• 5 years with ETL/ELT tools (Informatica, Matillion) and cloud services.

Responsibilities

• Collaborate with analysts and users to conceptualize and develop technical integrations.
• Develop, test, deploy, and maintain complex integration objects in Enterprise environments.
• Support Oracle releases and other vendor integrations; ensure IS standards.
• Design data models, web services, and REST APIs for scalable architectures.
• Lead CI/CD with GitHub Actions; manage IaC using Terraform, Docker, and Kubernetes.
• Coordinate with DBAs and infra teams for change control and performance.

Skills

Data integration

ETL/ELT

Python

Spark / Hadoop

SQL Databases

Airflow

CI/CD

Cloud platforms

REST APIs

Docker / Kubernetes

Education

Bachelor's degree in Computer Science, Computer Engineering, Electronics Engineering or Information Technology

Tools

Informatica

Matillion

Databricks

Snowflake

Oracle

Teradata

SQL Server

AWS

Azure

GCP

Job description

Collaborate with business analysts, business users and external systems integrators in conceptualization and development of new technical objects within the applications environment to support current or future Enterprise systems integrations. Perform software development lifecycle activities. Evaluate requirements from functional specifications and create efficient technical integration designs. Analyze, evaluate, and support impact of Oracle release upgrades in existing integrations. Adhere to and support the use of IS standards for code development and code promotion. Analyze and assess existing procedures to allow the application to respond to business changes. Develop complex technical objects in accordance with the technical development standards and best practices. Mitigate significant risks associated with projects, which have a high technical complexity and/or involve significant challenges to the business. Create and resolve Service Requests in collaboration with Oracle Support or third -party vendor integrations. Provide generalized production technical support. Gather business requirements and recommend industry best practices and work with functional knowledge holders. Design, develop, deploy, test, and maintain technical objects that exist in Enterprise Applications environment, e.g., interfaces, system designs and integrations. Design, construction, and support of web services. Create process flows, high level functional and detailed technical design specifications from business requirements. Provide customer support for business-critical application problems and issues. Proactively work through service requests with vendor support as needed. Coordinate work efforts with the DBA and infrastructure teams for application change controls and system performance issues. Partner with business analysts and application super users to successfully complete integration projects. Assist with testing and deployment of Release Update Pack and other module upgrades to keep application release level current. Assist with large scale projects may be required to contribute to efficiency, effectiveness, and success of the work. Conduct research into new technologies, including tools, components, and frameworks. Make presentations to management, clients, and peer groups as requested. Train and share knowledge with development teams. Role is office-based with flexibility to work up to 12 days from home per year within reasonable commuting distance of the Cleveland, OH office. Multiple openings available

Will report to The Sherwin-Williams Company, 100 Public Square, Cleveland, Ohio 44113

This position is not eligible for sponsorship for work authorization now or in the future, including conversion to H1 B visa. Must be legally authorized to work in the country of employment without needing sponsorship for employment work visa status now or in the future

Job duties include contact with other employees and access confidential and proprietary information and/or other items of value, and such access may be supervised or unsupervised. The Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Company’s staff, employees, and business relationships

Must be eighteen years or older

Required Qualifications:

• Bachelor's degree in Computer Science, Computer Engineering, Electronics Engineering or Information Technology field of study and five (5) years of experience as a Software Developer, Technology Consultant, Data Engineer, I.T. Analyst or related role where required experience gained.

• Five (5) years of IT (Information Technology)

• Five (5) years building applications and system integrations

• Five (5) years designing and delivering distributed cloud solutions using any cloud platform including Azure, Snowflake, AWS, GCP and Big data platforms like Databricks

• Five (5) years developing end-to-end data-based integrations solutions using ETL/ELT tools like Informatica, Matillion and Cloud services like AWS Glue, GCP Bigquery, Snowflake Stored procedures or Advanced SQLs;

• Five (5) years hands on experience with different On prem Database like Oracle, Teradata, SQL Server, MySQL, DB2, Sybase Or similar Cloud DBs like AWS RDS, GCP CloudSQL, Azure SQL Database or Oracle Database Cloud Service;

• Two (2) years with Data Orchestration tools like Airflow, AWS Managed Apache Airflow (MWAA), Snaplogic;

• Two (2) years of designing architectures capable of handling large data volumes, leveraging technologies like Hadoop, Spark, and NoSQL databases for scalability and real-time processing;

• Two (2) years with data streaming process like Kafka, Kinesis, Spark Streaming;

• Two (2) years Dev-Ops with Continuous Deployment and Continuous Integration (CI/CD) using GitHub Action and related tools; Data Ingestion and replication using IDMC, Fivetran, and Matillion; Principles, design patterns, application integration architectures; Developing, deploying, and managing Rest APIs using Python, Spark, Databricks; Infrastructure as Code (IaC) tools, like Terraform, Docker and Kubernetes; Cloud iPaaS platforms such as IICS (Informatica Intelligent Cloud Services), Oracle Integration Cloud (OIC); Designing data models, including conceptual, logical, and physical models defining data structures and blueprints for data management; Version control and software configuration management like JIRA and Confluence; Deployment tools including Git, GitHub, Jenkins, or other related tools; Testing, debugging, and diagnosing software bugs and system issues; and Executing data engineering and data conversion projects from small or large as individual or as a team.