Data Engineer (SQL, PySpark, Snowflake, DBT, Redshift) - Associate

COMPANY OVERVIEW

KKR is a leading global investment firm that offers alternative asset management as well as capital markets and insurance solutions. KKR aims to generate attractive investment returns by following a patient and disciplined investment approach, employing world-class people, and supporting growth in its portfolio companies and communities. KKR sponsors investment funds that invest in private equity, credit and real assets and has strategic partners that manage hedge funds. KKR’s insurance subsidiaries offer retirement, life and reinsurance products under the management of Global Atlantic Financial Group. References to KKR’s investments may include the activities of its sponsored funds and insurance subsidiaries.

TEAM OVERVIEW

KKR’s Technology team is responsible for building and supporting the firm’s technological foundation including a globally distributed infrastructure, information security, and application and data platforms. The team drives a culture of technology excellence across the firm through efficient workflow automation, democratization of data through modern data and collaboration platforms, and more recently through research and development of Generative AI based tools and services.

Technology is regarded as a key business enabler at KKR and is an important accelerator to drive towards global scale creation and business process transformation. A dedicated Program Management function along with the Product Managers drive execution discipline across multiple technology teams with a goal to consistently deliver excellence serving our business needs. The Technology team consists of highly technical and business centric technologists with the ability to form strong partnerships across all of our businesses.

POSITION SUMMARY

We are seeking an experienced Data Engineer to design, build, and operate scalable, production-grade data platforms on AWS. In this role you will own the full lifecycle of data pipelines - from ingestion and orchestration through transformation, storage, and governance - using a modern lakehouse stack built on Apache Iceberg, AWS Glue, and Snowflake. You will partner with data scientists, analysts, and platform teams to deliver reliable, well-governed, and cost-efficient data products that power analytics and business decisions across Insurance Systems.

ROLES & RESPONSIBILITIES

• Design, build, and maintain scalable, fault-tolerant data pipelines and ETL/ELT processes for structured, semi-structured, and unstructured data.
• Own end-to-end pipeline orchestration - scheduling, dependency management, retries, SLAs, and observability - using a data pipeline orchestrator.
• Build and manage lakehouse data assets on Apache Iceberg, including partitioning, schema evolution, time-travel, and table maintenance (compaction, snapshot expiry).
• Develop and operate large-scale data processing jobs using Apache Spark, including AWS Glue Spark jobs.
• Model, load, and optimize data in Snowflake, and govern data assets using data catalogs (AWS Glue Data Catalog and Snowflake Horizon).
• Architect and implement data solutions on AWS using native services (S3, Glue, EMR, Lambda, Athena, Kinesis, Redshift, IAM).
• Ensure data quality, integrity, lineage, and security across all systems and environments.
• Integrate data from diverse sources including APIs, relational databases, streaming feeds, and third-party tools.
• Monitor, troubleshoot, and tune pipelines for performance, reliability, and cost efficiency.
• Contribute to platform architecture, design reviews, code reviews, and engineering best practices.
• Mentor junior engineers and help drive standards across the data engineering function.

QUALIFICATIONS

• 5 to 8 years of hands-on data engineering experience building production data pipelines.
• Strong proficiency in Python for data engineering and automation.
• Advanced SQL and strong experience with relational databases (e.g., PostgreSQL, MySQL).
• A data pipeline orchestrator is mandatory - proven experience operating a workflow orchestration tool (e.g., Apache Airflow, Dagster, or equivalent) in production.
• Hands-on experience with Apache Spark for large-scale distributed data processing.
• Production experience with Apache Iceberg (or an equivalent open table format) for lakehouse storage.
• Hands-on experience with AWS Glue (ETL jobs and the Glue Data Catalog).
• Experience with Snowflake as a cloud data warehouse.
• Experience with data cataloging and governance using AWS Glue Data Catalog and Snowflake Horizon.
• Strong experience with AWS as the primary cloud platform, including S3, EMR, Lambda, Athena, Kinesis, Redshift, and IAM.
• Solid understanding of data modeling, data warehousing, and lakehouse architecture patterns.
• Working knowledge of REST APIs and data integration techniques.
• Strong problem-solving, analytical, and debugging skills.

Preferred / Good-to-Have

• Experience with Dagster as a data pipeline orchestrator (strongly preferred).
• Experience with containerization and orchestration (Docker, Kubernetes / Amazon EKS).
• Exposure to CI/CD pipelines and infrastructure-as-code (e.g., Terraform, AWS CloudFormation/CDK).
• Experience with streaming / real-time data (Kafka, Amazon Kinesis, Spark Structured Streaming).
• Familiarity with data observability and quality frameworks (e.g., Great Expectations, dbt tests).
• Knowledge of data governance, security, and compliance best practices.
• Experience within financial services or insurance data domains.

Technology Stack at a Glance

Cloud Platform - AWS (S3, Glue, EMR, Lambda, Athena, Kinesis, Redshift, IAM)

Orchestration - Data pipeline orchestrator required (e.g., Airflow); Dagster good-to-have

Processing - Apache Spark, AWS Glue

Lakehouse / Storage - Apache Iceberg on Amazon S3

Data Warehouse - Snowflake

Data Catalog / Governance - AWS Glue Data Catalog, Snowflake Horizon

Languages - Python, SQL

Soft Skills

• Strong communication and cross-functional collaboration skills.
• Ability to work in a fast-paced, agile environment.
• Self-driven with a proactive, ownership-oriented mindset.
• Ability to mentor peers and communicate technical concepts to non-technical stakeholders.

KKR is an equal opportunity employer. Individuals seeking employment are considered without regard to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, sexual orientation, or any other category protected by applicable law.

KKR will provide reasonable accommodations as required by applicable federal, state, and/or local laws. Individuals seeking an accommodation for the application or interview process should email [email protected]. Emails sent for unrelated issues, such as following up on an application, will not receive a response.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access https://www.kkr.com/careers because of your disability. You can request reasonable accommodations by sending an email to [email protected]. Only emails left for this purpose will be returned.

Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. This notice applies only to applicants and employees who work or will work in Massachusetts, in accordance with applicable state law.