Lead Data Integration Engineer

Lead Data Integration Engineer

Job Description

Kimberly-Clark USA, LLC

Lead Data Integration Engineer

Job Description: 

Lead Data Integration Engineer positions offered by Kimberly-Clark USA, LLC (Irving, Texas).

Work with Technical Architects, Product Owners and Business teams to translate requirements into technical design for data modelling and data integration.

Utilize background in data warehousing, data modelling and ETL/ELT data processing patterns.

Design and develop ETL/ELT pipelines with reusable patterns and frameworks.

Design and build efficient SQLs to process and curate the data sets in HANA, Azure and Snowflake.

Design and review data ingestion frameworks leveraging Python, Spark, Azure Data Factory, Snowpipe, etc.

Design and build Data Quality models and ABCR frameworks to ingest, validate, curate and prepare the data for consumption.

Review functional domain and business needs and identify the gaps in the requirements proactively prior to implementing solutions.

Work with platform teams to design and build processes for automation in pipeline build, testing and code migrations.

Minimum Requirements: 

Requires a bachelor’s or foreign equivalent degree in computer science, applied computer science, IT or a related field and 10 years of experience in the job offered or 10 years of experience designing, developing, and building ETL/ELT pipelines, procedures, and SQLs on MPP platforms including HANA, Snowflake, Greenplum, or Teradata.

Also requires 5 years of experience: designing and building metadata driven data ingestion frameworks, building SAP BO/Data Services, Azure Data Factory, SnowSQL, and Snowpipe, and building mini-batch, real-time and event-driven data processing jobs; designing and developing object stores (including Azure ADLS, HDFS, and GCP Cloud Storage), Row and Columnar databases (including Azure SQL DW, SQL Server, Snowflake, Teradata, PostgresSQL, and Oracle), NoSQL databases (including CosmosDB, MongoDB, and Cassandra), ElasticSearch, Redis, and Data processing platforms Spark, Databricks, and SnowSQL; and leveraging Azure Stream Analytics, Azure Analysis Services, Data Lake Analytics, HDInsight, HDP, Spark, Databricks, MapReduce, Pig, Hive, Tez, SSAS, Watson Analytics, and SPSS for Data Analytics development and solution architecture.

Employee reports to office in Irving, TX, but may telecommute from anywhere in the U.S.

Experience may be, but need not be, acquired concurrently.

Salary Range: $187,600 - $187,600 USD

At Kimberly-Clark, pay is just one aspect of our total rewards package, which also includes a variety of benefits and opportunities to achieve, thrive and grow.

Along with base pay, this position offers eligibility for a target bonus and a comprehensive benefits suite, including our 401(k) and Profit Sharing plan.

The anticipated base pay range for this role is provided above for a fully qualified hire.

Actual pay will depend on several factors, such as location, role, skills, perfor...