Data Engineering Senior Consultant

Clarkston Consulting is a firm that values its culture and people, and they are seeking a Senior Data Engineering Consultant to deliver creative business solutions to clients in the life sciences, consumer products, and retail industries. In this role, you will support data and analytics initiatives, lead client initiatives, and mentor a data engineering team while ensuring optimal data delivery architecture.

Responsibilities:

• 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

Requirements:

• Building modern data platforms that leverage Azure Data Lake, Azure Data Factory and Azure Databricks and/or Microsoft Fabric
• Designing, developing, and implementing data engineering solutions using Databricks on cloud platforms, and/or working across Microsoft Fabric, including OneLake, Lakehouse, and Warehouse
• Programming for data processing and automation in Python, PySpark, and SQL
• Developing and maintaining data pipelines and workflows
• 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
• 3+ years of experience in a Data Engineer role
• Advanced working SQL knowledge and experience working with relational databases and 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
• 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
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data' data stores
• 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