Data Integration Engineer

About the job:

The Red Hat Salesforce PRM (Partner Relationship Management) team is looking for a Data Integration Engineer. In this role, you will have responsibility for designing and building data pipelines to extract, transform, and load data from various sources into data warehouses, Salesforce, or other storage solutions, while optimizing processes for efficiency and reliability. You should have the ability to understand the needs of the business and translate them into technical solutions within the context of the desired system architecture, focused on efficiency, accuracy, and scalability. You’ll work as part of a scrum team to complete integration development work, as well as define end-to-end process implementation strategies.

What will you do?

• Work with Product Management to understand data-related business processes and requirements

• Understand the system architecture documented by the Enterprise Architecture team and design solutions that align with it

• Be responsible for the design and development of data pipelines

• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests and wants from the underlying, true business needs

• Understand the Salesforce data model

• Ensure solutions are portable so they can be promoted to additional environments, including production, by an automated deployment pipeline

• Meet team standards for solution design, code, configuration, testing, and quality

• Participate in peer reviews to provide and receive constructive feedback

• Work as part of a scrum team as well as on your own with minimal supervision

• Work with other technical teams to build integrated solutions

• Support and troubleshoot integration issues

What will you bring?

• 8+ years of data integration design and development experience

• High-level of proficiency in developing complex SQL

• Extensive experience in working with relational databases

• Proficiency in developing using Informatica SaaS for ETL and for automated data movement / integration

• Expertise with Python development

• Experience working with integrations with Salesforce

• Bachelor’s degree

• Ability to design solutions, break large solutions down into parts, and support the delivery of those solutions by other developers

• Ability to understand data “beyond the code” and its relevance to key business processes

• Ability to understand and troubleshoot implemented code

• Ability to understand an implemented architecture and deliver on technical specifications

• Ability to accurately scope, plan, and estimate the level of effort for tasks, with an appropriate balance of risk and effort

• Ability to work on your own and manage multiple-task assignments

• Outstanding written and verbal communication skills, including presentation skills

• Excellent problem-solving and troubleshooting skills with the ability to exercise mature judgment

The following are considered a plus:

• Experience with Salesforce CPQ, Loyalty Management, Rebates Management

• Experience with the deployment of Salesforce metadata using the Salesforce Command Line Interface (CLI)

• Experience with DBT is preferred

• Experience with FiveTran is preferred

• Experience with Starburst and Snowflake is preferred

• Experience with CI/CD and automated data schema deployments is preferred

• Experience with at least one of the following Source Code Management (SCM) technologies or similar: GitHub, GitLab, Bitbucket, git

• Experience with DevOps automation using one of the following or equivalent: GitHub Actions, Azure DevOps, Jenkins

• Advanced degree in the area of specialization

About Red Hat

Red Hat is the world’s leading provider of enterprise open source software solutions, using a community-powered approach to deliver high-performing Linux, cloud, container, and Kubernetes technologies. Spread across 40+ countries, our associates work flexibly across work environments, from in-office, to office-flex, to fully remote, depending on the requirements of their role. Red Hatters are encouraged to bring their best ideas, no matter their title or tenure. We're a leader in open source because of our open and inclusive environment. We hire creative, passionate people ready to contribute their ideas, help solve complex problems, and make an impact.

Diversity, Equity & Inclusion at Red Hat
Red Hat’s culture is built on the open source principles of transparency, collaboration, and inclusion, where the best ideas can come from anywhere and anyone. When this is realized, it empowers people from diverse backgrounds, perspectives, and experiences to come together to share ideas, challenge the status quo, and drive innovation. Our aspiration is that everyone experiences this culture with equal opportunity and access, and that all voices are not only heard but also celebrated. We hope you will join our celebration, and we welcome and encourage applicants from all the beautiful dimensions of diversity that compose our global village.

Equal Opportunity Policy (EEO)
Red Hat is proud to be an equal opportunity workplace and an affirmative action employer. We review applications for employment without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, ancestry, citizenship, age, veteran status, genetic information, physical or mental disability, medical condition, marital status, or any other basis prohibited by law.

Red Hat does not seek or accept unsolicited resumes or CVs from recruitment agencies. We are not responsible for, and will not pay, any fees, commissions, or any other payment related to unsolicited resumes or CVs except as required in a written contract between Red Hat and the recruitment agency or party requesting payment of a fee.
Red Hat supports individuals with disabilities and provides reasonable accommodations to job applicants. If you need assistance completing our online job application, email [email protected]. General inquiries, such as those regarding the status of a job application, will not receive a reply.