Senior Databricks Data Engineering Consultant

About the role

Clarkston Consulting is seeking motivated, self-driven leaders who are energized by team results and interested in joining a firm that values its culture and people as its biggest strengths. Come join us as a Senior Databricks Data Engineering Consultant and in this role, you will deliver creative business solutions to our market-leading clients in the life sciences, consumer products, and retail industries.

Responsibilities

• 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
• Lead, grow, and mentor a data engineering team in developing, maintaining, and monitoring data solutions for clients
• Aid in defining client solutions and support managing their delivery

How You'll Grow

• Receive the support and mentorship of your Clarkston colleagues and leaders
• Expand your existing skillset with internal and external professional development opportunities

Requirements

• Experience designing, developing, and implementing data engineering solutions using Databricks on cloud platforms
• Strong programming skills for data processing and automation in Python
• Skilled in developing and maintaining data pipelines and workflows in Databricks using Python
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Leverage 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
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
• Work with stakeholders including the Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs

Additional Qualifications

• 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
• Perform 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
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Manipulate, process, and extract value from large, disconnected datasets
• Experience supporting and working with cross-functional teams in a dynamic environment
• Experience 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

• 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