Principal Data Engineer Red Hat Sales Data Management (Raleigh Office)

Red Hats Global Sales Go-To-Market Strategy Incentives & Data Analytics organization is seeking a Principal Data Engineer to work with a high degree of autonomy to lead the integration automation and optimization of complex data this role you will move beyond simple execution to provide technical leadership in data massaging reconciliation and architectural design. You will be responsible for building robust data pipelines ensuring data governance and collaborating with cross-functional teams to deliver high-quality data products that drive business decisions.

What will you do

• Advanced SQL Development: Write complex highly optimized SQL queries across large datasets. You will be the subject matter expert for SQL query tuning and providing performance recommendations to the wider team.

• Python Automation: utilize advanced Python proficiency (including libraries such as Pandas and NumPy) to clean massage and merge raw datasets automating complex data extraction and loading processes.

• Pipeline Orchestration: Design schedule and monitor robust data pipelines using tools like Airflow. You will take ownership of debugging workflows and resolving performance bottlenecks.

• Data Stewardship: Act as a guardian of data integrity. This includes leading initiatives on data governance compliance transformation and validation audits.

• Automated Testing & CI/CD: Develop and maintain automated unit end-to-end and integration tests to ensure data accuracy. Participate actively in version control (Git) and CI/CD processes for deploying pipeline changes across environments.

• Cross-Functional Leadership: Partner with Analysts Engineers and Operations teams to understand data needs and ensure data accessibility for business stakeholders from the finance and operations organizations.

• Problem Solving: Apply strong analytical skills to translate complex algorithms into efficient software solutions converting raw data into actionable insights by identifying trends outliers and distributions.

What will you bring

• Experience: 5 years of experience as a Data Engineer BI Engineer or Systems Analyst in an enterprise environment with large complex data sources.

• Education: Masters degree in Computer Science IT Engineering or equivalent experience.

• Expert SQL: Deep expertise in relational databases (PostgreSQL MSSQL etc.) and query optimization.

• Expert Python: Strong programming skills for data querying cleaning and presentation with hands-on experience in data-centric libraries.

• Modern Stack Experience: Working knowledge of DBT (Data Build Tool) and Snowflake data warehousing is highly desirable.

• ELT/ETL Tools: Experience with Fivetran or similar integration tools.

• Autonomy: Ability to manage multiple projects simultaneously in a fast-paced distributed team environment across different time zones and cultures.

• Troubleshooting: Exceptional logic and reasoning skills to troubleshoot complex data issues.

• Planning: Ability to think strategically about data architecture and project planning.

#Li-NG1

Pay Transparency

Red Hat determines compensation based on several factors including but not limited to job location experience applicable skills and training external market value and internal pay equity. Annual salary is one component of Red Hats compensation package. This position may also be eligible for bonus commission and/or equity. For positions with Remote-US locations the actual salary range for the position may differ based on location but will be commensurate with job duties and relevant work experience.

About Red Hat

Red Hat is the worlds 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. Were 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.

Benefits
Comprehensive medical dental and vision coverage
Flexible Spending Account - healthcare and dependent care
Health Savings Account - high deductible medical plan
Retirement 401(k) with employer match
Paid time off and holidays
Paid parental leave plans for all new parents
Leave benefits including disability paid family medical leave and paid military leave
Additional benefits including employee stock purchase plan family planning reimbursement tuition reimbursement transportation expense account employee assistance program and more!

Note: These benefits are only applicable to full time permanent associates at Red Hat located in the United States.

Inclusion at Red Hat
Red Hats 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 different 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 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 . General inquiries such as those regarding the status of a job application will not receive a reply.