Clarkston Consulting
Clarkston Consulting
Clarkston Consulting is a strategic business consultancy supporting organizations in life sciences, consumer products, and retail. Its work spans business strategy, operations, implementation, managed services, change management, and data-driven transformation. The firm also provides expertise in business process consulting, clinical research, digital and technology consulting, and supply chain management, helping clients address complex operational and organizational challenges.

Senior Data Engineering Consultant (Hybrid, Dallas)

Senior data engineering consultant designing scalable pipelines and architectures for Clarkston Consulting. Leads client data solutions across life sciences, consumer products, and retail.

Description

  • Support solution architects, developers, analysts, and data scientists across data and analytics initiatives.
  • Lead client engagements and partner with stakeholders and technical teams to deliver data solutions.
  • Design, build, and optimize scalable data pipelines and architectures.
  • Create and maintain data models and schemas for analytics and reporting.
  • Convert business requirements into practical technical data solutions.
  • Maintain consistent, high-performing data delivery architectures throughout projects.
  • Improve data processes, scalability, performance, reliability, and automation.
  • Lead, develop, and mentor data engineering teams.
  • Support solution definition, effort estimation, proposals, and delivery planning.
  • Contribute to project planning, status updates, and consulting engagements.
  • Travel approximately 30–50% according to client and project requirements.
  • Work from a home office when not traveling or working at a client site.

Requirements

  • At least three years of experience in data engineering or a related data-focused role.
  • Experience assembling large, complex datasets against functional and non-functional business requirements.
  • Experience designing and implementing scalable data architectures, pipelines, and solutions.
  • Experience with data modeling and schema design, including star and snowflake schemas.
  • Advanced SQL skills, including relational databases and query development.
  • Experience building and optimizing big data pipelines, architectures, and datasets.
  • Experience conducting root-cause analysis on data and processes.
  • Strong analytical ability with structured and unstructured datasets.
  • Experience managing data transformation, metadata, dependencies, and workloads.
  • Working knowledge of message queuing, stream processing, and scalable big data stores.
  • Experience with Databricks, Spark, Snowflake, Airflow, and Kafka.
  • Experience with Azure or AWS cloud services.
  • Experience with Scala, Python, Java, and/or C++.
  • Strong written and verbal communication skills.
  • Demonstrated consulting and client-facing experience.
  • Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or an equivalent field.
  • Experience in life sciences, consumer products, and/or retail is preferred.

Benefits

  • Comprehensive medical, dental, vision, and other health and wellness coverage.
  • 401(k) plan with company contributions.
  • Paid vacation, personal days, holidays, and sick leave.
  • Paid parental leave and family-building support, including adoption, surrogacy, and infertility assistance.
  • Life and disability insurance.
  • Investment in training and professional development.
  • Tuition assistance.
  • Support for accommodations during the interview process.

Related Jobs