Red Hat Data Engineer in Raleigh, North Carolina

Company description

At Red Hat, we connect an innovative community of customers, partners, and contributors to deliver an open source stack of trusted, high-performing solutions. We offer cloud, Linux, middleware, storage, and virtualization technologies, together with award-winning global customer support, consulting, and implementation services. Red Hat is a rapidly growing company supporting more than 90% of Fortune 500 companies.

Job summary

The Red Hat Marketing Operations team is looking for a Data Engineer to join us in Raleigh, NC. In this role, you will work with data analysts and business analysts to build, deploy, and maintain scalable technology solutions that ensure accurate and reliable data for input into campaign planning and realization, lead generation, and segmentation. You’ll need to stay up to date on industry and technology trends, write detailed technical documentation, troubleshoot issues, and continuously enhance our marketing infrastructure. As a Data Engineer, you will be working in a fast-paced environment, managing multiple projects at once, which will involve stakeholders from across the company. You’ll need to be someone who enjoys designing software and database solutions that allow for flexibility in business process. You’ll rapidly and iteratively develop solutions, but you’ll always need to keep the long term in mind.

Primary job responsibilities

  • Write and validate complex SQL queries and ETL packages

  • Apply your expertise in writing scripts in data visualization tools like Tableau, Qlik Sense , etc.

  • Identify and adopt best practices in reporting and analysis, data integrity, test design, analysis, validation, and documentation

  • Create data processing and transformation pipelines which will promote business value for marketing and sales

  • Use vendor system APIs like Eloqua, Salesforce.com (SFDC), Adobe Analytics, etc.

  • Provide Tier 2 investigation for data anomalies, including deep dives into code, databases, and business logic to answer advanced user questions

  • Create automated unit tests and data validation scripts; implement system health monitoring and alerts

  • Monitor and consult on database indexing and dashboard performance

Required skills

  • Bachelor’s degree in computer science, engineering, information systems, or a related field, or bachelor's degree with relevant code school experience

  • 3+ years of relevant work experience with database or software development

  • 2+ years of experience using of SQL and RDBMS systems like Oracle, SQL Server, MySQL, etc.

  • Knowledge of logical and physical data modeling concepts

  • Record of using agile or scrum development processes to develop software

  • Great problem-solver, ability to learn on your own and work in an ambiguous environment

  • Ability to manage multiple projects at the same time in a fast-paced team environment, across time zones, and with different cultures and; great ability to work as part of a team

  • Ability to thrive in a fast-paced environment with minimal direction, extreme pressure, and tight deadlines

  • Solid problem-solving skills, troubleshooting, and root cause analysis

  • Experience writing complex SQL queries and stored procedures in RDBMS systems (e.g., MariaDB, PostgreSQL, Teiid, etc.) and data warehouse systems like Redshift

  • Experience working with business intelligence (BI) tools like SAP Business Objects (BOBJ), Tableau, QlikView, etc.

  • Experience with ETL processes and tools like Spoon, Kettle, SQL Server, or Informatica

  • Experience with back-end scripting languages like Python or Go

  • Experience with NoSQL databases like MongoDB, DynamoDB, or Cassandra)

The following are considered a plus:

  • Experience with data virtualization (e.g., Red Jboss Data Virtualization or Denodo)

  • Experience with version control tools like Git

  • Experience deploying containers in a Platform-as-a-Service (PaaS) tool like Red Hat OpenShift 3 or KubeNow

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, uniformed services, 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.

Job ID 67062

Category Corporate Marketing