Data Engineer

Trilyon, Inc.; Michigan; On-site; USD 100,000 - 140,000; Full time

Job summary

Trilyon, Inc. is seeking a Data Engineer to design, develop, and maintain scalable data pipelines and ETL workflows for enterprise data integration. The role emphasizes cloud platforms, data warehousing in Snowflake, and governance across data pipelines.

On-site in Cleveland, OH, with a 1-year duration and a competitive rate. The ideal candidate will bring expertise in Databricks, PySpark, Python, SQL, and Snowflake, plus experience with major ETL tools.

Qualifications

• Overall IT experience of 7+ years.
• 4+ years hands-on experience with major ETL tools: Informatica PowerCenter, ODI, IDMC or IICS.

Responsibilities

• Design, develop, and maintain complex ETL workflows and data pipelines.
• Build scalable data processing pipelines using Databricks, PySpark, and Python.
• Develop and optimize SQL/PLSQL queries, views, and stored procedures.
• Implement and manage Snowflake cloud data warehouses.
• Collaborate with cross-functional teams to translate data requirements into architecture.
• Monitor, troubleshoot, and optimize data pipelines and job scheduling.
• Ensure data quality, governance, and security across processing layers.

Tools

Databricks

PySpark

Python

SQL

Snowflake

Informatica PowerCenter

ODI

IDMC

IICS

Job description

For over 17 years, Trilyon has been a leader in global workforce solutions, specializing in Cloud Technology, AI/ML, Software Development, Technical Writing, and Digital Transformation. We partner with top companies to deliver high-quality talent in engineering, IT, and emerging technologies. For additional information or to view all of our job opportunities, please visit our website https://trilyonservices.com/careers/

We are seeking a Data Engineer to join our team. This role will involve building, maintaining, and optimizing scalable data pipelines, data warehouses, and ETL workflows to support enterprise data architecture. The ideal candidate will have experience in ETL processes, Databricks, Python, PySpark, SQL, and Snowflake and a passion for data engineering and cloud data integration.

Job Title: Data Engineer

Location: Cleveland, OH (On-site)

Duration: 1 Year

Rate/Salary: Competitive Rate

Job Description: We are seeking an experienced Data Engineer with a strong foundation in enterprise data integration and cloud platforms. The candidate will design, develop, and maintain high-performance data pipelines and ETL processes to support critical business operations.

Key Responsibilities:

• Design, develop, and deploy complex ETL workflows and data pipelines using enterprise tools (e.g., Informatica PowerCenter, ODI, IDMC, or IICS).

• Build scalable data processing pipelines utilizing Databricks, PySpark, and Python.

• Develop, optimize, and maintain complex SQL and PL/SQL queries, views, and stored procedures for data extraction and transformation.

• Implement and manage cloud data warehouse solutions in Snowflake.

• Collaborate with cross-functional teams to translate business and data requirements into robust technical architecture.

• Monitor, troubleshoot, and optimize database performance, job scheduling, and data pipeline efficiency.

• Ensure data quality, integrity, governance, and security standards across all data processing layers.

Experience & Qualifications:

• Overall Experience: Minimum 7+ years of overall IT experience.

• ETL Expertise: Minimum 4+ years of hands-on experience with at least one major ETL tool:

  • Informatica PowerCenter

  • Oracle Data Integrator (ODI)

  • Informatica Intelligent Data Management Cloud (IDMC)

  • Informatica Intelligent Cloud Services (IICS)

• Technical Skills:

  • Databricks & PySpark

  • Python Programming

  • Advanced SQL / PL-SQL

  • Snowflake Database

Why Join Us? Trilyon, Inc., offers a comprehensive benefits package. Opportunities for growth and professional development. Collaborative and inclusive company culture

Equal Employment Opportunity (EEO) Statement: Trilyon, Inc., is an Equal Opportunity Employer committed to diversity, equity, and inclusion. We do not discriminate based on race, color, religion, gender, gender identity, sexual orientation, national origin, age, disability, veteran status, or any other protected status under applicable laws. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.