Senior Data Integrations Engineer
About The Position
The Senior Data Integrations Engineer designs, builds, and maintains systems and infrastructure used to collect, store, process, integrate, and analyze data. The role works closely with data scientists, analysts, QA engineers, business process and functional subject matter experts, clients, and other stakeholders to provide accessible, reliable, and secure data. It covers data ingestion, transformation, integration, pipeline development, data governance, and software development and deployment of IT operations to shorten delivery timelines for data products, pipelines, and data warehousing. The position provides technical leadership to data engineers and acts as a technical point of contact for clients and stakeholders. It is based at Sherwin-Williams’ Cleveland Headquarters office and is not hybrid or remote. The role is not eligible for work authorization sponsorship, now or in the future. The job entails access to confidential and proprietary information; the company states that a criminal history review is necessary to protect its business, operations, reputation, staff, and business relationships.
Requirements
- Bachelor’s degree in Computer Science, Computer Engineering, or Information Technology, or at least 7 years of data engineering experience in lieu of a degree.
- 4–6+ years of data engineering experience.
- 2–4 years of SQL experience, including PostgreSQL, T-SQL, PL/SQL, or SNOWSQL.
- 2–4+ years of experience building applications, system integrations, and web services.
- 2–4+ years of server-side scripting and programming in a Linux environment, primarily bash shell.
- Advanced understanding of common database technologies, including Oracle and Snowflake, with performance, tuning, and optimization.
- Advanced data manipulation skills and experience with on-premises and cloud-based data warehouse ETL tools and processes.
- Basic understanding of business processes such as OTC, P2P, and PIM to understand data usage context.
- Technical skills in data security, automated testing tools, version control tools, and data modeling.
Nice To Haves
- 5+ years of experience with both cloud-based and on-premises OLTP database applications, such as MariaDB/MySQL and Oracle 19c+.
- Experience supporting microservices applications by building data processes, designing data structures, performance tuning, supporting data transformations and syncing, managing metadata and dependencies, and handling workload management.
- Experience with CI/CD pipelines and workflows, including data/SQL script management tools such as Liquibase.
Responsibilities
- Partner with a team of data engineers, providing technical guidance, mentorship, and support.
- Act as a technical point of contact for clients and stakeholders, providing updates and addressing data-related technical inquiries or concerns.
- Design, develop, and maintain efficient, robust data pipelines, ETL processes, and data workflows.
- Develop and maintain data models and schema designs to support data storage and retrieval needs.
- Optimize data storage, processing, and retrieval mechanisms for performance and scalability.
- Provide technical leadership and guidance in selecting and implementing data engineering tools and technologies.
- Identify and implement best practices and standards for data engineering processes and tools.
- Stay current with emerging data engineering technologies and trends and evaluate their potential impact on the data infrastructure.
- Collaborate with cross-functional teams to integrate data sources and enable seamless data flow across systems.
- Work with data scientists, analysts, and stakeholders to understand data requirements and develop scalable data solutions.
- Implement and maintain data governance and security measures to protect sensitive information.
- Ensure data quality and integrity through effective data validation and cleansing techniques.
Benefits
- The company describes a range of benefits related to retirement, health care, total well-being, and commuting; specific offerings and eligibility are available through its candidate benefits information.
- Opportunities to learn, develop new skills, and grow career contributions.
- An inclusive team and commitment to employees’ and broader communities’ connection.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
