Senior Data Engineer

Valiant Technologies LLC; Chicago (IL); On-site; USD 130,000 - 190,000; Full time

Job summary

Valiant Technologies LLC in Chicago is seeking a senior data engineer to design, build, and maintain scalable data pipelines using Snowflake. You will model data with dimensional approaches and develop complex SQL queries and ETL/ELT processes.

The role requires 7+ years in data engineering, experience with Snowflake, cloud platforms (AWS/Azure), and familiarity with Python, Git, CI/CD, and Agile methods. Collaboration with analysts and architects is essential.

Qualifications

• 7+ years of experience in data engineering.
• Hands-on Snowflake experience.
• Strong SQL and data modeling skills.
• Experience with ETL/ELT and data warehousing concepts.
• Experience with cloud platforms such as AWS or Azure.
• Knowledge of Python preferred.
• Experience with Git, CI/CD, and Agile methodologies.

Responsibilities

• Design, build, and maintain scalable data pipelines.
• Model data using dimensional approaches (star/snowflake).
• Develop complex SQL queries and optimized transformations.
• Implement ETL/ELT pipelines with Informatica, ADF, or dbt.
• Integrate data from multiple sources into Snowflake.
• Monitor query performance, storage, and data quality.
• Collaborate with analysts and architects; participate in design reviews.
• Troubleshoot pipeline issues and contribute to documentation.
• Follow CI/CD and Agile processes.

Skills

SQL

Data modeling

Python

Git & CI/CD

Agile methodologies

ETL/ELT concepts

Snowflake

Tools

Snowflake

Informatica

Azure Data Factory

dbt

AWS

Azure

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:

• Design, develop, and maintain scalable data pipelines using Snowflake.
• Strong experience in data modeling, including dimensional modeling, star and snowflake schemas.
• Develop complex SQL queries, stored procedures, and performance-optimized data transformations.
• Build and maintain ETL/ELT pipelines using tools such as Informatica, Azure Data Factory, dbt, or similar.
• Implement data integration from multiple source systems into Snowflake.
• Optimize Snowflake queries, warehouses, storage, and overall performance.
• Develop data models for analytics, reporting, and business intelligence.
• Ensure data quality, accuracy, security, and governance.
• Work with business analysts, architects, and data teams to understand requirements.
• Troubleshoot data pipeline and production issues.
• Participate in code reviews, documentation, and technical design discussions.

Required Skills:

• 7+ years of experience in Data Engineering.
• Strong hands-on experience with Snowflake.
• Strong SQL and Data Modeling skills.
• Experience with ETL/ELT and data warehousing concepts.
• Experience with cloud platforms such as AWS or Azure.
• Knowledge of Python is preferred.
• Experience with Git, CI/CD, and Agile methodologies.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.