Data Engineer

trane technologies • White Bear Lake, MN

2d • $107,540 - $137,200 • Hybrid

About The Position

Part of the CHVAC Strategy & Transformation organization, the CHVAC Data & Analytics team’s mission is to harness data to solve business challenges, implement AI-driven solutions, and build scalable data products to drive revenue growth, improve productivity, and add customer value. We are seeking a Data Engineer to actively design, build, improve and manage the critical data the CHVAC Data & Analytics team needs to support the business. Partnering with the Enterprise D&A and CHVAC IT teams, this role will deliver, build and support data products for CHVAC Americas to enable revenue growth and drive productivity. The Data Engineer will partner with the data architects, stakeholders and cross functional teams to build data pipelines and datasets into Trane’s Data Cloud – a Google Cloud Platform.

Requirements

• 2-4 years of experience with creating data pipelines utilizing Python, PySpark, SQL, or any other programming language in Cloud based environments
• Solid understanding of data warehousing concepts and hands-on experience with relational databases (e.g., PostgreSQL, MySQL) and columnar databases (e.g., Redshift, BigQuery, HBase, ClickHouse)
• Experience with big data technologies such as HDFS, YARN, MapReduce, Hive, Kafka, Spark, Airflow, or Presto
• Experience with Cloud environments, preferably GCP and AWS
• Strong communication skills, with the ability to work in a team and collaborate with other data professionals and business stakeholders

Nice To Haves

• Experience with big data technologies such as HDFS, YARN, MapReduce, Hive, Kafka, Spark, Airflow, or Presto
• Familiarity with Self Service Tools such as Dataiku and Tableau
• Agile experience
• Familiarity with ERP and CRM Systems

Responsibilities

• Design and develop data pipelines and transformations to extract, load and transform (ELT) data from source systems into data platforms for further processing and analysis
• Develop robust data solutions and streamline diverse datasets into simplified models to promote self-service
• Take responsibility for data mapping, business logic, transformations, and data quality
• Develop strong understanding of business value of data sets for analytics or machine learning models
• Support and maintain existing platforms while transitioning to newer technology stacks and architectures
• Support data scientists and data analysts in assessing, analyzing, and visualizing data, ensuring that data is accurate, reliable, and traceable
• Follow enterprise guidelines and best practices to ensure a consistent approach across the organization
• Stay up to date with emerging technologies and trends in the data engineering and cloud space and willingness to learn and use new tools and platforms that can improve efficiency

Benefits

• Health insurance
• Holistic wellness programs with generous incentives
• Family building benefits include fertility coverage and adoption/surrogacy assistance
• 401K match up to 6%, plus an additional 2% core contribution
• 15 vacation days
• 9 paid holidays
• 3 floating holidays
• Sick leave
• Additional options to support volunteer and parental leave
• Educational and training opportunities through company programs
• Tuition assistance
• Student debt support

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed