Job Details

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