Solutions Consultant (Data Engineering)
Posted: 03/03/2026
Job Number: 1068
Pay Rate: $100/hr - $120/hr
Remote Work Available?: Onsite
Job Description
Solutions Consultant (Data Engineering)
Location: MUST be able to work ONSITE in Chicago, IL
Experience Level: Mid-Senior (5+ Years Combined)
Pay rate: $100/hr – $120/hr
Contract Duration: Long term contract
Position Overview
Our client in the trading industry is seeking a Solutions Consultant with a strong technical foundation in Data Engineering and a proven track record in client-facing roles. You will be responsible for helping their customers design and implement modern data architectures, specifically focusing on the Databricks Lakehouse platform.
This role requires a blend of hands-on coding, architectural guidance, and the ability to navigate the nuances of cloud data warehouses like BigQuery, Synapse, or Redshift while migrating or integrating with Databricks.
Key Responsibilities
Required Qualifications
#IND1
Location: MUST be able to work ONSITE in Chicago, IL
Experience Level: Mid-Senior (5+ Years Combined)
Pay rate: $100/hr – $120/hr
Contract Duration: Long term contract
Position Overview
Our client in the trading industry is seeking a Solutions Consultant with a strong technical foundation in Data Engineering and a proven track record in client-facing roles. You will be responsible for helping their customers design and implement modern data architectures, specifically focusing on the Databricks Lakehouse platform.
This role requires a blend of hands-on coding, architectural guidance, and the ability to navigate the nuances of cloud data warehouses like BigQuery, Synapse, or Redshift while migrating or integrating with Databricks.
Key Responsibilities
- Technical Implementation: Lead the hands-on development of data pipelines, leveraging your experience with at least one major Databricks project delivery.
- Architecture Guidance: Design and implement the Medallion (Multi-hop) Architecture to ensure data quality and reliability from raw ingestion to business-ready layers.
- Optimization: Apply advanced Spark tuning techniques (Partitioning, Z-Ordering, Caching) to improve job performance and reduce cloud costs.
- Cross-Platform Integration: Assist clients in bridging the gap between traditional cloud data warehouses (Redshift, BigQuery, Synapse) and the Databricks Lakehouse.
- Client Advocacy: Act as a technical consultant, translating complex data requirements into scalable Python or Scala-based solutions.
Required Qualifications
- Professional Experience: 3+ years of consulting experience paired with 2+ years of dedicated Data Engineering experience.
- Platform Expertise: Hands-on development experience with Databricks (minimum 1 major project delivered).
- Certifications: Completion of the Data Engineering Associate certification and all required prerequisite classes.
- Technical Training: Must have successfully completed:
- Apache Spark Programming with Databricks
- Data Engineering with Databricks
- Optimizing Apache Spark™ on Databricks
- Programming Proficiency: Strong proficiency in Python is required; knowledge of Scala is a significant advantage.
- SQL & Cloud Data Warehousing: Proven experience delivering SQL-based solutions and familiarity with Google BigQuery, Azure Synapse, or AWS Redshift.
- Experience with application development and Dataricks Apps
- Comfort working in Linux environments
- Background in financial markets, such as market making, trading, or related domains
- Able to work independently, prioritize effectively, and proactively identify opportunities for improvement
- Comfortable operating in a loosely defined scope, where they are expected not only to execute tasks but also help define priorities and drive work forward.
#IND1
Meet Your Recruiter
Amber Boytis
Sr. Technical Recruiter
Senior Technical Recruiter and business professional with 13+ years of progressive experience and responsibility. A dedicated partner with candidates and hiring managers from the front line to the C-suite. Demonstrated results in identifying quality candidates in a variety of industries across all job families with strong expertise in IT and Engineering.
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Chicago, IL
Unlock your potential in the bustling job market around Chicago, Illinois! Dive into a world of endless possibilities and growth opportunities in the Windy City and its vibrant suburbs. From iconic landmarks like the Willis Tower and Navy Pier to the world-class cuisine of deep-dish pizza and Chicago-style hot dogs, this area is rich in culture and charm. Immerse yourself in the thriving arts scene at the Art Institute of Chicago or enjoy a night out at the renowned Second City comedy club. With top-notch theaters, professional sports teams like the Cubs and the Bears, and lush green spaces like Millennium Park, Chicago offers an unbeatable lifestyle for career-driven individuals. Explore our job listings today and discover why Chicago is the perfect place to kickstart your career journey!