Senior Data Engineer

Fractal; Chicago (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading AI consulting firm is seeking a Mid-Senior level Data Engineer in Chicago, IL. The role involves designing and maintaining data pipelines, optimizing SQL queries, and collaborating with cross-functional teams. Ideal candidates will have expertise in relational databases, data warehousing, and familiarity with Azure solutions. The position offers competitive pay ranging from $80,000 to $100,000 annually.

Qualifications

• Experience with MPP Relational Databases such as Synapse.
• Advanced SQL expertise to write complex queries.
• Experience with designing and maintaining ETL pipelines.
• Familiarity with Azure cloud-based data solutions.
• Excellent communication and teamwork abilities.

Responsibilities

• Design, develop, and maintain scalable data pipelines.
• Ensure reliability, performance, and security of data systems.
• Collaborate with data scientists, analysts, and engineers.
• Participate in performance tuning and database optimization.
• Provide mentorship to junior team members.

Skills

Experience with MPP Relational Databases such as Synapse

Advanced SQL expertise

Experience with ETL pipelines

Experience in Databricks

Familiarity with Azure cloud-based solutions

Strong problem-solving and analytical skills

Excellent communication and teamwork abilities

Tools

Python

Pyspark

Java

Informatica

Hadoop

Spark

Job description

Get AI-powered advice on this job and more exclusive features.

Fractal is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is the one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work Institute and recognized as a ‘Cool Vendor’ and a ‘Vendor to Watch’ by Gartner.

Please visit Fractal | Intelligence for Imagination for more information about Fractal.

Job Description

• Design, develop, and maintain scalable data pipelines.
• Implement data integration, transformation, and quality processes.
• Write, optimize, and troubleshoot complex SQL queries.
• Ensure the reliability, performance, and security of data systems.
• Collaborate with data scientists, analysts, and other engineers to meet business requirements.
• Participate in performance tuning and database optimization.
• Create and maintain technical documentation of data flows and processes.
• Ensure data accuracy and integrity through effective monitoring and testing.
• Provide support and troubleshooting for data-related issues.
• Provide mentorship and guidance to junior team members, helping them develop their skills and grow professionally.
• Collaborate with cross-functional teams to integrate data from multiple sources and ensure data quality and consistency.
• Implement best practices for data governance, security, and compliance to ensure data integrity and privacy

Mandatory/Required

• Experience with MPP Relational Databases such as Synapse.
• Advanced SQL expertise – ability to write complex queries, perform database tuning, and optimize queries.
• Experience with designing and maintaining ETL pipelines and data warehousing.
• Experience in Databricks - Delta Live Table design and development
• Familiarity with Azure cloud-based data solutions Strong problem-solving and analytical skills.
• Excellent communication and teamwork abilities.

Good to have

• Knowledge of Informatica for ETL processes.
• Experience with big data technologies (e.g., Hadoop, Spark).
• Exposure to programming languages like Python, Pyspark or Java for data manipulation and automation
• Exposure to data governance and compliance standards.
• Exposure to CI/CD framework

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting and Business Consulting and Services

Referrals increase your chances of interviewing at Fractal by 2x

Sign in to set job alerts for “Data Engineer” roles.

Chicago, IL $80,000.00-$100,000.00 3 days ago

Chicago, IL $120,000.00-$190,000.00 6 hours ago

Chicago, IL $63,288.00-$91,768.00 1 week ago

Chicago, IL $100,000.00-$110,000.00 1 week ago

Westmont, IL $95,000.00-$107,000.00 2 weeks ago

Chicago, IL $63,288.00-$91,768.00 2 weeks ago

Chicago, IL $90,915.00-$113,620.00 1 week ago

Chicago, IL $175,000.00-$225,000.00 2 weeks ago

Chicago, IL $1,000.00-$2,000.00 2 months ago

Chicago, IL $68,000.00-$110,000.00 1 week ago

Don’t See a Fit? Let Us Know What You’re Looking For

Chicago, IL $120,000.00-$200,000.00 1 month ago

Chicago, IL $80,000.00-$90,000.00 2 weeks ago

Backend/API Engineer, Money as a Service (US)

Chicago, IL $150,500.00-$269,200.00 1 week ago

College Graduates - Full-Time - Junior Software Engineer (2026)

Chicago, IL $145,000.00-$175,000.00 2 weeks ago

Chicago, IL $48,000.00-$120,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.