Senior Data Engineer

Senior Data Engineer

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 Data Engineer, and in this role, you will deliver creative business solutions to our market-leading clients in the life sciences, consumer products, and retail industries.

Together, we can find the answers to our clients most challenging business problems through a combination of our industry expertise, business process knowledge, and consulting excellence.

What You ll Do

As a Senior Data Engineer 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 for our clients.

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:

Receive the support and mentorship of your Clarkston colleagues and leaders

Expand your existing skillset with internal and external professional development opportunities

What We re Looking For:

An ideal Senior Data Engineer candidate would have experience:

Strong experience in building modern data platforms that leverage Azure Data Lake, Azure Data Factory and Azure Databricks. Should be proficient in PySpark, Python and SQL.

Strong experience designing data models that meets business needs that meets design guidelines and standards is a must.

Prior experience working/data modeling SAP/ERP data will be a plus.

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:

3+ years of experience in a Data Engineer role

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

Build processes supporting data transformation, data structures, metadata, dependency and workload management

A successful history of manipulating, processing and extracting value from large, disconnected datasets

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

Graduate degree in Computer Science, Statistics, Informatics, Information Systems or an equivalent field