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 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 field 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, but need not be, acquired concurrently. Salary and Benefits Salary Range: $187,600 – $187,600 USD. Along with base pay, this position offers eligibility for a target bonus and a comprehensive benefits suite, including 401(k) and Profit Sharing plan. #J-18808-Ljbffr Kimberly-Clark