Senior Technical Consultant - Data & Analytics

AHEAD; Chicago (IL); Hybrid; USD 140,000 - 200,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k)

Paid Holidays

Paid Time Off

Parental Leave

Job summary

AHEAD is seeking a Senior Data Engineer to lead design and hands-on engineering of Big Data and cloud environments that enable advanced analytics and data science for client projects. You will architect and implement scalable data pipelines across multi-cloud architectures, working closely with project teams both on-site and remotely.

The role requires 8+ years of technical experience, expertise in Hadoop, Spark, Snowflake, Python, and cloud platforms (AWS/Azure).

Qualifications

• 8+ years of professional technical experience.
• 4+ years of hands-on Data Architecture and Data Modelling.
• 4+ years of experience building highly scalable data solutions using Hadoop, Spark, Databricks, Snowflake.
• 4+ years of programming languages such as Python.
• 2+ years of experience working in cloud environments (AWS and/or Azure).
• Strong client-facing communication and facilitation skills.

Responsibilities

• Design, build, operationalize, secure, and monitor data processing systems.
• Create robust pipelines to ingest and process structured and unstructured data from various sources into analytical platforms using batch and streaming methods.
• Implement custom applications using cloud-native tools like Kinesis and Lambda as required for streaming use cases.
• Develop and maintain data structures including SQL and NoSQL databases.
• Maintain ELT processes for loading data lakes (Snowflake, Cloud Storage, Hadoop).
• Expose data through APIs for Enterprise Applications.
• Select appropriate tools to deliver testable, maintainable, modern data solutions.
• Collaborate with scrum team members to estimate and deliver work in sprints.
• Investigate data questions, identify root causes, and liaise with business and technical stakeholders.

Skills

Python

Cloud

NoSQL

SQL

Spark

Hadoop

Snowflake

ETL/ELT

Data Engineering

Tools

AWS

Azure

Kinesis

Lambda

Job description

AHEAD builds platforms for digital business. By weaving together advances in cloud infrastructure, automation and analytics, and software delivery, we help enterprises deliver on the promise of digital transformation.At AHEAD, we prioritize creating a culture of belonging, where all perspectives and voices are represented, valued, respected, and heard. We create spaces to empower everyone to speak up, make change, and drive the culture at AHEAD.We are an equal opportunity employer, and do not discriminate based on an individual's race, national origin, color, gender, gender identity, gender expression, sexual orientation, religion, age, disability, marital status, or any other protected characteristic under applicable law, whether actual or perceived.We embrace all candidates that will contribute to the diversification and enrichment of ideas and perspectives at AHEAD.
AHEAD is looking for a Senior Data Engineer to work closely with our dynamic project teams (both on-site and remotely). This Senior Data Engineer will be responsible for strategic planning and hands‑on engineering of Big Data and cloud environments that support our clients' advanced analytics, data science, and other data platform initiatives. This consultant will design, build, and support modern data environments that reside in the public cloud or multi-cloud enterprise architectures. They will be expected to be hands‑on technically, but also present to leadership, and lead projects.The Senior Data Engineer will have responsibility for working on a variety of data projects. This includes orchestrating pipelines using modern Data Engineering tools/architectures as well as design and integration of existing transactional processing systems. As a Senior Data Engineer, you will design and implement data pipelines to enable analytics and machine learning on rich datasets.

Roles and Responsibilities

• A Data Engineer should be able to design, build, operationalize, secure, and monitor data processing systems
• Create robust and automated pipelines to ingest and process structured and unstructured data from various source systems into analytical platforms using batch and streaming mechanisms leveraging cloud native toolset
• Implement custom applications using tools such as Kinesis, Lambda and other cloud native tools as required to address streaming use cases
• Engineers and supports data structures including but not limited to SQL and NoSQL databases
• Engineers and maintain ELT processes for loading data lake (Snowflake, Cloud Storage, Hadoop)
• Engineers API's for returning data from these structures to the Enterprise Applications
• Leverages the right tools for the right job to deliver testable, maintainable, and modern data solutions
• Respond to customer/team inquiries and assist in troubleshooting and resolving challenges
• Works with other scrum team members to estimate and deliver work inside of a sprint
• Research data questions, identifies root causes, and interacts closely with business users and technical resources

Qualifications

• 8+ years of professional technical experience
• 4+ years of hands‑on Data Architecture and Data Modelling.
• 4+ years of experience building highly scalable data solutions using Hadoop, Spark, Databricks, Snowflake
• 4+ years of programming languages such as Python
• 2+ years of experience working in cloud environments (AWS and/or Azure)
• Strong client‑facing communication and facilitation skills

Key Skills

• Python, Cloud, Linux, Windows, NoSQL, Git, ETL/ELT, Spark, Hadoop, Data Warehouse, Data Lake, Snowflake, SQL/RDBMS, OLAP, Data Engineering

The compensation range indicated in this posting reflects the On-Target Earnings ("OTE") for this role, which includes a base salary and any applicable target bonus amount. This OTE range may vary based on the candidate's relevant experience, qualifications, and geographic location.

Why AHEAD:

Through our daily work and internal groups like Moving Women AHEAD and RISE AHEAD, we value and benefit from diversity of people, ideas, experience, and everything in between. We fuel growth by stacking our office with top‑notch technologies in a multi‑million‑dollar lab, by encouraging cross department training and development, sponsoring certifications and credentials for continued learning.

USA Employment Benefits include:

• Medical, Dental, and Vision Insurance
• 401(k)
• Paid company holidays
• Paid time off
• Paid parental and caregiver leave
• Plus more! See benefits for additional details.

Use of AI:

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, assessing responses, or to capture recordings and create transcriptions or summaries during interviews. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please refer to the Candidate Privacy Notice or contact us at . You may opt‑out of the review or analysis of your application and resume by AI tools by using the General Application. Please include the role you wish to apply for in the Additional Information field. You may also choose to opt‑out of recording and transcription at any time, including after joining an interview. Candidates will not be penalized for choosing to opt‑out.