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 enterpriseopen 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.