Clarkston Consulting

Senior Data Engineer

Clarkston Consulting

full-time

Posted on:

Location Type: Hybrid

Location: Austin • Texas • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AirflowAWSAzureCloudJavaKafkaPythonScalaSparkSQL

About the role

  • **What You’ll Do**
  • As a Data Engineer Senior Consultant at Clarkston, you will:
  • - Support our solution architects, software developers, data analysts, and data scientists on data and analytics initiatives
  • - Serve in a lead capacity on client initiatives
  • - Ensure optimal data delivery architecture is consistent throughout ongoing projects
  • - Be self-directed and comfortable supporting the data needs of multiple teams, systems and products
  • - Be excited by the prospect of building our company’s data engineering capabilities to support our next generation of products and data initiatives
  • - Lead, grow, and mentor a data engineering team in developing, maintaining, and monitoring data solutions for clients
  • - Assist in defining client solutions and support managing their delivery
  • **How You’ll Grow**
  • Beyond your day-to-day responsibilities, throughout your career at Clarkston you will:
  • - Have the support and mentorship of your Clarkston colleagues and leaders
  • - Expand your existing skill set with internal and external professional development opportunities

Requirements

  • *What We’re Looking For:*
  • An ideal Data Engineer Senior Consultant candidate will have experience:
  • - Assembling large, complex data sets that meet functional / non-functional business requirements
  • - Identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • - Leveraging the appropriate infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and ‘big data’ technologies.
  • - Building analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
  • - Working with stakeholders - including the Product, Data, and Design teams - to assist with data-related technical issues and support their data infrastructure needs
  • Additional Qualifications:
  • - Hands-on experience designing, developing, and optimizing data solutions using Microsoft Fabric
  • - 5+ years of experience in a Data Engineer role
  • - Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
  • - Experience building and optimizing ‘big data’ data pipelines, architectures and data sets
  • - Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
  • - Strong analytic skills related to working with unstructured datasets
  • - Knowledge of build processes that support data transformation, data structures, metadata, dependency, and workload management
  • - Successful history of manipulating, processing and extracting value from large, disconnected datasets
  • - Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores
  • - Skilled in project management, including managing project plans, timelines, and deliverables
  • - Experience supporting and working with cross-functional teams in a dynamic environment
  • - Demonstrated ability with big data tools including Databricks, Spark, Snowflake, Airflow, and Kafka
  • - Expertise with Azure or AWS cloud services
  • - Experience with object-oriented/object function scripting languages such as Scala, Python, Java, and / or C++
  • - Graduate degree in Computer Science, Statistics, Informatics, Information Systems or an equivalent field
Benefits
  • *Our benefits include: *
  • - 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, and more
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data engineeringSQLMicrosoft Fabricbig data technologiesdata pipelinedata architecturedata transformationdata structuresmessage queuingstream processing
Soft Skills
leadershipmentoringproject managementanalytical skillscross-functional collaborationproblem-solvingself-directedcommunicationteam supportprocess improvement
Certifications
graduate degree in Computer Sciencegraduate degree in Statisticsgraduate degree in Informaticsgraduate degree in Information Systems