ETL Data Engineer

Rockwoods Inc; Salt Lake City (UT); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading tech firm is seeking a skilled ETL Data Engineer in Salt Lake City, Utah, with over 8 years of experience to build and support large-scale data pipelines. This full-time role involves designing and optimizing ETL processes using DataStage, SQL, and Python. The ideal candidate will collaborate with engineers and business teams, ensuring smooth data migrations and performance improvements. Strong analytical skills and a solid foundation in data management are essential for success in this position.

Qualifications

• 8+ years of hands-on expertise in ETL tools and big data technologies.
• Strong experience in Data Warehousing, ETL process optimization.
• Practical experience with Git for version control.

Responsibilities

• Collaborate to develop and deliver enterprise-level data platforms.
• Troubleshoot technical issues and recommend effective solutions.
• Deploy updates into production environments.

Skills

Data Warehousing

ETL tools

SQL

Python

DataStage

Big Data systems

Git

Education

Bachelor’s degree in Computer Science

Tools

DataStage

SQL Server

Teradata

Spark

UNIX/Linux

Job description

Direct message the job poster from Rockwoods Inc

Location: Salt Lake City, Utah – 5 days onsite

Experience: 8+ Years

We are seeking an ETL Data Engineer with strong experience in building and supporting large-scale data pipelines. The role involves designing, developing, and optimizing ETL processes using tools like DataStage, SQL, Python, and Spark. You will work closely with architects, engineers, and business teams to create efficient data solutions. The job includes troubleshooting issues, improving performance, and handling data migration and transformation tasks. You will also support Test, QA, and Production environments while ensuring smooth deployments. Strong skills in databases, scripting, and version control are essential for this position.

Responsibilities

• Collaborate with architects, engineers, analysts, and business teams to develop and deliver enterprise-level data platforms that support data-driven solutions.
• Apply strong analytical, organizational, and problem-solving skills to design and implement technical solutions based on business requirements.
• Develop, test, and optimize software components for data platforms, improving performance and efficiency.
• Troubleshoot technical issues, identify root causes, and recommend effective solutions.
• Work closely with data operations teams to deploy updates into production environments.
• Provide support across Test, QA, and Production environments and perform additional tasks as needed.

Required Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering, or a related discipline.
• Strong experience in Data Warehousing, Operational Data Stores, ETL tools, and data management technologies.
• 8+ years of hands‑on expertise in ETL (IBM DataStage), SQL, UNIX/Linux scripting, and Big Data distributed systems.
• 4+ years of experience with Teradata (Vantage), SQL Server, Greenplum, Hive, and delimited text data sources.
• 3+ years of experience with Python programming, orchestration tools, and ETL pipeline development using Python/Pandas.
• Deep understanding of data migration, data analysis, data transformation, large-volume ETL processing, database modeling, and SQL performance tuning.
• Experience creating DDL scripts, stored procedures, and database functions.
• Practical experience with Git for version control and release processes.
• Familiarity with Spark framework, including RDDs using Python or Scala.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Information Technology

Referrals increase your chances of interviewing at Rockwoods Inc by 2x