over 1 year ago
Mexico (city not specified)Entry Level
Responsibilities
- Design and build data pipelines that extract, transform, and load data into warehouses and data lakes.
- Manage and model data warehouses for efficient querying, performance, and data quality using platforms such as Synapse, Snowflake, Redshift, and BigQuery.
- Develop and optimize ETL processes and data pipeline orchestration workflows.
- Implement data cleaning, validation, monitoring, and remediation processes for data quality and pipeline reliability.
- Apply data security controls, permissions, and access management to protect sensitive information and support privacy compliance.
- Design scalable systems for large data volumes and optimize database and query performance.
- Modernize enterprise data architectures, establish standards and communities of practice, and support timely, high-quality client deliverables.
Requirements
- Master's degree in Technology, Data Science, Mathematics, Statistics, or a related field.
- At least 3 years of experience with data engineering, database technologies, data pipelines, and related responsibilities.
- Proficiency in SQL, including T-SQL, PL/pgSQL, and Spark-SQL, with experience in query optimization.
- Experience with Microsoft SQL Server and PostgreSQL in on-premises and cloud-based deployments, including database administration tasks.
- Experience designing and implementing data pipelines and understanding ETL processes.
- Familiarity with Airflow, Ascend, Apache Spark, or DBT for data pipeline orchestration and transformation.
- Experience with Java, C#.NET, and/or Python and methods for interacting with persistence layers.
- Working knowledge of AWS or Azure for infrastructure provisioning and management.
- Understanding of relational database systems, data warehousing, data quality practices, and data security.
- Familiarity with Git and database backup, recovery, user management, and performance monitoring.
- Ability to manage confidential and sensitive information.
- Cloud and data science certifications are preferred.
Tech Stack
Amazon RedshiftApache AirflowApache SparkAWSAzureC#dbtGitGoogle BigQueryInformaticaJavaMicrosoft SQL ServerPostgreSQLPythonSnowflakeSQL
Categories
Data Engineering
About Kroll
Kroll provides risk and financial advisory services, including valuation, corporate finance, restructuring, investigations, cyber risk, and compliance, to enterprises, financial institutions and law firms. It earns fees for advisory, due diligence, disputes, and agency/trustee services across global capital markets. Founded in 1972 and headquartered in New York, the firm operates internationally and is known for complex valuations and forensic investigations.