Kearney Activate Senior Consultant Data Engineer

Job Description

Job Description

As a Senior Consultant Data Engineer, you will be a key contributor within Kearney Activate’s Solutions Architecture and Data Engineering practice. You will design, build, and maintain scalable data pipelines and infrastructure that support client data driven initiatives and enterprise transformations.

You will lead technical work streams, mentor junior team members, and collaborate closely with client stakeholders and cross functional teams to deliver high impact data solutions that enable advanced analytics, AI, and intelligent automation.

Key responsibilities

Data pipeline development

• Design, implement, and optimize end to end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data across client environments

• Develop robust ETL and ELT processes to integrate data from diverse sources into modern data ecosystems, including data lakes, data warehouses, and cloud native platforms

• Implement data validation and quality checks to ensure accuracy, consistency, and reliability of data feeds

• Evaluate and implement streaming and real time data processing solutions where applicable

Data modeling and architecture

• Design and maintain data models, schemas, and database structures to support analytical, operational, and AI or ML use cases

• Optimize data storage and retrieval mechanisms for performance, scalability, and cost efficiency

• Evaluate and implement data storage solutions including relational databases, NoSQL databases, data lakes, data warehouses, and cloud storage services such as AWS S3, Azure Data Lake, Snowflake, and Data bricks

• Contribute to the development of modern data architectures aligned with client business objectives and technical requirements

Data integration and API development

• Build and maintain integrations with internal and external data sources, APIs, and enterprise systems

• Implement RESTful APIs and web services for data access and consumption

• Ensure compatibility and interoperability across systems and platforms

• Design secure data exchange mechanisms that adhere to information security and compliance requirements

Data infrastructure management

• Configure and manage data infrastructure components, including databases, data warehouses, data lakes, and distributed computing frameworks such as Spark and Data bricks

• Monitor system performance, troubleshoot issues, and implement optimizations to enhance reliability and efficiency

• Implement data security controls and access management policies to protect sensitive client information

• Leverage cloud platforms and services including AWS, Azure, and GCP to deploy and manage scalable data solutions

Technical leadership and innovation

• Act as technical lead on project work streams, providing guidance and oversight to junior data engineers and analysts

• Review code, data models, and technical designs to ensure adherence to best practices and standards

• Remove technical blockers and enable continuous progress across delivery teams

• Stay current with emerging technologies, including Gen AI capabilities, agentic architectures such as LangGraph and Agent Development Kit, Model Context Protocol, and automation frameworks

• Evaluate and implement intelligent automation and AI driven solutions where logically and practically applicable

• Contribute to internal knowledge repositories, reusable frameworks, and delivery accelerators

Client engagement and collaboration

• Collaborate directly with client technical and functional stakeholders to understand data requirements and deliver tailored solutions

• Partner with data scientists, analysts, architects, and business leaders to bridge technical execution and business outcomes

• Participate in client presentations and technical discussions, communicating complex concepts clearly and professionally

• Document technical designs, workflows, and best practices to support knowledge sharing and system maintenance

• Provide technical guidance and support to team members, clients, and stakeholders as needed.

Who you are

After nearly 100 years, we know this business is fundamentally about making connections between data, technology, strategy, and people. We look for curious, collaborative problem solvers who bring rigor to execution and thrive in fast paced, client facing environments.

We want to hear from you if you have:

Education and experience

• A bachelor’s degree in computer science, Engineering, Information Systems, or a related field, with a master’s degree preferred

• Five or more years of experience in data engineering, with significant exposure to client facing consulting or similar environments

• Demonstrated experience leading technical work streams and mentoring junior resources

Technical skills

• Proficiency in programming languages commonly used in data engineering, including Python and SQL, with Java or Scala a plus

• Strong knowledge of database systems, data modeling techniques, and advanced SQL

• Hands on experience with ETL and ELT tools such as Data bricks, Azure Data Factory, AWS Glue, Informatica Cloud, Talend, dbt, or Airflow

• Experience with big data technologies and frameworks including Spark, Hadoop, Kafka, and Kinesis

• Proven experience with cloud platforms and services such as Snowflake, AWS, and Azure, with Google Cloud Platform familiarity a plus

• Strong understanding of data warehousing concepts, dimensional modeling, and modern data architecture patterns

• Familiarity with GenAI applications in data engineering, agentic frameworks, and emerging technologies

Professional competencies

• Excellent problem-solving skills and attention to detail

• Strong communication skills with the ability to translate technical complexity for non-technical stakeholders

• Effective collaboration skills in cross functional, team-oriented environments

• Ability to manage multiple concurrent projects and adapt to shifting priorities

• Self-motivated with a drive to deliver high quality work and continuously improve

• A forward-thinking approach to technology and curiosity about emerging trends and capabilities

Security Clearance Requirement (or ability to obtain): Secret

This position requires an active Secret security clearance or the ability to obtain one. A Secret clearance is a U.S. government security clearance that allows access to classified national security information that could cause "serious damage" to national security if disclosed without authorization.

Key Points:

• Issued by the federal government after a background investigation

• Requires U.S. citizenship

• Involves investigation into criminal history, financial records, and personal conduct

• Must be sponsored by a government agency or cleared defense contractor

• Requires periodic reinvestigation (typically every 10 years)

• Clearance processing typically takes 3-6 months but can vary

Candidates must be able to meet the eligibility requirements established by the U.S. government for access to classified information at the Secret level.

What we can offer you

• Every day, our people work to make an impact for our clients, our colleagues, and our communities. At Kearney Activate, you will find competitive compensation, meaningful client work, and the opportunity to shape the future of data, AI, and enterprise transformation at scale.

• We offer a comprehensive benefits package, including but not limited to:

• Competitive base compensation with discretionary performance bonuses

• Comprehensive medical, dental, and vision coverage for employees and immediate family

• Generous retirement and savings contributions

• Non partner equity-based awards for consulting managers and above

• Structured learning, technical growth, and leadership development opportunities

• Flexible work and talent mobility programs, including remote work options and externships

• Access to health, wellness, and family care benefits

Read more about our benefits and careers at kearney.com/careers.

Compensation Range: $100k-$160k. It is important to note that at Kearney, it is not typical for an individual to be hired at the top of the range for their role. Individual salaries within each range are determined through a wide variety of factors including but not limited to education, experience, knowledge and skills. Kearney reviews compensation regularly and may adjust base salaries to reflect market competitiveness. In addition to salary, individuals may be eligible for a discretionary performance bonus. Our full suite of benefits includes paid time off, 401(k) match and profit sharing, medical, dental and vision coverage, healthcare concierge, backup child/adult care, annual employer HSA contribution, home office stipend, subsidized Gympass and annual wellness program, and leaves of absence when needed to support employees’ physical, mental, and emotional well-being.

Equal Employment Opportunity and Non-Discrimination

Kearney prides itself on providing a culture that allows employees to bring their best selves to work every day. Our people can feel comfortable, confident, and joyful to do great things for our firm, our colleagues, and our clients. Kearney aims to build diverse capabilities to help our clients solve their most mission critical problems. Kearney is committed to building a diverse, unbiased and inclusive workforce. Kearney is an equal opportunity employer; we recruit, hire, train, promote, develop, and provide other conditions of employment without regard to a person’s gender identity or expression, sexual orientation, race, religion, age, national origin, disability, marital status, pregnancy status, veteran status, genetic information or any other differences consistent with applicable laws. This includes providing reasonable accommodation for disabilities, or religious beliefs and practices. Members of communities historically underrepresented in consulting are encouraged to apply.