FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Senior Data Engineering Consultant
Clarkston Consulting. Support solution architects, software developers, data analysts, and data scientists on data and analytics initiatives .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in designing and optimizing scalable data pipelines and architectures, with advanced SQL knowledge and experience in data modeling, including star and snowflake schemas. Proven ability to lead data engineering teams and collaborate with cross-functional stakeholders to deliver effective data solutions.
Highest-signal resume keywords
Data Pipeline DevelopmentSQL ProficiencyData Modeling ExpertiseExperience with DatabricksCloud Services Knowledge
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLData ModelingData Pipeline OptimizationRoot Cause AnalysisData TransformationMessage QueuingStream ProcessingScalaPythonJava
Soft Skills
Analytical SkillsWritten CommunicationVerbal CommunicationClient-Facing ExperienceMentoring
Tools & Technologies
DatabricksSparkSnowflakeAirflowKafkaAzureAWS
Industry Keywords
Life SciencesConsumer ProductsRetail
Tech Stack
Tools & technologiesAirflowAWSAzureCloudJavaKafkaPythonScalaSparkSQLC++
About the role
Key responsibilities & impact- Support solution architects, software developers, data analysts, and data scientists on data and analytics initiatives
- Lead client initiatives and collaborate with client stakeholders and technical teams to define and deliver data solutions
- Design, develop, and optimize scalable data pipelines and architectures
- Develop and maintain data models and schemas for analytics and reporting, including star and snowflake schemas
- Translate business requirements into technical data solutions
- Ensure consistent and optimal data delivery architecture throughout projects
- Support data needs across multiple teams, systems, and products
- Improve data processes, scalability, performance, reliability, and automation
- Lead, grow, and mentor data engineering teams
- Assist with client solutions, work estimates, proposals, and solution delivery
- Contribute to project planning, status communication, and consulting activities
- Receive mentorship and pursue internal and external professional development opportunities
Requirements
What you’ll need- 3+ years of experience in a Data Engineer or related data-focused role
- Advanced working SQL knowledge and experience with relational databases and query authoring
- Experience building and optimizing big data pipelines, architectures, and data sets
- Experience with data modeling and schema design, including star and snowflake schemas
- Experience performing root cause analysis on internal and external data and processes
- Strong analytical skills with structured and unstructured datasets
- Experience building processes supporting data transformation, data structures, metadata, dependency, and workload management
- Experience manipulating, processing, and extracting value from large and disconnected datasets
- Working knowledge of message queuing, stream processing, and highly scalable big data data stores
- Experience with cross-functional teams in a dynamic environment
- 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 with technical and business audiences
- Demonstrated consulting and client-facing experience
- Experience in life sciences, consumer products, and/or retail is preferred
- Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or an equivalent field
- Willingness to travel an estimated 30–50%
Benefits
Comp & perks- Comprehensive Health and Wellness Benefits (Medical, Dental, Vision, and more)
- 401k with company contributions
- Paid vacation, personal days, holidays, and sick leave
- Paid Parental Leave and Family Building Benefits (Adoption, Surrogacy, and Infertility Support)
- Life and Disability Insurance
- Training and Professional Development investments
- Tuition Assistance
- Interview process accommodations upon request